diff options
author | Frederick Muriuki Muriithi | 2024-01-17 05:38:29 +0300 |
---|---|---|
committer | Frederick Muriuki Muriithi | 2024-01-17 05:39:10 +0300 |
commit | bf1c2ec1b16b50f419a349a54031baf85fcd4abd (patch) | |
tree | 3cd3bfdce0430f657457986becce7483a7172c16 /qc_app/db/species.py | |
parent | 4e3f6e51b92d9c56f77452bd4b723323a526bc52 (diff) | |
download | gn-uploader-bf1c2ec1b16b50f419a349a54031baf85fcd4abd.tar.gz |
UI: Initialise summary page.
Diffstat (limited to 'qc_app/db/species.py')
-rw-r--r-- | qc_app/db/species.py | 10 |
1 files changed, 4 insertions, 6 deletions
diff --git a/qc_app/db/species.py b/qc_app/db/species.py index 7006d15..653e59b 100644 --- a/qc_app/db/species.py +++ b/qc_app/db/species.py @@ -6,8 +6,8 @@ def species(conn: mdb.Connection) -> tuple: "Retrieve the species from the database." with conn.cursor(cursorclass=DictCursor) as cursor: cursor.execute( - "SELECT SpeciesId, SpeciesName, LOWER(Name) AS Name, MenuName " - "FROM Species") + "SELECT SpeciesId, SpeciesName, LOWER(Name) AS Name, MenuName, " + "FullName FROM Species") return tuple(cursor.fetchall()) return tuple() @@ -16,9 +16,7 @@ def species_by_id(conn: mdb.Connection, speciesid) -> dict: "Retrieve the species from the database by id." with conn.cursor(cursorclass=DictCursor) as cursor: cursor.execute( - ( - "SELECT " - "SpeciesId, SpeciesName, LOWER(Name) AS Name, MenuName " - "FROM Species WHERE SpeciesId=%s"), + "SELECT SpeciesId, SpeciesName, LOWER(Name) AS Name, MenuName, " + "FullName FROM Species WHERE SpeciesId=%s", (speciesid,)) return cursor.fetchone() |