Mercurial > gemma
diff schema/tap_tests_data.sql @ 182:4df4e4bf480e
Beautify SQL
E.g. indent with 4 spaces more consequently.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 18 Jul 2018 16:48:27 +0200 |
parents | 4e2451d561b1 |
children | 5dc8e734487a |
line wrap: on
line diff
--- a/schema/tap_tests_data.sql Tue Jul 17 19:13:16 2018 +0200 +++ b/schema/tap_tests_data.sql Wed Jul 18 16:48:27 2018 +0200 @@ -3,47 +3,50 @@ INSERT INTO countries VALUES ('AT'), ('RO'); INSERT INTO responsibility_areas VALUES - ('AT', ST_geomfromtext('MULTIPOLYGON(((0 0, 0 1, 1 1, 1 0, 0 0)))', 4326)); + ('AT', ST_geomfromtext('MULTIPOLYGON(((0 0, 0 1, 1 1, 1 0, 0 0)))', 4326)); INSERT INTO user_profiles (username, country, email_adress) - VALUES - ('waterway_user', 'AT', 'xxx'), - ('waterway_user2', 'RO', 'xxy'), - ('waterway_admin', 'AT', 'yyy'), - ('sys_admin', 'AT', 'zzz'); + VALUES + ('waterway_user', 'AT', 'xxx'), + ('waterway_user2', 'RO', 'xxy'), + ('waterway_admin', 'AT', 'yyy'), + ('sys_admin', 'AT', 'zzz'); INSERT INTO limiting_factors VALUES ('depth'), ('width'); INSERT INTO gauges ( - location, function_code, objname, geom, zero_point, source_organization) - VALUES - (('AT', 'XXX', '00001', '00000', 1)::isrs, + location, function_code, objname, geom, zero_point, source_organization) + VALUES ( + ('AT', 'XXX', '00001', '00000', 1)::isrs, 'xxx', 'testgauge', ST_geomfromtext('POINT(0 0)', 4326), 0, - 'testorganization'); + 'testorganization' + ); INSERT INTO bottlenecks ( - bottleneck_id, fk_g_fid, stretch, area, rb, lb, responsible_country, - revisiting_time, limiting, source_organization, staging_done) - VALUES - ('testbottleneck1', + bottleneck_id, fk_g_fid, stretch, area, rb, lb, responsible_country, + revisiting_time, limiting, source_organization, staging_done) + VALUES ( + 'testbottleneck1', ('AT', 'XXX', '00001', '00000', 1)::isrs, isrsrange(('AT', 'XXX', '00001', '00000', 0)::isrs, - ('AT', 'XXX', '00001', '00000', 2)::isrs), + ('AT', 'XXX', '00001', '00000', 2)::isrs), ST_geomfromtext('POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))', 4326), 'AT', 'AT', 'AT', - 1, 'depth', 'testorganization', false), - ('testbottleneck2', + 1, 'depth', 'testorganization', false + ), ( + 'testbottleneck2', ('AT', 'XXX', '00001', '00000', 1)::isrs, isrsrange(('AT', 'XXX', '00001', '00000', 0)::isrs, - ('AT', 'XXX', '00001', '00000', 2)::isrs), + ('AT', 'XXX', '00001', '00000', 2)::isrs), ST_geomfromtext('POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))', 4326), 'AT', 'AT', 'AT', - 1, 'depth', 'testorganization', true); + 1, 'depth', 'testorganization', true + ); INSERT INTO templates (template_name, template_data) - VALUES ('AT', '\x'), ('RO', '\x'); + VALUES ('AT', '\x'), ('RO', '\x'); INSERT INTO user_templates - VALUES ('waterway_user', 'AT'), ('waterway_user2', 'RO'); + VALUES ('waterway_user', 'AT'), ('waterway_user2', 'RO');