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)
