Adds triggers for testing

kiwicopple · w3b6x9 · commit fe5711dd5074 · 2021-07-06T23:32:25.000-04:00
diff --git a/test/postgres/mnt/00-init.sql b/test/postgres/mnt/00-init.sql
@@ -32,3 +32,26 @@ CREATE FUNCTION add(integer, integer) RETURNS integer
     LANGUAGE SQL
     IMMUTABLE
     RETURNS NULL ON NULL INPUT;
+
+create table public.users_audit (
+    id BIGINT generated by DEFAULT as identity,
+    created_at timestamptz DEFAULT now(),
+    user_id bigint,
+    previous_value jsonb
+);
+
+create function public.audit_action()
+returns trigger as $$
+begin
+    insert into public.users_audit (user_id, previous_value)
+    values (old.id, row_to_json(old));
+
+    return new;
+end;
+$$ language plpgsql;
+
+
+CREATE TRIGGER check_update
+BEFORE UPDATE ON users
+FOR EACH ROW
+EXECUTE FUNCTION public.audit_action();
