def select_all():
    zombie_types = []
    sql = "SELECT * FROM zombie_types"
    results = run_sql(sql)
    for result in results:
        zombie_type = ZombieType(result["name"], result["id"])
        zombie_types.append(zombie_type)
    return zombie_types
zombie_repository.delete_all()
zombie_type_repository.delete_all()

human_1 = Human("Rochelle")
human_repository.save(human_1)

human_2 = Human("Coach")
human_repository.save(human_2)

human_3 = Human("Nick")
human_repository.save(human_3)

human_4 = Human("Ellis")
human_repository.save(human_4)

zombie_type_1 = ZombieType("Walker")
zombie_type_repository.save(zombie_type_1)

zombie_type_2 = ZombieType("Crawler")
zombie_type_repository.save(zombie_type_2)

zombie_type_3 = ZombieType("Runner")
zombie_type_repository.save(zombie_type_3)

zombie_1 = Zombie("Ed", zombie_type_2)
zombie_repository.save(zombie_1)

zombie_2 = Zombie("Pete", zombie_type_1)
zombie_repository.save(zombie_2)

biting_1 = Biting(human_2, zombie_2)
def select(id):
    sql = "SELECT * FROM zombie_types WHERE id = %s"
    values = [id]
    result = run_sql(sql, values)[0]
    zombie_type = ZombieType(result["name"], result["id"])
    return zombie_type
def update_zombie(id):
    name = request.form["name"]
    zombie_type = ZombieType(name, id)
    zombie_type_repository.update(zombie_type)
def create_zombie_type():
    name = request.form["name"]
    new_zombie_type = ZombieType(name)
    zombie_type_repository.save(new_zombie_type)
    return redirect("/zombietypes")