Mercurial > lada > lada-server
view src/test/resources/datasets/clean_and_seed.sql @ 1161:ea6b062e5305 pgaudit
Use pgaudit to generate an audit trail.
Upgrade to PostgreSQL 9.5 because it is a requirement for pgaudit.
pgaudit/analyze can be used to transfer the audit trail into the
database, but it seems to be easy to do this with pgaudit directly
with some changes to the code.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Tue, 08 Nov 2016 19:21:24 +0100 |
parents | 186d602e031a |
children | 93918aca306e |
line wrap: on
line source
SET search_path TO stammdaten; -- cleanup DELETE FROM auth; DELETE FROM ort; DELETE FROM ort_typ; DELETE FROM pflicht_messgroesse; DELETE FROM datenbasis; DELETE FROM mess_einheit; DELETE FROM messgroesse; DELETE FROM mess_methode; DELETE FROM datensatz_erzeuger; DELETE FROM mess_stelle; DELETE FROM probenehmer; DELETE FROM messprogramm_kategorie; DELETE FROM netz_betreiber; DELETE FROM probenart; DELETE FROM proben_zusatz; DELETE FROM koordinaten_art; DELETE FROM staat; DELETE FROM umwelt; DELETE FROM verwaltungseinheit; -- seed -- minimal master data to make interface tests runnable INSERT INTO ort_typ (id) VALUES (1); INSERT INTO datenbasis (id) VALUES (9); INSERT INTO mess_einheit (id) VALUES (207); INSERT INTO mess_einheit (id) VALUES (208); INSERT INTO messgroesse (id, messgroesse) VALUES (56, 'Mangan'); INSERT INTO messgroesse (id, messgroesse) VALUES (57, 'Mangan'); INSERT INTO mess_methode (id) VALUES ('A3'); INSERT INTO netz_betreiber (id) VALUES ('06'); INSERT INTO mess_stelle (id, netzbetreiber_id) VALUES ('06010', '06'); INSERT INTO pflicht_messgroesse (id, mmt_id, datenbasis_id) VALUES (33, 'A3', 9); INSERT INTO probenart (id, probenart, probenart_eudf_id) VALUES (1, 'E', 'A'); INSERT INTO probenart (id, probenart, probenart_eudf_id) VALUES (2, 'S', 'B'); INSERT INTO proben_zusatz (id, beschreibung, zusatzwert) VALUES ('A74', 'Volumenstrom', 'VOLSTR'); INSERT INTO proben_zusatz (id, beschreibung, zusatzwert) VALUES ('A75', 'Volumenstrom', 'VOLSTR'); INSERT INTO proben_zusatz (id, beschreibung, zusatzwert) VALUES ('A76', 'Volumenstrom', 'VOLSTR'); INSERT INTO koordinaten_art (id) VALUES (5); INSERT INTO staat (id, staat, hkl_id, staat_iso) VALUES (0, 'Deutschland', 0, 'DE'); INSERT INTO umwelt (id, umwelt_bereich) VALUES ('L6', 'Spurenmessung Luft'); INSERT INTO umwelt (id, umwelt_bereich) VALUES ('A6', 'Umweltbereich für test'); INSERT INTO verwaltungseinheit ( id, bundesland, bezeichnung, is_bundesland, is_gemeinde, is_landkreis, is_regbezirk) VALUES ('11000000', '11000000', 'Berlin', 1, 1, 1, 0); INSERT INTO probenehmer ( id, netzbetreiber_id, prn_id, bezeichnung, kurz_bezeichnung) VALUES (726, '06', 'prn', 'test', 'test'); -- authorization data needed for tests INSERT INTO auth (ldap_group, netzbetreiber_id, mst_id, funktion_id) VALUES ('mst_06_status', '06', '06010', 1); INSERT INTO auth (ldap_group, netzbetreiber_id, funktion_id) VALUES ('land_06_stamm', '06', 4);