Changeset 1391

Timestamp:

08/18/15 11:48:52 (9 years ago)

Author:

nanardon

Message:

Adding trigger on to trigger user sync on aliases update

File:

• trunk/LATMOS-Accounts/bin/la-sql-upgrade.in (modified) (1 diff)

trunk/LATMOS-Accounts/bin/la-sql-upgrade.in

@@ -584 +584 @@
             FROM "user"
             WHERE ("user".expire IS NOT NULL and "user".expire <= now()) or "user".exported = false; 
-            }
+            },
+            q{
+            CREATE OR REPLACE FUNCTION rev_tg_aliases_f()
+            RETURNS trigger AS
+            $BODY$begin
+
+            IF (TG_OP = 'DELETE') THEN
+            update "user" set rev = nextval('revisions_rev_seq'::regclass), "date" = now() where "name" = ANY (old.forward);
+            return old;
+            ELSE
+                IF (TG_OP = 'UPDATE') THEN
+                update "user" set rev = nextval('revisions_rev_seq'::regclass), "date" = now() where "name" = ANY (old.forward);
+                END IF;
+            update "user" set rev = nextval('revisions_rev_seq'::regclass), "date" = now() where "name" = ANY (new.forward);
+            return new;
+            END IF;
+
+            end;$BODY$
+            LANGUAGE plpgsql VOLATILE
+            COST 100;
+
+            CREATE TRIGGER aliases_user_tg
+            AFTER INSERT OR UPDATE OR DELETE
+            ON aliases
+            FOR EACH ROW
+            EXECUTE PROCEDURE rev_tg_aliases_f();
+            },
         ],
     }