def select(id):
sql = "SELECT * FROM zombies WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
zombie_type = zombie_type_repository.select(result["zombie_type_id"])
zombie = Zombie(result["name"], zombie_type, result["id"])
return zombie
def create_zombie():
name = request.form["name"]
zombie_type_id = request.form["zombie_type_id"]
zombie_type = zombie_type_repository.select(zombie_type_id)
new_zombie = Zombie(name, zombie_type)
zombie_repository.save(new_zombie)
return redirect("/zombies")
def update_zombie(id):
name = request.form["name"]
zombie_type_id = request.form["zombie_type_id"]
zombie_type = zombie_type_repository.select(zombie_type_id)
zombie = Zombie(name, zombie_type, id)
zombie_repository.update(zombie)
return redirect("/zombies")
def select_all():
zombies = []
sql = "SELECT * FROM zombies"
results = run_sql(sql)
for result in results:
zombie_type = zombie_type_repository.select(result["zombie_type_id"])
zombie = Zombie(result["name"], zombie_type, result["id"])
zombies.append(zombie)
return zombies
def edit_zombie_type(id):
zombie_type = zombie_type_repository.select(id)
return render_template('zombie_types/edit.html', zombie_type=zombie_type)