Changes between Version 75 and Version 76 of AdvancedApplicationDevelopment

Timestamp:

08/31/24 13:53:14 (3 months ago)

Author:

184006

Comment:

--

AdvancedApplicationDevelopment

@@ -179 +179 @@
 
 }}}
+\\ При внес на dateending во Pet Cares се проверува дали е после startdate. Доколку не е полето dateending се пополнува со иста вредност како startdate.
+{{{
+CREATE OR REPLACE FUNCTION set_start_date()
+RETURNS TRIGGER AS $$
+BEGIN
+    IF NEW.start_date IS NULL OR NEW.start_date <> NEW.dateending THEN
+        NEW.start_date := NEW.dateending;
+    END IF;
+    RETURN NEW;
+END;
+$$ LANGUAGE plpgsql;
+
+
+CREATE TRIGGER set_start_date_trigger
+BEFORE INSERT OR UPDATE ON pet_cares
+FOR EACH ROW
+EXECUTE FUNCTION set_start_date();
+}}}