diff options
| author | Munyoki Kilyungi | 2026-02-18 11:03:48 +0300 |
|---|---|---|
| committer | Munyoki Kilyungi | 2026-02-18 11:03:48 +0300 |
| commit | 2091c1c812912755d9cd67723f1ba45a6666de5d (patch) | |
| tree | 0df37da679724fbffbcd82cceb7fe3337ce790d8 /examples/genotype-datasets.scm | |
| parent | f5e0df7a66f4dbecb27c8e4f41ac760746d6c9de (diff) | |
| download | gn-transform-databases-2091c1c812912755d9cd67723f1ba45a6666de5d.tar.gz | |
Only transform datasets with public > 0 and confidentiality < 1.
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
Diffstat (limited to 'examples/genotype-datasets.scm')
| -rwxr-xr-x | examples/genotype-datasets.scm | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/examples/genotype-datasets.scm b/examples/genotype-datasets.scm index ebe2349..38d524b 100755 --- a/examples/genotype-datasets.scm +++ b/examples/genotype-datasets.scm @@ -18,7 +18,7 @@ (tables (Species (inner-join InbredSet "ON InbredSet.SpeciesId = Species.Id") (inner-join GenoFreeze "ON GenoFreeze.InbredSetId = InbredSet.Id")) - "WHERE GenoFreeze.public > 0 AND Species.Name != 'monkey' GROUP BY Species.Name, GenoFreeze.ShortName") + "WHERE GenoFreeze.public > 0 AND GenoFreeze.confidentiality < 1 AND Species.Name != 'monkey' GROUP BY Species.Name, GenoFreeze.ShortName") (triples (string->identifier "set" (field InbredSet Name InbredSetName) #:separator "_") (multiset gnt:has_genotype_data (map (cut string->identifier "dataset" <> #:separator "_") @@ -31,7 +31,7 @@ (tables (GenoFreeze (inner-join InbredSet "ON InbredSet.Id = GenoFreeze.InbredSetId") (inner-join Species "ON InbredSet.SpeciesId = Species.Id")) - "WHERE GenoFreeze.public > 0 AND Species.Name != 'monkey'") + "WHERE GenoFreeze.public > 0 AND GenoFreeze.confidentiality < 1 AND Species.Name != 'monkey'") (triples (string->identifier "dataset" (field GenoFreeze Name) #:separator "_") (set gnt:has_strain (string->identifier "set" (field InbredSet Name InbredSetName) #:separator "_")) (set dct:created (annotate-field (field GenoFreeze CreateTime) '^^xsd:datetime)))) @@ -41,7 +41,7 @@ (inner-join InbredSet "ON InbredSet.Id = GenoFreeze.InbredSetId") (inner-join Species "ON InbredSet.SpeciesId = Species.Id") (inner-join Geno "ON Geno.SpeciesId = Species.Id")) - "WHERE GenoFreeze.public > 0 AND Species.Name != 'monkey' GROUP BY GenoFreeze.Name") + "WHERE GenoFreeze.public > 0 AND GenoFreeze.confidentiality < 1 AND Species.Name != 'monkey' GROUP BY GenoFreeze.Name") (triples (string->identifier "dataset" (field GenoFreeze Name) #:separator "_") (set gnt:has_marker_count (string->symbol |