dbgen

Documentation

Index

• type Author
• type Book
• type DBTX
• type Genre
• type GetBookByIDRow
• type ListBooksParams
• type ListBooksRow
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) GetBookByID(ctx context.Context, id pgtype.UUID) (GetBookByIDRow, error)
  • func (q *Queries) ListBooks(ctx context.Context, arg ListBooksParams) ([]ListBooksRow, error)
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries

Types

type Author

type Author struct {
	ID   pgtype.UUID
	Name string
	Bio  string
}

type Book

type Book struct {
	ID          pgtype.UUID
	Title       string
	Isbn        string
	PublishedAt pgtype.Date
	PriceCents  int64
	AuthorID    pgtype.UUID
	GenreID     pgtype.UUID
}

type DBTX

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type Genre

type Genre struct {
	ID   pgtype.UUID
	Name string
	Slug string
}

type GetBookByIDRow

type GetBookByIDRow struct {
	ID          pgtype.UUID
	Title       string
	Isbn        string
	PublishedAt pgtype.Date
	PriceCents  int64
	AuthorID    pgtype.UUID
	AuthorName  string
	AuthorBio   string
	GenreID     pgtype.UUID
	GenreName   string
	GenreSlug   string
}

type ListBooksParams

type ListBooksParams struct {
	Limit  int32
	Offset int32
	Query  pgtype.Text
	Genre  pgtype.Text
}

type ListBooksRow

type ListBooksRow struct {
	ID          pgtype.UUID
	Title       string
	Isbn        string
	PublishedAt pgtype.Date
	PriceCents  int64
	AuthorID    pgtype.UUID
	AuthorName  string
	AuthorBio   string
	GenreID     pgtype.UUID
	GenreName   string
	GenreSlug   string
}

type Queries

type Queries struct {
	// contains filtered or unexported fields
}

func New

func New(db DBTX) *Queries

func (*Queries) GetBookByID

func (q *Queries) GetBookByID(ctx context.Context, id pgtype.UUID) (GetBookByIDRow, error)

func (*Queries) ListBooks

func (q *Queries) ListBooks(ctx context.Context, arg ListBooksParams) ([]ListBooksRow, error)

func (*Queries) WithTx

func (q *Queries) WithTx(tx pgx.Tx) *Queries