aboutsummaryrefslogtreecommitdiff
path: root/gn3/db/species.py
diff options
context:
space:
mode:
authorFrederick Muriuki Muriithi2021-11-26 11:44:53 +0300
committerFrederick Muriuki Muriithi2021-11-29 12:05:16 +0300
commitf88d8e4446c8c9d6693197a452669e0e9c8ea812 (patch)
tree5a5c9c3c68f8a33efb5c8b2445672fffab4bac32 /gn3/db/species.py
parent40f264876f2309fcccfcd3d04a2999bdf3fa5d98 (diff)
downloadgenenetwork3-f88d8e4446c8c9d6693197a452669e0e9c8ea812.tar.gz
Fix query parametrisation
Issue: https://github.com/genenetwork/gn-gemtext-threads/blob/main/topics/gn1-migration-to-gn2/partial-correlations.gmi * Pass parameters to the query the way the MySQL driver expects.
Diffstat (limited to 'gn3/db/species.py')
-rw-r--r--gn3/db/species.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/gn3/db/species.py b/gn3/db/species.py
index 20170ba..5b8e096 100644
--- a/gn3/db/species.py
+++ b/gn3/db/species.py
@@ -71,6 +71,6 @@ def species_name(conn: Any, group: str) -> str:
("SELECT Species.Name FROM Species, InbredSet "
"WHERE InbredSet.Name = %(group_name)s "
"AND InbredSet.SpeciesId = Species.Id"),
- group_name=group_name)
+ {"group_name": group})
return cursor.fetchone()[0]
return None