def create_patients(db: Session, patients: List[schemas.PatientInDb] ):
num_of_deleted_rows = db.query(models.Patient).delete()
for patient in patients:
try:
patient = models.Patient(**patient.dict())
db.add(patient)
except:
pass
db.commit()
return db.query(models.Patient).count()
def update_patients(db: Session, patients: List[schemas.PatientInDb] ):
for patient in patients:
patient = models.Patient(**patient.dict())
db_patient = get_patient_by_id(db, patient.patient_id)
if db_patient:
flag = delete_patient_by_id(db,patient.patient_id)
else:
pass
db.add(patient)
db.commit()
return db.query(models.Patient).count()
def create_patient_by_id(db: Session, patient: schemas.PatientCreate, patient_id: str):
bed_type, institute_type, institute_name, institute_flag = get_patient_derived_feilds(patient)
if institute_flag:
db_patient = models.Patient(
patient_id = patient_id,
ticket_id = patient.ticket_id,
institute_name = institute_name,
institute_type = institute_type,
bed_type = bed_type,
allotted = patient.allotted,
in_queue = patient.in_queue,
created_date = datetime.now()
)
db.add(db_patient)
db.commit()
db.refresh(db_patient)
return 1, db_patient
else:
return 0, None
#!/usr/bin/python
# -*- coding: utf8 -*-
import datetime
from app import db, models
user1 = models.User('1', '1')
user2 = models.User('bhh', 'bhh')
patient1 = models.Patient(u'BHH', u'098', u'32', u'nam', u'ở chùa', u'đẹp trai', u'đẹp trai')
patient2 = models.Patient(u'TheMoon', u'0923', u'23', u'nữ', u'vô gia cư', u'đẹp gái', u'đẹp gái')
patient3 = models.Patient(u'TheSun', u'0923', u'23', u'pêđê', u'trên sao hỏa', u'đẹp pêde', u'đẹp pêde')
medicine1 = models.Medicine(u'aspirin', u'mã 1', u'nhóm 1', u'hoạt tính 1', u'hộp', 10, 10000)
medicine2 = models.Medicine(u'toplexin', u'mã 2', u'nhóm 12', u'hoạt tính 2', u'vỉ', 130, 25400)
medicine3 = models.Medicine(u'pracetamon', u'mã 2', u'nhóm 12', u'hoạt tính 2', u'vỉ', 130, 25400)
diagnostic1 = models.Diagnostic(u'100', u'90', u'36', u'80', u'O', u'aa', patient1)
diagnostic2 = models.Diagnostic(u'200', u'900', u'36', u'81', u'O', u'bb', patient1)
diagnostic3 = models.Diagnostic(u'100', u'90', u'36', u'80', u'O', u'aa', patient2)
treatment1 = models.Treatment(u'khám lần đầu', patient1)
treatment2 = models.Treatment(u'khám lần hai', patient2)
db.session.add(user1)
db.session.add(user2)
db.session.add(patient1)
def create_patient(db: Session, patient: schemas.PatientCreate):
db_patient = models.Patient(age=patient.age, sex=patient.sex, name=patient.name, id=patient.id)
db.add(db_patient)
db.commit()
db.refresh(db_patient)
return db_patient