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 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)
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)
from databaseApp.models import Doctor, Clinic, Doctor_Clinic_Link, Experience, Speciality, Qualification import datetime from jinja2 import Environment, PackageLoader init_db() #Doctor_Clinic_Link.query.delete() #Speciality.query.delete() #Experience.query.delete() #Qualification.query.delete() #Doctor.query.delete() #Clinic.query.delete() doc = Doctor('*****@*****.**', 'Neel5') clinic = Clinic('Raj Dental Clinic', '33-4', 'Koramangala', 'Bangalore', '560078', 'India') db_session.add(doc) db_session.add(clinic) db_session.commit() link = Doctor_Clinic_Link(doc.email_id, clinic.id, 'Mon', 'Fri', '4', '7', '400', '893491281', 'random services') start_date = datetime.datetime.strptime('2012-12-04','%Y-%m-%d'); end_date = datetime.datetime.strptime('2014-12-04','%Y-%m-%d'); experience = Experience(doc.email_id, 'Some old Clinic', start_date, end_date) speciality = Speciality(doc.email_id, "Dentist") qualification = Qualification(doc.email_id, 'college5', start_date, end_date) db_session.add(link) db_session.add(experience) db_session.add(speciality) db_session.add(qualification) db_session.commit()