Mercurial > gemma
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' |