authors

Documentation

Index

• type Author
• type Book
• type DBTX
• type InsertAuthorParams
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CountAuthor(ctx context.Context) (int64, error)
  • func (q *Queries) CountBook(ctx context.Context) (int64, error)
  • func (q *Queries) DeleteAuthor(ctx context.Context, authorID int64) error
  • func (q *Queries) DeleteBook(ctx context.Context, bookID uuid.UUID) error
  • func (q *Queries) InsertAuthor(ctx context.Context, arg InsertAuthorParams) (Author, error)
  • func (q *Queries) InsertBook(ctx context.Context, name string) (Book, error)
  • func (q *Queries) ListAuthor(ctx context.Context, authorID int64) ([]Author, error)
  • func (q *Queries) ListBook(ctx context.Context) ([]Book, error)
  • func (q *Queries) SelectAuthor(ctx context.Context, authorID int64) (Author, error)
  • func (q *Queries) SelectBook(ctx context.Context, bookID uuid.UUID) (Book, 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 UpdateAuthorParams
• type UpdateBookParams

Types

type Author

type Author struct {
	AuthorID int64
	Ssid     sql.NullInt32
	Name     string
	Spouses  sql.NullInt32
	Children sql.NullInt32
	Bio      string
	Acct     sql.NullString
}

type Book

type Book struct {
	BookID uuid.UUID
	Name   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 InsertAuthorParams

type InsertAuthorParams struct {
	Ssid     sql.NullInt32
	Name     string
	Spouses  sql.NullInt32
	Children sql.NullInt32
	Bio      string
	Acct     sql.NullString
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CountAuthor

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

Count # of Author

func (*Queries) CountBook

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

Count # of Book

func (*Queries) DeleteAuthor

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

Delete one Author using author_id

func (*Queries) DeleteBook

func (q *Queries) DeleteBook(ctx context.Context, bookID uuid.UUID) error

Delete one Book using book_id

func (*Queries) InsertAuthor

func (q *Queries) InsertAuthor(ctx context.Context, arg InsertAuthorParams) (Author, error)

Insert one row of Author

func (*Queries) InsertBook

func (q *Queries) InsertBook(ctx context.Context, name string) (Book, error)

Insert one row of Book

func (*Queries) ListAuthor

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

Lists 1000 Author having id > @author_id

func (*Queries) ListBook

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

Lists all Book

func (*Queries) SelectAuthor

func (q *Queries) SelectAuthor(ctx context.Context, authorID int64) (Author, error)

Select one Author using author_id

func (*Queries) SelectBook

func (q *Queries) SelectBook(ctx context.Context, bookID uuid.UUID) (Book, error)

Select one Book using book_id

func (*Queries) UpdateAuthor

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

Update one row of Author using author_id

func (*Queries) UpdateBook

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

Update one row of Book using book_id

func (*Queries) WithTx

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

type UpdateAuthorParams

type UpdateAuthorParams struct {
	Ssid     sql.NullInt32
	Name     string
	Spouses  sql.NullInt32
	Children sql.NullInt32
	Bio      string
	Acct     sql.NullString
	AuthorID int64
}

type UpdateBookParams

type UpdateBookParams struct {
	Name   string
	BookID uuid.UUID
}