aboutsummaryrefslogtreecommitdiff
path: root/uploader/db/species.py
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()