Changes between Version 61 and Version 62 of AdvancedApplicationDevelopment

Timestamp:

08/31/24 02:00:31 (5 months ago)

Author:

184006

Comment:

--

AdvancedApplicationDevelopment

@@ -61 +61 @@
 }}}
 === Тригери
+\\Тригер кој што го искористив за да го пополнам полето date_askes во Blog Post Consultation со моменталниот датум.
+{{{
+CREATE OR REPLACE FUNCTION set_default_date_askes()
+RETURNS TRIGGER AS $$
+BEGIN
+    IF NEW.date_askes IS NULL THEN
+        NEW.date_askes := CURRENT_DATE;
+    END IF;
+    RETURN NEW;
+END;
+$$ LANGUAGE plpgsql;
+
+CREATE TRIGGER before_insert_blogpost
+BEFORE INSERT ON blog_post_for_consultations
+FOR EACH ROW
+EXECUTE FUNCTION set_default_date_askes();
+
+CREATE TRIGGER before_update_blogpost
+BEFORE UPDATE ON blog_post_for_consultations
+FOR EACH ROW
+EXECUTE FUNCTION set_default_date_askes();
+}}}