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.' )