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');