示例#1
0
    def get(self, _id=None):
        if _id:
            doctor = DoctorModel.find_by_id(_id)
            if doctor:
                return BaseResponse.ok_response('Successful.', doctor.json())
            return BaseResponse.bad_request_response('Doctor does not exists.', {})
        else:
            doctors = list(map(lambda x: x.json(), DoctorModel.find_all()))

            return BaseResponse.ok_response('Successful.', doctors)
    def put(self, _id=None, doc_spec_id=None):
        try:
            data = DoctorSpeciality.parser.parse_args()

            if DoctorModel.find_by_id(_id) is None:
                return BaseResponse.bad_request_response(
                    'Doctor does not exists.', {})

            doctor_speciality = DoctorSpecialityModel.find_by_id(doc_spec_id)
            if doctor_speciality:
                doctor_speciality.doctorId = data['doctorId'] if (data['doctorId'] is not None) \
                    else doctor_speciality.doctorId
                doctor_speciality.medicalSpecialityId = data['medicalSpecialityId'] \
                    if (data['medicalSpecialityId'] is not None) else doctor_speciality.medicalSpecialityId

                doctor_speciality.save_to_db()

                return BaseResponse.created_response(
                    'Doctor speciality updated successfully.',
                    doctor_speciality.json(only_spec=False))
            else:
                return BaseResponse.not_acceptable_response(
                    'Doctor speciality does not exists.', {})
        except Exception as e:
            return BaseResponse.server_error_response(unicode(e))
示例#3
0
    def delete(self, patient_id=None, doctor_id=None, _id=None):
        try:
            if PatientModel.find_by_id(patient_id) is None:
                return BaseResponse.bad_request_response(
                    'Patient does not exists.', {})
            elif DoctorModel.find_by_id(doctor_id) is None:
                return BaseResponse.bad_request_response(
                    'Doctor does not exists.', {})

            prescription = PrescriptionModel.find_by_id(_id)

            if prescription:
                prescription.status = 'INA'
                prescription.finishedAt = datetime.now().strftime(
                    '%Y-%m-%d %H:%M:%S')

                prescription.save_to_db()

                return BaseResponse.ok_response(
                    'Prescription deleted successfully.', {})
            else:
                return BaseResponse.not_acceptable_response(
                    'Prescription does not exists.', {})
        except Exception as e:
            return BaseResponse.server_error_response(unicode(e))
示例#4
0
    def put(self, doctor_id=None, _id=None):
        try:
            data = MembershipDoctor.parser.parse_args()

            if DoctorModel.find_by_id(doctor_id) is None:
                return BaseResponse.bad_request_response(
                    'Doctor does not exists.', {})

            membership = MembershipModel.find_by_id(_id)

            if membership:
                membership.expiresAt = data['expiresAt'] if (
                    data['expiresAt'] is not None) else membership.expiresAt
                membership.updatedOn = datetime.now().strftime(
                    '%Y-%m-%d %H:%M:%S')

                membership.save_to_db()

                return BaseResponse.created_response(
                    'Membership updated successfully.',
                    membership.json(role_id=1))
            else:
                return BaseResponse.not_acceptable_response(
                    'Membership does not exists.', {})
        except Exception as e:
            return BaseResponse.server_error_response(unicode(e))
示例#5
0
    def put(self, doctor_id=None, patient_id=None, _id=None):
        try:
            data = PrescriptionDoctor.parser.parse_args()

            if DoctorModel.find_by_id(doctor_id) is None:
                return BaseResponse.bad_request_response(
                    'Doctor does not exists.', {})
            elif PatientModel.find_by_id(patient_id) is None:
                return BaseResponse.bad_request_response(
                    'Patient does not exists.', {})

            prescription = PrescriptionModel.find_by_id(_id)

            if prescription:
                prescription.frequency = data['frequency'] if (data['frequency'] is not None) \
                    else prescription.frequency
                prescription.quantity = data['quantity'] if (
                    data['quantity'] is not None) else prescription.quantity
                prescription.durationInDays = data['durationInDays'] if (data['durationInDays'] is not None) \
                    else prescription.durationInDays
                prescription.description = data['description'] if (data['description'] is not None) \
                    else prescription.description
                prescription.finishedAt = data['finishedAt'] if (data['finishedAt'] is not None) \
                    else prescription.finishedAt

                prescription.save_to_db()

                return BaseResponse.created_response(
                    'Prescription updated successfully.',
                    prescription.json(role_id=1))
            else:
                return BaseResponse.not_acceptable_response(
                    'Prescription does not exists.', {})
        except Exception as e:
            return BaseResponse.server_error_response(unicode(e))
