Changeset 679 for trunk/cgi-bin

Timestamp:

01/19/15 18:09:59 (10 years ago)

Author:

Kris Deugau

Message:

/trunk

• Add a bit more detail to a couple of docucomments in db-update.pl
• Drop and recreate the modtime trigger on the allocations table when doing the database update. This preserves the *real* modtimes, instead of generating an entirely artificial one that has nothing to do with changes in the actual IP assignment data.

File:

• trunk/cgi-bin/db-update.pl (modified) (3 diffs)

trunk/cgi-bin/db-update.pl

@@ -8 +8 @@
 use MyIPDB;
 
-# run the tabledef update first
+# run the tabledef update first.  This is "safe";  IPDB < 3.0 can still happily munch away at it.
 print qx { PGPASSWORD=ipdbpwd psql -h localhost -U ipdb ipdb <ipdb-2.7-3.0.sql };
 
@@ -60 +60 @@
         " WHERE id = ?");
 
+  # Need to disable the update trigger on the allocations table, so we don't mangle the real mtimes on the data.
+  $dbh->do("DROP TRIGGER up_modtime ON allocations");
+
   $getm->execute;
   while (my ($master,$mctime,$mmtime,$mswip) = $getm->fetchrow_array()) {
@@ -110 +113 @@
     # weesa gotsa BIIIIG job, gotta fetch all the current rDNS.  note this relies
     # on having had the DNS data imported and munged into the new pseudotypes.
+    # ... never mind.  this will be opportunistic, since DNS data isn't viewed
+    # unless adding (not present, we should hope!) or updating (where it should
+    # be retrieved from the authoritative API in real time)
   }
+
+  # Recreate modtime trigger on allocations, now that we're done monkeying with it.
+  $dbh->do("CREATE TRIGGER up_modtime BEFORE UPDATE ON allocations FOR EACH ROW EXECUTE PROCEDURE up_modtime()");
 
   $dbh->commit;