summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-07-18 20:53:23 +0200
committerYorhel <git@yorhel.nl>2009-07-18 20:53:23 +0200
commit4df0638b6f615489bd946c03753b3bbe0269e3b2 (patch)
tree4c2ede71b3902d9f4b6a9df7d32479107ba12681 /util
parentae53633780260b152a105c83fb4a7a72cd82d33b (diff)
Notify Multi::Image for new cover images via LISTEN/NOTIFY
Yay! Another weird shared-memory-command optimized away. And the image resizer reacts a lot faster now. Noticably, even.
Diffstat (limited to 'util')
-rw-r--r--util/dump.sql13
-rw-r--r--util/updates/update_2.6.sql13
2 files changed, 26 insertions, 0 deletions
diff --git a/util/dump.sql b/util/dump.sql
index 6c08b1b4..583212cd 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -713,6 +713,19 @@ $$ LANGUAGE plpgsql;
CREATE TRIGGER anime_fetch_notify AFTER INSERT OR UPDATE ON anime FOR EACH ROW EXECUTE PROCEDURE anime_fetch_notify();
+-- Send a notify when a new cover image is uploaded
+CREATE OR REPLACE FUNCTION vn_rev_image_notify() RETURNS trigger AS $$
+BEGIN
+ IF NEW.image < 0 THEN
+ NOTIFY coverimage;
+ END IF;
+ RETURN NULL;
+END;
+$$ LANGUAGE plpgsql;
+
+CREATE TRIGGER vn_rev_image_notify AFTER INSERT OR UPDATE ON vn_rev FOR EACH ROW EXECUTE PROCEDURE vn_rev_image_notify();
+
+
diff --git a/util/updates/update_2.6.sql b/util/updates/update_2.6.sql
index 28f82420..8cd0962a 100644
--- a/util/updates/update_2.6.sql
+++ b/util/updates/update_2.6.sql
@@ -61,3 +61,16 @@ $$ LANGUAGE plpgsql;
CREATE TRIGGER anime_fetch_notify AFTER INSERT OR UPDATE ON anime FOR EACH ROW EXECUTE PROCEDURE anime_fetch_notify();
+
+-- Send a notify when a new cover image is uploaded
+CREATE OR REPLACE FUNCTION vn_rev_image_notify() RETURNS trigger AS $$
+BEGIN
+ IF NEW.image < 0 THEN
+ NOTIFY coverimage;
+ END IF;
+ RETURN NULL;
+END;
+$$ LANGUAGE plpgsql;
+
+CREATE TRIGGER vn_rev_image_notify AFTER INSERT OR UPDATE ON vn_rev FOR EACH ROW EXECUTE PROCEDURE vn_rev_image_notify();
+