diff schema/run_tests.sh @ 207:88d21c29cf04

Care for the fact that role attributes are not inherited Tests are now run with login roles instead of abstract base roles. create_user has become a SECURITY DEFINER function, thus circumventing RLS policies and that a sys_admin cannot CREATE ROLEs by himself. A test has been added to showcase the intentional error in case the name of an abstract base role is used as a new username.
author Tom Gottfried <tom@intevation.de>
date Mon, 23 Jul 2018 11:29:41 +0200
parents b67208d82543
children cfde876fbaf9
line wrap: on
line diff
--- a/schema/run_tests.sh	Sun Jul 22 10:40:17 2018 +0200
+++ b/schema/run_tests.sh	Mon Jul 23 11:29:41 2018 +0200
@@ -13,7 +13,7 @@
 # in cluster, which would prevent tests from being repeatable
 psql -qXv ON_ERROR_STOP= -v AUTOCOMMIT=off -d gemma_test \
     -f tap_tests_data.sql \
-    -c 'SELECT plan(22)' \
+    -c 'SELECT plan(23)' \
     -f auth_tests.sql \
     -f manage_users_tests.sql \
     -c 'SELECT * FROM finish()' \