blob: 98337a3cdb6695c303fdb48c42445a298f3f70da (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
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()
|
