diff options
author | Frederick Muriuki Muriithi | 2024-02-02 05:17:50 +0300 |
---|---|---|
committer | Frederick Muriuki Muriithi | 2024-02-02 05:17:50 +0300 |
commit | 2b8fd63af18e70b4c8c20a34a6dfa041e8a832b9 (patch) | |
tree | 26276f08f6059e0b649a7ab55511622c93203a14 /qc_app | |
parent | 07deef46a3f3ba53cc632a9381fb25c55e1017b1 (diff) | |
download | gn-uploader-2b8fd63af18e70b4c8c20a34a6dfa041e8a832b9.tar.gz |
Bug: Specify DictCursor class to return dict-like result
Without specifying the `cursorclass`, the result is a tuple of the
form:
((query_col01_val, query_col02_val, ...), ...)
where the ellipsis specify the possibility of more than one of the
previous form.
We specify the DictCursor class instead so that the form changes to:
({query_col01_name: query_col01_val, ...}, ...)
which allows us to pick the value we want with a string index.
Diffstat (limited to 'qc_app')
-rw-r--r-- | qc_app/db/populations.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/qc_app/db/populations.py b/qc_app/db/populations.py index 0bcbe5d..06ae773 100644 --- a/qc_app/db/populations.py +++ b/qc_app/db/populations.py @@ -28,7 +28,7 @@ def populations_by_species(conn: mdb.Connection, speciesid) -> tuple: def save_population(conn: mdb.Connection, population_details: dict) -> dict: """Save the population details to the db.""" - with conn.cursor() as cursor: + with conn.cursor(cursorclass=DictCursor) as cursor: cursor.execute("SELECT MAX(Id) AS last_id FROM InbredSet") new_id = cursor.fetchone()["last_id"] + 1 cursor.execute( |