示例#6
0
    def put(self, _id=None, appointment_id=None):
        try:
            data = AppointmentDoctor.parser.parse_args()

            if DoctorModel.find_by_id(_id) is None:
                return BaseResponse.bad_request_response(
                    'Doctor does not exists.', {})

            appointment = AppointmentModel.find_by_id(appointment_id)
            if appointment:
                appointment.appointmentDate = data['appointmentDate'] if (data['appointmentDate'] is not None) \
                    else appointment.appointmentDate
                appointment.reason = data['reason'] if (
                    data['reason'] is not None) else appointment.reason
                appointment.canceledAt = data['canceledAt'] if (data['canceledAt'] is not None) \
                    else appointment.canceledAt
                appointment.updatedOn = datetime.now().strftime(
                    '%Y-%m-%d %H:%M:%S')

                appointment.save_to_db()

                return BaseResponse.created_response(
                    'Appointment updated successfully.',
                    appointment.json(role_id=1))
            else:
                return BaseResponse.not_acceptable_response(
                    'Appointment does not exists.', {})
        except Exception as e:
            return BaseResponse.server_error_response(str(e))
示例#7
0
    def post(self, doctor_id=None, patient_id=None):
        try:
            data = PrescriptionDoctor.parser.parse_args()

            if DoctorModel.find_by_id(doctor_id) is None:
                return BaseResponse.bad_request_response(
                    'Doctor does not exists.', {})
            elif PatientModel.find_by_id(patient_id) is None:
                return BaseResponse.bad_request_response(
                    'Patient does not exists.', {})

            prescription = PrescriptionModel(
                doctor_id=doctor_id,
                patient_id=patient_id,
                prescription_type_id=data['prescriptionTypeId'],
                frequency=data['frequency'],
                quantity=data['quantity'],
                duration_in_days=data['durationInDays'],
                description=data['description'],
                created_at=None,
                started_at=data['startedAt'],
                finished_at=None,
                status=None)

            prescription.save_to_db()

            return BaseResponse.created_response(
                'Prescription created successfully.',
                prescription.json(role_id=1))
        except Exception as e:
            return BaseResponse.server_error_response(unicode(e))
示例#8
0
    def post(self, _id=None):
        try:
            data = AppointmentDoctor.parser.parse_args()

            if DoctorModel.find_by_id(_id) is None:
                return BaseResponse.bad_request_response(
                    'Doctor does not exists.', {})
            elif AppointmentModel.find_by_appointment_date(
                    data['appointmentDate']):
                return BaseResponse.bad_request_response(
                    'An appointment is already scheduled in that date.', {})

            appointment = AppointmentModel(
                doctor_id=_id,
                patient_id=data['patientId'],
                appointment_date=data['appointmentDate'],
                reason=data['reason'],
                created_at=None,
                canceled_at=data['canceledAt'],
                updated_on=None,
                status=None)

            appointment.save_to_db()

            return BaseResponse.created_response(
                'Appointment created successfully.',
                appointment.json(role_id=1))
        except Exception as e:
            return BaseResponse.server_error_response(unicode(e))
    def get(self, _id=None, doc_spec_id=None):
        if DoctorModel.find_by_id(_id) is None:
            return BaseResponse.bad_request_response('Doctor does not exists.',
                                                     {})

        if doc_spec_id:
            doctor_speciality = DoctorSpecialityModel.find_by_id(doc_spec_id)
            if doctor_speciality:
                return BaseResponse.ok_response(
                    'Successful.', doctor_speciality.json(only_spec=False))
            return BaseResponse.bad_request_response(
                'Doctor speciality does not exists.', {})
        else:
            doctor = DoctorModel.find_by_id(_id)
            doctor_specialities = list(
                map(lambda x: x.json(only_spec=True),
                    doctor.doctorSpecialities))

            return BaseResponse.ok_response('Successful.', doctor_specialities)
