Removing stewardupdates from the repository.

SimonGoring · SimonGoring · commit 88a65012b207 · 2020-09-28T15:18:31.000-07:00
diff --git a/connect_remote.py b/connect_remote.py
@@ -232,6 +232,7 @@
 
 # This section makes sure that the sequences are reset properly.  We ran into
 # this issue unintentionally during a re-load of the Neotoma data.
+
 cur.execute(open('helpers/reset_sequences.sql', 'r').read())
 cur2 = conn.cursor()
 
diff --git a/function/ts/deletedatasettaxonnotes.sql b/function/ts/deletedatasettaxonnotes.sql
@@ -4,7 +4,4 @@ CREATE OR REPLACE FUNCTION ts.deletedatasettaxonnotes(_datasetid integer, _taxon
 AS $function$
   DELETE FROM ndb.datasettaxonnotes AS dtn
   WHERE dtn.datasetid = _datasetid AND dtn.taxonid = _taxonid;
-
-  INSERT INTO ti.stewardupdates(contactid, tablename, pk1, pk2, operation)
-  values      (_contactid, n'datasettaxonnotes', _datasetid, _taxonid, n'delete');
 $function$
diff --git a/function/ts/updatedatasettaxonnotes.sql b/function/ts/updatedatasettaxonnotes.sql
@@ -9,7 +9,4 @@ AS $function$
   	    date = TO_DATE(_date, 'YYYY-MM-DD'),
   	    notes = _notes
 	WHERE (dtn.datasetid = _datasetid) AND (dtn.taxonid = _taxonid);
-
-  INSERT INTO ti.stewardupdates(contactid, tablename, pk1, pk2, operation, columnname)
-  values      (_contactid, 'datasettaxonnotes', _datasetid, _taxonid, 'update', 'notes')
 $function$
diff --git a/function/ts/updatedatavariable.sql b/function/ts/updatedatavariable.sql
@@ -11,12 +11,4 @@ AS $function$
   SET variableid = _newvariableid
   WHERE dataid = (SELECT dataid FROM dataids);
 
-  WITH dataids AS (
-	SELECT    dsds.dataid
-	FROM      ndb.dsdatasample AS dsds
-	WHERE     (dsds.datasetid = _datasetid) AND (dsds.variableid = _oldvariableid)
-  )
-  INSERT INTO ti.stewardupdates(contactid, tablename,pk1, operation, columnname)
-  SELECT _contactid, 'Data', dids.dataid, 'Update', 'variableid'
-  FROM (SELECT * FROM dataids) AS dids
 $function$
diff --git a/function/ts/updatesite.sql b/function/ts/updatesite.sql
@@ -19,8 +19,6 @@ BEGIN
 	IF oldsitename <> _sitename	THEN
 		UPDATE ndb.sites
 		SET sitename = _sitename WHERE siteid = _siteid;
-		INSERT INTO ti.stewardupdates(contactid, tablename, pk1, operation, columnname)
-		VALUES      (_stewardcontactid, 'sites', _siteid, 'Update', 'sitename');
   	END IF;
 
 	IF ((_north > _south) AND (_east > _west)) THEN
diff --git a/function/ts/updatesitegeopol.sql b/function/ts/updatesitegeopol.sql
@@ -9,8 +9,6 @@ BEGIN
 	IF _sitegeopolid IS NOT NULL THEN
 		UPDATE ndb.sitegeopolitical
 		SET geopoliticalid = _newgeopolid WHERE sitegeopoliticalid = _sitegeopolid;
-		INSERT INTO ti.stewardupdates(contactid, tablename, pk1, operation, columnname)
-		VALUES  (_stewardcontactid, 'sitegeopolitical', _sitegeopolid, 'update', _newgeopolid);
 	END IF;
 
 END;
diff --git a/function/ts/updatesitegeopoldelete.sql b/function/ts/updatesitegeopoldelete.sql
@@ -9,8 +9,6 @@ DECLARE
 BEGIN
 	IF _sitegeopolid IS NOT NULL THEN
     	DELETE FROM ndb.sitegeopolitical WHERE (sitegeopoliticalid = _sitegeopolid);
-    	INSERT INTO ti.stewardupdates(contactid, tablename, pk1, operation)
-    	VALUES  (_stewardcontactid, 'sitegeopolitical', _sitegeopolid, 'delete');
 	END IF;
 
 END;
diff --git a/function/ts/updatesitelatlon.sql b/function/ts/updatesitelatlon.sql
@@ -24,8 +24,6 @@ BEGIN
 	IF (ST_Equals(geo,oldgeo) IS FALSE) THEN
 	    UPDATE ndb.sites
 	    SET    geog = geo::geography WHERE siteid = _siteid;
-	    INSERT INTO ti.stewardupdates(contactid, tablename, pk1, operation, columnname)
-     	VALUES (_stewardcontactid, 'Sites', _siteid, 'Update', 'geog');
 	END IF;
 
 END;
diff --git a/function/ts/updatespecimennisp.sql b/function/ts/updatespecimennisp.sql
@@ -1,14 +1,11 @@
 CREATE OR REPLACE FUNCTION ts.updatespecimennisp(_specimenid integer, _nisp double precision, _contactid integer)
  RETURNS void
  LANGUAGE sql
-AS $function$ 
+AS $function$
 
-UPDATE ndb.specimens
-SET nisp = _nisp
-WHERE specimenid = _specimenid;
-
-INSERT INTO ti.stewardupdates(contactid, tablename, pk1, operation, columnname) 
-VALUES (_contactid, 'Specimens', _specimenid, 'Update', 'NISP')
+  UPDATE ndb.specimens
+  SET nisp = _nisp
+  WHERE specimenid = _specimenid;
 
 
 $function$
diff --git a/function/ts/updatesynonymy.sql b/function/ts/updatesynonymy.sql
@@ -18,7 +18,4 @@ SET      reftaxonid = _reftaxonid,
 	  datesynonymized = _datesynonymized
 WHERE synonymyid = _synonymyid;
 
-INSERT INTO ti.stewardupdates(contactid, tablename, pk1, operation)
-VALUES (_contactid, 'synonymy', _synonymyid, 'update')
-
 $function$
