diff options
author | Frederick Muriuki Muriithi | 2024-08-29 15:21:27 -0500 |
---|---|---|
committer | Frederick Muriuki Muriithi | 2024-08-30 15:06:24 -0500 |
commit | e49b4367f1dab1c3acb3cd5d71ba09359c5ab4ee (patch) | |
tree | 63035669dd9a82bccee60b572a565d028cf3ef38 /uploader/species/models.py | |
parent | f95037b93329d5a4953b81ba1b58e4028a6274e8 (diff) | |
download | gn-uploader-e49b4367f1dab1c3acb3cd5d71ba09359c5ab4ee.tar.gz |
Initialise package for dealing with Species.
Diffstat (limited to 'uploader/species/models.py')
-rw-r--r-- | uploader/species/models.py | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/uploader/species/models.py b/uploader/species/models.py new file mode 100644 index 0000000..98337a3 --- /dev/null +++ b/uploader/species/models.py @@ -0,0 +1,22 @@ +"""Database functions for species.""" +import MySQLdb as mdb +from MySQLdb.cursors import DictCursor + +def all_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, " + "FullName, TaxonomyId FROM Species") + return tuple(cursor.fetchall()) + + return tuple() + +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, " + "FullName FROM Species WHERE SpeciesId=%s", + (speciesid,)) + return cursor.fetchone() |