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)