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)