database

Documentation

Index

• type Author
• type CreateAuthorParams
• type DBTX
• type PartialUpdateAuthorParams
• type Postgres
  • func NewPostgres(host, user, password string) (*Postgres, error)
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateAuthor(ctx context.Context, arg CreateAuthorParams) (Author, error)
  • func (q *Queries) DeleteAuthor(ctx context.Context, id int64) error
  • func (q *Queries) GetAuthor(ctx context.Context, id int64) (Author, error)
  • func (q *Queries) ListAuthors(ctx context.Context) ([]Author, error)
  • func (q *Queries) PartialUpdateAuthor(ctx context.Context, arg PartialUpdateAuthorParams) (Author, error)
  • func (q *Queries) TruncateAuthor(ctx context.Context) error
  • func (q *Queries) UpdateAuthor(ctx context.Context, arg UpdateAuthorParams) (Author, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type UpdateAuthorParams

Types

type Author

type Author struct {
	ID   int64
	Name string
	Bio  string
}

type CreateAuthorParams

type CreateAuthorParams struct {
	Name string
	Bio  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 PartialUpdateAuthorParams

type PartialUpdateAuthorParams struct {
	UpdateName bool
	Name       string
	UpdateBio  bool
	Bio        string
	ID         int64
}

type Postgres

type Postgres struct {
	DB *sql.DB
}

func NewPostgres

func NewPostgres(host, user, password string) (*Postgres, error)

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateAuthor

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

func (*Queries) DeleteAuthor

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

func (*Queries) GetAuthor

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

func (*Queries) ListAuthors

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

func (*Queries) PartialUpdateAuthor

func (q *Queries) PartialUpdateAuthor(ctx context.Context, arg PartialUpdateAuthorParams) (Author, error)

func (*Queries) TruncateAuthor

func (q *Queries) TruncateAuthor(ctx context.Context) error

func (*Queries) UpdateAuthor

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

func (*Queries) WithTx

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

type UpdateAuthorParams

type UpdateAuthorParams struct {
	ID   int64
	Name string
	Bio  string
}