Changes between Version 47 and Version 48 of DevWikiGardenTest


Ignore:
Timestamp:
Dec 3, 2010, 7:28:12 AM (13 years ago)
Author:
robe
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • DevWikiGardenTest

    v47 v48  
    1313The latest version includes logic that will during the tests -  create two tables in the test database and populate them for later inspection:
    1414 * '''postgis_garden_log''': This contains a record for each test and logs both the start, end times and the sql statement that was run.
    15    columns are: ''logid'' -  an autonumber it should end up being the same numbers for the same tests if the same generated script file is used to run against each postgresql box, 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.
     15   columns are:
     16   * ''logid'' -  an autonumber it should end up being the same numbers for the same tests if the same generated script file is used to run against each postgresql box
     17   * ''log_label'' - a short description of the test
     18   * ''spatial_class'' - (will contain geometry or geography)
     19   * ''func'' - name of function being tested
     20   * ''g1'' - type of geometry of first geometry
     21   * ''g2'' - type of geometry of second or null if a single geometry function
     22   * ''log_start'' - start time (timestamp)
     23   * ''log_end'' - end time (timestamp)
     24   * ''log_sql'' - the SQL statement that was run.
    1625
    17 If the test crashes before completion, the record with the largest logid will tell you the query that crashed the server.
     26If the test crashes before completion, the record with the max logid will tell you the query that crashed the server.
    1827
    1928 * '''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.