aboutsummaryrefslogtreecommitdiff
path: root/uploader/genotypes/models.py
diff options
context:
space:
mode:
authorFrederick Muriuki Muriithi2024-11-22 12:16:28 -0600
committerFrederick Muriuki Muriithi2024-11-22 12:16:28 -0600
commit8a84c4d6762446e5fdf9f9121f539c89419ae6a0 (patch)
tree0c4d175767bdfb24d83a7f0c15e0ab677e00ebba /uploader/genotypes/models.py
parent82fb92db448f1985b821193bcfdee72d512e27bb (diff)
downloadgn-uploader-8a84c4d6762446e5fdf9f9121f539c89419ae6a0.tar.gz
Use gn-libs code for db connection.
Use the code in gn-libs to connect to the database, rather than a local module.
Diffstat (limited to 'uploader/genotypes/models.py')
-rw-r--r--uploader/genotypes/models.py7
1 files changed, 4 insertions, 3 deletions
diff --git a/uploader/genotypes/models.py b/uploader/genotypes/models.py
index 44c98b1..4c3e634 100644
--- a/uploader/genotypes/models.py
+++ b/uploader/genotypes/models.py
@@ -4,8 +4,9 @@ from datetime import datetime
import MySQLdb as mdb
from MySQLdb.cursors import Cursor, DictCursor
+from flask import current_app as app
-from uploader.db_utils import debug_query
+from gn_libs.mysqldb import debug_query
def genocode_by_population(
conn: mdb.Connection, population_id: int) -> tuple[dict, ...]:
@@ -38,7 +39,7 @@ def genotype_markers(
with conn.cursor(cursorclass=DictCursor) as cursor:
cursor.execute(_query, (species_id,))
- debug_query(cursor)
+ debug_query(cursor, app.logger)
return tuple(dict(row) for row in cursor.fetchall())
@@ -64,7 +65,7 @@ def genotype_dataset(
with conn.cursor(cursorclass=DictCursor) as cursor:
cursor.execute(_query, _params)
- debug_query(cursor)
+ debug_query(cursor, app.logger)
result = cursor.fetchone()
if bool(result):
return dict(result)