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()
