Mercurial > gemma

comparison schema/tap_tests_data.sql @ 1873:9f8f7d3fd655

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fix policies interfering badly with integrity checks The 'parent_allowed' policies did not allow concurrent inserts into parent and child table in one statement (like in the tests introduced here) nor would they have allowed deferring foreign keys in transactions.
author Tom Gottfried <tom@intevation.de>
date Thu, 17 Jan 2019 19:22:49 +0100
parents 9d51f022b8ee
children 931b15be6d7f
comparison
equal deleted inserted replaced
1872:f63712670c25 1873:9f8f7d3fd655
26 'waterway_user', 'test_user_at', 'user_at1$', 'AT', NULL, 'xxx'); 26 'waterway_user', 'test_user_at', 'user_at1$', 'AT', NULL, 'xxx');
27 INSERT INTO users.list_users VALUES ( 27 INSERT INTO users.list_users VALUES (
28 'waterway_user', 'test_user_ro', 'user_ro1$', 'RO', NULL, 'xxy'); 28 'waterway_user', 'test_user_ro', 'user_ro1$', 'RO', NULL, 'xxy');
29 INSERT INTO users.list_users VALUES ( 29 INSERT INTO users.list_users VALUES (
30 'waterway_admin', 'test_admin_at', 'admin_at1$', 'AT', NULL, 'yyy'); 30 'waterway_admin', 'test_admin_at', 'admin_at1$', 'AT', NULL, 'yyy');
31 INSERT INTO users.list_users VALUES (
32 'waterway_admin', 'test_admin_ro', 'admin_ro1$', 'RO', NULL, 'yyx');
31 INSERT INTO users.list_users VALUES ( 33 INSERT INTO users.list_users VALUES (
32 'sys_admin', 'test_sys_admin1', 'sys_admin1$', 'AT', NULL, 'zzz'); 34 'sys_admin', 'test_sys_admin1', 'sys_admin1$', 'AT', NULL, 'zzz');
33 35
34 INSERT INTO limiting_factors VALUES ('depth'), ('width'); 36 INSERT INTO limiting_factors VALUES ('depth'), ('width');
35 37