def update(id): date = request.form["date"] entry = request.form["entry"] animal = animal_repository.select(request.form["animal_id"]) record = Record(date, entry, animal, id) record_repository.update(record) return redirect(f"/records/{id}")
def create(): description = request.form['description'] animal_id = request.form['animal'] animal = animal_repository.select(animal_id) new_note = Medical(description, animal) medical_repository.save(new_note) return redirect("/medicals")
def edit_animal(id): animal = animal_repository.select(id) customers = customer_repository.select_all() return render_template("/animals/edit.html", title="Edit Animal", animal=animal, all_customers=customers)
def update(id): 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"]) old_treatment = treatment_repository.select(animal) animal.owner.decrease_bill(old_treatment.cost) treatment = Treatment(description, duration, recovery, cost, animal, id) if "start" in request.form: treatment.start_treatment() else: start = treatment_repository.select(animal).start treatment.start_treatment(start) animal.owner.increase_bill(treatment.cost) owner_repository.update(animal.owner) treatment_repository.update(treatment) return redirect(f"/animals/{animal.id}")
def create(): date = request.form["date"] entry = request.form["entry"] animal = animal_repository.select(request.form["animal_id"]) record = Record(date, entry, animal) record_repository.save(record) return redirect(f"/animals/{request.form['animal_id']}")
def create(): allergy_id = request.form['allergy'] animal_id = request.form['animal'] allergy = allergy_repository.select(allergy_id) animal = animal_repository.select(animal_id) new_animal_allergy = AnimalAllergy(animal, allergy) animalallergy_repository.save(new_animal_allergy) return redirect("/allergys")
def edit_animal(id): animal = animal_repository.select(id) owners = owner_repository.select_all() vets = vet_repository.select_all() return render_template('animals/edit.html', animal=animal, all_owners=owners, all_vets=vets)
def delete_from_source(id, source): treatment = treatment_repository.select(id) if source == "vet": source_id = vet_repository.select(treatment.vet.id).id elif source == "animal": source_id = animal_repository.select(treatment.animal.id).id treatment_repository.delete(id) return redirect(f'/{source}s/{source_id}')
def show_owners(id): animals = animal_repository.select(id) owner = owner_repository.select(id) owned_animals = animal_repository.display_animals_owned(id) return render_template("owners/show.html", owner=owner, owned_animals=owned_animals, animals=animals)
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 get_info_for_update(id): animal = animal_repository.select(id) vets = vet_repository.select_all() owners = owner_repository.select_all() return render_template('/animals/edit.html', animal=animal, vets=vets, owners=owners, title=f"Update {animal.name}")
def create_appointment(): start_time = request.form["start_time"] end_time = request.form["end_time"] appointment_date = request.form["appointment_date"] animal = animal_repository.select(request.form["animal_id"]) new_appointment = Appointment(start_time, end_time, appointment_date, animal) appointment_repository.save(new_appointment) return redirect("/appointments")
def select(id): record = None sql = "SELECT * FROM records WHERE id = %s" values = [id] row = run_sql(sql, values)[0] if row is not None: animal = animal_repository.select(row["animal_id"]) record = Record(row["date"], row["entry"], animal, row["id"]) return record
def select_all(): records = [] sql = "SELECT * FROM records" results = run_sql(sql) for row in results: animal = animal_repository.select(row["animal_id"]) record = Record(row["date"], row["entry"], animal, row["id"]) records.append(record) return records
def new(animal_id): animal = animal_repository.select(animal_id) dh = DateHelper() current_time = dh.print_datetime_local(datetime.datetime.now()) return render_template( "records/new.html", title="New Record", animal=animal, current_time=current_time, )
def select_all(): aallergy = [] sql = "SELECT * FROM animal_allergies" results = run_sql(sql) for row in results: animal = animal_repository.select(row['owner_id']) allergy = allergy_repository.select(row['vet_id']) animalallergy = AnimalAllergy(row[animal], row[allergy]) aallergy.append(animalallergy) return aallergy
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(id): aallergy = None sql = "SELECT * FROM animal_allergies WHERE id = %s" values = [id] result = run_sql(sql, values)[0] if result is not None: animal = animal_repository.select(result['owner_id']) allergy = allergy_repository.select(result['vet_id']) animalallergy = AnimalAllergy(result[animal], result[allergy]) aallergy.append(animalallergy) return aallergy
def edit(animal_id): animal = animal_repository.select(animal_id) treatment = treatment_repository.select(animal) duration = dh.list_delta(treatment.duration) recovery = dh.list_delta(treatment.recovery) return render_template( "treatments/edit.html", title="Edit Treatment", treatment=treatment, duration=duration, recovery=recovery, )
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 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(id): sql = "SELECT * FROM appointments WHERE id = %s" vaules = [id] result = run_sql(sql, vaules)[0] animal = animal_repository.select(result["animal_id"]) if result is not None: appointment = Appointment( result["start_time"], result["end_time"], result["appointment_date"], animal, result["id"]) return appointment
def show(id): animal = animal_repository.select(id) treatment = treatment_repository.select(animal) animal.where(treatment) if not animal.checked_in and treatment is not None: treatment_repository.delete(treatment.id) treatment = None records = record_repository.records_by_animal(animal) return render_template( "animals/show.html", title="Animal", animal=animal, records=records, treatment=treatment, )
def edit(id): animal = animal_repository.select(id) vets = vet_repository.select_all() for vet in vets: count = animal_repository.assigned_to(vet) vet.set_count(count) if vet.animal_count >= vet.max_animals and animal.vet.id is not vet.id: vet.set_busy() else: vet.set_available() return render_template( "animals/edit.html", title="Edit Animal", animal=animal, # owners=owners, vets=vets, )
def select_all(): appointments = [] sql = "SELECT * FROM appointments" results = run_sql(sql) for result in results: animal = animal_repository.select(result["animal_id"]) appointment = Appointment( result["start_time"], result["end_time"], result["appointment_date"], animal, result["id"]) appointments.append(appointment) return appointments
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 show(id): animal = animal_repository.select(id) treatments = animal_repository.treatments(id) date_today = datetime.datetime.now() treatments_future = [ treatment for treatment in treatments if treatment.date >= date_today.date() ] treatments_past = [ treatment for treatment in treatments if treatment.date < date_today.date() ] return render_template('/animals/show.html', animal=animal, treatments_future=treatments_future, treatments_past=treatments_past, title=animal.name)
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 edit_animal(id): animal = animal_repository.select(id) owners = owner_repository.select_all() return render_template("/animals/edit.html", all_owners=owners, animal=animal)
def get_animal(id): animal = animal_repository.select(id) return render_template("/animals/show.html", animal=animal)