Mercurial > lada > lada-server
comparison db_schema/audit.sql @ 1325:d3113d594013
Exclude probe/messung foreign keys in audit trail.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Fri, 24 Mar 2017 12:02:06 +0100 |
| parents | 84bb7e2aecb1 |
| children |
comparison
equal
deleted
inserted
replaced
| 1318:6fbfb8f0927a | 1325:d3113d594013 |
|---|---|
| 87 IF audit_row.changed_fields = '{}'::jsonb THEN | 87 IF audit_row.changed_fields = '{}'::jsonb THEN |
| 88 -- All changed fields are ignored. Skip this update. | 88 -- All changed fields are ignored. Skip this update. |
| 89 RETURN NULL; | 89 RETURN NULL; |
| 90 END IF; | 90 END IF; |
| 91 ELSIF (TG_OP = 'INSERT' AND TG_LEVEL = 'ROW') THEN | 91 ELSIF (TG_OP = 'INSERT' AND TG_LEVEL = 'ROW') THEN |
| 92 audit_row.row_data = row_to_json(NEW)::JSONB - excluded_cols; | 92 audit_row.row_data = row_to_json(NEW)::JSONB; |
| 93 audit_row.changed_fields = jsonb_strip_nulls(row_to_json(NEW)::JSONB - excluded_cols); | 93 audit_row.changed_fields = jsonb_strip_nulls(row_to_json(NEW)::JSONB - excluded_cols); |
| 94 ELSE | 94 ELSE |
| 95 RAISE EXCEPTION '[land.if_modified_func] - Trigger func added as trigger for unhandled case: %, %',TG_OP, TG_LEVEL; | 95 RAISE EXCEPTION '[land.if_modified_func] - Trigger func added as trigger for unhandled case: %, %',TG_OP, TG_LEVEL; |
| 96 RETURN NULL; | 96 RETURN NULL; |
| 97 END IF; | 97 END IF; |
| 201 cast(row_data ->> 'messungs_id' AS int) AS messungs_id | 201 cast(row_data ->> 'messungs_id' AS int) AS messungs_id |
| 202 FROM audit_trail; | 202 FROM audit_trail; |
| 203 | 203 |
| 204 | 204 |
| 205 SELECT audit_table('probe', true, false, '{id, tree_modified, letzte_aenderung}'::text[]); | 205 SELECT audit_table('probe', true, false, '{id, tree_modified, letzte_aenderung}'::text[]); |
| 206 SELECT audit_table('messung', true, false, | 206 SELECT audit_table('messung', true, false, '{id, probe_id, tree_modified, letzte_aenderung, status}'::text[]); |
| 207 '{id, tree_modified, letzte_aenderung, status}'::text[]); | 207 SELECT audit_table('messwert', true, false, '{id, messungs_id, tree_modified, letzte_aenderung}'::text[]); |
| 208 SELECT audit_table('messwert', true, false, '{id, tree_modified, letzte_aenderung}'::text[]); | 208 SELECT audit_table('kommentar_p', true, false, '{id, probe_id, tree_modified, letzte_aenderung}'::text[]); |
| 209 SELECT audit_table('kommentar_p', true, false, '{id, tree_modified, letzte_aenderung}'::text[]); | 209 SELECT audit_table('kommentar_m', true, false, '{id, messungs_id, tree_modified, letzte_aenderung}'::text[]); |
| 210 SELECT audit_table('kommentar_m', true, false, '{id, tree_modified, letzte_aenderung}'::text[]); | 210 SELECT audit_table('zusatz_wert', true, false, '{id, probe_id, tree_modified, letzte_aenderung}'::text[]); |
| 211 SELECT audit_table('zusatz_wert', true, false, '{id, tree_modified, letzte_aenderung}'::text[]); | 211 SELECT audit_table('ortszuordnung', true, false, '{id, probe_id, tree_modified, letzte_aenderung}'::text[]); |
| 212 SELECT audit_table('ortszuordnung', true, false, '{id, tree_modified, letzte_aenderung}'::text[]); | |
| 213 | 212 |
| 214 SET search_path TO public; | 213 SET search_path TO public; |