Changes between Version 26 and Version 27 of DevWikiGardenTest

Timestamp:

Dec 3, 2010, 4:50:10 AM (13 years ago)

Author:

robe

Comment:

—

DevWikiGardenTest

@@ -18 +18 @@
 
  * 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.
+columns:
+   * logid -- you can join this with the postgis_garden_log table to get the descriptive detail and SQL for the test.  
+   * log_output - an xml field that contains the query_to_xml output of the query.
+
+The really nice benefit about logging the query and the output to a table, is that it's easier to inspect and you can also rerun a subset of the queries for closer inspection by just writing an sql statement something like below -- which will test all tests for the ST_Distance function that involve points and linestrings
+
+{{{
+SELECT logid, log_label, query_to_xml(log_sql, false,false,'') As result, log_sql
+ FROM postgis_garden_log 
+WHERE func = 'ST_3DDistance' AND 
+  (g1 IN('POINTZ', 'MULTIPOINTZ', 'LINESTRINGZ') OR 
+     g2 IN('POINTZ', 'MULTIPOINTZ', 'LINESTRINGZ') )
+) ;
+}}}
+
 
 There is an unfortunate dependency on postgis_agg_mm.xml which is really not needed