def setUp(self):
self.test_treat_clipclaw = Treatment(1, 1, "15/06/2020",
"Clipped claws", 5)
self.test_treat_wormtabs = Treatment(1, 1, "01/02/2020",
"Given worming tablets", 4)
self.test_treat_checkup = Treatment(1, 1, "29/12/2019",
"regular checkup", 3)
self.test_treat_scan = Treatment(2, 1, "15/11/2019", "MRI scan", 10)
def select(animal):
treatment = None
sql = "SELECT * FROM treatments WHERE animal_id = %s"
values = [animal.id]
row = run_sql(sql, values)
if len(row) > 0:
row = row[0]
treatment = Treatment(
row["description"],
row["duration"],
row["recovery"],
row["cost"],
animal,
row["id"],
)
treatment.start = row["start"]
return treatment
def select_all():
treatments = []
sql = "SELECT * FROM treatments"
results = run_sql(sql)
for row in results:
animal = animal_repository.select(row["animal_id"])
treatment = Treatment(
row["decription"],
row["duration"],
row["recovery"],
row["cost"],
animal,
row["id"],
)
treatment.start = row["start"]
treatments.append(treatment)
return treatments
def select(id):
sql = "SELECT * FROM treatments WHERE id=%s"
values = [id]
result = run_sql(sql, values)[0]
vet = vet_repository.select(result['vet_id'])
animal = animal_repository.select(result['animal_id'])
treatment = Treatment(animal, vet, result['details'], result['date'], id)
return treatment
def select_all(self):
treatments = []
sql = f"SELECT * FROM {self.table}"
results = run_sql(sql)
for row in results:
treatment = Treatment(row["title"], row["description"], row["id"])
treatments.append(treatment)
return treatments
def create_new_treatment():
animal_id = request.form['animal_id']
animal = animal_repository.select(animal_id)
vet_id = request.form['vet_id']
vet = vet_repository.select(vet_id)
date = request.form['date']
details = request.form['details']
new_treatment = Treatment(animal, vet, details, date)
treatment_repository.save(new_treatment)
return redirect(f'/animals/{animal_id}')
def select(self, id):
treatment = None
sql = f"SELECT * FROM {self.table} " + "WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
treatment = Treatment(result["title"], result["description"],
result["id"])
return treatment
def select_all():
treatments = []
sql = "SELECT * FROM treatments ORDER BY id ASC"
results = run_sql(sql)
for row in results:
treatment = Treatment(row['animal_id'], row['vet_id'], row['date'],
row['notes'], row['weight'], row['id'])
treatments.append(treatment)
return treatments
def create():
description = request.form["description"]
days = request.form["duration_days"]
hours = request.form["duration_hours"]
minutes = request.form["duration_minutes"]
duration = dh.time_delta(f"{days}:{hours}:{minutes}:00")
days = request.form["recovery_days"]
hours = request.form["recovery_hours"]
minutes = request.form["recovery_minutes"]
recovery = dh.time_delta(f"{days}:{hours}:{minutes}:00")
cost = int(float(request.form["cost"]) * 100)
animal = animal_repository.select(request.form["animal_id"])
treatment = Treatment(description, duration, recovery, cost, animal)
treatment.start_treatment()
treatment_repository.save(treatment)
animal.owner.increase_bill(treatment.cost)
owner_repository.update(animal.owner)
return redirect(f"animals/{animal.id}")
def select_all_by_vet_id(id):
treatments = []
sql = "SELECT * FROM treatments WHERE vet_id = %s"
values = [id]
results = run_sql(sql, values)
for row in results:
treatment = Treatment(row['animal_id'], row['vet_id'], row['date'],
row['notes'], row['weight'], row['id'])
treatments.append(treatment)
return treatments
def select(id):
# Create SQL query, input data && run
sql = "SELECT * FROM treatment WHERE id = %s"
values = [id]
result = run_sql(sql, values)
# If the result exists create an object to be returned
if len(result) > 0:
treatment = Treatment(result[0]['name'], result[0]['cost'],
result[0]['length'], result[0]['medicine'],
result[0]['type'], result[0]['id'])
return treatment
def setUp(self):
owner = Owner('Jack',
'White',
'*****@*****.**',
'487239847',
True,
id=3)
vet = Vet('White', 'Jack', 3)
pet = Pet('dummy pet', dt.date(2020, 2, 2), '1', 'dog', owner, vet,
'dkfj', 'what', 2)
treatment = Treatment('kadjf', 'a description', 1)
self.pet_treatment = PetTreatment(pet, treatment, 3)
def select_id(id):
animal = None
sql = "SELECT * FROM treatments WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
treatment = Treatment(result['animal_id'], result['vet_id'],
result['date'], result['notes'],
result['weight'], result['id'])
return treatment
def treatments(id):
treatments = []
sql = "SELECT * FROM treatments WHERE animal_id=%s"
values = [id]
results = run_sql(sql, values)
for row in results:
vet = vet_repository.select(row['vet_id'])
animal = animal_repository.select(row['animal_id'])
treatment = Treatment(animal, vet, row['details'], row['date'], row['id'])
treatments.append(treatment)
return treatments
def select_all():
treatments = []
sql = "SELECT * FROM treatments"
results = run_sql(sql)
for row in results:
vet = vet_repository.select(row['vet_id'])
animal = animal_repository.select(row['animal_id'])
treatment = Treatment(animal, vet, row['details'], row['date'],
row['id'])
treatments.append(treatment)
return treatments
def select_all():
# Create list of treatments == empty list
treatments = []
# Create SQL query, insert data && run
sql = "SELECT * FROM treatment"
results = run_sql(sql)
# Loop through results
for row in results:
treatment = Treatment(row['name'], row['cost'], row['length'],
row['medicine'], row['type'], row['id'])
treatments.append(treatment)
return treatments
def get_treatments(self, pet_id):
treatments = []
sql = """
SELECT treatments.* FROM treatments
INNER JOIN pets_treatments ON treatments.id = pets_treatments.treatment_id
INNER JOIN pets ON pets_treatments.pet_id = pets.id
WHERE pets.id = %s
"""
values = [pet_id]
results = run_sql(sql, values)
for row in results:
treatment = Treatment(row['title'], row['description'])
treatments.append(treatment)
return treatments
def update_treatment(id):
animal_id = request.form['animal_id']
animal = animal_repository.select(animal_id)
vet_id = request.form['vet_id']
vet = vet_repository.select(vet_id)
date = request.form['date']
details = request.form['details']
source = request.form['source']
if source == "vet":
source_id = vet.id
elif source == "animal":
source_id = animal.id
updated_treatment = Treatment(animal, vet, details, date, id)
treatment_repository.update(updated_treatment)
return redirect(f'/{source}s/{source_id}')
def new():
if request.method == 'GET':
message = request.args.get('message')
show_all = request.args.get('show_all')
active_vets = vet_repository.select_all_active()
active_animals = animal_repository.select_all_active()
return render_template("treatments/new.html.j2", **locals())
if request.method == 'POST':
vet_id = request.form['vet_id']
animal_id = request.form['animal_id']
date = request.form['date']
notes = request.form['notes']
weight = request.form['weight']
treatment = Treatment(vet_id, animal_id, date, notes, weight)
saved_treatment = treatment_repository.save(treatment)
message = f"Treatment ID:{saved_treatment.id} Added"
return redirect(url_for("treatments.index", message=message))
def select_by_pet(id):
# Create list of treatments == empty list
treatments = []
# Creat SQL query, input the values && run
sql = "SELECT treatment.* FROM treatment INNER JOIN perscribed_treatment ON perscribed_treatment.treatment_id = treatment.id WHERE perscribed_treatment.pet_id = %s"
values = [id]
results = run_sql(sql, values)
# Loop through results
for row in results:
# Create new object
treatment = Treatment(row['name'], row['cost'], row['length'],
row['medicine'], row['type'], row['id'])
treatments.append(treatment)
return treatments
# Pets
pet_1 = Pet('Hudini', '1/1/2012', owner_1, pet_type_3, vet_1)
PR.save(pet_1)
pet_2 = Pet('KitKat', '1/1/2010', owner_1, pet_type_3, vet_1)
PR.save(pet_2)
pet_3 = Pet('Steven', '03/10/2004', owner_3, pet_type_5, vet_2)
PR.save(pet_3)
# Notes
note_1 = Note('09/08/2020', 'Hudini is a stinky boy', pet_1, vet_1)
NR.save(note_1)
# Treatments
treatment_1 = Treatment('Worming tablets', 10, 2, 'dewormitroxin',
'Liquid Spray')
TR.save(treatment_1)
treatment_2 = Treatment('Antibiotics - Stinkyitus', 50, 7, 'stinkicillin',
'Tablet')
TR.save(treatment_2)
# Test appointment
appointment1 = Appointment('2020-09-12', 'Note text', vet_1, pet_3)
AR.save(appointment1)
pdb.set_trace()
TestimonialRep().save(testimonial4)
testimonial5 = Testimonial(
'This was a life changing experience for me and my pet -thank you so much guys!!',
lola_obj)
TestimonialRep().save(testimonial5)
testimonial6 = Testimonial(
'This was a great experience for me and my pet -thank you so much guys!!',
kost_obj)
TestimonialRep().save(testimonial6)
##############
# TREATMENTS
anthelmintics = Treatment(
'Anthelmintics',
'These are used to eliminate parasitic worms, which infest their systems and steal important nutrients.'
)
treatment1 = TreatmentRep().save(anthelmintics)
dermatological = Treatment(
'Dermatological drugs',
'Oral, topical, or injected medications might be used to treat common skin and ear conditions in animals.'
)
treatment2 = TreatmentRep().save(dermatological)
cnsmed = Treatment(
'Central nervous system medications',
'Drugs like aminocaproic acid or potassium bromide might be prescribed to help animals suffering from seizures or epilepsy.'
)
treatment3 = TreatmentRep().save(cnsmed)
owner_4,
vet_2,
)
animal_repository.save(animal_1)
animal_repository.save(animal_2)
animal_repository.save(animal_3)
animal_repository.save(animal_4)
animal_repository.save(animal_5)
animal_repository.save(animal_6)
animal_repository.save(animal_7)
animal_repository.save(animal_8)
animal_repository.save(animal_9)
animal_repository.save(animal_10)
treatment_1 = Treatment(animal_1, vet_1, "Vaccination: COVID First Shot",
datetime.datetime(2020, 8, 14).date())
treatment_2 = Treatment(animal_1, vet_1, "Vaccination: COVID Second Shot",
datetime.datetime(2020, 8, 11).date())
treatment_3 = Treatment(animal_1, vet_1, "Check-up: General",
datetime.datetime(2020, 8, 12).date())
treatment_4 = Treatment(animal_1, vet_1, "De-fleaing",
datetime.datetime(2020, 8, 13).date())
treatment_5 = Treatment(animal_1, vet_1, "Treatment for banana-addiction",
datetime.datetime(2020, 8, 14).date())
treatment_6 = Treatment(animal_1, vet_1, "Check-up: General",
datetime.datetime(2020, 8, 15).date())
treatment_7 = Treatment(animal_7, vet_2, "Shell polishing",
datetime.datetime(2020, 8, 14).date())
treatment_8 = Treatment(animal_2, vet_2, "Vaccination: COVID First Shot",
datetime.datetime(2020, 8, 11).date())
treatment_9 = Treatment(animal_3, vet_3, "Couldn't find him",
test_animal_earnie = Animal("Earnie ", "01/03/2012", "Giant Chicken",
test_owner_david, test_vet_sam, False)
test_animal_brian = Animal("Brian", "19/01/2014", "Dog", test_owner_peter,
test_vet_joe, False)
test_animal_evil_monkey = Animal("Evil Monkey", "17/02/2015", "Monkey",
test_owner_jamie, test_vet_joe, False)
test_animal_vinny = Animal("Vinny", "04/08/2018", "Dog", test_owner_jamie,
test_vet_joe, False)
test_animal_apollo = Animal("Apollo", "22/03/2016", "Dog", test_owner_jamie,
test_vet_sam, False)
test_animal_buster = Animal("Buster", "29/04/2019", "Dog", test_owner_sarah,
test_vet_sam, False)
test_animal_izzy = Animal("Izzy", "30/05/2020", "Cat", test_owner_sarah,
test_vet_alison, False)
test_treat_clipclaw = Treatment(1, 1, "15/06/2020", "Clipped claws", 5)
test_treat_wormtabs = Treatment(2, 3, "01/02/2020", "Given worming tablets", 4)
test_treat_checkup = Treatment(3, 3, "29/12/2019", "Regular checkup", 3)
test_treat_4 = Treatment(4, 2, "15/11/2019", "Broken arm", 5)
test_treat_5 = Treatment(4, 2, "15/11/2019", "Dental surgeries", 3)
test_treat_6 = Treatment(4, 2, "15/11/2019", "Tooth Extraction", 8)
test_treat_7 = Treatment(4, 1, "15/11/2019", "Neutering", 9)
test_treat_8 = Treatment(4, 2, "15/11/2019", "Skin Surgeries", 6)
# --------
# save three 3 vets
vet_repository.save(test_vet_sam)
vet_repository.save(test_vet_joe)
vet_repository.save(test_vet_alison)
# save 4 owners
owner_repository.save(test_owner_david)
def setUp(self):
self.treatment = Treatment(
'Anthelmintics',
'These are used to eliminate parasitic worms, which infest their systems and steal important nutrients.'
)
