From d95501bd2bd41ef8cf3584118382e83cbbbe0c87 Mon Sep 17 00:00:00 2001
From: Munyoki Kilyungi
Date: Mon, 15 Jul 2024 09:08:06 +0300
Subject: Add missing RIF symbols.

Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
---
 examples/generif.scm | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

diff --git a/examples/generif.scm b/examples/generif.scm
index fb3208a..b6a1e2c 100755
--- a/examples/generif.scm
+++ b/examples/generif.scm
@@ -45,6 +45,19 @@
     (set rdfs:label
          (field GeneRIF_BASIC symbol))))
 
+(define-transformer generif-symbols
+  (tables (GeneRIF)
+          "WHERE symbol NOT IN (SELECT symbol from GeneRIF_BASIC) GROUP BY BINARY symbol")
+  (triples
+      (string->identifier
+       "symbol"
+       (regexp-substitute/global #f "[^A-Za-z0-9:]"
+                                 (field GeneRIF symbol)
+                                 'pre "_" 'post)
+       #:proc (lambda (x) x))
+    (set rdfs:label
+         (field GeneRIF symbol))))
+
 (define-transformer gn-genewiki-entries
   (tables (GeneRIF
            (left-join Species "ON Species.SpeciesId = GeneRIF.SpeciesId")
@@ -219,6 +232,7 @@
    (inputs
     (list
      genewiki-symbols
+     generif-symbols
      gn-genewiki-entries
      ncbi-genewiki-entries))
    (outputs
-- 
cgit v1.2.3