Mercurial > gemma

comparison schema/tap_tests_data.sql @ 2000:352493221fa5 importschedulerefac

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
merge with default
author Thomas Junk <thomas.junk@intevation.de>
date Thu, 24 Jan 2019 14:24:39 +0100
parents 59055c8301df
children b66cfcde8ff7
comparison
equal deleted inserted replaced
1999:c420add2dec2 2000:352493221fa5
93 INSERT INTO users.user_templates 93 INSERT INTO users.user_templates
94 VALUES ('test_user_at', 'AT'), ('test_user_ro', 'RO'); 94 VALUES ('test_user_at', 'AT'), ('test_user_ro', 'RO');
95 95
96 WITH 96 WITH
97 job AS ( 97 job AS (
98 INSERT INTO waterway.imports (kind, username, data) VALUES ( 98 INSERT INTO import.imports (kind, username, data) VALUES (
99 'test', 'test_admin_ro', 'test') RETURNING id), 99 'test', 'test_admin_ro', 'test') RETURNING id),
100 log AS ( 100 log AS (
101 INSERT INTO waterway.import_logs (import_id, msg) 101 INSERT INTO import.import_logs (import_id, msg)
102 SELECT id, 'test' FROM job) 102 SELECT id, 'test' FROM job)
103 INSERT INTO waterway.track_imports 103 INSERT INTO import.track_imports
104 SELECT id, 'waterway.bottlenecks', 1 FROM job; 104 SELECT id, 'waterway.bottlenecks', 1 FROM job;
105 105
106 WITH 106 WITH
107 config AS ( 107 config AS (
108 INSERT INTO waterway.import_configuration (kind, username) VALUES ( 108 INSERT INTO import.import_configuration (kind, username) VALUES (
109 'test', 'test_admin_ro') RETURNING id) 109 'test', 'test_admin_ro') RETURNING id)
110 INSERT INTO waterway.import_configuration_attributes 110 INSERT INTO import.import_configuration_attributes
111 SELECT id, 'test key', 'test value' FROM config; 111 SELECT id, 'test key', 'test value' FROM config;