Preparing PostgreSQL / PostGIS specific regress tests

In addition to C-Unit tests, we also need a test that tests the function in the PostgreSQL environment. These tests are kept in svn in the /regress folder.

Basic steps:

  • Create a .sql file listing key preferably corner cases of your function and name it some variant of your function name e.g myfunc.sql. Examples of these are in the /regress folder e.g. dumppoints.sql
  • Run this sql file in a PostGIS enabled db using psql and save the output in myfunc_expected -- e.g.
    psql -tXA -h localhost -U postgres -d postgis_reg -f myfunc.sql > myfunc_expected

The make check does some regex replaces, so when you put in your expected, it may fail. Replace your expected with the output generated by the make check.

  • Add this .sql script to the in trunk/regress (NOTE: we can do this if you are submitting the patch). Also note that if your function relies on a particular version of GEOS that is not the minimum version for the PostGIS release, you need to wrap it in a conditional of the form:
ifeq ($(shell expr $(POSTGIS_GEOS_VERSION) ">=" 32),1)
	TESTS += myfunc

Last modified 6 years ago Last modified on Jan 14, 2011 8:19:03 AM