示例#10
0
    def delete(self, _id=None):
        try:
            if _id:
                doctor = DoctorModel.find_by_id(_id)
                if doctor:
                    doctor.status = 'INA'
                    doctor.updatedOn = datetime.now().strftime('%Y-%m-%d %H:%M:%S')

                    doctor.save_to_db()

                    return BaseResponse.ok_response('User deleted successfully.', doctor.json())
                else:
                    return BaseResponse.not_acceptable_response('Doctor does not exists.', {})
            else:
                return BaseResponse.bad_request_response('Doctor id is not given.', {})
        except Exception as e:
            return BaseResponse.server_error_response(str(e))
    def delete(self, _id=None, doc_spec_id=None):
        try:
            if DoctorModel.find_by_id(_id) is None:
                return BaseResponse.bad_request_response(
                    'Doctor does not exists.', {})

            doctor_speciality = DoctorSpecialityModel.find_by_id(doc_spec_id)
            if doctor_speciality:
                doctor_speciality.delete_from_db()

                return BaseResponse.ok_response(
                    'Doctor speciality deleted successfully.', {})
            else:
                return BaseResponse.not_acceptable_response(
                    'Doctor speciality does not exists.', {})
        except Exception as e:
            return BaseResponse.server_error_response(unicode(e))
示例#12
0
    def get(self, doctor_id=None, _id=None):
        doctor = DoctorModel.find_by_id(doctor_id)
        if doctor is None:
            return BaseResponse.bad_request_response('Doctor does not exists.',
                                                     {})

        if _id:
            membership = MembershipModel.find_by_patient_id(_id)
            if membership:
                return BaseResponse.ok_response('Successful.',
                                                membership.json(role_id=1))
            return BaseResponse.bad_request_response(
                'Membership does not exists.', {})
        else:
            memberships = list(
                map(lambda x: x.json(role_id=1), doctor.memberships))

            return BaseResponse.ok_response('Successful.', memberships)
示例#13
0
    def get(self, _id=None, appointment_id=None):
        doctor = DoctorModel.find_by_id(_id)
        if doctor is None:
            return BaseResponse.bad_request_response('Doctor does not exists.',
                                                     {})

        if appointment_id:
            appointment = AppointmentModel.find_by_id(appointment_id)
            if appointment:
                return BaseResponse.ok_response('Successful.',
                                                appointment.json(role_id=1))
            return BaseResponse.bad_request_response(
                'Appointment does not exists.', {})
        else:
            appointments = list(
                map(lambda x: x.json(role_id=1), doctor.appointments))

            return BaseResponse.ok_response('Successful.', appointments)
示例#14
0
    def post():
        try:
            data = Doctor.parser.parse_args()

            if DoctorModel.find_by_user_id(data['userId']):
                return BaseResponse.bad_request_response('This doctor already exists.', {})

            doctor = DoctorModel(user_id=data['userId'], plan_id=data['planId'], address_id=data['addressId'],
                                 doctor_identification=data['doctorIdentification'], created_at=None,
                                 updated_on=None, status=None)

            doctor.save_to_db()

            return BaseResponse.created_response('Doctor created successfully.', doctor.json())
        except Exception as e:
            return BaseResponse.server_error_response(str(e))
示例#15
0
    def delete(self, doctor_id=None, _id=None):
        try:
            if DoctorModel.find_by_id(doctor_id) is None:
                return BaseResponse.bad_request_response(
                    'Doctor does not exists.', {})

            membership = MembershipModel.find_by_id(_id)

            if membership:
                membership.status = 'INA'
                membership.updatedOn = datetime.now().strftime(
                    '%Y-%m-%d %H:%M:%S')

                membership.save_to_db()

                return BaseResponse.ok_response(
                    'Membership deleted successfully.', {})
            else:
                return BaseResponse.not_acceptable_response(
                    'Membership does not exists.', {})
        except Exception as e:
            return BaseResponse.server_error_response(unicode(e))
    def post(self, _id=None):
        try:
            data = DoctorSpeciality.parser.parse_args()

            if DoctorModel.find_by_id(_id) is None:
                return BaseResponse.bad_request_response(
                    'Doctor does not exists.', {})
            elif DoctorSpecialityModel.verify_doctor_speciality(
                    _id, data['medicalSpecialityId']):
                return BaseResponse.bad_request_response(
                    'This doctor already have this specialities.', {})

            doctor_speciality = DoctorSpecialityModel(
                doctor_id=_id,
                medical_speciality_id=data['medicalSpecialityId'])

            doctor_speciality.save_to_db()

            return BaseResponse.created_response(
                'Doctor speciality created successfully.',
                doctor_speciality.json(only_spec=False))
        except Exception as e:
            return BaseResponse.server_error_response(unicode(e))
