diff options
author | Frederick Muriuki Muriithi | 2024-09-23 16:29:25 -0500 |
---|---|---|
committer | Frederick Muriuki Muriithi | 2024-09-23 16:35:39 -0500 |
commit | 480ee0b657b762f1dd0b1164f98ab13bc9a11f56 (patch) | |
tree | 28c7e8e450112039bb764a6fe967838369aba937 /uploader/db | |
parent | 4285cc10e24d6410206329ba079406e9aa21cc30 (diff) | |
download | gn-uploader-480ee0b657b762f1dd0b1164f98ab13bc9a11f56.tar.gz |
Initialise "Platforms" section.
Diffstat (limited to 'uploader/db')
-rw-r--r-- | uploader/db/platforms.py | 25 |
1 files changed, 0 insertions, 25 deletions
diff --git a/uploader/db/platforms.py b/uploader/db/platforms.py deleted file mode 100644 index cb527a7..0000000 --- a/uploader/db/platforms.py +++ /dev/null @@ -1,25 +0,0 @@ -"""Handle db interactions for platforms.""" -from typing import Optional - -import MySQLdb as mdb -from MySQLdb.cursors import DictCursor - -def platforms_by_species( - conn: mdb.Connection, speciesid: int) -> tuple[dict, ...]: - """Retrieve platforms by the species""" - with conn.cursor(cursorclass=DictCursor) as cursor: - cursor.execute("SELECT * FROM GeneChip WHERE SpeciesId=%s " - "ORDER BY GeneChipName ASC", - (speciesid,)) - return tuple(dict(row) for row in cursor.fetchall()) - -def platform_by_id(conn: mdb.Connection, platformid: int) -> Optional[dict]: - """Retrieve a platform by its ID""" - with conn.cursor(cursorclass=DictCursor) as cursor: - cursor.execute("SELECT * FROM GeneChip WHERE Id=%s", - (platformid,)) - result = cursor.fetchone() - if bool(result): - return dict(result) - - return None |