blob: 653e59bf9ff804b78e180a07e6361f103b0a8084 (
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 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 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()
|
