1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
|
"""This contains all the necessary functions that access the phenotypes from
the db"""
from dataclasses import dataclass, asdict, astuple
from typing import Any, Optional
from MySQLdb import escape_string
# pylint: disable=[R0902]
@dataclass(frozen=True)
class Phenotype:
"""Data Type that represents a Phenotype"""
id_: Optional[int] = None
pre_pub_description: Optional[str] = None
post_pub_description: Optional[str] = None
original_description: Optional[str] = None
units: Optional[str] = None
pre_pub_abbrevition: Optional[str] = None
post_pub_abbreviation: Optional[str] = None
lab_code: Optional[str] = None
submitter: Optional[str] = None
owner: Optional[str] = None
authorized_users: Optional[str] = None
# Mapping from the Phenotype dataclass to the actual column names in the
# database
phenotype_column_mapping = {
"id_": "id",
"pre_pub_description": "Pre_publication_description",
"post_pub_description": "Post_publication_description",
"original_description": "Original_description",
"units": "Units",
"pre_pub_abbrevition": "Pre_publication_abbreviation",
"post_pub_abbreviation": "Post_publication_abbreviation",
"lab_code": "Lab_code",
"submitter": "Submitter",
"owner": "Owner",
"authorized_users": "Authorized_Users",
}
def update_phenotype(conn: Any,
data: Phenotype,
where: Phenotype) -> Optional[int]:
"""Update phenotype metadata with DATA that depends on the WHERE clause"""
if not any(astuple(data) + astuple(where)):
return None
sql = "UPDATE Phenotype SET "
sql += ", ".join(f"{phenotype_column_mapping.get(k)} "
f"= '{escape_string(str(v)).decode('utf-8')}'" for
k, v in asdict(data).items()
if v is not None and k in phenotype_column_mapping)
sql += " WHERE "
sql += "AND ".join(f"{phenotype_column_mapping.get(k)} = "
f"'{escape_string(str(v)).decode('utf-8')}'" for
k, v in asdict(where).items()
if v is not None and k in phenotype_column_mapping)
with conn.cursor() as cursor:
cursor.execute(sql)
return cursor.rowcount
|
