def generic_view_singletable(select_ports, view_ports, table_fields, table):
table_name = [table]
another = "Y"
field_array = []
data_array = []
while (another.lower() == "y"):
print("Enter field: \n")
f_no = db.select_make(select_ports)
field_name = select_ports[f_no - 1]
field_array.append(field_name)
if field_name == "date":
data = db.quote_str(
db.date_process(input("Enter Date(DD-MM-YYYY): ")))
else:
data = db.quote_str(
input("Enter {field}: ".format(field=select_ports[f_no - 1])))
data_array.append(data)
another = input("Do you want to enter another field ? [Y/N]")
db.view_entry(table_name, field_array, data_array, view_ports,
table_fields)
def generic_view_value(select_ports,
view_ports,
table_fields,
delete_check,
combo,
datefield1="",
datefield2="",
jointype="LEFT JOIN"):
another = "Y"
field_array = []
data_array = []
while (another.lower() == "y"):
print("Enter field: \n")
f_no = db.select_make(select_ports)
field_name = select_ports[f_no - 1]
field_array.append(field_name)
if field_name == datefield1 or field_name == datefield2:
data = db.quote_str(
db.date_process(input("Enter Date(DD-MM-YYYY): ")))
else:
data = db.quote_str(
input("Enter {field}: ".format(field=select_ports[f_no - 1])))
data_array.append(data)
another = input("Do you want to enter another field ? [Y/N]")
db.view_entry(delete_check, field_array, data_array, view_ports,
table_fields, combo)
def generic_view_range(select_ports,
view_ports,
table_fields,
delete_check,
combo,
datefield1="",
datefield2="",
jointype="LEFT JOIN"):
another = "Y"
field_array = []
data_array = []
inequality_array = []
while (another.lower() == "y"):
print("Enter field: \n")
f_no = db.select_make(select_ports)
field_name = select_ports[f_no - 1]
if field_name == datefield1 or field_name == datefield2:
data_lesser = db.quote_str(
db.date_process(input("Date(DD-MM-YYYY) > ")))
else:
data_lesser = db.quote_str(
input("{field} > ".format(field=field_name)))
if data_lesser != '""':
data_array.append(data_lesser)
field_array.append(field_name)
inequality_array.append(" > ")
if field_name == datefield1 or field_name == datefield2:
data_greater = db.quote_str(
db.date_process(input("Enter Date(DD-MM-YYYY) < ")))
else:
data_greater = db.quote_str(
input("{field} < ".format(field=field_name)))
if data_greater != '""':
data_array.append(data_greater)
field_array.append(field_name)
inequality_array.append(" < ")
another = input("Do you want to enter another field ? [Y/N]")
db.view_range(delete_check,
field_array,
data_array,
view_ports,
table_fields,
inequality_array,
combo,
jointype=jointype)
def generic_delete_value(select_ports,
view_ports,
table_fields,
delete_check,
combo,
datefield1="",
datefield2="",
jointype="LEFT JOIN",
deletetype=""):
table_name = [delete_check[0]]
another = "Y"
field_array = []
data_array = []
print("\nSearch for the entry: \n")
while (another.lower() == "y"):
print("Enter field: \n")
f_no = db.select_make(select_ports)
field_name = select_ports[f_no - 1]
field_array.append(field_name)
if field_name == "date":
data = db.quote_str(
db.date_process(input("Enter Date(DD-MM-YYYY): ")))
else:
data = db.quote_str(
input("Enter {field}: ".format(field=select_ports[f_no - 1])))
data_array.append(data)
another = input("Do you want to enter another field ? [Y/N]")
sel = db.check_entry(delete_check, field_array, data_array, view_ports,
table_fields, combo)
if (sel):
x = input("Are you sure you want to delete this entry ? : [Y/N]")
if (x.lower() == "y"):
if (deletetype == "admin"):
p = db.choice_make("Soft Delete", "Hard Delete")
else:
p = 1
if p == 1:
db.update_data(table_name, sel, ['is_deleted'], ['1'])
print("Entry Deleted")
elif p == 2:
db.delete_data(table_name, sel)
else:
print("Entry was NOT deleted")
def reports():
table_name = 'diagnosticreport'
presid = input("Enter Prescription ID: ")
docid = input("Enter Doctor ID: ")
date = db.quote_str(db.date_process(input("Enter Date (DD-MM-YYYY): ")))
time = db.quote_str(input("Enter time: "))
report = db.quote_str(input("Report: "))
data = db.list_make(presid, docid, date, time, report)
db.insert_data(table_name, insert_scope['admin:report'], data)
def med_entry():
table_name = 'medicine'
brandname = db.quote_str(input("Brand Name: "))
genname = db.quote_str(input("Generic Name: "))
manufecturer = db.quote_str(input("Manufecturer Name: "))
literature = db.quote_str(input("Literature: "))
stock = input("Stock: ")
data = db.list_make(brandname, genname, manufecturer, literature, stock)
db.insert_data(table_name, insert_scope['medicine'], data)
def roomduty_entry_staff():
table_name = 'roomduty'
staffid = input("Enter Staff id: ")
roomid = input("Enter Room id: ")
date = db.quote_str(db.date_process(input("Enter Date (DD-MM-YYYY): ")))
time = db.quote_str(input("Enter time: "))
#Where to start from
data = db.list_make(staffid, roomid, date, time)
db.insert_data(table_name, insert_scope['admin-staff:roomduty'], data)
def staff_entry():
table_name = 'staffmanagement'
name = db.quote_str(input("Staff Name: "))
sex = db.quote_str(input("Sex: "))
age = input("Age: ")
position = db.quote_str(input("Position: "))
contactno = db.quote_str(input("Phone number: "))
email = db.quote_str(input("Email: "))
salary = input("Salary: ")
data = db.list_make(name, sex, age, position, contactno, email, salary)
db.insert_data(table_name, insert_scope['admin:staffmanagemnet'], data)
def roomduty_entry():
table_name = 'roomduty'
docid = input("Enter Doctor id: ")
roomid = input("Enter Room id: ")
date = db.quote_str(db.date_process(input("Enter Date (DD-MM-YYYY): ")))
print(date)
time = db.quote_str(input("Enter time: "))
#Where to start from
data = db.list_make(docid, roomid, date, time)
db.insert_data(table_name, insert_scope['admin-doc:roomduty'], data)
def doctor_view_admin():
table_name = ['doctorsmanagement']
another = "Y"
field_array = []
data_array = []
while (another.lower() == "y"):
print("Enter field: \n")
f_no = db.select_make(select_ports['dview:doctorsmanagement'])
field_name = select_ports['dview:doctorsmanagement'][f_no - 1]
field_array.append(field_name)
data = db.quote_str(
input("Enter {field}: ".format(
field=select_ports['dview:doctorsmanagement'][f_no - 1])))
data_array.append(data)
another = input("Do you want to enter another field ? [Y/N]")
db.view_entry(table_name, field_array, data_array,
select_ports['dview:doctorsmanagement'],
table_fields['doctorsmanagement'])
def prescription():
table_name = 'prescription'
patid = input("Enter Patient ID: ")
docid = input("Enter Doctor ID: ")
diagnosis = db.quote_str(input("Diagnosis: "))
medid = input("Enter Med ID: ")
testid = input("Enter Test ID: ")
if len(medid) == 0:
medid = "NULL"
if len(testid) == 0:
testid = "NULL"
date = db.quote_str(db.date_process(input("Enter Date (DD-MM-YYYY): ")))
time = db.quote_str(input("Enter time: "))
data = db.list_make(patid, docid, diagnosis, medid, testid, date, time)
db.insert_data(table_name, insert_scope['admin:prescription'], data)
def patient_admission():
table_name = 'admission'
patid = input("Enter Patient ID: ")
docid = input("Enter Doctor ID: ")
roomid = input("Enter Room ID: ")
bedno = input("Enter Bed no: ")
admitdate = db.quote_str(
db.date_process(input("Enter Admission Date (DD-MM-YYYY): ")))
admittime = db.quote_str(input("Enter Admission time: "))
redate = db.quote_str(
db.date_process(input("Enter Release Date (DD-MM-YYYY): ")))
retime = db.quote_str(input("Enter Release time: "))
data = db.list_make(patid, "1", roomid, bedno, docid, admitdate, admittime,
redate, retime)
db.insert_data(table_name, insert_scope['admin:admission'], data)
def emergency_patient():
patid = input("Enter Patient ID: ")
docid = input("Enter Doctor ID: ")
date = db.quote_str(db.date_process(input("Enter Date (DD-MM-YYYY): ")))
time = db.quote_str(input("Enter time: "))
print("Where did the patient come ? ")
roomtype = db.choice_make("Emergency", "Outdoor")
data = db.list_make(patid, docid, date, time)
if roomtype == 1:
db.insert_data('emergency', insert_scope['patinet:outdoor-emergency'],
data)
elif roomtype == 2:
db.insert_data('outdoor', insert_scope['patinet:outdoor-emergency'],
data)
def equip_entry():
table_name = 'medequipment'
name = db.quote_str(input("Equipment Name: "))
stock = input("Stock: ")
data = db.list_make(name, stock)
db.insert_data(table_name, insert_scope['medequipment'], data)
def room_entry():
table_name = 'room'
roomtype = db.quote_str(input("Room Type: "))
bedcount = input("Bedcount: ")
data = db.list_make(roomtype, bedcount)
db.insert_data(table_name, insert_scope['room'], data)
def generic_range_singletable(select_ports, view_ports, table_fields, table):
table_name = [table]
another = "Y"
field_array = []
data_array = []
inequality_array = []
while (another.lower() == "y"):
print("Enter field: \n")
f_no = db.select_make(select_ports)
field_name = select_ports[f_no - 1]
if field_name == "date":
data_lesser = db.quote_str(
db.date_process(input("Date(DD-MM-YYYY) > ")))
else:
data_lesser = db.quote_str(
input("{field} > ".format(field=field_name)))
if data_lesser != '""':
data_array.append(data_lesser)
field_array.append(field_name)
inequality_array.append(" > ")
if field_name == "date":
data_greater = db.quote_str(
db.date_process(input("Enter Date(DD-MM-YYYY) < ")))
else:
data_greater = db.quote_str(
input("{field} < ".format(field=field_name)))
if data_greater != '""':
data_array.append(data_greater)
field_array.append(field_name)
inequality_array.append(" < ")
another = input("Do you want to enter another field ? [Y/N]")
db.view_range(table_name, field_array, data_array, view_ports,
table_fields, inequality_array)
def test_entry():
table_name = 'diagnostictests'
name = db.quote_str(input("Test Name: "))
roomid = input("Enter Room id: ")
#Where to start from
data = db.list_make(name, roomid)
db.insert_data(table_name, insert_scope['diagnostictests'], data)
def doctor_entry():
table_name = 'doctorsmanagement'
print("Enter the following data: \n")
name = db.quote_str(input("Doctor Name: "))
sex = db.quote_str(input("Sex: "))
expertise = db.quote_str(input("Area of expertise: "))
degree = db.quote_str(input("Degree: "))
position = db.quote_str(input("Position: "))
chamber = db.quote_str(input("Chamber Location: "))
time = db.quote_str(input("Availble at: "))
fee = input("Fee: ")
contactno = db.quote_str(input("Phone number: "))
email = db.quote_str(input("Email: "))
data = db.list_make(name, sex, expertise, position, chamber, degree, time,
fee, contactno, email)
db.insert_data(table_name, insert_scope['dview:doctorsmanagement'], data)
def doctor_range_admin():
table_name = ['doctorsmanagement']
another = "Y"
field_array = []
data_array = []
inequality_array = []
while (another.lower() == "y"):
print("Enter field: \n")
f_no = db.select_make(select_ports['drange:doctorsmanagement'])
data_lesser = db.quote_str(
input("{field} > ".format(
field=select_ports['drange:doctorsmanagement'][f_no - 1])))
if data_lesser != '""':
data_array.append(data_lesser)
field_array.append(select_ports['drange:doctorsmanagement'][f_no -
1])
inequality_array.append(" > ")
data_greater = db.quote_str(
input("{field} < ".format(
field=select_ports['drange:doctorsmanagement'][f_no - 1])))
if data_greater != '""':
data_array.append(data_greater)
field_array.append(select_ports['drange:doctorsmanagement'][f_no -
1])
inequality_array.append(" < ")
another = input("Do you want to enter another field ? [Y/N]")
db.view_range(table_name, field_array, data_array,
view_ports['dview:doctorsmanagement'],
table_fields[table_name[0]], inequality_array)
def patient_entry():
table_name = 'patientmanagement'
print("Enter the following data: \n")
name = db.quote_str(input("Patient Name: "))
sex = db.quote_str(input("Sex: "))
age = input("Age: ")
bloodgroup = db.quote_str(input("Blood Group: "))
medicalhistory = db.quote_str(input("Medical History: "))
address = db.quote_str(input("Address: "))
contactno = db.quote_str(input("Phone number: "))
email = db.quote_str(input("Email: "))
data = db.list_make(name, sex, age, bloodgroup, medicalhistory, address,
contactno, email)
db.insert_data(table_name, insert_scope['admin-patient:patientmanagement'],
data)
def patient_view_admin():
table_name = ['patientmanagement']
another = "Y"
field_array = []
data_array = []
while (another.lower() == "y"):
print("Enter field: \n")
f_no = db.select_make(select_ports['admin:patientmanagement'])
field_name = select_ports['admin:patientmanagement'][f_no - 1]
field_array.append(field_name)
data = db.quote_str(
input("Enter {field}: ".format(
field=select_ports['admin:patientmanagement'][f_no - 1])))
data_array.append(data)
another = input("Do you want to enter another field ? [Y/N]")
db.view_entry(table_name, field_array, data_array,
view_ports['admin:patientmanagement'],
table_fields['patientmanagement'])
print("\nLatest Prescription: ")
delete_check = ['prescription', 'patientmanagement', 'doctorsmanagement']
combo = [["prescription", 'patientmanagement', "patientid"],
["prescription", "doctorsmanagement", "docid"],
["prescription", "diagnostictests", "testid"],
["prescription", "medicine", "medid"]]
db.view_entry(delete_check, field_array, data_array,
view_ports['admin:last-pres'],
table_fields['admin:last-pres'], combo, "prescription.date")
print("\nLatest Report: ")
delete_check = ['prescription', 'patientmanagement']
combo = [["prescription", 'patientmanagement', "patientid"],
["prescription", "diagnosticreport", "presid"],
["prescription", "diagnostictests", "testid"],
["diagnosticreport", "doctorsmanagement", "docid"]]
db.view_entry(delete_check, field_array, data_array,
view_ports['admin:last-rep'], table_fields['admin:last-rep'],
combo, "prescription.date")
def generic_update_value(select_ports,
view_ports,
table_fields,
delete_check,
combo,
datefield1="",
datefield2="",
jointype="LEFT JOIN",
update_ports=select_ports):
table_name = [delete_check[0]]
another = "Y"
field_array = []
data_array = []
print("\nSearch for the entry: \n")
while (another.lower() == "y"):
print("Enter field: \n")
f_no = db.select_make(select_ports)
field_name = select_ports[f_no - 1]
field_array.append(field_name)
if field_name == "date":
data = db.quote_str(
db.date_process(input("Enter Date(DD-MM-YYYY): ")))
else:
data = db.quote_str(
input("Enter {field}: ".format(field=select_ports[f_no - 1])))
data_array.append(data)
another = input("Do you want to enter another field ? [Y/N]")
sel = db.check_entry(delete_check, field_array, data_array, view_ports,
table_fields, combo)
if (sel):
print("Select the field you want to update? ")
select_fields = update_ports.copy()
primary_key_check = [
'patientmanagement', 'doctorsmanagement', 'medicine',
'medequipment', 'staffmanagement', 'diagnostictests', 'room'
]
table_name = [delete_check[0]]
for table in primary_key_check:
if table_name[0] == table:
select_fields.pop(0)
another = "Y"
field_array = []
data_array = []
while (another.lower() == "y" and len(select_fields) != 0):
print("Enter field: \n")
f_no = db.select_make(select_fields)
field_name = select_fields[f_no - 1]
select_fields.pop(f_no - 1)
field_array.append(field_name)
if field_name == "date":
data = db.quote_str(
db.date_process(input("Enter Date(DD-MM-YYYY): ")))
else:
data = db.quote_str(
input("Enter {field}: ".format(field=field_name)))
data_array.append(data)
another = input("Do you want to enter another field ? [Y/N]")
db.update_data(table_name, sel, field_array, data_array)
