sqlc

Documentation

Index

• type Agent
• type Author
• type Book
• type BookAuthor
• type CreateAgentParams
• type CreateAuthorParams
• type CreateBookParams
• type DBTX
• type ListAgentsByAuthorIDsRow
• type ListAuthorsByBookIDsRow
• type ListBooksByAuthorIDsRow
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateAgent(ctx context.Context, arg CreateAgentParams) (Agent, error)
  • func (q *Queries) CreateAuthor(ctx context.Context, arg CreateAuthorParams) (Author, error)
  • func (q *Queries) CreateBook(ctx context.Context, arg CreateBookParams) (Book, error)
  • func (q *Queries) DeleteAgent(ctx context.Context, id int64) (Agent, error)
  • func (q *Queries) DeleteAuthor(ctx context.Context, id int64) (Author, error)
  • func (q *Queries) DeleteBook(ctx context.Context, id int64) (Book, error)
  • func (q *Queries) GetAgent(ctx context.Context, id int64) (Agent, error)
  • func (q *Queries) GetAuthor(ctx context.Context, id int64) (Author, error)
  • func (q *Queries) GetBook(ctx context.Context, id int64) (Book, error)
  • func (q *Queries) ListAgents(ctx context.Context) ([]Agent, error)
  • func (q *Queries) ListAgentsByAuthorIDs(ctx context.Context, dollar_1 []int64) ([]ListAgentsByAuthorIDsRow, error)
  • func (q *Queries) ListAuthors(ctx context.Context) ([]Author, error)
  • func (q *Queries) ListAuthorsByAgentIDs(ctx context.Context, dollar_1 []int64) ([]Author, error)
  • func (q *Queries) ListAuthorsByBookIDs(ctx context.Context, dollar_1 []int64) ([]ListAuthorsByBookIDsRow, error)
  • func (q *Queries) ListBooks(ctx context.Context) ([]Book, error)
  • func (q *Queries) ListBooksByAuthorIDs(ctx context.Context, dollar_1 []int64) ([]ListBooksByAuthorIDsRow, error)
  • func (q *Queries) SetBookAuthor(ctx context.Context, arg SetBookAuthorParams) error
  • func (q *Queries) UnsetBookAuthors(ctx context.Context, bookID int64) error
  • func (q *Queries) UpdateAgent(ctx context.Context, arg UpdateAgentParams) (Agent, error)
  • func (q *Queries) UpdateAuthor(ctx context.Context, arg UpdateAuthorParams) (Author, error)
  • func (q *Queries) UpdateBook(ctx context.Context, arg UpdateBookParams) (Book, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type SetBookAuthorParams
• type UpdateAgentParams
• type UpdateAuthorParams
• type UpdateBookParams

Types

type Agent

type Agent struct {
	ID    int64
	Name  string
	Email string
}

type Author

type Author struct {
	ID      int64
	Name    string
	Website sql.NullString
	AgentID int64
}

type Book

type Book struct {
	ID          int64
	Title       string
	Description string
	Cover       string
}

type BookAuthor

type BookAuthor struct {
	ID       int64
	BookID   int64
	AuthorID int64
}

type CreateAgentParams

type CreateAgentParams struct {
	Name  string
	Email string
}

type CreateAuthorParams

type CreateAuthorParams struct {
	Name    string
	Website sql.NullString
	AgentID int64
}

type CreateBookParams

type CreateBookParams struct {
	Title       string
	Description string
	Cover       string
}

type DBTX

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type ListAgentsByAuthorIDsRow

type ListAgentsByAuthorIDsRow struct {
	ID       int64
	Name     string
	Email    string
	AuthorID int64
}

type ListAuthorsByBookIDsRow

type ListAuthorsByBookIDsRow struct {
	ID      int64
	Name    string
	Website sql.NullString
	AgentID int64
	BookID  int64
}

type ListBooksByAuthorIDsRow

type ListBooksByAuthorIDsRow struct {
	ID          int64
	Title       string
	Description string
	Cover       string
	AuthorID    int64
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateAgent

func (q *Queries) CreateAgent(ctx context.Context, arg CreateAgentParams) (Agent, error)

func (*Queries) CreateAuthor

func (q *Queries) CreateAuthor(ctx context.Context, arg CreateAuthorParams) (Author, error)

func (*Queries) CreateBook

func (q *Queries) CreateBook(ctx context.Context, arg CreateBookParams) (Book, error)

func (*Queries) DeleteAgent

func (q *Queries) DeleteAgent(ctx context.Context, id int64) (Agent, error)

func (*Queries) DeleteAuthor

func (q *Queries) DeleteAuthor(ctx context.Context, id int64) (Author, error)

func (*Queries) DeleteBook

func (q *Queries) DeleteBook(ctx context.Context, id int64) (Book, error)

func (*Queries) GetAgent

func (q *Queries) GetAgent(ctx context.Context, id int64) (Agent, error)

func (*Queries) GetAuthor

func (q *Queries) GetAuthor(ctx context.Context, id int64) (Author, error)

func (*Queries) GetBook

func (q *Queries) GetBook(ctx context.Context, id int64) (Book, error)

func (*Queries) ListAgents

func (q *Queries) ListAgents(ctx context.Context) ([]Agent, error)

func (*Queries) ListAgentsByAuthorIDs

func (q *Queries) ListAgentsByAuthorIDs(ctx context.Context, dollar_1 []int64) ([]ListAgentsByAuthorIDsRow, error)

func (*Queries) ListAuthors

func (q *Queries) ListAuthors(ctx context.Context) ([]Author, error)

func (*Queries) ListAuthorsByAgentIDs

func (q *Queries) ListAuthorsByAgentIDs(ctx context.Context, dollar_1 []int64) ([]Author, error)

func (*Queries) ListAuthorsByBookIDs

func (q *Queries) ListAuthorsByBookIDs(ctx context.Context, dollar_1 []int64) ([]ListAuthorsByBookIDsRow, error)

func (*Queries) ListBooks

func (q *Queries) ListBooks(ctx context.Context) ([]Book, error)

func (*Queries) ListBooksByAuthorIDs

func (q *Queries) ListBooksByAuthorIDs(ctx context.Context, dollar_1 []int64) ([]ListBooksByAuthorIDsRow, error)

func (*Queries) SetBookAuthor

func (q *Queries) SetBookAuthor(ctx context.Context, arg SetBookAuthorParams) error

func (*Queries) UnsetBookAuthors

func (q *Queries) UnsetBookAuthors(ctx context.Context, bookID int64) error

func (*Queries) UpdateAgent

func (q *Queries) UpdateAgent(ctx context.Context, arg UpdateAgentParams) (Agent, error)

func (*Queries) UpdateAuthor

func (q *Queries) UpdateAuthor(ctx context.Context, arg UpdateAuthorParams) (Author, error)

func (*Queries) UpdateBook

func (q *Queries) UpdateBook(ctx context.Context, arg UpdateBookParams) (Book, error)

func (*Queries) WithTx

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

type SetBookAuthorParams

type SetBookAuthorParams struct {
	BookID   int64
	AuthorID int64
}

type UpdateAgentParams

type UpdateAgentParams struct {
	ID    int64
	Name  string
	Email string
}

type UpdateAuthorParams

type UpdateAuthorParams struct {
	ID      int64
	Name    string
	Website sql.NullString
	AgentID int64
}

type UpdateBookParams

type UpdateBookParams struct {
	ID          int64
	Title       string
	Description string
	Cover       string
}