Notify Multi::Image via PostgreSQL for new screenshots

This finished the rewrite of Multi::Image and everything surrounding it.

1 files changed, 14 insertions, 0 deletions

diff --git a/util/updates/update_2.6.sql b/util/updates/update_2.6.sql
index a2fa5b32..723e7c57 100644
--- a/util/updates/update_2.6.sql
+++ b/util/updates/update_2.6.sql
@@ -83,3 +83,17 @@ $$ LANGUAGE plpgsql;
 
 CREATE TRIGGER vn_rev_image_notify AFTER INSERT OR UPDATE ON vn_rev FOR EACH ROW EXECUTE PROCEDURE vn_rev_image_notify();
 
+
+-- Send a notify when a screenshot needs to be processed
+CREATE OR REPLACE FUNCTION screenshot_process_notify() RETURNS trigger AS $$
+BEGIN
+  IF NEW.processed = FALSE THEN
+    NOTIFY screenshot;
+  END IF;
+  RETURN NULL;
+END;
+$$ LANGUAGE plpgsql;
+
+CREATE TRIGGER screenshot_process_notify AFTER INSERT OR UPDATE ON screenshots FOR EACH ROW EXECUTE PROCEDURE screenshot_process_notify();
+
+