From 9df0828255632582f515d5d869a3a06f8eda735b Mon Sep 17 00:00:00 2001 From: Munyoki Kilyungi Date: Mon, 29 May 2023 14:26:47 +0300 Subject: Only dump public data Signed-off-by: Munyoki Kilyungi --- examples/dump-dataset-metadata.scm | 2 +- examples/dump-genotype.scm | 2 +- examples/dump-phenotype.scm | 2 +- examples/dump-probeset-metadata.scm | 3 ++- 4 files changed, 5 insertions(+), 4 deletions(-) (limited to 'examples') diff --git a/examples/dump-dataset-metadata.scm b/examples/dump-dataset-metadata.scm index 4747700..ebaea52 100755 --- a/examples/dump-dataset-metadata.scm +++ b/examples/dump-dataset-metadata.scm @@ -91,7 +91,7 @@ (left-join Investigators "USING (InvestigatorId)") (left-join AvgMethod "USING (AvgMethodId)") (left-join GeneChip "USING (GeneChipId)")) - "WHERE GN_AccesionId IS NOT NULL") + "WHERE GN_AccesionId IS NOT NULL AND ((PublishFreeze.public > 0 AND PublishFreeze.confidentiality < 1) OR (GenoFreeze.public > 0 AND GenoFreeze.confidentiality < 1) OR (ProbeSetFreeze.public > 0 AND ProbeSetFreeze.confidentiality < 1))") (schema-triples (gn:datasetOfInvestigator rdfs:domain gn:dataset) (gn:datasetOfInvestigator rdfs:range foaf:Person) diff --git a/examples/dump-genotype.scm b/examples/dump-genotype.scm index cffa917..53d101b 100755 --- a/examples/dump-genotype.scm +++ b/examples/dump-genotype.scm @@ -27,7 +27,7 @@ (tables (GenoFreeze (left-join InfoFiles "ON InfoFiles.InfoPageName = GenoFreeze.Name") (left-join InbredSet "ON GenoFreeze.InbredSetId = InbredSet.InbredSetId")) - "WHERE GenoFreeze.public > 0 AND InfoFiles.InfoPageName IS NULL") + "WHERE GenoFreeze.public > 0 AND GenoFreeze.confidentiality < 1 AND InfoFiles.InfoPageName IS NULL") (schema-triples (gn:datasetOfInbredSet rdfs:range gn:inbredSet) (gn:genotypeDataset rdfs:subPropertyOf gn:dataset) diff --git a/examples/dump-phenotype.scm b/examples/dump-phenotype.scm index 0b46a14..113c367 100755 --- a/examples/dump-phenotype.scm +++ b/examples/dump-phenotype.scm @@ -28,7 +28,7 @@ (tables (PublishFreeze (left-join InfoFiles "ON InfoFiles.InfoPageName = PublishFreeze.Name") (left-join InbredSet "ON PublishFreeze.InbredSetId = InbredSet.InbredSetId")) - "WHERE PublishFreeze.public > 0 AND InfoFiles.InfoPageName IS NULL") + "WHERE PublishFreeze.public > 0 AND PublishFreeze.confidentiality < 1 AND InfoFiles.InfoPageName IS NULL") (schema-triples (gn:datasetOfInbredSet rdfs:range gn:inbredSet) (gn:name rdfs:range rdfs:Literal) diff --git a/examples/dump-probeset-metadata.scm b/examples/dump-probeset-metadata.scm index ae9931c..b3f4165 100755 --- a/examples/dump-probeset-metadata.scm +++ b/examples/dump-probeset-metadata.scm @@ -23,7 +23,8 @@ (define-dump dump-probeset-metadata (tables (ProbeSetXRef (left-join ProbeSet "ON ProbeSetXRef.ProbeSetId = ProbeSet.Id") - (left-join ProbeSetFreeze "ON ProbeSetXRef.ProbeSetFreezeId = ProbeSetFreeze.Id"))) + (left-join ProbeSetFreeze "ON ProbeSetXRef.ProbeSetFreezeId = ProbeSetFreeze.Id")) + "WHERE ProbeSetFreeze.public > 0 AND ProbeSetFreeze.confidentiality < 1") (schema-triples (gn:probesetData rdfs:range gn:probeset) (gn:hasProbeset rdfs:range rdfs:Literal)) -- cgit v1.2.3