From 90ed50db7385b11994dc72874aae94cc647fc855 Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Thu, 15 Feb 2024 11:02:22 +0300
Subject: Filter out NULL values

---
 scripts/rqtl2/install_genotypes.py | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'scripts/rqtl2')

diff --git a/scripts/rqtl2/install_genotypes.py b/scripts/rqtl2/install_genotypes.py
index 7f3f65a..709fe0f 100644
--- a/scripts/rqtl2/install_genotypes.py
+++ b/scripts/rqtl2/install_genotypes.py
@@ -99,7 +99,7 @@ def insert_genotype_data(dbconn: mdb.Connection,
         markerids = {row["Name"]: row["Id"] for row in cursor.fetchall()}
         cursor.execute("SELECT MAX(Id) AS lastid FROM GenoData")
         lastid = cursor.fetchone()["lastid"]
-        data = tuple(
+        data = tuple(item for item in (
             {**row, "gid": gid}
             for gid, row in enumerate(
                     ({
@@ -109,6 +109,7 @@ def insert_genotype_data(dbconn: mdb.Connection,
                     } for innerrow in genotypes for marker in
                      (key for key in innerrow.keys() if key != "id")),
                     start=lastid+1))
+                     if item["value"] is not None)
         cursor.executemany(
             "INSERT INTO GenoData(Id, StrainId, value) "
             "VALUES(%(gid)s, %(indid)s, %(value)s)",
-- 
cgit v1.2.3