Add script to create and initialize postgis test database

Sandro Santilli · Sandro Santilli · commit cdf05acac8cf · 2016-02-17T11:08:18.000+01:00
diff --git a/tests/README.md b/tests/README.md
@@ -52,9 +52,15 @@ If this does not match your setup you can set the environment variable
 on standard libpq environment variables to tweak host, port user and
 password (PGHOST, PGPORT, PGUSER, PGPASSWORD).
 
-Please note that the database needs to be initialized using the sql-script
+Please note that the database needs to be initialized using
+the sql-scripts:
 
     tests/testdata/provider/testdata_pg*.sql
 
 They take care of activating postgis for the test database and
 create some tables containing test data.
+
+For convenience, a shell script is provided to create the database
+and initialize it as needed:
+
+    tests/testdata/provider/testdata_pg.sh
diff --git a/tests/testdata/provider/testdata_pg.sh b/tests/testdata/provider/testdata_pg.sh
@@ -0,0 +1,12 @@
+#!/bin/sh
+
+SCRIPTS="
+  tests/testdata/provider/testdata_pg.sql
+  tests/testdata/provider/testdata_pg_reltests.sql
+  tests/testdata/provider/testdata_pg_vectorjoin.sql
+"
+
+createdb qgis_test || exit 1
+for f in ${SCRIPTS}; do
+  psql -f $f qgis_test --set ON_ERROR_STOP=1 || exit 1
+done
