Changes between Version 37 and Version 38 of DevWikiGardenTest


Ignore:
Timestamp:
Dec 3, 2010, 5:26:47 AM (13 years ago)
Author:
robe
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • DevWikiGardenTest

    v37 v38  
    1212== Version PostGIS 2.0+ ==
    1313The latest version includes logic that will during the tests -  create two tables in the test database and populate them for later inspection:
    14  * postgis_garden_log: This contains a record for each test and logs both the start, end times and the sql statement that was run.
     14 * '''postgis_garden_log''': This contains a record for each test and logs both the start, end times and the sql statement that was run.
    1515   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.
    1616
    1717If the test crashes before completion, the record with the largest logid will tell you the query that crashed the server.
    1818
    19  * 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.
     19 * '''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.
    2020columns:
    2121   * logid -- you can join this with the postgis_garden_log table to get the descriptive detail and SQL for the test.