Mercurial > lada > lada-server
comparison src/test/resources/datasets/clean_and_seed.sql @ 977:aba3a5384c69
Use a minimal set of master data based on empty database for tests.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Tue, 14 Jun 2016 18:30:41 +0200 |
| parents | |
| children | 1da90ad6b35f |
comparison
equal
deleted
inserted
replaced
| 976:01ce190079e5 | 977:aba3a5384c69 |
|---|---|
| 1 SET search_path TO stammdaten; | |
| 2 | |
| 3 -- minimal master data to make interface tests runnable | |
| 4 DELETE FROM auth; | |
| 5 DELETE FROM ort; | |
| 6 DELETE FROM ort_typ; | |
| 7 DELETE FROM pflicht_messgroesse; | |
| 8 DELETE FROM datenbasis; | |
| 9 DELETE FROM mess_einheit; | |
| 10 DELETE FROM messgroesse; | |
| 11 DELETE FROM mess_methode; | |
| 12 DELETE FROM datensatz_erzeuger; | |
| 13 DELETE FROM mess_stelle; | |
| 14 DELETE FROM probenehmer; | |
| 15 DELETE FROM messprogramm_kategorie; | |
| 16 DELETE FROM netz_betreiber; | |
| 17 DELETE FROM probenart; | |
| 18 DELETE FROM proben_zusatz; | |
| 19 DELETE FROM koordinaten_art; | |
| 20 DELETE FROM staat; | |
| 21 DELETE FROM umwelt; | |
| 22 DELETE FROM verwaltungseinheit; | |
| 23 | |
| 24 -- seed | |
| 25 -- minimal master data to make interface tests runnable | |
| 26 INSERT INTO ort_typ (id) VALUES (1); | |
| 27 INSERT INTO datenbasis (id) VALUES (9); | |
| 28 INSERT INTO mess_einheit (id) VALUES (207); | |
| 29 INSERT INTO messgroesse (id, messgroesse) VALUES (56, 'Mangan'); | |
| 30 INSERT INTO mess_methode (id) VALUES ('GI'); | |
| 31 INSERT INTO netz_betreiber (id) VALUES ('06'); | |
| 32 INSERT INTO mess_stelle (id, netzbetreiber_id) VALUES ('06010', '06'); | |
| 33 INSERT INTO pflicht_messgroesse (id, datenbasis_id) VALUES (33, 9); | |
| 34 INSERT INTO probenart (id, probenart, probenart_eudf_id) VALUES (1, 'E', 'A'); | |
| 35 INSERT INTO proben_zusatz (id, beschreibung, zusatzwert) | |
| 36 VALUES ('A74', 'Volumenstrom', 'VOLSTR'); | |
| 37 INSERT INTO koordinaten_art (id) VALUES (5); | |
| 38 INSERT INTO staat (id, staat, hkl_id, staat_iso) | |
| 39 VALUES (0, 'Deutschland', 0, 'DE'); | |
| 40 INSERT INTO umwelt (id, umwelt_bereich) VALUES ('L6', 'Spurenmessung Luft'); | |
| 41 INSERT INTO verwaltungseinheit ( | |
| 42 id, bundesland, bezeichnung, | |
| 43 is_bundesland, is_gemeinde, is_landkreis, is_regbezirk) | |
| 44 VALUES ('11000000', '11000000', 'Berlin', 1, 1, 1, 0); | |
| 45 | |
| 46 -- authorization data needed for tests | |
| 47 INSERT INTO auth (ldap_group, netzbetreiber_id, mst_id, funktion_id) | |
| 48 VALUES ('mst_06_status', '06', '06010', 1); | |
| 49 INSERT INTO auth (ldap_group, netzbetreiber_id, funktion_id) | |
| 50 VALUES ('land_06_stamm', '06', 4); |