diff options
author | Yorhel <git@yorhel.nl> | 2009-07-18 20:53:23 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2009-07-18 20:53:23 +0200 |
commit | 4df0638b6f615489bd946c03753b3bbe0269e3b2 (patch) | |
tree | 4c2ede71b3902d9f4b6a9df7d32479107ba12681 /util | |
parent | ae53633780260b152a105c83fb4a7a72cd82d33b (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.sql | 13 | ||||
-rw-r--r-- | util/updates/update_2.6.sql | 13 |
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(); + |