Mercurial > gemma

comparison schema/tap_tests_data.sql @ 136:25dba84d5703

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Schema: Fixed test for responsibility_areas as multi polygons. The test must reflect the fact, that responsibility_areas are now MULTIPOLYGONs.
author Sascha Wilde <wilde@intevation.de>
date Fri, 29 Jun 2018 15:03:39 +0200
parents d349db18bece
children 4e2451d561b1
comparison
equal deleted inserted replaced
135:731fb359b29c 136:25dba84d5703
1 SET search_path TO public, gemma, gemma_waterway, gemma_fairway; 1 SET search_path TO public, gemma, gemma_waterway, gemma_fairway;
2 2
3 INSERT INTO countries VALUES ('AT'); 3 INSERT INTO countries VALUES ('AT');
4 4
5 INSERT INTO responsibility_areas VALUES 5 INSERT INTO responsibility_areas VALUES
6 ('AT', ST_geomfromtext('POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))', 4326)); 6 ('AT', ST_geomfromtext('MULTIPOLYGON(((0 0, 0 1, 1 1, 1 0, 0 0)))', 4326));
7 7
8 INSERT INTO user_profiles (username, country, email_adress) 8 INSERT INTO user_profiles (username, country, email_adress)
9 VALUES 9 VALUES
10 ('waterway_user', 'AT', 'xxx'), 10 ('waterway_user', 'AT', 'xxx'),
11 ('waterway_admin', 'AT', 'yyy'), 11 ('waterway_admin', 'AT', 'yyy'),