diff options
| author | Munyoki Kilyungi | 2023-06-06 14:41:05 +0300 |
|---|---|---|
| committer | BonfaceKilz | 2023-06-12 19:06:36 +0300 |
| commit | 672e902bfede56e952ca006fd2d8745de637f4ba (patch) | |
| tree | 673e3e399abf9283e6ef554e8244ae93731e6d29 | |
| parent | aabe2fcc6b9e48269b0051bf115093d974d10065 (diff) | |
| download | gn-transform-databases-672e902bfede56e952ca006fd2d8745de637f4ba.tar.gz | |
Add organization to dataset dump
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
| -rwxr-xr-x | examples/dump-dataset-metadata.scm | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/examples/dump-dataset-metadata.scm b/examples/dump-dataset-metadata.scm index afbec75..cf0504a 100755 --- a/examples/dump-dataset-metadata.scm +++ b/examples/dump-dataset-metadata.scm @@ -95,6 +95,7 @@ (schema-triples (gn:dataset rdfs:range rdfs:Literal) (gn:datasetOfInvestigator rdfs:domain gn:dataset) + (gn:datasetOfOrganization rdfs:domain gn:dataset) (gn:datasetOfInvestigator rdfs:range foaf:Person) (gn:datasetOfInbredSet rdfs:domain gn:dataset) (gn:datasetOfInbredSet rdfs:range gn:inbredSet) @@ -139,6 +140,8 @@ (investigator-attributes->id (field Investigators FirstName) (field Investigators LastName) (field Investigators Email))) + (set gn:datasetOfOrganization + (field ("CAST(CONVERT(BINARY CONVERT(Organizations.OrganizationName USING latin1) USING utf8) AS VARCHAR(1500))" Organizations))) (set gn:accessionId (string-append "GN" (number->string (field InfoFiles GN_AccesionId)))) (set gn:datasetStatusName (string-downcase |