diff schema/tap_tests_data.sql @ 4118:b785b6bef578

Adapted db tests to new historization-implementation. Additional test for the histoprization features and constraints would be nice... But for now at least the existing ones run without errors...
author Sascha Wilde <wilde@intevation.de>
date Wed, 31 Jul 2019 18:33:49 +0200
parents 1ecfe5d015b0
children 52f7264265bb
line wrap: on
line diff
--- a/schema/tap_tests_data.sql	Wed Jul 31 18:26:02 2019 +0200
+++ b/schema/tap_tests_data.sql	Wed Jul 31 18:33:49 2019 +0200
@@ -57,7 +57,7 @@
         current_timestamp,
         'testorganization',
         current_timestamp)
-    RETURNING location, validity, validity),
+    RETURNING location, validity),
 bns AS (
     VALUES (
         'testbottleneck1',
@@ -75,7 +75,7 @@
         1, 'depth', current_timestamp, 'testorganization', true
     ))
 INSERT INTO waterway.bottlenecks (
-    gauge_location, gauge_validity, validity,
+    gauge_location, validity,
     bottleneck_id, stretch, area, rb, lb, responsible_country,
     revisiting_time, limiting, date_info, source_organization, staging_done)
     SELECT * FROM gs, bns;