Mercurial > gemma
view schema/run_tests.sh @ 948:5f89868bd75e
Store virtual and physical distance marks separately
Virtual distance marks on waterway axis always have an ISRS location
code, which is their natural primary key, but which other distance
marks do not (always) have. catdis and position_code are constant
for distance marks on fairway axis and do not need to be stored.
Btw. add a previously missing field for the name of the ENC the
information is based on.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Sat, 13 Oct 2018 14:26:40 +0200 |
parents | ad07846b09d1 |
children | 6590208e3ee1 |
line wrap: on
line source
#!/bin/sh -e dropdb --if-exists gemma_test ./install-db.sh -d gemma_test psql -qv ON_ERROR_STOP= -c 'CREATE EXTENSION pgtap' -d gemma_test # Collect test roles to be dropped # Concatenate with dummy role to prevent syntax error if there is no test role TEST_ROLES=$(psql -qtc \ "SELECT concat_ws(',', 'test', string_agg(rolname, ',')) FROM pg_roles WHERE rolname LIKE 'test%'") # Drop test roles, add test data and run tests psql -qXv ON_ERROR_STOP= -v -d gemma_test \ -c 'SET client_min_messages TO WARNING' \ -c "DROP ROLE IF EXISTS $TEST_ROLES" \ -f tap_tests_data.sql \ -c 'SELECT plan(45)' \ -f isrs_tests.sql \ -f auth_tests.sql \ -f manage_users_tests.sql \ -c 'SELECT * FROM finish()'