comparison src/test/resources/datasets/clean_and_seed.sql @ 1040:ea550e9a09a3 schema-update

Updated unit tests to fit the new data model.
author Raimund Renkert <raimund.renkert@intevation.de>
date Fri, 02 Sep 2016 14:03:25 +0200
parents 1da90ad6b35f
children 6960275c4609
comparison
equal deleted inserted replaced
1039:7339dd0f8a67 1040:ea550e9a09a3
25 -- minimal master data to make interface tests runnable 25 -- minimal master data to make interface tests runnable
26 INSERT INTO ort_typ (id) VALUES (1); 26 INSERT INTO ort_typ (id) VALUES (1);
27 INSERT INTO datenbasis (id) VALUES (9); 27 INSERT INTO datenbasis (id) VALUES (9);
28 INSERT INTO mess_einheit (id) VALUES (207); 28 INSERT INTO mess_einheit (id) VALUES (207);
29 INSERT INTO messgroesse (id, messgroesse) VALUES (56, 'Mangan'); 29 INSERT INTO messgroesse (id, messgroesse) VALUES (56, 'Mangan');
30 INSERT INTO mess_methode (id) VALUES ('GI'); 30 INSERT INTO mess_methode (id) VALUES ('A3');
31 INSERT INTO netz_betreiber (id) VALUES ('06'); 31 INSERT INTO netz_betreiber (id) VALUES ('06');
32 INSERT INTO mess_stelle (id, netzbetreiber_id) VALUES ('06010', '06'); 32 INSERT INTO mess_stelle (id, netzbetreiber_id) VALUES ('06010', '06');
33 INSERT INTO pflicht_messgroesse (id, datenbasis_id) VALUES (33, 9); 33 INSERT INTO pflicht_messgroesse (id, mmt_id, datenbasis_id) VALUES (33, 'A3', 9);
34 INSERT INTO probenart (id, probenart, probenart_eudf_id) VALUES (1, 'E', 'A'); 34 INSERT INTO probenart (id, probenart, probenart_eudf_id) VALUES (1, 'E', 'A');
35 INSERT INTO proben_zusatz (id, beschreibung, zusatzwert) 35 INSERT INTO proben_zusatz (id, beschreibung, zusatzwert)
36 VALUES ('A74', 'Volumenstrom', 'VOLSTR'); 36 VALUES ('A74', 'Volumenstrom', 'VOLSTR');
37 INSERT INTO koordinaten_art (id) VALUES (5); 37 INSERT INTO koordinaten_art (id) VALUES (5);
38 INSERT INTO staat (id, staat, hkl_id, staat_iso) 38 INSERT INTO staat (id, staat, hkl_id, staat_iso)
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)