Mercurial > gemma
view 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 source
#!/bin/sh -e dropdb --if-exists gemma_test createdb gemma_test psql -qv ON_ERROR_STOP= -c 'CREATE EXTENSION pgtap' -d gemma_test psql -qv ON_ERROR_STOP= -d gemma_test \ -f gemma.sql \ -f auth.sql \ -f manage_users.sql # 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 \ -f tap_tests_data.sql \ -c 'SELECT plan(23)' \ -f auth_tests.sql \ -f manage_users_tests.sql \ -c 'SELECT * FROM finish()' \ -c 'ROLLBACK'