示例#17
0
    def delete(self, _id=None, appointment_id=None):
        try:
            if DoctorModel.find_by_id(_id) is None:
                return BaseResponse.bad_request_response(
                    'Doctor does not exists.', {})

            appointment = AppointmentModel.find_by_id(appointment_id)
            if appointment:
                appointment.status = 'INA'
                appointment.updatedOn = datetime.now().strftime(
                    '%Y-%m-%d %H:%M:%S')
                appointment.canceledAt = datetime.now().strftime(
                    '%Y-%m-%d %H:%M:%S')

                appointment.save_to_db()

                return BaseResponse.ok_response(
                    'Appointment deleted successfully.', {})
            else:
                return BaseResponse.not_acceptable_response(
                    'Appointment does not exists.', {})
        except Exception as e:
            return BaseResponse.server_error_response(str(e))
示例#18
0
    def get(self, doctor_id=None, patient_id=None, _id=None):
        if DoctorModel.find_by_id(doctor_id) is None:
            return BaseResponse.bad_request_response('Doctor does not exists.',
                                                     {})
        elif PatientModel.find_by_id(patient_id) is None:
            return BaseResponse.bad_request_response(
                'Patient does not exists.', {})

        if _id:
            prescription = PrescriptionModel.find_by_id(_id)
            if prescription:
                return BaseResponse.ok_response('Successful.',
                                                prescription.json(role_id=1))
            return BaseResponse.bad_request_response(
                'Prescription does not exists.', {})
        else:
            prescriptions = list(
                map(
                    lambda x: x.json(role_id=1),
                    PrescriptionModel.find_by_doctor_and_patient_id(
                        doctor_id, patient_id)))

            return BaseResponse.ok_response('Successful.', prescriptions)
示例#19
0
    def put(self, _id=None):
        try:
            data = Doctor.parser.parse_args()

            if _id:
                doctor = DoctorModel.find_by_id(_id)
                if doctor:
                    doctor.userId = data['userId'] if (data['userId'] is not None) else doctor.userId
                    doctor.planId = data['planId'] if (data['planId'] is not None) else doctor.planId
                    doctor.addressId = data['addressId'] if (data['addressId'] is not None) else doctor.addressId
                    doctor.doctorIdentification = data['doctorIdentification'] if \
                        (data['doctorIdentification'] is not None) else doctor.doctorIdentification
                    doctor.updatedOn = datetime.now().strftime('%Y-%m-%d %H:%M:%S')

                    doctor.save_to_db()

                    return BaseResponse.ok_response('User updated successfully.', doctor.json())
                else:
                    return BaseResponse.not_acceptable_response('Doctor does not exists.', {})
            else:
                return BaseResponse.bad_request_response('Doctor id is not given.', {})
        except Exception as e:
            return BaseResponse.server_error_response(str(e))
示例#20
0
    def post(self, doctor_id=None):
        try:
            data = MembershipDoctor.parser.parse_args()
            supposed_membership = MembershipModel.find_by_doctor_id(doctor_id)

            if DoctorModel.find_by_id(doctor_id) is None:
                return BaseResponse.bad_request_response(
                    'Doctor does not exists.', {})
            elif supposed_membership.patientId == data['patientId']:
                if supposed_membership.status == 'INA':
                    supposed_membership.status = 'ACT'

                    supposed_membership.save_to_db()

                    return BaseResponse.ok_response(
                        'Membership activated.',
                        supposed_membership.json(role_id=1))
                return BaseResponse.bad_request_response(
                    'A membership with this patient already exists.', {})

            membership = MembershipModel(
                doctor_id=doctor_id,
                patient_id=data['patientId'],
                referenced_email=data['referencedEmail'],
                access_code=None,
                created_at=None,
                expires_at=None,
                updated_on=None,
                status=None)

            membership.save_to_db()

            return BaseResponse.created_response(
                'Membership created successfully.', membership.json(role_id=1))
        except Exception as e:
            return BaseResponse.server_error_response(unicode(e))
