gemma: schema/tap_tests_data.sql annotate

annotate schema/tap_tests_data.sql @ 177:4e2451d561b1

Make schema for templates more realistic A print template should be stored with name and timestamp and the template itself will be any data to be interpreted as a template file by a templating engine. Delete relations in user_templates with their parents using CASCADE, because user_templates is only an m:n-table.

author	Tom Gottfried <tom@intevation.de>
date	Tue, 17 Jul 2018 16:50:16 +0200
parents	25dba84d5703
children	4df4e4bf480e

rev	line source
115 d349db18bece s/wamos/gemma/g on database schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 113 diff changeset	1 SET search_path TO public, gemma, gemma_waterway, gemma_fairway;
109 0e486e6ee60d Set search path in test data script for standalone use. Tom Gottfried <tom@intevation.de> parents: 108 diff changeset	2
177 4e2451d561b1 Make schema for templates more realistic Tom Gottfried <tom@intevation.de> parents: 136 diff changeset	3 INSERT INTO countries VALUES ('AT'), ('RO');
108 f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	4
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	5 INSERT INTO responsibility_areas VALUES
136 25dba84d5703 Schema: Fixed test for responsibility_areas as multi polygons. Sascha Wilde <wilde@intevation.de> parents: 115 diff changeset	6 ('AT', ST_geomfromtext('MULTIPOLYGON(((0 0, 0 1, 1 1, 1 0, 0 0)))', 4326));
108 f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	7
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	8 INSERT INTO user_profiles (username, country, email_adress)
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	9 VALUES
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	10 ('waterway_user', 'AT', 'xxx'),
177 4e2451d561b1 Make schema for templates more realistic Tom Gottfried <tom@intevation.de> parents: 136 diff changeset	11 ('waterway_user2', 'RO', 'xxy'),
108 f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	12 ('waterway_admin', 'AT', 'yyy'),
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	13 ('sys_admin', 'AT', 'zzz');
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	14
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	15 INSERT INTO limiting_factors VALUES ('depth'), ('width');
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	16
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	17 INSERT INTO gauges (
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	18 location, function_code, objname, geom, zero_point, source_organization)
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	19 VALUES
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	20 (('AT', 'XXX', '00001', '00000', 1)::isrs,
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	21 'xxx',
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	22 'testgauge',
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	23 ST_geomfromtext('POINT(0 0)', 4326),
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	24 0,
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	25 'testorganization');
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	26
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	27 INSERT INTO bottlenecks (
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	28 bottleneck_id, fk_g_fid, stretch, area, rb, lb, responsible_country,
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	29 revisiting_time, limiting, source_organization, staging_done)
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	30 VALUES
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	31 ('testbottleneck1',
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	32 ('AT', 'XXX', '00001', '00000', 1)::isrs,
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	33 isrsrange(('AT', 'XXX', '00001', '00000', 0)::isrs,
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	34 ('AT', 'XXX', '00001', '00000', 2)::isrs),
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	35 ST_geomfromtext('POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))', 4326),
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	36 'AT', 'AT', 'AT',
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	37 1, 'depth', 'testorganization', false),
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	38 ('testbottleneck2',
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	39 ('AT', 'XXX', '00001', '00000', 1)::isrs,
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	40 isrsrange(('AT', 'XXX', '00001', '00000', 0)::isrs,
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	41 ('AT', 'XXX', '00001', '00000', 2)::isrs),
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	42 ST_geomfromtext('POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))', 4326),
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	43 'AT', 'AT', 'AT',
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	44 1, 'depth', 'testorganization', true);
f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	45
177 4e2451d561b1 Make schema for templates more realistic Tom Gottfried <tom@intevation.de> parents: 136 diff changeset	46 INSERT INTO templates (template_name, template_data)
4e2451d561b1 Make schema for templates more realistic Tom Gottfried <tom@intevation.de> parents: 136 diff changeset	47 VALUES ('AT', '\x'), ('RO', '\x');
108 f6aba3ee3a75 Put test data in own file for easier debugging. Tom Gottfried <tom@intevation.de> parents: diff changeset	48 INSERT INTO user_templates
177 4e2451d561b1 Make schema for templates more realistic Tom Gottfried <tom@intevation.de> parents: 136 diff changeset	49 VALUES ('waterway_user', 'AT'), ('waterway_user2', 'RO');

Mercurial > gemma

annotate schema/tap_tests_data.sql @ 177:4e2451d561b1