Changeset 1186 for trunk/LATMOS-Accounts/bin/la-sql-upgrade.in

Timestamp:

10/30/12 09:45:25 (12 years ago)

Author:

nanardon

Message:

add managedAlsoBy attribute to group

File:

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

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

@@ -203 +203 @@
         ],
     },
+    {
+        ver => 7,
+        sql => [
+            q{
+            CREATE OR REPLACE FUNCTION group_sort_fields()
+              RETURNS trigger AS
+              $BODY$BEGIN
+
+              IF (TG_OP='INSERT') then
+              IF (new.attr='managedBy'
+                  OR  new.attr='managedAlsoBy'
+                  OR  new.attr='member'
+                  OR  new.attr='memberUID') THEN
+              insert into group_attributes_users VALUES (new.*);
+              RETURN NULL;
+              END IF;
+
+              IF (new.attr='sutype') THEN
+              insert into group_attributes_sutypes VALUES (new.*);
+              RETURN NULL;
+              END IF;
+              end if;
+
+
+              IF (TG_OP = 'UPDATE') THEN
+              IF (new.attr='gidNumber') then
+              update "group" set gidnumber = new.value::integer where
+              "group".ikey = new.okey;
+              RETURN NULL;
+              END IF;
+              END IF;
+
+              IF (TG_OP = 'DELETE') THEN
+              IF (old.attr='exported') then
+              update "group" set exported = false where "group".ikey = old.okey;
+              return null;
+              end if;
+              else
+              IF (new.attr='exported') then
+              update "group" set exported = true where "group".ikey = new.okey;
+              RETURN NULL;
+              end if;
+              END IF;
+
+              if (TG_OP='DELETE') THEN
+              RETURN old;
+              else
+              RETURN new;
+              end if;
+              END;$BODY$
+                LANGUAGE plpgsql VOLATILE
+                  COST 100;
+            },
+        ],
+    },
+
 );