Straightforward ts functions for chroncontrols.

SimonGoring · SimonGoring · commit 25ac8bcd5c07 · 2020-10-23T17:23:37.000-07:00
diff --git a/function/ts/updatechroncontrolage.sql b/function/ts/updatechroncontrolage.sql
@@ -0,0 +1,8 @@
+CREATE OR REPLACE FUNCTION ts.updatechroncontrolage(_chroncontrolid integer, _age float DEFAULT NULL)
+ RETURNS void
+ LANGUAGE sql
+AS $function$
+  UPDATE ndb.chroncontrols
+  SET    age = _age
+  WHERE  chroncontrolid = _chroncontrolid
+$function$
diff --git a/function/ts/updatechroncontrolageolder.sql b/function/ts/updatechroncontrolageolder.sql
@@ -0,0 +1,8 @@
+CREATE OR REPLACE FUNCTION ts.updatechroncontrolageolder(_chroncontrolid integer, _agelimitolder float DEFAULT NULL)
+ RETURNS void
+ LANGUAGE sql
+AS $function$
+  UPDATE ndb.chroncontrols
+  SET    agelimitolder = _agelimitolder
+  WHERE  chroncontrolid = _chroncontrolid
+$function$
diff --git a/function/ts/updatechroncontrolagetype.sql b/function/ts/updatechroncontrolagetype.sql
@@ -0,0 +1,8 @@
+CREATE OR REPLACE FUNCTION ts.updatechroncontrolagetype(_chroncontrolid integer, _agetypeid integer)
+ RETURNS void
+ LANGUAGE sql
+AS $function$
+  UPDATE ndb.chroncontrols
+  SET    agetypeid = _agetypeid
+  WHERE  chroncontrolid = _chroncontrolid
+$function$
diff --git a/function/ts/updatechroncontrolageyounger.sql b/function/ts/updatechroncontrolageyounger.sql
@@ -0,0 +1,8 @@
+CREATE OR REPLACE FUNCTION ts.updatechroncontrolageyounger(_chroncontrolid integer, _ageyounger float DEFAULT NULL)
+ RETURNS void
+ LANGUAGE sql
+AS $function$
+  UPDATE ndb.chroncontrols
+  SET    agelimityounger = _ageyounger
+  WHERE  chroncontrolid = _chroncontrolid
+$function$
diff --git a/function/ts/updatechroncontrolevent.sql b/function/ts/updatechroncontrolevent.sql
@@ -0,0 +1,12 @@
+CREATE OR REPLACE FUNCTION ts.updatechroncontrolevent(_chroncontrolid int, _eventid int, _analysisunitid int = null)
+ RETURNS void
+ LANGUAGE sql
+AS $function$
+  INSERT INTO ndb.eventchronology
+    (analysisunitid, eventid, chroncontrolid)
+  VALUES (_analysisunitid, _eventid, _chroncontrolid)
+  ON CONFLICT ON CONSTRAINT uniqueeventset
+  DO UPDATE
+    SET   analysisunitid = _analysisunitid, eventid = _eventid, chroncontrolid = _chroncontrolid, notes = null
+  WHERE ndb.eventchronology.eventchronologyid = (SELECT ec.eventchronologyid FROM ndb.eventchronology AS ec WHERE (chroncontrolid = _chroncontrolid))
+$function$
diff --git a/function/ts/updatechroncontrolnotes.sql b/function/ts/updatechroncontrolnotes.sql
@@ -0,0 +1,8 @@
+CREATE OR REPLACE FUNCTION ts.updatechroncontrolnotes(_chroncontrolid integer, _notes CHARACTER VARYING DEFAULT NULL)
+ RETURNS void
+ LANGUAGE sql
+AS $function$
+  UPDATE ndb.chroncontrols
+  SET    notes = _notes
+  WHERE  chroncontrolid = _chroncontrolid
+$function$
