def insert_to_young(name,age,address): data=[name,age,address] try: cur.execute("""INSERT INTO YOUNG(ID,NAME,AGE,ADDRESS) VALUES(NULL,?,?,?);""",data) conn.commit() except: print("can not insert please try again later")
def insert_care(oid,yid): dat=[oid,yid] try: cur.execute("""INSERT INTO CARE(OID<YID) VALUES(?,?);""",data) conn.commit() except: print("can not insert please try again later")
def approve_request(oname,yname): try: yid=get_young_id_by_name(yname) oid=get_olie_id_by_name(oname) query="UPDATE REQUEST_APPROVE SET REQUEST=1 WHERE OID="+oid+"&& YID="+yid cur.execute(query) conn.commit() except: print("can not insert please try again later")
def put(self,id): """Update the appointment details by the appointment id""" appointment = request.get_json(force=True) pat_id = appointment['pat_id'] doc_id = appointment['doc_id'] conn.execute("UPDATE appointment SET pat_id=?,doc_id=? WHERE app_id=?", (pat_id, doc_id, id)) conn.commit() return appointment
def post(self): """Create the appoitment by assiciating patient and docter with appointment date""" appointment = request.get_json(force=True) pat_id = appointment['pat_id'] doc_id = appointment['doc_id'] appointment_date = appointment['appointment_date'] appointment['app_id'] = conn.execute('''INSERT INTO appointment(pat_id,doc_id,appointment_date) VALUES(?,?,?)''', (pat_id, doc_id,appointment_date)).lastrowid conn.commit() return appointment
def make_request(yname,oname): yid=get_young_id_by_name(yname) oid=get_olie_id_by_name(oname) query="SELECT COUNT(YID) FROM CARE WHERE YID="+str(yid[0]) data=[oid[0],yid[0]] if(next(cur.execute(query))[0]<4): cur.execute("""INSERT INTO REQUEST_APPROVE(OID,YID,REQUEST) VALUES(?,?,0);""",data) conn.commit() else: print("YOU CANNOT TAKE CARE OF MORE THAN 4 PEOPLE")
def put(self, id): """Update the medicine by its id""" medicineInput = request.get_json(force=True) medicine_name = medicineInput['medicine_name'] desease = medicineInput['desease'] pat_name = medicineInput['pat_name'] conn.execute( "UPDATE medicine SET medicine_name=?,desease=?,pat_name=? WHERE med_id=?", (medicine_name, desease, pat_name, id)) conn.commit() return medicineInput
def post(self): """Add the new doctor""" doctorInput = request.get_json(force=True) doc_first_name=doctorInput['doc_first_name'] doc_last_name = doctorInput['doc_last_name'] doc_ph_no = doctorInput['doc_ph_no'] doc_address = doctorInput['doc_address'] doctorInput['doc_id']=conn.execute('''INSERT INTO doctor(doc_first_name,doc_last_name,doc_ph_no,doc_address) VALUES(?,?,?,?)''', (doc_first_name, doc_last_name,doc_ph_no,doc_address)).lastrowid conn.commit() return doctorInput
def post(self): """api to add the bill in the database""" billInput = request.get_json(force=True) pat_name = billInput['pat_name'] amount = billInput['amount'] bill_date = billInput['bill_date'] billInput['bill_id'] = conn.execute( '''INSERT INTO bill(pat_name,amount) VALUES(?,?)''', (pat_name, amount)).lastrowid conn.commit() return billInput
def post(self): """Add the new medicine""" medicineInput = request.get_json(force=True) #med_id=medicineInput['med_id'] medicine_name = medicineInput['medicine_name'] desease = medicineInput['desease'] pat_name = medicineInput['pat_name'] medicineInput['med_id'] = conn.execute( '''INSERT INTO medicine(medicine_name,desease,pat_name) VALUES(?,?,?)''', (medicine_name, desease, pat_name)).lastrowid conn.commit() return medicineInput
def put(self, id): """api to update the bill by it id""" billInput = request.get_json(force=True) pat_name = billInput['pat_name'] amount = billInput['amount'] bill_date = billInput['bill_date'] #bill_id = billInput['bill_id'] #pat_address = billInput['pat_address'] conn.execute("UPDATE bill SET pat_name=?,amount=? WHERE bill_id=?", (pat_name, amount, id)) conn.commit() return billInput
def put(self, id): """Update the staff by its id""" staffInput = request.get_json(force=True) stf_first_name = staffInput['stf_first_name'] stf_last_name = staffInput['stf_last_name'] stf_ph_no = staffInput['stf_ph_no'] stf_address = staffInput['stf_address'] conn.execute( "UPDATE staff SET stf_first_name=?,stf_last_name=?,stf_ph_no=?,stf_address=? WHERE stf_id=?", (stf_first_name, stf_last_name, stf_ph_no, stf_address, id)) conn.commit() return staffInput
def put(self,id): """Update the doctor by its id""" doctorInput = request.get_json(force=True) doc_first_name=doctorInput['doc_first_name'] doc_last_name = doctorInput['doc_last_name'] doc_ph_no = doctorInput['doc_ph_no'] doc_address = doctorInput['doc_address'] conn.execute( "UPDATE doctor SET doc_first_name=?,doc_last_name=?,doc_ph_no=?,doc_address=? WHERE doc_id=?", (doc_first_name, doc_last_name, doc_ph_no, doc_address, id)) conn.commit() return doctorInput
def post(self): """Add the new staff""" staffInput = request.get_json(force=True) stf_first_name = staffInput['stf_first_name'] stf_last_name = staffInput['stf_last_name'] stf_ph_no = staffInput['stf_ph_no'] stf_address = staffInput['stf_address'] staffInput['stf_id'] = conn.execute( '''INSERT INTO staff(stf_first_name,stf_last_name,stf_ph_no,stf_address) VALUES(?,?,?,?)''', (stf_first_name, stf_last_name, stf_ph_no, stf_address)).lastrowid conn.commit() return staffInput
def put(self, id): """api to update the patient by it id""" patientInput = request.get_json(force=True) pat_first_name = patientInput['pat_first_name'] pat_last_name = patientInput['pat_last_name'] pat_insurance_no = patientInput['pat_insurance_no'] pat_ph_no = patientInput['pat_ph_no'] pat_address = patientInput['pat_address'] conn.execute( "UPDATE patient SET pat_first_name=?,pat_last_name=?,pat_insurance_no=?,pat_ph_no=?,pat_address=? WHERE pat_id=?", (pat_first_name, pat_last_name, pat_insurance_no, pat_ph_no, pat_address, id)) conn.commit() return patientInput
def post(self): """api to add the patient in the database""" patientInput = request.get_json(force=True) pat_first_name = patientInput['pat_first_name'] pat_last_name = patientInput['pat_last_name'] pat_insurance_no = patientInput['pat_insurance_no'] pat_ph_no = patientInput['pat_ph_no'] pat_address = patientInput['pat_address'] patientInput['pat_id'] = conn.execute( '''INSERT INTO patient(pat_first_name,pat_last_name,pat_insurance_no,pat_ph_no,pat_address) VALUES(?,?,?,?,?)''', (pat_first_name, pat_last_name, pat_insurance_no, pat_ph_no, pat_address)).lastrowid conn.commit() return patientInput
def delete(self,id): """Delete teh appointment by its id""" conn.execute("DELETE FROM appointment WHERE app_id=?",(id,)) conn.commit() return {'msg': 'sucessfully deleted'}
def delete(self, id): """Delete the staff by its id""" conn.execute("DELETE FROM staff WHERE stf_id=?", (id, )) conn.commit() return {'msg': 'sucessfully deleted'}
from flask_restful import Resource, Api, request from model import conn #billInput = request.get_json(force=True) pat_name = 'pat' #bill_date = bill['bill_date'] amount = 25000 conn.execute('''INSERT INTO bill(pat_name,amount) VALUES(?,?)''', (pat_name, amount)).lastrowid conn.commit()
def delete(self, id): """Delete the doctor by its id""" conn.execute("DELETE FROM doctor WHERE doc_id=?", (id,)) conn.commit() return {'msg': 'sucessfully deleted'}
def insert_to_old(data): try: cur.execute("""INSERT INTO OLD(ID,NAME,AGE,ADDRESS,FUND) VALUES(NULL,?,?,?,?);""",data) conn.commit() except: print("can not insert please try again later")
def delete(self, id): """api to delete the patiend by its id""" conn.execute("DELETE FROM patient WHERE pat_id=?", (id, )) conn.commit() return {'msg': 'sucessfully deleted'}
def delete(self, id): """Delete the medicine by its id""" conn.execute("DELETE FROM medicine WHERE med_id=?", (id, )) conn.commit() return {'msg': 'sucessfully deleted'}