Mercurial > gemma
comparison schema/tap_tests_data.sql @ 1905:4f58bada50b8 dev-pdf-generation
merging in default branch
author | Bernhard Reiter <bernhard@intevation.de> |
---|---|
date | Fri, 18 Jan 2019 17:10:16 +0100 |
parents | 931b15be6d7f |
children | f9f1babe52ae |
comparison
equal
deleted
inserted
replaced
1903:7247ac316cb7 | 1905:4f58bada50b8 |
---|---|
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_at2', 'admin_at2$', 'AT', NULL, 'yyy'); | |
33 INSERT INTO users.list_users VALUES ( | |
34 'waterway_admin', 'test_admin_ro', 'admin_ro1$', 'RO', NULL, 'yyx'); | |
31 INSERT INTO users.list_users VALUES ( | 35 INSERT INTO users.list_users VALUES ( |
32 'sys_admin', 'test_sys_admin1', 'sys_admin1$', 'AT', NULL, 'zzz'); | 36 'sys_admin', 'test_sys_admin1', 'sys_admin1$', 'AT', NULL, 'zzz'); |
33 | 37 |
34 INSERT INTO limiting_factors VALUES ('depth'), ('width'); | 38 INSERT INTO limiting_factors VALUES ('depth'), ('width'); |
35 | 39 |
86 | 90 |
87 INSERT INTO users.templates (template_name, template_data) | 91 INSERT INTO users.templates (template_name, template_data) |
88 VALUES ('AT', '\x'), ('RO', '\x'); | 92 VALUES ('AT', '\x'), ('RO', '\x'); |
89 INSERT INTO users.user_templates | 93 INSERT INTO users.user_templates |
90 VALUES ('test_user_at', 'AT'), ('test_user_ro', 'RO'); | 94 VALUES ('test_user_at', 'AT'), ('test_user_ro', 'RO'); |
95 | |
96 WITH | |
97 job AS ( | |
98 INSERT INTO waterway.imports (kind, username, data) VALUES ( | |
99 'test', 'test_admin_ro', 'test') RETURNING id), | |
100 log AS ( | |
101 INSERT INTO waterway.import_logs (import_id, msg) | |
102 SELECT id, 'test' FROM job) | |
103 INSERT INTO waterway.track_imports | |
104 SELECT id, 'waterway.bottlenecks', 1 FROM job; | |
105 | |
106 WITH | |
107 config AS ( | |
108 INSERT INTO waterway.import_configuration (kind, username) VALUES ( | |
109 'test', 'test_admin_ro') RETURNING id) | |
110 INSERT INTO waterway.import_configuration_attributes | |
111 SELECT id, 'test key', 'test value' FROM config; |