Reverting an accidental change to the doi.freeze function.

SimonGoring · SimonGoring · commit ff64762cbf88 · 2021-12-08T11:58:26.000-08:00
It was accidentally overwritten by doi.doiapi().
diff --git a/function/doi/doifreeze.sql b/function/doi/doifreeze.sql
@@ -1,5 +1,5 @@
-CREATE OR REPLACE FUNCTION doi.doiapi(dsid integer[])
- RETURNS TABLE(dataset jsonb)
+CREATE OR REPLACE FUNCTION doi.doifreeze(dsid integer[])
+ RETURNS TABLE(datasetid integer, record json)
  LANGUAGE sql
 AS $function$
 WITH chronmeta AS (
@@ -14,11 +14,12 @@ ids AS (
 datameta AS (
   SELECT * FROM doi.ndbdata(dsid)
 )
-SELECT jsonb_build_object(   'datasetid', ids.dsid,
-	                      'chronologies', chr.chronologies,
-	                              'data', dt.data) AS dataset
+SELECT ids.dsid AS datasetid,
+			 json_strip_nulls(json_build_object('chronologies', jsonb_build_object('chronologies', chr.chronologies),
+															'data', dt.data)) AS record
 FROM
 	datameta  AS dt
 	JOIN chronmeta AS chr ON dt.datasetid = chr.datasetid
 											JOIN ids AS ids ON ids.dsid = dt.datasetid
-$function$;
+
+$function$
