def view(id):
# Get data to be displayed
owner = OR.select(id)
pets = PR.select_by_owner(id)
pet_count = len(pets)
return render_template('owners/specific.html', title=owner.first_name + " " + owner.last_name, owner=owner, pets=pets, pet_count=pet_count)
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 create_animal():
name = request.form['name']
species = request.form['species']
owner_id = request.form['owner_id']
owner = owner_repository.select(owner_id)
new_animal = Animal(name, species, owner)
animal_repository.save(new_animal)
return redirect('/animals')
def create():
name = request.form['name']
animal_type = request.form['animal_type']
owner_id = request.form['owner_id']
owner = owner_repository.select(owner_id)
new_animal = Animal(name, animal_type, owner)
animal_repository.save(new_animal)
return redirect("/animals")
def update_animal(id):
name = request.form['name']
species = request.form['species']
owner_id = request.form['owner_id']
owner = owner_repository.select(owner_id)
animal = Animal(name, species, owner, id)
animal_repository.update(animal)
return redirect('/animals')
def select(id):
animal = None
sql = 'SELECT * FROM animals WHERE id = %s'
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
owner = owner_repository.select(result['owner_id'])
animal = Animal(result['name'], result['species'], owner, result['id'])
return animal
def show(id):
owner = owner_repository.select(id)
animals = animal_repository.animals_by_owner(owner)
address = owner.address.printable()
return render_template("owners/show.html",
title="Owner",
owner=owner,
animals=animals,
address=address)
def select_all():
animals = []
sql = 'SELECT * FROM animals'
results = run_sql(sql)
for row in results:
owner = owner_repository.select(row['owner_id'])
animal = Animal(row['name'], row['species'], owner, row['id'])
animals.append(animal)
return animals
def select_all():
animals = []
sql = "SELECT * FROM animals"
results = run_sql(sql)
for row in results:
owner = owner_repository.select(row['owner_id'])
vet = vet_repository.select(row['vet_id'])
animal = Animal(row['name'], row['type'], row['dob'], owner, vet, row['id'])
animals.append(animal)
return animals
def select(id):
animal = None
sql = "SELECT * FROM animals WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
owner = owner_repository.select(result['owner_id'])
vet = vet_repository.select(result['vet_id'])
animal = Animal(result['name'], result['type'], result['dob'], owner, vet, result['id'])
return animal
def create_animal():
name = request.form["name"]
date_of_birth = request.form["date_of_birth"]
animal_type = request.form["animal_type"]
treatment_notes = request.form["treatment_notes"]
owner = owner_repository.select(request.form["owner_id"])
new_animal = Animal(name, date_of_birth, animal_type, treatment_notes,
owner)
animal_repository.save(new_animal)
return redirect("/animals")
def create():
name = request.form['name']
type = request.form['type']
dob = request.form['dob']
owner_id = request.form['owner']
vet_id = request.form['vet']
owner = owner_repository.select(owner_id)
vet = vet_repository.select(vet_id)
new_Animal = Animal(name, type, dob, owner, vet)
animal_repository.save(new_Animal)
return redirect("/animals")
def select_all():
animals = []
sql = 'SELECT * FROM animals'
results = run_sql(sql)
for result in results:
owner = owner_repository.select(result['owner_id'])
vet = vet_repository.select(result['vet_id'])
animal = Animal(result['name'], result['dob'], result['type'], owner,
vet, result['id'], result['treatment_notes'])
animals.append(animal)
return animals
def update(id):
name = request.form["name"]
dob = request.form["dob"]
species = request.form["species"]
breed = request.form["breed"]
owner = owner_repository.select(request.form["owner_id"])
vet = vet_repository.select(request.form["vet_id"])
date_registered = request.form["date_registered"]
animal = Animal(name, dob, species, breed, owner, vet, date_registered, id)
animal_repository.update(animal)
return redirect(f"/animals/{id}")
def create():
name = request.form["name"]
dob = request.form["dob"]
species = request.form["species"]
breed = request.form["breed"]
owner = owner_repository.select(request.form["owner_id"])
vet = vet_repository.select(request.form["vet_id"])
date_registered = datetime.datetime.now()
animal = Animal(name, dob, species, breed, owner, vet, date_registered)
animal_repository.save(animal)
return redirect(f"/animals/{animal.id}")
def select(animal_id):
sql = "SELECT * FROM animals WHERE id = %s"
values = [animal_id]
result = run_sql(sql, values)
if result:
dict_animal = result[0]
vet = vet_repository.select(dict_animal['vet_id']) if dict_animal['vet_id'] else None
owner = owner_repository.select(dict_animal['owner_id'])
animal = Animal(dict_animal['name'], dict_animal['dob'], dict_animal['animal_type'], owner, vet, dict_animal['img_url'], dict_animal['id'])
return animal
def update(id):
name = request.form['name']
type = request.form['type']
dob = request.form['dob']
owner_id = request.form['owner_id']
vet_id = request.form['vet_id']
owner = owner_repository.select(owner_id)
vet = vet_repository.select(vet_id)
animal = Animal(name, type, dob, owner, vet, id)
animal_repository.update(animal)
return redirect('/animals')
def create_animal():
name = request.form["name"]
species = request.form["species"]
breed = request.form["breed"]
age = request.form["age"]
picture = request.form["picture"]
owner_id = request.form["owner_id"]
owner = owner_repository.select(owner_id)
new_animal = Animal(name, species, breed, age, picture, owner)
animal_repository.save(new_animal)
return redirect("/animals")
def select(id):
sql = "SELECT * FROM animals WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
owner = owner_repository.select(result["owner_id"])
if result is not None:
animal = Animal(result["name"], result["date_of_birth"],
result["animal_type"], result["treatment_notes"],
owner, result["id"])
return animal
def select_id_owner(id):
animals = []
sql = "SELECT * FROM animals WHERE owner_id = %s"
values = [id]
results = run_sql(sql, values)
for row in results:
owner = owner_repository.select(row['owner_id'])
vet = vet_repository.select(row['vet_id'])
animal = Animal(row['name'], row['type'], row['dob'], owner, vet, row['id'])
animals.append(animal)
return animals
def select_all():
animals = []
sql = "SELECT * FROM animals"
results = run_sql(sql)
for result in results:
owner = owner_repository.select(result["owner_id"])
animal = Animal(result["name"], result["date_of_birth"],
result["animal_type"], result["treatment_notes"],
owner, result["id"])
animals.append(animal)
return animals
def animals(vet_id):
animals = []
sql = "SELECT * FROM animals WHERE vet_id = %s"
values = [vet_id]
results = run_sql(sql, values)
for row in results:
vet = select(row['vet_id']) if row['vet_id'] else None
owner = owner_repository.select(row['owner_id'])
animal = Animal(row['name'], row['dob'], row['animal_type'], owner,
vet, row['img_url'], row['id'])
animals.append(animal)
return animals
def select(pet_id):
# Create the SQL query, pass in the data and run it
sql = "SELECT * FROM pet WHERE id = %s"
values = [pet_id]
result = run_sql(sql, values)
# Create object if data is found in the database
if len(result) > 0:
pet_type = PTR.select(result[0]['type_id'])
owner = OR.select(result[0]['owner_id'])
vet = VR.select(result[0]['vet_id'])
new_pet = Pet(result[0]['name'], result[0]['dob'], owner, pet_type, vet, result[0]['id'])
return new_pet
def update_animal(id):
name = request.form['name']
animal_type = request.form['animal_type']
dob_string = request.form['dob']
dob = datetime.datetime.strptime(dob_string, '%Y-%m-%d').date()
owner_id = request.form['owner_id']
owner = owner_repository.select(owner_id)
img_url = request.form['img_url'] if request.form[
'img_url'] else "static/images/no_img.jpg"
vet_id = None if request.form['vet_id'] == "None" else request.form[
'vet_id']
vet = vet_repository.select(vet_id)
updated_animal = Animal(name, dob, animal_type, owner, vet, img_url, id)
animal_repository.update(updated_animal)
return redirect(f'/animals/{updated_animal.id}')
def update(id):
owner = owner_repository.select(id)
first_name = request.form["first_name"]
last_name = request.form["last_name"]
num = request.form["num"]
street = request.form["street"]
city = request.form["city"]
postcode = request.form["postcode"]
address_id = request.form["address_id"]
address = Address(num, street, city, postcode, address_id)
address_repository.update(address)
tel = request.form["tel"]
email = request.form["email"]
owner = Owner(first_name, last_name, address, tel, email, owner.bill, id)
owner_repository.update(owner)
return redirect(f"/owners/{id}")
def update(id):
# Get the data from the form
name = request.form['pet_name']
dob = request.form['pet_age']
type_id = request.form['pet_type']
owner_id = request.form['pet_owner']
vet_id = request.form['pet_vet']
# Find the correct data for the Pet object
pet_type = PTR.select(type_id)
owner = OR.select(owner_id)
vet = VR.select(vet_id)
# Create new Pet object to be saved to db
pet = Pet(name, dob, owner, pet_type, vet, id)
PR.update(pet)
return redirect('/pets/' + id)
def select(id):
animal = None
sql = "SELECT * FROM animals WHERE id = %s"
values = [id]
row = run_sql(sql, values)[0]
if row is not None:
owner = owner_repository.select(row["owner_id"])
vet = vet_repository.select(row["vet_id"])
animal = Animal(
row["name"],
row["dob"],
row["species"],
row["breed"],
owner,
vet,
row["date_registered"],
row["id"],
)
return animal
def select_all():
animals = []
sql = "SELECT * FROM animals"
results = run_sql(sql)
for row in results:
owner = owner_repository.select(row["owner_id"])
vet = vet_repository.select(row["vet_id"])
animal = Animal(
row["name"],
row["dob"],
row["species"],
row["breed"],
owner,
vet,
row["date_registered"],
row["id"],
)
animals.append(animal)
return animals
def select_all():
# Create list of pet objects and set == empty list
pets = []
# Create the SQL query && input data before running it
sql = "SELECT * FROM pet"
results = run_sql(sql)
# Loop through all the results and append the objects to a list
for row in results:
# Get the objects to create the pet object
pet_type = PTR.select(row['type_id'])
owner = OR.select(row['owner_id'])
vet = VR.select(row['vet_id'])
# Create new pet object && append to pets list
new_pet = Pet(row['name'], row['dob'], owner, pet_type, vet, row['id'])
pets.append(new_pet)
return pets
def select_by_owner(owner_id):
# Create list of pets == empty list
pets = []
# Create SQL query, input data && run
sql = "SELECT * FROM pet WHERE owner_id = %s"
values = [owner_id]
results = run_sql(sql, values)
# Loop through the results
for row in results:
# Get the objects to create the pet object
pet_type = PTR.select(row['type_id'])
owner = OR.select(row['owner_id'])
vet = VR.select(row['vet_id'])
# Create new pet object && append to pets list
new_pet = Pet(row['name'], row['dob'], owner, pet_type, vet, row['id'])
pets.append(new_pet)
return pets
