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