def edit_customer(id): customer = customer_repository.select(id) animals = animal_repository.select_all() return render_template("/customers/edit.html", title="Edit Customer", customer=customer, all_animals=animals)
def create_animal(): print(request.form) name = request.form["name"] dob = request.form["dob"] animal_type = request.form["animal_type"] notes = request.form["notes"] customer = customer_repository.select(request.form["customer_id"]) animal = Animal(name, dob, animal_type, notes, customer) animal_repository.save(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: customer = customer_repository.select(result['customer_id']) animal = Animal(result['name'], result['dob'], result['animal_type'], result['notes'], customer, result['id']) return animal
def select_all(): animals = [] sql = "SELECT * FROM animals ORDER by name" results = run_sql(sql) for row in results: customer = customer_repository.select(row['customer_id']) animal = Animal(row['name'], row['dob'], row['animal_type'], row['notes'], customer, row['id']) animals.append(animal) return animals
def update_animal(id): # takes data from form name = request.form["name"] dob = request.form["dob"] animal_type = request.form["animal_type"] notes = request.form["notes"] customer = customer_repository.select(request.form["customer_id"]) # make new instance of an Animal using data as constructor values animal = Animal(name, dob, animal_type, notes, customer) # add this new animal object to animal list animal_repository.save(animal) return redirect("/animals")
def create_order(): order_timestamp = request.form['order_timestamp'] customer_id = request.form['customer'] restaurant_id = request.form['restaurant'] dish_ids = request.form.getlist('dishes') customer = customer_repository.select(customer_id) restaurant = restaurant_repository.select(restaurant_id) new_order = Order(order_timestamp, customer, restaurant) order_repository.save(new_order) order_dishes = [] for id in dish_ids: new_order_dish = OrderDish(new_order, dish_repository.select(id)) order_dish_repository.save(new_order_dish) order_dishes.append(new_order_dish) return redirect('/orders')
def update_order(order_id): timestamp = request.form["order_timestamp"] customer_id = request.form["customer"] restaurant_id = request.form["restaurant"] dish_ids = request.form.getlist('dishes') customer = customer_repository.select(customer_id) restaurant = restaurant_repository.select(restaurant_id) update_order = Order(timestamp, customer, restaurant, order_id) order_repository.update(update_order) updated_order_dishes = [] for id in dish_ids: updated_order_dish = OrderDish(update_order, dish_repository.select(id)) order_dish_repository.save(updated_order_dish) updated_order_dishes.append(updated_order_dishes) return redirect("/orders")
def edit_customer(id): customer = customer_repository.select(id) return render_template('customers/edit.html', customer=customer)
def show_customer(id): customer = customer_repository.select(id) return render_template("customers/show.html", customer=customer)
def edit_customer(id): customer = customer_repository.select(id) all_gyms = gym_repository.select_all() return render_template("customers/edit.html", customer=customer, all_gyms=all_gyms)