summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2013-01-05 13:06:18 +0100
committerYorhel <git@yorhel.nl>2013-01-05 13:06:18 +0100
commit5fb01aeb58c77d2abda4e11d72be2217215a0ce5 (patch)
tree5d59608330ebb3879b9183cbe239d356aa13151f /util
parenta208fac4225ab8775a57c72eca0f042ee743b7bc (diff)
Don't use Multi for processing VN cover images
I used to do this to avoid loading Image::Magick in each TUWF process, decreasing memory usage, and lowering the blocking time by avoiding too much processing. Memory isn't much of a problem nowadays, and processing images is fast enough, too, so this complexity isn't necessary anymore. (Character images and screenshots pending)
Diffstat (limited to 'util')
-rw-r--r--util/sql/all.sql1
-rw-r--r--util/sql/func.sql7
-rw-r--r--util/updates/update_2.23.sql6
3 files changed, 6 insertions, 8 deletions
diff --git a/util/sql/all.sql b/util/sql/all.sql
index 68739776..94e8bf41 100644
--- a/util/sql/all.sql
+++ b/util/sql/all.sql
@@ -64,7 +64,6 @@ CREATE TRIGGER vn_anime_aid_edit BEFORE UPDATE ON vn_anime
CREATE TRIGGER anime_fetch_notify AFTER INSERT OR UPDATE ON anime FOR EACH ROW WHEN (NEW.lastfetch IS NULL) EXECUTE PROCEDURE anime_fetch_notify();
-CREATE TRIGGER vn_rev_image_notify AFTER INSERT OR UPDATE ON vn_rev FOR EACH ROW WHEN (NEW.image < 0) EXECUTE PROCEDURE vn_rev_image_notify();
CREATE TRIGGER chars_rev_image_notify AFTER INSERT OR UPDATE ON chars_rev FOR EACH ROW WHEN (NEW.image < 0) EXECUTE PROCEDURE chars_rev_image_notify();
CREATE TRIGGER screenshot_process_notify AFTER INSERT OR UPDATE ON screenshots FOR EACH ROW WHEN (NEW.processed = FALSE) EXECUTE PROCEDURE screenshot_process_notify();
diff --git a/util/sql/func.sql b/util/sql/func.sql
index e5be2fde..261ce9ad 100644
--- a/util/sql/func.sql
+++ b/util/sql/func.sql
@@ -603,13 +603,6 @@ $$ LANGUAGE plpgsql;
--- Send a notify when a new cover image is uploaded
-CREATE OR REPLACE FUNCTION vn_rev_image_notify() RETURNS trigger AS $$
- BEGIN NOTIFY coverimage; RETURN NULL; END;
-$$ LANGUAGE plpgsql;
-
-
-
-- Send a notify when a new character image is uploaded
CREATE OR REPLACE FUNCTION chars_rev_image_notify() RETURNS trigger AS $$
BEGIN NOTIFY charimage; RETURN NULL; END;
diff --git a/util/updates/update_2.23.sql b/util/updates/update_2.23.sql
index 4464053c..1846593d 100644
--- a/util/updates/update_2.23.sql
+++ b/util/updates/update_2.23.sql
@@ -52,3 +52,9 @@ UPDATE vn SET c_rating = (SELECT (
ALTER TYPE prefs_key ADD VALUE 'vn_list_own' AFTER 'notify_announce';
ALTER TYPE prefs_key ADD VALUE 'vn_list_wish' AFTER 'vn_list_own';
+
+
+-- Image processing doesn't happen via Multi anymore, so no more notifications
+
+DROP TRIGGER vn_rev_image_notify ON vn_rev;
+DROP FUNCTION vn_rev_image_notify();