def api_get_hospitals(*, page='1'): page_index = get_page_index(page) num = yield from Hospital.findNumber('count(id)') p = Page(num, page_index) if num == 0: return dict(page=p, hospitals=()) hospitals = yield from Hospital.findAll(limit=(p.offset, p.limit)) return dict(page=p, hospitals=hospitals)
def add_hospital(): if request.method == "POST": hosp_name = request.form['hosp_name'] hosp_type = request.form['hosp_type'] hosp_addr = request.form['hosp_addr'] hosp_email = request.form['hosp_email'] hosp_num = request.form['hosp_num'] hosp_spec_empnl = request.form['hosp_spec_empnl'] hosp_spec_up = request.form['hosp_spec_up'] hosp = Hospital(hosp_name=hosp_name, hosp_type=hosp_type, hosp_addr=hosp_addr, hosp_contact_mail=hosp_email, hosp_contact_no=hosp_num, hosp_spec_empanl=hosp_spec_empnl, hosp_spec_upgraded=hosp_spec_up) hosp.save_to_db() return redirect(url_for("login")) # login for hosp return render_template("register.html") # return to hosp registration
def add_human(): name = request.form.get("doctor_name") surname = request.form.get("doctor_surname") tc = request.form.get("doctor_tc") password = request.form.get("doctor_password") email = request.form.get("doctor_email") authorize = request.form.get("authorize_select") city = request.form.get("city_select_add") district = request.form.get("district_select_add") address = Place(city=city, district=district).get_objects()[0] human = Human(tc=tc).get_object() if human is None: human = Human(tc=tc, password=password, authorize=authorize, name=name, surname=surname, mail=email, address=address) human.save() if authorize == 'doctor': workdays = str() day_list = ["Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"] for i, day in enumerate(day_list): if request.form.get(day) == "on": workdays += str(i + 1) expertise = request.form.get("doctor_expertise") hospital_id = request.form.get("hospital_select_add") hospital = Hospital(id=hospital_id).get_object() doctor = Doctor(human=human).get_object() if doctor is None: doctor = Doctor(human=human, workdays=workdays, expertise=expertise, hospital=hospital) doctor.save() # else doctor is already created return redirect(url_for(views.admin_humans_page.__name__))
def process_item(self, item, spider): record = Hospital(item['name'], item['province'], item['city'], item['district'],\ item['address'], item['phone'], item['category'], item['label'], item['groundpos'],\ item['marspos'], item['baidupos'], item['poiid']) self.session.add(record) self.session.commit()
def add_hospital(): hospital_name = request.form.get('hospital_name') city = request.form.get('city_select') district = request.form.get('district_select') park = helpers.checkbox_to_bool(request.form.get('park')) handicapped = helpers.checkbox_to_bool(request.form.get('handicapped')) p = Place(city, district).get_objects()[0] Hospital(hospital_name, p.id, park=park, handicapped=handicapped).save() return redirect(url_for(views.admin_hospitals_page.__name__))
def CreateHospitalInfo(dict = None): create = False if Hospital.objects.all() > 0: create = True if dict is None: raise Exception('Hospital dictionary is not defined') # También crearemos la información del Hospital if create: h = Hospital() else: h = Hospital.objects.get(pk=1) h.razon = dict['razon'] h.rfc = dict['rfc'] h.numero = dict['numero'] h.calle = dict['calle'] h.colonia = dict['colonia'] h.municipio = dict['municipio'] h.estado = dict['estado'] h.save()
def add_hospitals(): from models import Hospital hospitals = pd.DataFrame() hospitals = hospitals.append(pd.read_csv('../kb/kerala_hospitals.csv')) hospitals = hospitals.append(pd.read_csv('../kb/tamilnadu_hospitals.csv')) hospitals.index = hospitals.Sno hospitals = hospitals.drop('Sno', axis=1) hospitals = hospitals.drop('Unnamed: 0', axis=1) for i, row in hospitals.iterrows(): new_hosp = Hospital( hosp_name=cleanVal(row['Hospital Name']), hosp_type=cleanVal(row['Hospital Type']), hosp_addr=cleanVal(row['Hospital Address']), hosp_contact_mail=cleanVal(row['Hospital E-Mail']), hosp_contact_no=cleanVal(row['Hospital Contact']), hosp_spec_empanl=cleanVal(row['Specialities Empanelled']), hosp_spec_upgraded=cleanVal(row['Specialities Upgraded'])) new_hosp.save_to_db()
def add_history(): patient = Human(tc=session['user_tc']).get_object() doctor_tc = request.form.get('doctor_select') doctor = Doctor(human=Human(tc=doctor_tc).get_object()).get_object() hospital_id = request.form.get('hospital_select') hospital = Hospital(id=hospital_id).get_object() sickness = request.form.get('sickness') date = request.form.get('date') time = request.form.get('time') date_time = date + " " + time History(date=date_time, patient=patient, doctor=doctor, hospital=hospital, sickness=sickness).save() return redirect(url_for(views.home_page.__name__))
def update_hospital(hospital_id): hospital_name = request.form.get('modal_hospital_name') city = request.form.get('modal_city_select') district = request.form.get('modal_district_select') a = request.form.get('modal_park') park = helpers.checkbox_to_bool(request.form.get('modal_park')) handicapped = helpers.checkbox_to_bool(request.form.get('modal_handicapped')) if city and district: address = Place(city, district).get_objects()[0] else: address = None Hospital(id=hospital_id).get_object().update(hospital_name, address, handicapped=handicapped, park=park) return redirect(url_for(views.admin_hospitals_page.__name__))
def add_user_hospital(): request_body = json.loads(request.data) # if request_body["birth"] : # return "Datos incompletos" # else: user = Hospital( birth=request_body["birth"], DNI_paciente_hospital=request_body["DNI_paciente_hospital"], DNI_doctor_hospital=request_body["DNI_doctor_hospital"]) db.session.add(user) db.session.commit() return "Posteo exitoso"
def find_match(): for i in file.iterrows(): name = str(i[1]['hosp_name']).split(',')[0] out = Hospital.find_by_name(_name=name) out = out.order_by(Hospital.hosp_name).all() found = False if out: for one_id in out: if str(str(i[1]['hosp_name']).split(',') [-1]).upper() in one_id.hosp_addr: print('sor') print('\t', one_id.hosp_id, one_id.hosp_name, one_id.hosp_addr) found = True print('eor')
def addhospital(): form = addhospitalform() if request.method=='POST' and form.validate_on_submit(): hospital = Hospital(name=form.hospitalname.data,area=form.area.data,\ district=form.district.data, phone=form.phone.data, total_beds=form.total_beds.data,\ state=form.state.data,total_ward_beds=form.total_ward_beds.data,\ total_ward_beds_with_oxygen=form.total_ward_beds_with_oxygen.data,total_icu_beds=form.total_icu_beds.data,\ total_icu_beds_with_oxygen=form.total_icu_beds_with_oxygen.data,available_beds=form.total_beds.data,\ available_ward_beds=form.total_ward_beds.data,available_ward_beds_with_oxygen=form.total_ward_beds_with_oxygen.data,\ available_icu_beds=form.total_icu_beds.data,available_icu_beds_with_oxygen=form.total_icu_beds_with_oxygen.data) db.session.add(hospital) user = User(name=form.user.data, role='hospital', hospital=hospital) user.set_password(form.password.data) db.session.add(user) db.session.commit() return redirect(url_for('hospital')) return render_template('hospitaladd.html', form=form, title="Add Hospital")
def populateTable(type): # fields: name, address, zipcode, lat/long, opening_hours, business_status, rating, website, google_maps_url # phone_number, city_id, drugstores_nearby for city in cities_list: city_info = get_city_opendata(city) result = getJSON(type, city, city_info['state']) name = result['name'] address = result['address'] zipcode = result['zipcode'] latitude = result['latitude'] longitude = result['longitude'] opening_hours = result['opening_hours'] business_status = result['business_status'] # rating = result['rating'] # website = result['website'] google_maps_url = result['url'] # phone_number = result['phone_number'] id = result['place_id'] city_id = db.execute("SELECT * FROM city WHERE name = :city", { ":city": city }).first() if (type == 'hospital'): entry = Hospital(id=id, name=name, address=address, zipcode=zipcode, latitude=latitude, longitude=longitude, opening_hours=opening_hours, business_status=business_status, google_maps_url=google_maps_url, city_id=city_id) else: entry = Drugstore(id=id, name=name, address=address, zipcode=zipcode, latitude=latitude, longitude=longitude, opening_hours=opening_hours, business_status=business_status, google_maps_url=google_maps_url, city_id=city_id) db.session.add(entry) db.session.commit()
def filter_hospital_ajax(): city = request.form.get('city') district = request.form.get('district') name = request.form.get('name') if name == '': name = None capacity = request.form.get('capacity') rate = request.form.get('rate') park = helpers.checkbox_to_bool(request.form.get('park')) handicapped = helpers.checkbox_to_bool(request.form.get('handicapped')) if city and district: address = Place(city, district).get_objects()[0] else: address = None hospitals = Hospital(address=address, name=name, capacity=capacity, rate=rate, park=park, handicapped=handicapped).get_objects() return render_template('sub_templates/filtered_hospital_table.html', hospitals=hospitals)
def seeder(): print('#### Check Database seed ####') all_hospitals = db.session.execute(db.select(Hospital)).all() all_hospitals = [id for id, in all_hospitals] if (len(all_hospitals) <= 0): print('#### Tables are empty ####') print('#### Adding some entries... ####') with open('flaskr/seeders/seeders.json') as f: print('#### Adding some entries... ---####') data = json.load(f) for hospital in data['hospitals']: new_hospital = Hospital(hospital['id'], hospital['name'], hospital['city']) db.session.add(new_hospital) patients = {} for patient in data['patients']: new_patient = Patient(patient['id'], patient['name'], patient['surname'], patient['dni'], patient['hospital_id']) patients[patient['id']] = new_patient db.session.add(new_patient) for doctor in data['doctors']: new_doctor = Doctor(doctor['id'], doctor['name'], doctor['surname'], doctor['speciality']) if (new_doctor.id == '014bd297-0a3d-4a17-b207-cff187690045'): new_doctor.patients.append(patients['3a268172-6c5c-4d9b-8964-8b9a1e531af5']) if (new_doctor.id == 'a0f54d52-5ccb-4e50-adca-5ea0064262fd'): new_doctor.patients.append(patients['088d58e2-7691-47b6-a322-eeffcadc9054']) if (new_doctor.id == '1497d1be-577a-41ad-b129-45271e113cc0'): new_doctor.patients.append(patients['8ec8c43b-f7e1-43e4-b70f-6d5a9799a86a']) if (new_doctor.id == '9bb2e300-fa15-4063-a291-13f7199ddb52'): new_doctor.patients.append(patients['923ec756-87b7-4743-808b-795a04b6dd21']) new_doctor.patients.append(patients['3a268172-6c5c-4d9b-8964-8b9a1e531af5']) db.session.add(new_doctor) print(patients) db.session.commit() print('#### Finished! ####') else: print('#### Database already seed ####')
def hospital_details(): selected_id = str(request.args.get('hosp_id')) hosp = Hospital.find_by_id(selected_id) specs_up = hosp.hosp_spec_upgraded specs_emp = hosp.hosp_spec_empanl dec_specs_up = decodeSpecialties(specs_up) dec_specs_emp = decodeSpecialties(specs_emp) # from views import AddScheme # form = AddScheme() # if form.is_submitted(): # sch_id = form.sch.data # print(sch_id) # scheme = Scheme.find_by_scheme_id(sch_id) # print(scheme.name) # hosp.Schemes.append(scheme) # hosp.save_to_db() # return render_template('hospitalDetails.html', title='Hospital Details', data=hosp, specs_up=dec_specs_up, # specs_emp=dec_specs_emp, auth=is_auth()) return render_template('hospitalDetails.html', title='Hospital Details', data=hosp, specs_up=dec_specs_up, specs_emp=dec_specs_emp, auth=is_auth())
def main(): last_update = last_scrape() print("Last update: {}".format(last_update)) print("Fetching page...") data = scrape("https://www.indexsante.ca/urgences/", last_update) cur_update = data.pop("last_update", last_update) if last_update == cur_update: print("Data already processed.") return all_records = [] scrape_id = Scrape.create(scrape_date=cur_update).id defaults = {"scrape": scrape_id} for (region_str, records) in data.items(): (region, _) = Region.get_or_create(nom=region_str, defaults=defaults) for record in records: hospital_name = record.pop("nom") (hospital, _) = Hospital.get_or_create(nom=hospital_name, region=region.id, defaults=defaults) record["hospital"] = hospital.id record["scrape"] = scrape_id all_records.append(record) HospitalRecord.insert_many(all_records).execute()
def get_doctors_ajax(): hospital = Hospital(id=request.form.get('hospital_id')).get_object() doctors = Doctor(hospital=hospital).get_objects() response = " ".join( ['<option value="{}">{}</option>'.format(doctor.human.tc, doctor.human.name + " " + doctor.human.surname) for doctor in doctors]) return response
def add_scheme_by_hosp_id(hosp_id, scheme_id): from models import Hospital, Scheme hosp = Hospital.find_by_id(int(hosp_id)) scheme = Scheme.find_by_scheme_id(scheme_id) hosp.Schemes.append(scheme) hosp.save_to_db()
def addOneCityInfo(city_name): city_info = get_city_opendata(city_name) lat = city_info['latitude'] longitude = city_info['longitude'] state = city_info['state'] pop = city_info['population'] entryCity = City(name=city_name, state=state, latitude=lat, longitude=longitude, population=pop) db.session.add(entryCity) db.session.commit() sql_query = text("SELECT city.id FROM city WHERE city.name = \'" + city_name + "\';") result = db.engine.execute(sql_query).first() cityID = result[0] hospital_results = getJSON('hospital', city_name, state) for hospital in hospital_results: name = hospital['name'] address = hospital['address'] zipcode = hospital['zipcode'] latitude = hospital['latitude'] longitude = hospital['longitude'] opening_hours = hospital['opening_hours'] business_status = hospital['business_status'] google_maps_url = hospital['url'] id = hospital['place_id'] entry = Hospital(id=id, name=name, address=address, zipcode=zipcode, latitude=latitude, longitude=longitude, opening_hours=opening_hours, business_status=business_status, google_maps_url=google_maps_url, city_id=cityID) db.session.add(entry) db.session.commit() drugstore_results = getJSON('drugstore', city_name, state) for drugstore in drugstore_results: name = drugstore['name'] address = drugstore['address'] zipcode = drugstore['zipcode'] latitude = drugstore['latitude'] longitude = drugstore['longitude'] opening_hours = drugstore['opening_hours'] business_status = drugstore['business_status'] google_maps_url = drugstore['url'] id = drugstore['place_id'] entry = Drugstore(id=id, name=name, address=address, zipcode=zipcode, latitude=latitude, longitude=longitude, opening_hours=opening_hours, business_status=business_status, google_maps_url=google_maps_url, city_id=cityID) db.session.add(entry) db.session.commit() sql_query = text( "SELECT hospital.id FROM hospital WHERE hospital.zipcode = \'" + zipcode + "\';") result = db.engine.execute(sql_query) if result.returns_rows: hospital_ids = [item[0] for item in result.fetchall()] for hospital_id in hospital_ids: hospitalObj = db.session.query(Hospital).get(hospital_id) entry.hospitals_nearby.append(hospitalObj) db.session.commit()
def get_hospitals_ajax(): place = Place(request.form.get('city_name'), request.form.get('district_name')).get_objects()[0] hospitals = Hospital(address=place).get_objects() response = " ".join( ['<option value="{}">{}</option>'.format(hospital.id, hospital.name) for hospital in hospitals]) return response
def serach_for_hosp(search_term): results1 = Hospital.find_by_name(_name=search_term).all() results2 = Hospital.find_by_addr(_addr=search_term).all() results = results1 + results2 return list(set(results))
from models import Admin from models import Hospital, Ward, Theater from models import PractitionerDetails, PatientDetails from models import PreOperativeRecord, OperativeRecord, PostOperativeRecord from models import OperationRecord from models import db_session as db # creating models for use admin = Admin(username="******", email="*****@*****.**", password="******") parirenyatwa = Hospital(name="parirenyatwa") bc1 = Ward(name="BC1", hospital_id=parirenyatwa.id) theatre_a = Theater(name="TA", ward_id=bc1.id) if __name__ == '__main__': db.add_all([admin, parirenyatwa, bc1, theatre_a]) db.commit()
def search_hospital(): form = SearchHospitalForm() if form.state != "None": form.city.choices = [(city.uuid, city.name) for city in City.find_by_state(form.city.data)] if form.is_submitted(): if form.city != "None" or form.state != "None": city = City.get_by_id(form.city.data) state_name = city.name spec = form.spec.data scheme_id = form.scheme.data if spec != "None" and state_name != "" and not state_name.isspace(): hosps = Hospital.find_by_spec_and_state(_spec=spec, _state=state_name) print("scheme id is ", scheme_id) if scheme_id != '0': filtered = [] scheme = Scheme.find_by_scheme_id(scheme_id) print(scheme.name) print(scheme.partner_hospitals) for a_hosp in hosps: if a_hosp in scheme.partner_hospitals.all(): filtered.append(a_hosp) print(filtered) if len(filtered) <= 0: flash("No Hospitals found, why don't you try without the Scheme filter!!") return render_template("search_hospital.html", current_user=current_user, form=form) return render_template('searchResult.html', data=filtered, current_user=current_user, auth=is_auth(), searchterm=state_name) print("results form spec for ", decodeSpecialties(spec)[0]) if len(hosps.all()) > 0: return render_template('searchResult.html', data=hosps, current_user=current_user, auth=is_auth(), searchterm=state_name) else: print('no hospitals with ', spec) flash("No Hospitals found, why don't you try without the Speciality filter!!") return render_template("search_hospital.html", current_user=current_user, form=form, auth=is_auth()) elif state_name != '' and not state_name.isspace(): hosp = Hospital.find_by_state(state_name) if len(hosp.all()) > 0: print("scheme id is ", scheme_id) if scheme_id != '0': scheme = Scheme.find_by_scheme_id(scheme_id) print(scheme.name) filtered = [] for a_hosp in hosp: if a_hosp in scheme.partner_hospitals.all(): filtered.append(a_hosp) if len(filtered) <= 0: flash("No Hospitals found, why don't you try without the Scheme filter!!") return render_template("search_hospital.html", current_user=current_user, form=form, auth=is_auth()) return render_template('searchResult.html', data=filtered, current_user=current_user, auth=is_auth(), searchterm=state_name) return render_template('searchResult.html', data=hosp, current_user=current_user, searchterm=state_name, auth=is_auth()) else: flash('No Hospitals found!!') return render_template("search_hospital.html", current_user=current_user, form=form, auth=is_auth()) else: flash("Enter a valid query") return render_template("search_hospital.html", current_user=current_user, form=form, auth=is_auth()) flash("State and City are Mandatory Fields") return render_template("search_hospital.html", current_user=current_user, form=form, auth=is_auth()) return render_template("search_hospital.html", current_user=current_user, form=form, auth=is_auth())
def del_hospital(hospital_id): Hospital(id=hospital_id).delete() return redirect(url_for(views.admin_hospitals_page.__name__))