def delete_venue(conn: sqlc.GenericConnection, slug: str) -> sqlc.ReturnType[None]: return conn.execute_none(DELETE_VENUE, slug)
def update_book_isbn(conn: sqlc.GenericConnection, title: str, tags: List[str], book_id: int, isbn: str) -> sqlc.ReturnType[None]: return conn.execute_none(UPDATE_BOOK_ISBN, title, tags, book_id, isbn)
def create_venue(conn: sqlc.GenericConnection, arg: CreateVenueParams) -> sqlc.ReturnType[Optional[int]]: return conn.execute_one(CREATE_VENUE, arg.slug, arg.name, arg.city, arg.spotify_playlist, arg.status, arg.statuses, arg.tags)
def get_author(conn: sqlc.GenericConnection, author_id: int) -> sqlc.ReturnType[Optional[models.Author]]: return conn.execute_one_model(models.Author, GET_AUTHOR, author_id)
def get_book(conn: sqlc.GenericConnection, book_id: int) -> sqlc.ReturnType[Optional[GetBookRow]]: return conn.execute_one_model(GetBookRow, GET_BOOK, book_id)
def update_venue_name(conn: sqlc.GenericConnection, slug: str, name: str) -> sqlc.ReturnType[Optional[int]]: return conn.execute_one(UPDATE_VENUE_NAME, slug, name)
def get_city(conn: sqlc.GenericConnection, slug: str) -> sqlc.ReturnType[Optional[models.City]]: return conn.execute_one_model(models.City, GET_CITY, slug)
def books_by_title_year(conn: sqlc.GenericConnection, title: str, year: int) -> sqlc.IteratorReturn[BooksByTitleYearRow]: return conn.execute_many_model(BooksByTitleYearRow, BOOKS_BY_TITLE_YEAR, title, year)
def create_author(conn: sqlc.GenericConnection, name: str) -> sqlc.ReturnType[Optional[models.Author]]: return conn.execute_one_model(models.Author, CREATE_AUTHOR, name)
def list_authors( conn: sqlc.GenericConnection) -> sqlc.IteratorReturn[models.Author]: return conn.execute_many_model(models.Author, LIST_AUTHORS)
def books_by_tags(conn: sqlc.GenericConnection, dollar_1: List[str]) -> sqlc.IteratorReturn[BooksByTagsRow]: return conn.execute_many_model(BooksByTagsRow, BOOKS_BY_TAGS, dollar_1)
def delete_author(conn: sqlc.GenericConnection, id: int) -> sqlc.ReturnType[None]: return conn.execute_none(DELETE_AUTHOR, id)
def update_city_name(conn: sqlc.GenericConnection, slug: str, name: str) -> sqlc.ReturnType[None]: return conn.execute_none(UPDATE_CITY_NAME, slug, name)
def list_cities( conn: sqlc.GenericConnection) -> sqlc.IteratorReturn[models.City]: return conn.execute_many_model(models.City, LIST_CITIES)
def get_venue(conn: sqlc.GenericConnection, slug: str, city: str) -> sqlc.ReturnType[Optional[GetVenueRow]]: return conn.execute_one_model(GetVenueRow, GET_VENUE, slug, city)
def create_book( conn: sqlc.GenericConnection, arg: CreateBookParams) -> sqlc.ReturnType[Optional[CreateBookRow]]: return conn.execute_one_model(CreateBookRow, CREATE_BOOK, arg.author_id, arg.isbn, arg.book_type, arg.title, arg.year, arg.available, arg.tags)
def list_venues(conn: sqlc.GenericConnection, city: str) -> sqlc.IteratorReturn[ListVenuesRow]: return conn.execute_many_model(ListVenuesRow, LIST_VENUES, city)
def delete_book(conn: sqlc.GenericConnection, book_id: int) -> sqlc.ReturnType[None]: return conn.execute_none(DELETE_BOOK, book_id)
def venue_count_by_city( conn: sqlc.GenericConnection ) -> sqlc.IteratorReturn[VenueCountByCityRow]: return conn.execute_many_model(VenueCountByCityRow, VENUE_COUNT_BY_CITY)
def create_city(conn: sqlc.GenericConnection, name: str, slug: str) -> sqlc.ReturnType[Optional[models.City]]: return conn.execute_one_model(models.City, CREATE_CITY, name, slug)