SET search_path TO public, gemma, gemma_waterway, gemma_fairway;

INSERT INTO countries VALUES ('AT');

INSERT INTO responsibility_areas VALUES
       ('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_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,
        'xxx',
        'testgauge',
        ST_geomfromtext('POINT(0 0)', 4326),
        0,
        'testorganization');

INSERT INTO bottlenecks (
       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),
        ST_geomfromtext('POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))', 4326),
        'AT', 'AT', 'AT',
        1, 'depth', 'testorganization', false),
       ('testbottleneck2',
        ('AT', 'XXX', '00001', '00000', 1)::isrs,
        isrsrange(('AT', 'XXX', '00001', '00000', 0)::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);

INSERT INTO templates (dummy_attrib)
       VALUES ('usertemplate'), ('othertemplate');
INSERT INTO user_templates
       SELECT 'waterway_user', id FROM templates
              WHERE dummy_attrib = 'usertemplate';