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()