diff options
| author | Munyoki Kilyungi | 2023-05-26 08:37:29 +0300 |
|---|---|---|
| committer | BonfaceKilz | 2023-05-26 08:40:22 +0300 |
| commit | 37a294839a66615e8d6967e06034ae3020caf0e6 (patch) | |
| tree | c8573822785d9b06469a5b5c1fd1cf289d2265e5 | |
| parent | 7982647f5d2f9f1752f7b777de4b5b65f8a3248f (diff) | |
| download | gn-transform-databases-37a294839a66615e8d6967e06034ae3020caf0e6.tar.gz | |
Use a phenotype's abbreviation as it's name
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
| -rwxr-xr-x | examples/dump-phenotype.scm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/examples/dump-phenotype.scm b/examples/dump-phenotype.scm index 5f8cd94..0b46a14 100755 --- a/examples/dump-phenotype.scm +++ b/examples/dump-phenotype.scm @@ -61,8 +61,8 @@ (set rdf:type 'gn:phenotype) (set gn:name (sanitize-rdf-string (field - ("CAST(CONVERT(BINARY CONVERT(CONCAT(IF(PublishFreeze.Name IS NULL, '', CONCAT(PublishFreeze.Name, '-')), IF(Phenotype.Post_publication_abbreviation IS NULL, IF(Phenotype.Pre_publication_abbreviation IS NULL, Phenotype.Id, Phenotype.Pre_publication_abbreviation), Phenotype.Post_publication_abbreviation)) USING latin1) USING utf8) AS VARCHAR(10000))" - abbrev)))) + ("CAST(CONVERT(BINARY CONVERT(IF(Phenotype.Post_publication_abbreviation IS NULL, IF(Phenotype.Pre_publication_abbreviation IS NULL, Phenotype.Id, Phenotype.Pre_publication_abbreviation), Phenotype.Post_publication_abbreviation) USING latin1) USING utf8) AS VARCHAR(100))" + PhenotypeName)))) ;; There is no row with an empty post-publication description so ;; use this field as the main publication description (set gn:publicationDescription |