Implemented relgraph notify from PgSQL trigger

This finishes the new relation graph generator, as it'll now regenerate
graphs as soon as is needed.
This obsletes the VNDB::Util::Misc::vnCacheUpdate() function, this
functionality is provided by triggers within PostgreSQL.

The update_vncache(0) procedure is now significantly slower due to the
trigger on the vn table. It'd be a good idea to rewrite this procedure
by using triggers and conditional updates, to drastically lower the number
of rows that need to be updated.

1 files changed, 2 insertions, 20 deletions

diff --git a/lib/VNDB/Util/Misc.pm b/lib/VNDB/Util/Misc.pm
index 139eb571..f4eb5a7c 100644
--- a/lib/VNDB/Util/Misc.pm
+++ b/lib/VNDB/Util/Misc.pm
@@ -6,7 +6,7 @@ use warnings;
 use Exporter 'import';
 use Tie::ShareLite ':lock';
 
-our @EXPORT = qw|multiCmd vnCacheUpdate|;
+our @EXPORT = qw|multiCmd|;
 
 
 # Sends a command to Multi
@@ -28,23 +28,5 @@ sub multiCmd {
 }
 
 
-# Recalculates the vn.c_* columns and regenerates the related relation graphs on any change
-# Arguments: list of vids to be updated
-sub vnCacheUpdate {
-  my($self, @vns) = @_;
-
-  my $before = $self->dbVNGet(id => \@vns, order => 'v.id', what => 'relations');
-  $self->dbVNCache(@vns);
-  my $after = $self->dbVNGet(id => \@vns, order => 'v.id');
-
-  my @upd = map {
-    @{$before->[$_]{relations}} && (
-      $before->[$_]{c_released} != $after->[$_]{c_released}
-      || $before->[$_]{c_languages} ne $after->[$_]{c_languages}
-    ) ? $before->[$_]{id} : ();
-  } 0..$#$before;
-  $self->multiCmd('relgraph '.join(' ', @upd)) if @upd;
-}
-
-
 1;
+