def select_all():
bitings = []
sql = "SELECT * FROM bitings"
results = run_sql(sql)
for result in results:
biting = Biting(result["human"], result["zombie"])
bitings.append(biting)
return bitings
def select(id):
sql = "SELECT * FROM bitings WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
human = human_repository.select(result["human_id"])
zombie = zombie_repository.select(result["zombie_id"])
biting = Biting(human, zombie, result["id"])
return biting
def update_biting(id):
human_id = request.form["human_id"]
zombie_id = request.form["zombie_id"]
human = human_repository.select(human_id)
zombie = zombie_repository.select(zombie_id)
biting = Biting(human, zombie, id)
biting_repository.update(biting)
return redirect("/bitings")
def create_biting():
human_id = request.form["human_id"]
zombie_id = request.form["zombie_id"]
human = human_repository.select(human_id)
zombie = zombie_repository.select(zombie_id)
new_biting = Biting(human, zombie)
biting_repository.save(new_biting)
return redirect("/bitings")
def select_all():
bitings = []
sql = "SELECT * FROM bitings"
result = run_sql(sql)
for row in results:
biting = Biting(row["human_id"], row["zombie_id"], row["id"])
bitings.append(biting)
return bitings
def select_all():
bitings = []
sql = "SELECT * FROM bitings"
results = run_sql(sql)
for result in results:
human = human_repository.select(result["human_id"])
zombie = zombie_repository.select(result["zombie_id"])
biting = Biting(human, zombie, result["id"])
bitings.append(biting)
return bitings
def select_all():
bitings_list = []
sql = "SELECT * FROM bitings"
results = run_sql(sql)
for row in results:
human = human_repository.select(row['human_id'])
zombie = zombie_repository.select(row['zombie_id'])
biting = Biting(human, zombie, row['id'])
bitings_list.append(biting)
return bitings_list
def select(id):
sql = "SELECT * FROM bitings WHERE id = %s"
values = [id]
result = run_sql(sql, values) [0]
biting = Biting(result["human"], result["id"])
return biting
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)
biting_repository.save(biting_1)
biting_2 = Biting(human_3, zombie_1)
biting_repository.save(biting_2)
biting_3 = Biting(human_3, zombie_2)
biting_repository.save(biting_3)
biting_4 = Biting(human_4, zombie_2)
biting_repository.save(biting_4)
pdb.set_trace()