diff options
author | Frederick Muriuki Muriithi | 2024-11-22 12:16:28 -0600 |
---|---|---|
committer | Frederick Muriuki Muriithi | 2024-11-22 12:16:28 -0600 |
commit | 8a84c4d6762446e5fdf9f9121f539c89419ae6a0 (patch) | |
tree | 0c4d175767bdfb24d83a7f0c15e0ab677e00ebba /uploader/genotypes/models.py | |
parent | 82fb92db448f1985b821193bcfdee72d512e27bb (diff) | |
download | gn-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.py | 7 |
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) |