示例#21
0
def load_tables():
    db.engine.execute("SET @@auto_increment_increment=1;")
    db.engine.execute("SET @@auto_increment_offset=1;")

    # District
    if DistrictModel.query.first() is None:
        district1 = DistrictModel('Callao', 'CAL')
        district2 = DistrictModel('Bellavista', 'BEL')
        district3 = DistrictModel('Carmen De La Legua Reynoso', 'CLR')
        district4 = DistrictModel('La Perla', 'LPE')
        district5 = DistrictModel('La Punta', 'LPU')
        district6 = DistrictModel('Ventanilla', 'VEN')
        district7 = DistrictModel('Cusco', 'CUS')
        district8 = DistrictModel('Ccorca', 'CCO')
        district9 = DistrictModel('Poroy', 'POR')
        district10 = DistrictModel('San Jeronimo', 'SJE')
        district11 = DistrictModel('San Sebastian', 'SSE')
        district12 = DistrictModel('Santiago', 'SAN')
        district13 = DistrictModel('Saylla', 'SAY')
        district14 = DistrictModel('Wanchaq', 'WAN')
        district15 = DistrictModel('Lima', 'LIM')
        district16 = DistrictModel('Ancon', 'ANC')
        district17 = DistrictModel('Ate', 'ATE')
        district18 = DistrictModel('Barranco', 'BAR')
        district19 = DistrictModel('Breña', 'BRE')
        district20 = DistrictModel('Carabayllo', 'CAR')
        district21 = DistrictModel('Chaclacayo', 'CHC')
        district22 = DistrictModel('Chorrillos', 'CHO')
        district23 = DistrictModel('Cieneguilla', 'CIE')
        district24 = DistrictModel('Comas', 'COM')
        district25 = DistrictModel('El Agustino', 'EAG')
        district26 = DistrictModel('Independencia', 'IND')
        district27 = DistrictModel('Jesus Maria', 'JEM')
        district28 = DistrictModel('La Molina', 'LMO')
        district29 = DistrictModel('La Victoria', 'LVI')
        district30 = DistrictModel('Lince', 'LIN')
        district31 = DistrictModel('Los Olivos', 'LOL')
        district32 = DistrictModel('Lurigancho', 'LRG')
        district33 = DistrictModel('Lurin', 'LUR')
        district34 = DistrictModel('Magdalena Del Mar', 'MGM')
        district35 = DistrictModel('Magdalena Vieja', 'MGV')
        district36 = DistrictModel('Miraflores', 'MIR')
        district37 = DistrictModel('Pachacamac', 'PAC')
        district38 = DistrictModel('Pucusana', 'PUC')
        district39 = DistrictModel('Puente Piedra', 'PUP')
        district40 = DistrictModel('Punta Hermosa', 'PUH')
        district41 = DistrictModel('Punta Negra', 'PUN')
        district42 = DistrictModel('Rimac', 'RIM')
        district43 = DistrictModel('San Bartolo', 'SBA')
        district44 = DistrictModel('San Borja', 'SBO')
        district45 = DistrictModel('San Isidro', 'SIS')
        district46 = DistrictModel('San Juan De Lurigancho', 'SJL')
        district47 = DistrictModel('San Juan De Miraflores', 'SJM')
        district48 = DistrictModel('San Luis', 'SAL')
        district49 = DistrictModel('San Martin De Porres', 'SMP')
        district50 = DistrictModel('San Miguel', 'SMI')
        district51 = DistrictModel('Santa Anita', 'SNT')
        district52 = DistrictModel('Santa Maria Del Mar', 'SMM')
        district53 = DistrictModel('Santa Rosa', 'SAR')
        district54 = DistrictModel('Santiago De Surco', 'SAS')
        district55 = DistrictModel('Surquillo', 'SUR')
        district56 = DistrictModel('Villa El Salvador', 'VES')
        district57 = DistrictModel('Villa Maria Del Triunfo', 'VMT')

        districts = [district1, district2, district3, district4, district5, district6, district7, district8,
                     district9,
                     district10, district11, district12, district13, district14, district15, district16, district17,
                     district18, district19, district20, district21, district22, district23, district24, district25,
                     district26, district27, district28, district29, district30, district31, district32, district33,
                     district34, district35, district36, district37, district38, district39, district40, district41,
                     district42, district43, district44, district45, district46, district47, district48, district49,
                     district50, district51, district52, district53, district54, district55, district56, district57]

        for obj_district in districts:
            obj_district.save_to_db()
            pass
        pass

    # Plan
    if PlanModel.query.first() is None:
        plan1 = PlanModel('General Patient', 'GEP', 'You can be monitored by your doctor through the application',
                          None, 0)
        plan2 = PlanModel('Premium Patient', 'PRP', 'You can sync your wearable with the application', None, 9.99)
        plan3 = PlanModel('General Doctor', 'GED', 'You can take care of 10 patients', 10, 39.99)
        plan4 = PlanModel('Premium Doctor', 'PRD',
                          'You can take care of 20 patients and grant access to dashboard.',
                          20, 59.99)
        plan5 = PlanModel('Extra Plan', 'EXT', 'You can add 10 more patients to your plan', 10, 9.99)

        plans = [plan1, plan2, plan3, plan4, plan5]

        for obj_plan in plans:
            obj_plan.save_to_db()
            pass
        pass

    # Role
    if RoleModel.query.first() is None:
        role1 = RoleModel('Doctor', 'DOC')
        role2 = RoleModel('Patient', 'PAT')

        roles = [role1, role2]

        for obj_role in roles:
            obj_role.save_to_db()
            pass
        pass

    # Medical Speciality
    if MedicalSpecialityModel.query.first() is None:
        med_spec1 = MedicalSpecialityModel('Pathological Anatomy', 'PAA')
        med_spec2 = MedicalSpecialityModel('Allergology', 'ALE')
        med_spec3 = MedicalSpecialityModel('Cardiology', 'CAR')
        med_spec4 = MedicalSpecialityModel('Cardiac surgery', 'CRS')
        med_spec5 = MedicalSpecialityModel('General Surgery', 'GNS')
        med_spec6 = MedicalSpecialityModel('Plastic Surgery', 'PLS')
        med_spec7 = MedicalSpecialityModel('Dermatology', 'DER')
        med_spec8 = MedicalSpecialityModel('Endocrinology', 'END')
        med_spec9 = MedicalSpecialityModel('Nutrition', 'NUT')
        med_spec10 = MedicalSpecialityModel('Gastroenterology', 'GAS')
        med_spec11 = MedicalSpecialityModel('Geriatrician', 'GER')
        med_spec12 = MedicalSpecialityModel('Gynecology', 'GYN')
        med_spec13 = MedicalSpecialityModel('Hematology', 'HEM')
        med_spec14 = MedicalSpecialityModel('Hepatology', 'HEP')
        med_spec15 = MedicalSpecialityModel('Infectious Diseases', 'IDS')
        med_spec16 = MedicalSpecialityModel('Internal Medicine', 'INM')
        med_spec17 = MedicalSpecialityModel('Nephrology', 'NEP')
        med_spec18 = MedicalSpecialityModel('Pulmonology', 'PUL')
        med_spec19 = MedicalSpecialityModel('Neurology', 'NEU')
        med_spec20 = MedicalSpecialityModel('Neurosurgery', 'NRS')
        med_spec21 = MedicalSpecialityModel('Ophthalmology', 'OPH')
        med_spec22 = MedicalSpecialityModel('Otolaryngology', 'OTO')
        med_spec23 = MedicalSpecialityModel('Oncology', 'ONC')
        med_spec24 = MedicalSpecialityModel('Pediatrician', 'PED')
        med_spec25 = MedicalSpecialityModel('Proctology', 'PRC')
        med_spec26 = MedicalSpecialityModel('Psychiatrist', 'PSY')
        med_spec27 = MedicalSpecialityModel('Rehabilitation', 'REH')
        med_spec28 = MedicalSpecialityModel('Rheumatology', 'RHE')
        med_spec29 = MedicalSpecialityModel('Traumatology', 'TRA')
        med_spec30 = MedicalSpecialityModel('Urology', 'URO')

        med_specialities = [med_spec1, med_spec2, med_spec3, med_spec4, med_spec5, med_spec6, med_spec7, med_spec8,
                            med_spec9, med_spec10, med_spec11, med_spec12, med_spec13, med_spec14, med_spec15,
                            med_spec16, med_spec17, med_spec18, med_spec19, med_spec20, med_spec21, med_spec22,
                            med_spec23, med_spec24, med_spec25, med_spec26, med_spec27, med_spec28, med_spec29,
                            med_spec30]

        for obj_med_spec in med_specialities:
            obj_med_spec.save_to_db()
            pass
        pass

    # Prescription Type
    if PrescriptionTypeModel.query.first() is None:
        prescription_type1 = PrescriptionTypeModel('Medication', 'MED')
        prescription_type2 = PrescriptionTypeModel('Activity', 'ACV')
        prescription_type3 = PrescriptionTypeModel('Diet', 'DIE')
        prescription_type4 = PrescriptionTypeModel('Other', 'OTH')

        prescriptions_type = [prescription_type1, prescription_type2, prescription_type3, prescription_type4]

        for obj_prescription_type in prescriptions_type:
            obj_prescription_type.save_to_db()
            pass
        pass

    # Unit of Measure
    if UnitOfMeasureModel.query.first() is None:
        unit_of_m1 = UnitOfMeasureModel('Millimeter', 'mm')
        unit_of_m2 = UnitOfMeasureModel('Centimeter', 'cm')
        unit_of_m3 = UnitOfMeasureModel('Metre', 'm')
        unit_of_m4 = UnitOfMeasureModel('Kilometer', 'km')
        unit_of_m5 = UnitOfMeasureModel('Mile', 'mi')
        unit_of_m6 = UnitOfMeasureModel('Milligram', 'mg')
        unit_of_m7 = UnitOfMeasureModel('Gram', 'g')
        unit_of_m8 = UnitOfMeasureModel('Kilogram', 'kg')
        unit_of_m9 = UnitOfMeasureModel('Pound', 'lb')
        unit_of_m10 = UnitOfMeasureModel('Ounce', 'oz')
        unit_of_m11 = UnitOfMeasureModel('Ampere', 'A')
        unit_of_m12 = UnitOfMeasureModel('Celsius', '°C')
        unit_of_m13 = UnitOfMeasureModel('Kelvin', 'K')
        unit_of_m14 = UnitOfMeasureModel('Candela', 'cd')
        unit_of_m15 = UnitOfMeasureModel('Mole', 'mol')
        unit_of_m16 = UnitOfMeasureModel('Liter', 'l')

        units_of_m = [unit_of_m1, unit_of_m2, unit_of_m3, unit_of_m4, unit_of_m5, unit_of_m6, unit_of_m7,
                      unit_of_m8,
                      unit_of_m9, unit_of_m10, unit_of_m11, unit_of_m12, unit_of_m13, unit_of_m14, unit_of_m15,
                      unit_of_m16]

        for obj_unit_of_m in units_of_m:
            obj_unit_of_m.save_to_db()
            pass
        pass

    # User
    if UserModel.query.first() is None:
        user1 = UserModel(1, 'admin',
                          'pbkdf2:sha256:50$XJfN5axB$9085ca50638eb956ab238f650b11896a6810887fa3e13f063406b838ddc1ff3b',
                          'Hugo Andres', 'Rosado Oliden', '944479181', None, '01.02.03.04', None, None, None)
        user2 = UserModel(1, '*****@*****.**',
                          'pbkdf2:sha256:50$6N2VRxhu$15d2e00aecff3ab9a797532efa8e11129f6c6ada6157fbbeef8818efb1ad9bcf',
                          'Dani Alonso', 'Romera Alves', '987654321', None, '04.03.02.01', None, None, None)
        user3 = UserModel(2, '*****@*****.**',
                          'pbkdf2:sha256:50$6N2VRxhu$15d2e00aecff3ab9a797532efa8e11129f6c6ada6157fbbeef8818efb1ad9bcf',
                          'José María', 'Zapata Giménez', '91827364', None, '05.06.07.08', None, None, None)
        user4 = UserModel(2, 'patient',
                          'pbkdf2:sha256:50$4wQeHHga$4b178248f66a23a25ab58c32ecc982a8ad7602e4bcf51406ce01908910b8bd42',
                          'Rosa Luz', 'Ramirez Falcón', '647382915', None, '08.07.06.05', None, None, None)

        users = [user1, user2, user3, user4]

        for obj_user in users:
            obj_user.save_to_db()
            pass
        pass

    # Doctor
    if DoctorModel.query.first() is None:
        doctor1 = DoctorModel(1, 3, None, 'ASDFG12345', None, None, None)
        doctor2 = DoctorModel(2, 4, None, '12345ASDFG', None, None, None)

        doctors = [doctor1, doctor2]

        for obj_doctor in doctors:
            obj_doctor.save_to_db()
            pass
        pass

    # Patient
    if PatientModel.query.first() is None:
        patient1 = PatientModel(3, 1, 20, 'O+', 60.00, 'Male', 1.84, None, None, None)
        patient2 = PatientModel(4, 2, 26, 'AB+', 72.00, 'Female', 1.95, None, None, None)
        patients = [patient1, patient2]

        for obj_patient in patients:
            obj_patient.save_to_db()
            pass
        pass
    pass