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)