Mercurial > gemma
comparison schema/tap_tests_data.sql @ 2000:352493221fa5 importschedulerefac
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; |