From fefdb26c67d89ff5dfb67b57cd9f29bf4257dffb Mon Sep 17 00:00:00 2001 From: Munyoki Kilyungi Date: Wed, 31 May 2023 19:12:55 +0300 Subject: Default to InfoFiles with the Dataset being a fallback for citations Signed-off-by: Munyoki Kilyungi --- examples/dump-dataset-metadata.scm | 15 ++++++++++++++- 1 file changed, 14 insertions(+), 1 deletion(-) diff --git a/examples/dump-dataset-metadata.scm b/examples/dump-dataset-metadata.scm index 37e0f2a..042c16a 100755 --- a/examples/dump-dataset-metadata.scm +++ b/examples/dump-dataset-metadata.scm @@ -174,7 +174,20 @@ (set gn:experimentDesign (sanitize-rdf-string (field Datasets ExperimentDesign))) (set gn:contributors (sanitize-rdf-string (field Datasets Contributors))) - (set gn:citation (sanitize-rdf-string (field Datasets Citation))) + (set gn:citation + (sanitize-rdf-string + (regexp-substitute/global + #f "^[Nn]one$" + (field + ("CAST(CONVERT(BINARY CONVERT(IFNULL(IF(InfoFiles.Citation = 'None' OR InfoFiles.Citation = '' OR InfoFiles.Citation IS NULL, Datasets.Citation, InfoFiles.Citation), '') USING latin1) USING utf8) AS VARCHAR(1500))" + Citation)) + ""))) + (set gn:dataSourceAcknowledgment + (sanitize-rdf-string + (string-trim-both + (regexp-substitute/global #f "^[Nn]one$" + (field InfoFiles Data_Source_Acknowledge) + "")))) (set gn:acknowledgment (sanitize-rdf-string (field Datasets Acknowledgment))))) -- cgit v1.2.3