Changes between Version 13 and Version 14 of AdvancedApplicationDevelopment

Timestamp:

07/19/24 19:37:54 (2 months ago)

Author:

211012

Comment:

--

AdvancedApplicationDevelopment

@@ -559 +559 @@
     }
 }}}
+Алтернативно истото ова може да се изведе и преку тригер, директно во базата
+{{{#!sql
+CREATE OR REPLACE FUNCTION trg_insert_korisnicki_profil()
+RETURNS TRIGGER AS $$
+BEGIN
+    INSERT INTO public.korisnicki_profil (g_id, kp_korisnicko_ime, kp_lozinka, kp_uloga, is_admin, is_committee, is_super_admin)
+    SELECT 
+        NEW.g_id, 
+        gr.ime || '.' || gr.prezime kp_korisnicko_ime,
+        gr.embg kp_lozinka,
+        'COMMITTEE' kp_uloga,
+        FALSE is_admin,
+        TRUE is_committee,
+        FALSE is_super_admin
+    FROM public.gragjani gr
+    WHERE gr.g_id = NEW.g_id;
+
+    RETURN NEW;
+END;
+$$ LANGUAGE plpgsql;
+
+CREATE TRIGGER trg_nov_clen_komisija
+AFTER INSERT ON public.clenovi_na_komisija
+FOR EACH ROW
+EXECUTE FUNCTION trg_insert_korisnicki_profil();
+}}}