From b9252098ede330fb41b463530e93f182d4e929bf Mon Sep 17 00:00:00 2001 From: Munyoki Kilyungi Date: Mon, 11 Sep 2023 14:00:00 +0300 Subject: Filter out empty symbols when dumping generif metadata. Signed-off-by: Munyoki Kilyungi --- examples/generif.scm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'examples/generif.scm') diff --git a/examples/generif.scm b/examples/generif.scm index 89e7fce..83f8632 100755 --- a/examples/generif.scm +++ b/examples/generif.scm @@ -138,7 +138,7 @@ (define-transformer ncbi-genewiki-entries (tables (GeneRIF_BASIC (left-join Species "USING (SpeciesId)")) - "WHERE GeneRIF_BASIC.comment IS NOT NULL GROUP BY GeneRIF_BASIC.comment, GeneRIF_BASIC.createtime, GeneRIF_BASIC.VersionId, GeneRIF_BASIC.SpeciesId, GeneRIF_BASIC.TaxID") + "WHERE GeneRIF_BASIC.comment IS NOT NULL AND TRIM(GeneRIF_BASIC.comment) != '' AND TRIM(GeneRIF_BASIC.symbol) != '' GROUP BY GeneRIF_BASIC.comment, GeneRIF_BASIC.createtime, GeneRIF_BASIC.VersionId, GeneRIF_BASIC.SpeciesId, GeneRIF_BASIC.TaxID") (schema-triples (gnc:NCBIWikiEntry rdfs:subClassOf gnc:GeneWikiEntry) (gnc:NCBIWikiEntry rdfs:comment "Represents GeneRIF Entries obtained from NCBI") -- cgit v1.2.3