def update_pigeon(pindex, data):
cols = utils.build_sql_cols(data)
data["pindex_old"] = pindex
try:
session.cursor.execute(
"UPDATE Pigeons SET %s WHERE pindex=:pindex_old" % cols, data)
except sqlite3.IntegrityError as exc:
raise InvalidValueError(exc)
session.connection.commit()
def update_racepoint(racepoint, data):
cols = utils.build_sql_cols(data)
data["racepoint"] = racepoint
session.cursor.execute(
"UPDATE Racepoints SET %s WHERE racepoint=:racepoint" % cols, data)
session.connection.commit()
def update_address(key, data):
cols = utils.build_sql_cols(data)
data["key"] = key
session.cursor.execute(
"UPDATE Addresses SET %s WHERE Addresskey=:key" % cols, data)
session.connection.commit()
def get_address_data(data):
cols = utils.build_sql_cols(data)
session.cursor.execute("SELECT * FROM Addresses WHERE %s" % cols, data)
return session.cursor.fetchone()
def remove_media(data):
cols = utils.build_sql_cols(data, delimiter=utils.AND)
session.cursor.execute("DELETE FROM Media WHERE %s" % cols, data)
session.connection.commit()
def update_breeding(key, data):
cols = utils.build_sql_cols(data)
data["key"] = key
session.cursor.execute(
"UPDATE Breeding SET %s WHERE Breedingkey=:key" % cols, data)
session.connection.commit()
def update_media_for_pindex(pindex, data):
cols = utils.build_sql_cols(data)
data["pindex_old"] = pindex
session.cursor.execute(
"UPDATE Media SET %s WHERE pindex=:pindex_old" % cols, data)
session.connection.commit()
def update_medication(medid, data):
cols = utils.build_sql_cols(data)
data["medid"] = medid
session.cursor.execute(
"UPDATE Medication SET %s WHERE medid=:medid" % cols, data)
session.connection.commit()
def update_result_for_key(key, data):
cols = utils.build_sql_cols(data)
data["key"] = key
session.cursor.execute("UPDATE Results SET %s WHERE Resultkey=:key" % cols,
data)
session.connection.commit()
def get_results_for_data(data):
cols = utils.build_sql_cols(data, delimiter=utils.AND)
session.cursor.execute(
"SELECT * FROM Results WHERE %s ORDER BY place ASC" % cols, data)
return session.cursor.fetchall()
def result_exists(data):
cols = utils.build_sql_cols(data, delimiter=utils.AND)
session.cursor.execute(
"SELECT EXISTS(SELECT 1 FROM Results WHERE %s LIMIT 1)" % cols, data)
return bool(session.cursor.fetchone()[0])
def update_status(table, pindex, data):
cols = utils.build_sql_cols(data)
data["pindex_old"] = pindex
session.cursor.execute(
"UPDATE %s SET %s WHERE pindex=:pindex_old" % (table, cols), data)
session.connection.commit()