Mercurial > gemma

comparison schema/tap_tests_data.sql @ 1905:4f58bada50b8 dev-pdf-generation

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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;