diff options
| author | Frederick Muriuki Muriithi | 2024-02-15 11:02:22 +0300 |
|---|---|---|
| committer | Frederick Muriuki Muriithi | 2024-02-15 11:02:22 +0300 |
| commit | 90ed50db7385b11994dc72874aae94cc647fc855 (patch) | |
| tree | b79c2c605d99914d96cac60182aa40e27de1cc5c /scripts | |
| parent | 22a3076313b5ea3229320ba2ea30b77b3eb72c7e (diff) | |
| download | gn-uploader-90ed50db7385b11994dc72874aae94cc647fc855.tar.gz | |
Filter out NULL values
Diffstat (limited to 'scripts')
| -rw-r--r-- | scripts/rqtl2/install_genotypes.py | 3 |
1 files changed, 2 insertions, 1 deletions
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)", |