about summary refs log tree commit diff
diff options
context:
space:
mode:
authorMunyoki Kilyungi2023-03-06 14:05:48 +0300
committerBonfaceKilz2023-03-06 22:30:50 +0300
commitf5eb10c5b598753cd2c40920e4344c7f29a2bb99 (patch)
tree8e7aae832c767e22c6cd8a1e269d57a9a4e9b068
parentc79ac02bb27ed3036ddb4928bf723a59852ee24d (diff)
downloadgn-transform-databases-f5eb10c5b598753cd2c40920e4344c7f29a2bb99.tar.gz
Add mapping method and species info to inbredsets.
* dump.scm (dump-inbred-set): Add mapping method and species as extra
metadata for inbredsets.

Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
-rwxr-xr-xdump.scm8
1 files changed, 6 insertions, 2 deletions
diff --git a/dump.scm b/dump.scm
index 43d6cda..7ab070f 100755
--- a/dump.scm
+++ b/dump.scm
@@ -367,17 +367,21 @@ must be remedied."
 
 (define-dump dump-inbred-set
   (tables (InbredSet
-           (inner-join Species "USING (SpeciesId)")))
+           (left-join Species "ON InbredSet.SpeciesId=Species.Id")
+           (left-join MappingMethod
+                       "ON InbredSet.MappingMethodId=MappingMethod.Id")))
   (schema-triples
    (gn:fullName rdfs:range rdfs:Literal)
    (gn:geneticType rdfs:range rdfs:Literal)
    (gn:family rdfs:range rdfs:Literal)
-   (gn:inbredSetOfSpecies rdfs:range gn:species))
+   (gn:inbredSetOfSpecies rdfs:range gn:species)
+   (gn:inbredSetOfMappingMethod rdfs:range gn:mappingMethod))
   (triples (inbred-set-name->id (field InbredSet Name))
     (set rdf:type 'gn:inbredSet)
     (set gn:fullName (field InbredSet FullName))
     (set gn:geneticType (field InbredSet GeneticType))
     (set gn:family (field InbredSet Family))
+    (set gn:inbredSetOfMappingMethod (field MappingMethod Name))
     (set gn:inbredSetOfSpecies
          (binomial-name->species-id (field Species FullName BinomialName)))))