def delete(id):
sql = "DELETE FROM player_leagues WHERE id = %s"
values = [id]
run_sql(sql, values)
def delete_all():
sql = "DELETE FROM members"
run_sql(sql)
def save(member):
sql = "INSERT INTO members (name, age, premium, active) VALUES(%s, %s, %s, %s) RETURNING id"
values = [member.name, member.age, member.premium, member.active]
results = run_sql(sql, values)
member.id = results[0]['id']
def delete(id):
sql = "DELETE FROM animals WHERE id = %s"
values = [id]
run_sql(sql, values)
def update(deshi):
sql = "UPDATE deshis SET (name, waza_id) = (%s, %s) WHERE id = %s"
values = [deshi.name, deshi.waza.id, deshi.id]
run_sql(sql, values)
def update(pokemon):
sql = "UPDATE pokemons SET (name, trainer, nurse_id, species, hatched, notes) = (%s, %s, %s, %s, %s, %s) WHERE id = %s"
values = [pokemon.name, pokemon.trainer, pokemon.nurse.id, pokemon.species, pokemon.hatched, pokemon.notes, pokemon.id]
run_sql(sql, values)
def delete_all():
sql = "DELETE FROM pokemons"
run_sql(sql)
# add pokemon.trainer_id connections later
def delete_all():
sql = "DELETE FROM suppliers"
run_sql(sql)
def delete_all():
sql = "DELETE FROM locations"
run_sql(sql)
def save(merchant):
sql = "INSERT INTO merchants(name, description) VALUES (%s, %s) RETURNING ID"
values = [merchant.name, merchant.description]
results = run_sql(sql, values)
merchant.id = results[0]['id']
return merchant
def update(merchant):
sql = "UPDATE merchants SET (name, description) = (%s,%s) WHERE id = %s"
values = [merchant.name, merchant.description, merchant.id]
run_sql(sql, values)
def delete_all():
sql = "DELETE FROM merchants"
run_sql(sql)
def update(runner):
sql = "UPDATE runners SET (first_name, last_name) = (%s, %s) WHERE id = %s"
values = [runner.first_name, runner.last_name, runner.id]
print(values)
run_sql(sql, values)
def save(deshi):
sql = "INSERT INTO deshis (name, waza_id) VALUES (%s, %s) RETURNING id"
values = [deshi.name, deshi.waza.id]
results = run_sql(sql, values)
id = results[0]['id']
deshi.id = id
def delete_all():
sql = "DELETE FROM player_leagues"
run_sql(sql)
def delete_all():
sql = "DELETE FROM reds"
run_sql(sql)
def save(player_league):
sql = "INSERT INTO player_leagues (player_id, league_id) VALUES (%s, %s) RETURNING id"
values = [player_league.player.id, player_league.league.id]
result = run_sql(sql, values)
player_league.id = result[0]['id']
return player_league
def delete_all():
sql = "DELETE FROM pets"
run_sql(sql)
def delete(id):
sql = "DELETE FROM pokemons WHERE id = %s"
values = [id]
run_sql(sql, values)
def update(member):
sql = "UPDATE members SET (name, age, premium, active) = (%s, %s, %s, %s) WHERE id = %s"
values = [
member.name, member.age, member.premium, member.active, member.id
]
run_sql(sql, values)
def save(pokemon):
sql = "INSERT INTO pokemons (name, trainer, species, hatched, nurse_id, notes) VALUES (%s, %s, %s, %s, %s, %s) RETURNING id"
values = [pokemon.name, pokemon.trainer, pokemon.species, pokemon.hatched, pokemon.nurse.id, pokemon.notes]
results = run_sql( sql, values )
pokemon.id = results[0]['id']
return pokemon
def delete(id):
sql = "DELETE FROM members WHERE id = %s"
values = [id]
run_sql(sql, values)
def delete_all():
sql = "DELETE FROM books"
run_sql(sql)
def delete_all():
sql = "DELETE FROM deshis"
run_sql(sql)
