def addClinic(doctor_id): form = ClinicForm(request.form) doctor = Doctor.query.get(int(doctor_id)) doctors = Doctor.query.all() if request.method == 'POST': if form.validate(): clinic = Clinic.query.filter_by(clinicName = form.clinicName.data, locality = form.locality.data, city = form.city.data, address = form.address.data).first() docclinic = DocClinic(request.form['fees'], request.form['timings']) db_session.add(docclinic) if clinic: docclinicAll = DocClinic.query.filter_by(doctor_id = doctor.id, clinic_id = clinic.id).first() if docclinicAll: return render_template("home.html", errMsg = "Already added for this doctor", doctors = doctors) doctor.docClinics.append(docclinic) clinic.docClinics.append(docclinic) db_session.commit() else: clinic = Clinic(clinicName = form.clinicName.data, locality = form.locality.data, city = form.city.data, address = form.address.data, services = form.services.data) db_session.add(clinic) doctor.docClinics.append(docclinic) clinic.docClinics.append(docclinic) db_session.commit() else: flash ('Form Validation unsuccessful. Please enter valid data') return render_template("home.html", doctors = doctors) else: return render_template("addClinic.html", form = form, doctor = doctor)
def deleteDoctor(doctor_id): try: doc = Doctor.query.get(int(doctor_id)) except AttributeError: return render_template("home.html", errMsg = "No Such doctor") DocClinic.query.filter_by(doctor_id = doctor_id).delete() Doctor.query.filter_by(id = doctor_id).delete() db_session.commit() doctors = Doctor.query.all() return render_template("home.html", doctors = doctors)
def home(): doctors = Doctor.query.all()[:200] form = DoctorForm(request.form) if request.method == 'POST': if form.validate(): #flash ('Form Validated') if form.id.data == '': doc = Doctor(name = form.name.data, email = form.email.data, phoneNumber = form.phoneNumber.data, description = form.description.data, education = form.education.data, experience = form.experience.data, speciality = form.speciality.data) db_session.add(doc) db_session.commit() doctors = Doctor.query.all() else: flash ('Form Validation unsuccessful. Please enter valid data') return render_template("addDoctor.html",form = form) return render_template("home.html", doctors = doctors, form = form)
def editClinic(clinic_id): try: clinic = Clinic.query.get(int(clinic_id)) except AttributeError: doctors = Doctor.query.all() return render_template("home.html", doctors = doctors, errMsg = "No Such clinic") form = ClinicForm(request.form) if request.method == 'POST': if form.validate(): clinic.clinicName = form.clinicName.data clinic.locality = form.locality.data clinic.city = form.city.data clinic.address = form.address.data clinic.services = form.services.data db_session.commit() else: flash("Invalid data entered. Please verify and try again.") doctors = Doctor.query.all() return render_template("home.html", doctors = doctors) else: return render_template("editClinics.html", form = form, clnc = clinic)
def editDoctor(doctor_id): try: doc = Doctor.query.get(int(doctor_id)) form = DoctorForm(request.form) #return render_template("editDoctor.html",form=form,doctor=doc) except AttributeError: return render_template("home.html", errMsg = "No Such Doctor") if request.method == 'POST': if form.validate(): doc.name = form.name.data doc.email = form.email.data doc.phoneNumber = form.phoneNumber.data doc.description = form.description.data doc.education = form.education.data doc.experience = form.experience.data db_session.commit() doctors = Doctor.query.all() return render_template("home.html", doctors = doctors) else: flash("Invalid data entered!!") doctors = Doctor.query.all() return render_template('editDoctor.html', doctor = doc, form = form) else: return render_template("editDoctor.html", doctor = doc, form = form)
from databaseApp.database import db_session, init_db from databaseApp.models import Doctor, Clinic,DocClinic from random import randint from faker import Factory init_db() fake = Factory.create('en_US') for _ in range(200): print _ loct = ['BTM','Whitefield','JP Nagar','Jayanagar','Koramangala','Indira Nagar','Pratap Nagar','Gandhi Nagar','Hiran Magri','Yeshwantpur','Marathalli'] clinic = Clinic(fake.street_name(),loct[int(randint(1,1000)%len(loct))],fake.city(),fake.address(),"Many Services") db_session.add(clinic) db_session.commit() allClinics = Clinic.query.all() for _ in range(1000): print _ years = randint(1,20) spclts = ['Dentist','Cardiologist','Surgeon','Heart Specialist','Neurologist','Dermatologist','Brain Surgeon','Urologist','Psychologist','Psychiatrist'] costs = [200,500,300,220,1239,233,2424,2324,1000] name = fake.name() name1 = name.split()[0] desc = fake.text() doc = Doctor(name,years,desc[:100],fake.phone_number(),"DESCRIPTION",name1+"@example.com",spclts[int(randint(1,1000)%len(spclts))]) db_session.add(doc) dc = DocClinic(costs[int(randint(20,300)%len(costs))],"Monday to Friday, 8:00am to 10:00am") dc2 = DocClinic(randint(1,2000),"Monday to Thursday, 9:10am to 12:10pm") db_session.add(dc) db_session.add(dc2)