Changes between Version 32 and Version 33 of DevWikiGardenTest
- Timestamp:
- 12/03/10 05:20:04 (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DevWikiGardenTest
v32 v33 1 1 = PostGIS Garden Test = 2 2 3 The PostGIS Garden Test is a suite of SQL statements designed to stress test the PostGIS library within the PostgreSQL environment. It is a test generated from the PostGIS documentation reference.xml (PostGIS Reference section of manual) that tries to test every documented function against every kind of geometry supported by PostGIS as well as common issues like handling of nulls, empty geometries etc. The main objective of the tests is to try to catch bugs that will crash the server. It is also useful for monitoring odd behavior as well as a regression test against prior versions of the software. To test against prior versions, build a test from the prior version reference.xml and test against both the old and the new version on the same server and then do a diff between the two. With postgis-1.4 and postgis-1.5this is much easier to do as you can run both versions on the same server in different databases.3 The PostGIS Garden Test is a suite of SQL statements designed to stress test the PostGIS library within the PostgreSQL environment. It is a test generated from the PostGIS documentation reference.xml (PostGIS Reference section of manual) that tries to test every documented function against every kind of geometry supported by PostGIS as well as common issues like handling of nulls, empty geometries etc. The main objective of the tests is to try to catch bugs that will crash the server. It is also useful for monitoring odd behavior as well as a regression test against prior versions of the software. To test against prior versions, build a test from the prior version reference.xml and test against both the old and the new version on the same server and then do a diff between the two. With postgis-1.4, postgis-1.5, and postgis-2.0 this is much easier to do as you can run both versions on the same server in different databases. 4 4 5 5 To build the garden test you need an xsltproc (the same that is used to build the docs or some other .xsl processor). On windows you can download precompiled binaries from [http://www.zlatkovic.com/pub/libxml/] and its part of the libxslt package. You may also need to download the iconv and zlib packages at same site and extract bin/.dlls in same folder as your xsltproc.exe. 6 6 7 The (reference.xml or postgis.xml) and postgis_gardentest.sql.xsllocated in the doc and doc/xsl folders are both needed to build the tests.7 The (reference.xml or postgis.xml) and (postgis_gardentest.sql.xsl, raster_gardentest.sql.xsl (introduced in PostGIS 2.0) located in the doc and doc/xsl folders are both needed to build the tests. 8 8 9 NOTE that these tests are equivalent to a monkey testing the software so a lot of tests fail. Its good in a sense as a monkey will stuff a geometryin any function that takes that and as such will test the system as human monkeys are bound to do.9 NOTE: These tests are equivalent to a monkey testing the software so a lot of tests fail. It's good in a sense as a monkey will stuff a geometry, geography or raster in any function that takes that and as such will test the system as human monkeys are bound to do. 10 10 11 11 To Build the script