diff options
author | Yorhel <git@yorhel.nl> | 2009-12-05 18:29:53 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2009-12-05 18:32:47 +0100 |
commit | 9aa6f31f9a800157dd6899e3b237316890e2872f (patch) | |
tree | d34f43d4bf96dd62182ce470f14c1fd12c333e2f /util/updates | |
parent | f8becca564556989db2973577336ea3fb8f5fd7e (diff) |
SQL: Call update_vncache() in a trigger
This removes the need for the dbVNCache() function in perl.
Diffstat (limited to 'util/updates')
-rw-r--r-- | util/updates/update_2.10.sql | 17 |
1 files changed, 16 insertions, 1 deletions
diff --git a/util/updates/update_2.10.sql b/util/updates/update_2.10.sql index c2437136..e034b6e8 100644 --- a/util/updates/update_2.10.sql +++ b/util/updates/update_2.10.sql @@ -92,7 +92,7 @@ CREATE TRIGGER vn_relgraph_notify AFTER UPDATE ON vn FOR EACH ROW EXECUTE PROCED DROP TRIGGER vn_relgraph_notify ON producers; -CREATE OR REPLACE FUNCTION vn_relgraph_notify() RETURNS trigger AS $$ +CREATE OR REPLACE FUNCTION producer_relgraph_notify() RETURNS trigger AS $$ BEGIN -- 1. IF NEW.rgraph IS DISTINCT FROM OLD.rgraph OR NEW.latest IS DISTINCT FROM OLD.latest THEN @@ -167,3 +167,18 @@ CREATE OR REPLACE FUNCTION update_vncache(integer) RETURNS void AS $$ $$ LANGUAGE sql; +-- call update_vncache() when a release is added, edited, hidden or unhidden +CREATE OR REPLACE FUNCTION release_vncache_update() RETURNS trigger AS $$ +BEGIN + IF OLD.latest IS DISTINCT FROM NEW.latest OR OLD.hidden IS DISTINCT FROM NEW.hidden THEN + PERFORM update_vncache(vid) FROM ( + SELECT DISTINCT vid FROM releases_vn WHERE rid = OLD.latest OR rid = NEW.latest + ) AS v(vid); + END IF; + RETURN NULL; +END; +$$ LANGUAGE plpgsql; + +CREATE TRIGGER release_vncache_update AFTER UPDATE ON releases FOR EACH ROW EXECUTE PROCEDURE release_vncache_update(); + + |