comparison 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
comparison
equal deleted inserted replaced
206:cd6ad5eaef8d 207:88d21c29cf04
11 11
12 # Add test data, run tests and ROLLBACK to prevent test roles to stay 12 # Add test data, run tests and ROLLBACK to prevent test roles to stay
13 # in cluster, which would prevent tests from being repeatable 13 # in cluster, which would prevent tests from being repeatable
14 psql -qXv ON_ERROR_STOP= -v AUTOCOMMIT=off -d gemma_test \ 14 psql -qXv ON_ERROR_STOP= -v AUTOCOMMIT=off -d gemma_test \
15 -f tap_tests_data.sql \ 15 -f tap_tests_data.sql \
16 -c 'SELECT plan(22)' \ 16 -c 'SELECT plan(23)' \
17 -f auth_tests.sql \ 17 -f auth_tests.sql \
18 -f manage_users_tests.sql \ 18 -f manage_users_tests.sql \
19 -c 'SELECT * FROM finish()' \ 19 -c 'SELECT * FROM finish()' \
20 -c 'ROLLBACK' 20 -c 'ROLLBACK'