changeset 222:cfde876fbaf9

Try to DROP ROLEs before creating them and keep test results
author Tom Gottfried <tom@intevation.de>
date Wed, 25 Jul 2018 11:59:10 +0200
parents 696c19abe869
children e9382dccb331
files schema/run_tests.sh
diffstat 1 files changed, 3 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/schema/run_tests.sh	Tue Jul 24 18:21:31 2018 +0200
+++ b/schema/run_tests.sh	Wed Jul 25 11:59:10 2018 +0200
@@ -11,10 +11,10 @@
 
 # Add test data, run tests and ROLLBACK to prevent test roles to stay
 # in cluster, which would prevent tests from being repeatable
-psql -qXv ON_ERROR_STOP= -v AUTOCOMMIT=off -d gemma_test \
+psql -qXv ON_ERROR_STOP= -v -d gemma_test \
+    -c 'DROP ROLE IF EXISTS user_at, user_ro, admin_at, sys_admin1' \
     -f tap_tests_data.sql \
     -c 'SELECT plan(23)' \
     -f auth_tests.sql \
     -f manage_users_tests.sql \
-    -c 'SELECT * FROM finish()' \
-    -c 'ROLLBACK'
+    -c 'SELECT * FROM finish()'