aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMunyoki Kilyungi2023-05-31 19:14:01 +0300
committerBonfaceKilz2023-06-12 19:06:36 +0300
commitad236987b1b320ed649a589ab228d91700b56038 (patch)
tree9ea78af414600a496a8130f7c31d30f373f5c18b
parentfefdb26c67d89ff5dfb67b57cd9f29bf4257dffb (diff)
downloadgn-transform-databases-ad236987b1b320ed649a589ab228d91700b56038.tar.gz
Remove "^[Nn]one$" from some fields from the InfoFiles table
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
-rwxr-xr-xexamples/dump-dataset-metadata.scm11
1 files changed, 9 insertions, 2 deletions
diff --git a/examples/dump-dataset-metadata.scm b/examples/dump-dataset-metadata.scm
index 042c16a..56efcf2 100755
--- a/examples/dump-dataset-metadata.scm
+++ b/examples/dump-dataset-metadata.scm
@@ -131,7 +131,10 @@
(set rdf:type (string->symbol
(field ("IF(GenoFreeze.Id IS NOT NULL, 'gn:genotypeDataset', IF(PublishFreeze.Id IS NOT NULL, 'gn:phenotypeDataset', 'gn:dataset'))"
rdfType))))
- (set gn:name (field InfoFiles InfoPageName))
+ (set gn:name (regexp-substitute/global
+ #f "^[Nn]one$"
+ (field InfoFiles InfoPageName)
+ ""))
(set dct:created
(field ("IFNULL(GenoFreeze.CreateTime, IFNULL(PublishFreeze.CreateTime, IFNULL(ProbeSetFreeze.CreateTime, '')))"
createTimeGenoFreeze)))
@@ -163,7 +166,11 @@
(and (not (string-prefix-ci? "no geo series"
(field Datasets GeoSeries)))
(field Datasets GeoSeries)))
- (set gn:title (field InfoFiles Title))
+ (set gn:title
+ (regexp-substitute/global
+ #f "^[Nn]one$"
+ (field InfoFiles Title)
+ ""))
(set gn:specifics (sanitize-rdf-string (field InfoFiles Specifics)))
(set gn:datasetGroup (field Datasets DatasetName DatasetGroup))
(set gn:aboutCases (sanitize-rdf-string (field Datasets AboutCases)))