def post(self): """api to add the patient in the database""" try: if session['role_id'] == Roles.ADMIN.val(): 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'] pat_email = patientInput['pat_email'] pat_password = patientInput['pat_password'] 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 hashed_password = bcrypt.hashpw(pat_password.encode('utf-8'), SALT) pat_id = patientInput['pat_id'] r = conn.execute( "INSERT INTO user(id, email, password, role_id) VALUES(?,?,?,?)", (pat_id, pat_email, hashed_password, Roles.PATIENT.val())) conn.commit() return patientInput else: return {'status': 401, 'msg': 'Not authorized'} except KeyError as no_key: return {'status': 403, 'msg': 'Forbidden'}
def get(self): """Retrive the patient, doctor, appointment, medication count for the dashboard page""" getPatientCount=conn.execute("SELECT COUNT(*) AS patient FROM patient").fetchone() getDoctorCount = conn.execute("SELECT COUNT(*) AS doctor FROM doctor").fetchone() getAppointmentCount = conn.execute("SELECT COUNT(*) AS appointment FROM appointment").fetchone() getMedicationCount = conn.execute("SELECT COUNT(*) AS medication from medication").fetchone() getDepartmentCount = conn.execute("SELECT COUNT(*) AS department FROM department").fetchone() getNurseCount = conn.execute("SELECT COUNT(*) AS nurse FROM nurse").fetchone() getRoomCount = conn.execute("SELECT COUNT(*) AS room FROM room").fetchone() getProcedureCount = conn.execute("SELECT COUNT(*) AS procedure FROM procedure").fetchone() getPrescribesCount = conn.execute("SELECT COUNT(*) AS prescribes FROM prescribes").fetchone() getUndergoesCount = conn.execute("SELECT COUNT(*) AS undergoes FROM undergoes").fetchone() getPatientCount.update(getDoctorCount) getPatientCount.update(getAppointmentCount) getPatientCount.update(getMedicationCount) getPatientCount.update(getDepartmentCount) getPatientCount.update(getNurseCount) getPatientCount.update(getRoomCount) getPatientCount.update(getProcedureCount) getPatientCount.update(getPrescribesCount) getPatientCount.update(getUndergoesCount) return getPatientCount
def put(self, id): """api to update the patient by its id""" patientInputPafh = request.get_json(force=True) pat_first_name = patientInputPafh['pat_first_name'] #pat_last_name = patientInput['pat_last_name'] #pat_insurance_no = patientInput['pat_insurance_no'] pat_ph_no = patientInputPafh['pat_ph_no'] #pat_address = patientInput['pat_address'] pat_age = patientInputPafh['pat_age'] pat_bp = patientInputPafh['pat_bp'] pat_cancer = patientInputPafh['pat_cancer'] pat_diabetes = patientInputPafh['pat_diabetes'] pat_father = patientInputPafh['pat_father'] pat_mother = patientInputPafh['pat_mother'] pat_father_age = patientInputPafh['pat_father_age'] pat_mother_age = patientInputPafh['pat_mother_age'] pat_father_bp = patientInputPafh['pat_father_bp'] pat_father_cancer = patientInputPafh['pat_father_cancer'] pat_father_diabetes = patientInputPafh['pat_father_diabetes'] pat_mother_bp = patientInputPafh['pat_mother_bp'] pat_mother_cancer = patientInputPafh['pat_mother_cancer'] pat_mother_diabetes = patientInputPafh['pat_mother_diabetes'] conn.execute( "UPDATE patient_history SET pat_first_name=?,pat_ph_no=?,pat_age=?,pat_bp=?,pat_cancer=?,pat_diabetes=?,pat_father=?,pat_mother=?,pat_father_age=?,pat_mother_age=?,pat_father_bp=?,pat_father_cancer=?,pat_father_diabetes=?,pat_mother_bp=?,pat_mother_cancer=?,pat_mother_diabetes=? WHERE pat_id=?", (pat_first_name, pat_ph_no, pat_age, pat_bp, pat_cancer, pat_diabetes, pat_father, pat_mother, pat_father_age, pat_mother_age, pat_father_bp, pat_father_cancer, pat_father_diabetes, pat_mother_bp, pat_mother_cancer, pat_mother_diabetes, id)) conn.commit() return patientInputPafh
def put(self, id): bed = request.get_json(force=True) pat_id = appointment['pat_id'] conn.execute("UPDATE bed SET pat_id=? WHERE bed_id=?", (pat_id, id)) conn.commit() return bed
def post(self): """Add the new doctor""" try: if session['role_id'] == Roles.ADMIN.val(): 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'] doc_password = doctorInput['doc_password'] doc_email = doctorInput['doc_email'] 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 hashed_password = bcrypt.hashpw(doc_password.encode('utf-8'), SALT) doc_id = doctorInput['doc_id'] r = conn.execute( "INSERT INTO user(id, email, password, role_id) VALUES(?,?,?,?)", (doc_id, doc_email, hashed_password, Roles.DOCTOR.val())) conn.commit() return doctorInput else: return {'status': 401, 'msg': 'Not authorized'} except KeyError as no_key: return {'status': 403, 'msg': 'Forbidden'}
def get(self): """Retrive the patient,doctor and appointment count for the dashboard page""" getPatientCount=conn.execute("SELECT COUNT(*) AS patient FROM patient").fetchone() getDoctorCount = conn.execute("SELECT COUNT(*) AS doctor FROM doctor").fetchone() getAppointmentCount = conn.execute("SELECT COUNT(*) AS appointment FROM appointment").fetchone() getPatientCount.update(getDoctorCount) getPatientCount.update(getAppointmentCount) return getPatientCount
def put(self,department_id): """Update the department details by the department id""" department = request.get_json(force=True) name = department['name'] head_id = department['head_id'] conn.execute("UPDATE department SET name=?,head_id=? WHERE department_id=?", (name, head_id, department_id)) conn.commit() return department
def put(self,code): """Update the medication details by the code""" medication = request.get_json(force=True) name = medication['name'] brand = medication['brand'] description = medication['description'] conn.execute("UPDATE medication SET name=?,brand=?,description=? WHERE code=?", (name, brand, description, code)) conn.commit() return medication
def put(self,id): """Actualiza un turno por 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 put(self, room_no): """Update the room details by the room_no""" room = request.get_json(force=True) room_type = room['room_type'] available = room['available'] conn.execute("UPDATE room SET room_type=?,available=? WHERE room_no=?", (room_type, available, room_no)) conn.commit() return room
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 put(self, id): appointment = request.get_json(force=True) pat_id = appointment['pat_id'] doc_id = appointment['user_id'] conn.execute( "UPDATE appointment SET pat_id=?,user_id=? WHERE app_id=?", (pat_id, doc_id, id)) conn.commit() return appointment
def post(self): """Api to add departmentf in the database""" department = request.get_json(force=True) department_id = department['department_id'] name = department['name'] head_id = department['head_id'] conn.execute('''INSERT INTO department(department_id, name, head_id) VALUES(?,?,?)''', (department_id, name, head_id)) conn.commit() return department
def put(self, code): """Update the procedure details by the code""" procedure = request.get_json(force=True) name = procedure['name'] cost = procedure['cost'] conn.execute("UPDATE procedure SET name=?,cost=? WHERE code=?", (name, cost, code)) conn.commit() return procedure
def put(self, id): patientInput = request.get_json(force=True) tests = patientInput['tests'] charges = patientInput['charges'] diagnosis = patientInput['diagnosis'] conn.execute( "UPDATE patient SET tests=?, diagnosis=?, charges=? WHERE pat_id=?", (tests, diagnosis, charges, id)) conn.commit() return patientInput
def put(self, id): medInput = request.get_json(force=True) med_name = medInput['med_name'] uses = medInput['uses'] quant = medInput['quant'] conn.execute( "UPDATE medicine SET med_name=?,uses=?,quant=? WHERE med_id=?", (med_name, uses, quant, id)) conn.commit() return medInput
def post(self): """Api to add medication in the database""" medication = request.get_json(force=True) code = medication['code'] name = medication['name'] brand = medication['brand'] description = medication['description'] conn.execute('''INSERT INTO medication(code, name, brand, description) VALUES(?,?,?,?)''', (code, name, brand, description)) conn.commit() return medication
def put(self, email): personInput = request.get_json(force=True) person_email = personInput['person_email'] person_first_name = personInput['person_first_name'] person_last_name = personInput['person_last_name'] person_ph_no = personInput['person_ph_no'] conn.execute( "UPDATE contacts SET person_first_name=?,person_last_name=?,person_ph_no=?, WHERE person_email=?", (person_first_name, person_last_name, person_ph_no, person_email)) conn.commit() return personInput
def register(user): # salt = bcrypt.gensalt() hashed_password = bcrypt.hashpw(user.password.encode('utf-8'), SALT) sql_admin = "INSERT INTO admin(ad_first_name, ad_last_name, ad_gender) VALUES(?,?,?)" uid = conn.execute(sql_admin, (user.first_name, user.last_name, 1,)) print uid sql_user = "******" uid = conn.execute( sql_user, (3, user.email, hashed_password, user.role_id,)) conn.commit()
def delete(self, id): """api to delete the patiend by its id""" try: if session['role_id'] == Roles.ADMIN.val(): conn.execute("DELETE FROM patient WHERE pat_id=?", (id, )) conn.commit() return {'msg': 'sucessfully deleted'} else: return {'status': 401, 'msg': 'Not authorized'} except KeyError as no_key: return {'status': 403, 'msg': 'Forbidden'}
def post(self): """Api to add procedure in the database""" procedure = request.get_json(force=True) code = procedure['code'] name = procedure['name'] cost = procedure['cost'] conn.execute( '''INSERT INTO procedure(code, name, cost) VALUES(?,?,?)''', (code, name, cost)) conn.commit() return procedure
def get(self): """Obtiene numero de pacientes activos, numero de terapistas y turnos del mes para el dashboard principal """ getPatientCount = conn.execute( "SELECT COUNT(*) AS patient FROM patient").fetchone() getDoctorCount = conn.execute( "SELECT COUNT(*) AS doctor FROM doctor").fetchone() getAppointmentCount = conn.execute( "SELECT COUNT(*) AS appointment FROM appointment").fetchone() getPatientCount.update(getDoctorCount) getPatientCount.update(getAppointmentCount) return getPatientCount
def post(self): """Api to add room in the database""" room = request.get_json(force=True) room_no = room['room_no'] room_type = room['room_type'] available = room['available'] conn.execute( '''INSERT INTO room(room_no, room_type, available) VALUES(?,?,?)''', (room_no, room_type, available)) conn.commit() return room
def put(self, id): """api to update the other by it id""" otherInput = request.get_json(force=True) oth_name = otherInput['oth_name'] oth_role = otherInput['oth_role'] oth_ph_no = otherInput['oth_ph_no'] conn.execute( "UPDATE other SET oth_name=?,oth_role=?,oth_ph_no=? WHERE oth_id=?", (oth_name, oth_role, oth_ph_no, id)) conn.commit() return otherInput
def put(self,id): """api to update the patient by it id""" patientInput = request.get_json(force=True) pat_name=patientInput['pat_name'] pat_disease=patientInput['pat_disease'] pat_date=patientInput['pat_date'] pat_address = patientInput['pat_address'] pat_ph_no = patientInput['pat_ph_no'] conn.execute('''UPDATE patient SET pat_name=?,pat_disease=?,pat_date=?,pat_address=?,pat_ph_no=? WHERE pat_id=?''', (pat_name,pat_disease,pat_date,pat_address,pat_ph_no,id)).fetchall() conn.commit() return patientInput
def put(self, id): """Update the nurse by its id""" nurseInput = request.get_json(force=True) nur_first_name = nurseInput['nur_first_name'] nur_last_name = nurseInput['nur_last_name'] nur_ph_no = nurseInput['nur_ph_no'] nur_address = nurseInput['nur_address'] conn.execute( "UPDATE nurse SET nur_first_name=?,nur_last_name=?,nur_ph_no=?,nur_address=? WHERE nur_id=?", (nur_first_name, nur_last_name, nur_ph_no, nur_address, id)) conn.commit() return nurseInput
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 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 register(user): # salt = bcrypt.gensalt() hashed_password = bcrypt.hashpw( user.password.encode('utf-8'), SALT) sql_admin = "INSERT INTO admin(ad_first_name, ad_last_name) VALUES(?,?)" uid = conn.execute(sql_admin, (user.first_name, user.last_name)).lastrowid sql_user = "******" uid = conn.execute( sql_user, (uid, user.email, hashed_password, Roles.ADMIN.val())) conn.commit() return True
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 get(self): """Api to retive all the patient from the database""" fingerprint_id = fsearch.search() patients = conn.execute( "SELECT pat_id FROM patient where pat_fingerprint_id = ?", (fingerprint_id, )).fetchall() #pat = json.loads(patients[0]) print type(patients[0]) idnew = str(patients[0]['pat_id']) appointment = conn.execute( '''INSERT INTO appointment(pat_id) VALUES(?)''', (idnew)).lastrowid conn.commit() return appointment
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 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 the doctor by its id""" conn.execute("DELETE FROM doctor WHERE doc_id=?", (id,)) conn.commit() return {'msg': 'sucessfully deleted'}
def get(self,id): """api to retrive details of the patient by it id""" patient = conn.execute("SELECT * FROM patient WHERE pat_id=?",(id,)).fetchall() return patient
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 get(self): """Retrive list of all the doctor""" doctors = conn.execute("SELECT * FROM doctor ORDER BY doc_date DESC").fetchall() return doctors
def get(self): """Api to retive all the patient from the database""" patients = conn.execute("SELECT * FROM patient ORDER BY pat_date DESC").fetchall() return patients
def get(self,id): """get the details of the docktor by the doctor id""" doctor = conn.execute("SELECT * FROM doctor WHERE doc_id=?",(id,)).fetchall() return doctor