-
Notifications
You must be signed in to change notification settings - Fork 0
/
services.py
49 lines (44 loc) · 1018 Bytes
/
services.py
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
import mysql.connector as mysql
def table_mapper(table_name):
tables = [
"drug_order",
"encounter",
"obs",
"orders",
"patient",
"patient_identifier",
"patient_program",
"patient_state",
"person",
"person_address",
"person_attribute",
"person_name",
"pharmacies",
"pharmacy_batch_item_reallocations",
"pharmacy_batch_items",
"pharmacy_batches",
"pharmacy_obs",
"pharmacy_stock_balances",
"pharmacy_stock_verifications",
"relationship",
"merge_audits",
"note",
"cohort_member"
]
if table_name in tables:
return True
else:
return False
def connectTest():
try:
db = mysql.connect(
host="",
user="",
password="",
database=""
)
return db
except Exception as e:
# logg the error
print(e)
return None