Mercurial > gemma
diff schema/tap_tests_data.sql @ 1904:931b15be6d7f
Complement authorisation tests for import management
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 18 Jan 2019 17:01:19 +0100 |
parents | 9f8f7d3fd655 |
children | f9f1babe52ae |
line wrap: on
line diff
--- a/schema/tap_tests_data.sql Fri Jan 18 16:11:08 2019 +0100 +++ b/schema/tap_tests_data.sql Fri Jan 18 17:01:19 2019 +0100 @@ -29,6 +29,8 @@ INSERT INTO users.list_users VALUES ( 'waterway_admin', 'test_admin_at', 'admin_at1$', 'AT', NULL, 'yyy'); INSERT INTO users.list_users VALUES ( + 'waterway_admin', 'test_admin_at2', 'admin_at2$', 'AT', NULL, 'yyy'); +INSERT INTO users.list_users VALUES ( 'waterway_admin', 'test_admin_ro', 'admin_ro1$', 'RO', NULL, 'yyx'); INSERT INTO users.list_users VALUES ( 'sys_admin', 'test_sys_admin1', 'sys_admin1$', 'AT', NULL, 'zzz'); @@ -90,3 +92,20 @@ VALUES ('AT', '\x'), ('RO', '\x'); INSERT INTO users.user_templates VALUES ('test_user_at', 'AT'), ('test_user_ro', 'RO'); + +WITH +job AS ( + INSERT INTO waterway.imports (kind, username, data) VALUES ( + 'test', 'test_admin_ro', 'test') RETURNING id), +log AS ( + INSERT INTO waterway.import_logs (import_id, msg) + SELECT id, 'test' FROM job) +INSERT INTO waterway.track_imports + SELECT id, 'waterway.bottlenecks', 1 FROM job; + +WITH +config AS ( + INSERT INTO waterway.import_configuration (kind, username) VALUES ( + 'test', 'test_admin_ro') RETURNING id) +INSERT INTO waterway.import_configuration_attributes + SELECT id, 'test key', 'test value' FROM config;