Changes between Version 5 and Version 6 of AdvancedTopics

Timestamp:

06/11/26 10:38:30 (5 days ago)

Author:

231035

Comment:

--

AdvancedTopics

@@ -260 +260 @@
 USING hnsw (embedding vector_cosine_ops);
 }}}
+=== Trigger for bookings
+{{{
+CREATE OR REPLACE FUNCTION trg_refresh_profile_after_booking()
+RETURNS trigger
+LANGUAGE plpgsql
+AS $$
+DECLARE
+    v_user_id BIGINT;
+BEGIN
+    SELECT g.user_id
+    INTO v_user_id
+    FROM guests g
+    WHERE g.guest_id = NEW.guest_id;
+
+    IF NEW.booking_status IN ('CONFIRMED', 'COMPLETED') THEN
+        PERFORM refresh_user_recommendation_profile(v_user_id);
+    END IF;
+
+    RETURN NEW;
+END;
+$$;
+
+CREATE TRIGGER after_booking_refresh_recommendation_profile
+AFTER INSERT OR UPDATE OF booking_status
+ON bookings
+FOR EACH ROW
+EXECUTE FUNCTION trg_refresh_profile_after_booking();
+}}}