diff options
| author | Munyoki Kilyungi | 2026-02-03 09:38:31 +0300 |
|---|---|---|
| committer | Munyoki Kilyungi | 2026-02-03 09:38:31 +0300 |
| commit | 28b9947c645c1c2499c13f241fe26c8520eb2a76 (patch) | |
| tree | 7a6762aa499045d2bdbab4aab7c0b64dca9d4b70 /examples | |
| parent | e8342e619fe9899b9469fe4bd6b1e6241005ff29 (diff) | |
| download | gn-transform-databases-28b9947c645c1c2499c13f241fe26c8520eb2a76.tar.gz | |
Add missing join.
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
Diffstat (limited to 'examples')
| -rwxr-xr-x | examples/phenotype.scm | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/examples/phenotype.scm b/examples/phenotype.scm index b243ccd..690b6a9 100755 --- a/examples/phenotype.scm +++ b/examples/phenotype.scm @@ -96,6 +96,7 @@ (define-transformer gn:trait->gn:phenotype (tables (PublishXRef (left-join InbredSet "ON InbredSet.InbredSetId = PublishXRef.InbredSetId") + (inner-join PublishFreeze "ON PublishFreeze.InbredSetId = InbredSet.Id") (left-join Publication "ON Publication.Id = PublishXRef.PublicationId") (left-join Phenotype "ON Phenotype.Id = PublishXRef.PhenotypeId")) "WHERE InbredSet.public > 0") @@ -112,7 +113,7 @@ (set gnt:has_strain (string->identifier "set" (field InbredSet Name InbredSetName) #:separator "_")) (set owl:equivalentClass (field ("CONCAT(IFNULL(InbredSet.InbredSetCode, PublishXRef.InbredSetId), '_', PublishXRef.Id)" - Phenotype))) + Phenotype))) (set dct:references (let ((pmid (field ("IF(Publication.PubMed_ID IS NULL, '', CONVERT(Publication.PubMed_Id, INT))" @@ -183,7 +184,11 @@ ("xkos:" "<http://rdf-vocabulary.ddialliance.org/xkos#>") ("pubmed:" "<http://rdf.ncbi.nlm.nih.gov/pubmed/>"))) (inputs - (list gn:set->gn:dataset gn:dataset->gn:trait gnc:phenotype->gn:phenotype gn:phenotype->metadata gn:trait->gn:phenotype)) + (list gn:set->gn:dataset + gn:dataset->gn:trait + gnc:phenotype->gn:phenotype + gn:phenotype->metadata + gn:trait->gn:phenotype)) (outputs `(#:documentation ,documentation #:rdf ,output)))) |