Changes between Version 25 and Version 26 of DevWikiGardenTest

Timestamp:

Dec 3, 2010, 4:42:58 AM (13 years ago)

Author:

robe

Comment:

—

DevWikiGardenTest

@@ -10 +10 @@
 
 To Build the script
-== Version PostGIS 1.4 ==
+== Version PostGIS 2.0+ ==
+The latest version includes logic that will create two tables in the test database and populate them for later inspection:
+ * postgis_garden_log: This contains a record for each test and logs both the start, end times and the sql statement that was run. 
+   columns are: logid-  an autonumber, log_label - a short description, spatial_class - (will contain geometry or geography), func - name of function being tested, g1 - type of geometry of first geometry, g2 - type of geometry of second or null if a single geometry function, log_start - start time (timestamp), log_end - end time (timestamp), log_sql - the SQL statement that was run.
 
+If the test crashes before completion, the record with the largest logid will tell you the query that crashed the server..
+
+ * postgis_garden_log_output -- this outputs the query results for queries that return something in xml format.  It  uses the built-in query_to_xml function that has existed since PostgreSQL 8.3 to do that.
+columns: logid -- you can join this with the postgis_garden_log table to get the descriptive detail and SQL for the test.  log_out - an xml field that contains the query_to_xml output of the query.
+
+There is an unfortunate dependency on postgis_agg_mm.xml which is really not needed 
+just create a dummy blank file called postgis_agg_mm.xml in the trunk/doc to get around this
+Then:
 {{{
-xsltproc -o torturetest.sql branches/1.4/doc/xsl/postgis_gardentest.sql.xsl branches/1.4/doc/reference.xml
+xsltproc -o torturetest.sql trunk/doc/xsl/postgis_gardentest.sql.xsl trunk/doc/postgis.xml
 }}}
 
@@ -21 +32 @@
 Then:
 {{{
-xsltproc -o torturetest.sql trunk/doc/xsl/postgis_gardentest.sql.xsl trunk/doc/postgis.xml
+xsltproc -o torturetest.sql branches/1.5/doc/xsl/postgis_gardentest.sql.xsl branches/1.5/doc/postgis.xml
 }}}
 
@@ -28 +39 @@
 
 {{{
+psql -p 5432 -U postgres -d postgres -c "DROP DATABASE testpostgis;"
 psql -p 5432 -U postgres -d postgres -c "CREATE DATABASE testpostgis;" 
 psql -p 5432 -U postgres -d testpostgis -c "CREATE LANGUAGE plpgsql;" 
 psql -p 5432 -U postgres -d testpostgis -f postgis.sql 
 psql -p 5432 -U postgres -d testpostgis -f spatial_ref_sys.sql
-psql -p 5432 -U postgres -d testpostgis -f torturetest.sql > torturetest_results.txt 
-psql -p 5432 -U postgres -d postgres -c "DROP DATABASE testpostgis;" 
+psql -p 5432 -U postgres -d testpostgis -f torturetest.sql > torturetest_results.txt  
 
 }}}
@@ -51 +62 @@
 \timing 
 }}}
+
+== Version PostGIS 1.4 ==
+
+{{{
+xsltproc -o torturetest.sql branches/1.4/doc/xsl/postgis_gardentest.sql.xsl branches/1.4/doc/reference.xml
+}}}
+
 
 = Testing subset of functions =