def add_medicine_by_name_manufacturer_brand_spec_amount_default_price( med_name, med_manufacturer, brand, spec, amount, price): sql_helper.exec_sql( 'INSERT INTO Medicines values (%(med_name)s, %(med_manufacturer)s,%(brand)s, %(spec)s, ' '%(amount)s, %(price)s)', { 'med_name': med_name, 'med_manufacturer': med_manufacturer, 'brand': brand, 'spec': spec, 'amount': amount, 'price': price }) return sql_helper.fetchall_to_dict( "SELECT * FROM Medicines " "WHERE med_name = %(med_name)s, med_manufacturer = %(med_manufacturer)s, " "brand = %(brand)s, spec = %(spec)s", { 'med_name': med_name, 'med_manufacturer': med_manufacturer, 'brand': brand, 'spec': spec })
def get_bp_records_by_patient_id(patient_id): return sql_helper.fetchall_to_dict( "SELECT * FROM BP_Records WHERE patient_id = %(patient_id)s ORDER BY create_time DESC", {'patient_id': patient_id})
def get_medicine_by_med_name(med_name): return sql_helper.fetchall_to_dict( "SELECT * FROM Medicines" " where med_name LIKE %(med_name)s", {'med_name': '%' + med_name + '%'})
def get_patients_by_patient_id(patient_id): return sql_helper.fetchall_to_dict( "SELECT * FROM Patients WHERE patient_id = %(patient_id)s", {'patient_id': patient_id})
def search_patients(keyword): return sql_helper.fetchall_to_dict( "SELECT * FROM Patients p WHERE p.name LIKE %(keyword)s", {"keyword": '%' + keyword + '%'})
def get_patients_by_name(name): return sql_helper.fetchall_to_dict( "SELECT * FROM Patients p WHERE p.name = %(name)s", {'name': name})
def get_prescriptions_with_medicine_by_patient_name(patient_name): return sql_helper.fetchall_to_dict( "SELECT uname, patient_id, create_time, prescription_id, med_name, med_manufacturer, brand, spec, name, phone_number" " FROM ((Patients NATURAL JOIN Prescriptions) NATURAL JOIN Has_Medicine) p WHERE p.name = %(name)s" " ORDER BY patient_id DESC", {'name': patient_name})
def get_all_patients(): return sql_helper.fetchall_to_dict("SELECT * FROM Patients")
def get_prescriptions_with_medicine_by_patient_id(patient_id): return sql_helper.fetchall_to_dict( "SELECT * FROM Prescriptions NATURAL JOIN Has_Medicine WHERE patient_id = %(patient_id)s ORDER BY create_time", {'patient_id': patient_id})
def get_all_paid_unpaid_bills_by_doc_uname(uname, paid): return sql_helper.fetchall_to_dict( "SELECT * FROM Bills WHERE paid = %(paid), uname = %(uname)s ORDER BY create_time", {'uname': uname, 'paid': paid})
def set_bill_paid_by_bill_id_and_status(bill_id, paid, paid_time): return sql_helper.fetchall_to_dict("UPDATE Bills SET paid = %(paid)s" " WHERE bill_id = %(bill_id)s, paid_time = %(paid_time)s", {'bill_id': bill_id, 'paid': paid, 'paid_time': paid_time})
def get_all_bills_by_doc_uname(uname): return sql_helper.fetchall_to_dict( "SELECT * FROM Bills WHERE uname = %(uname)s ORDER BY create_time", {'uname': uname})
def get_doctors_by_uname(uname): return sql_helper.fetchall_to_dict("SELECT u.name, u.email FROM Users u NATURAL JOIN Doctors WHERE uname = %(uname)s", {'uname': uname})