db

Documentation

Index

• type CreateTodoParams
• type DBTX
• type ListTodosParams
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateTodo(ctx context.Context, arg CreateTodoParams) (Todo, error)
  • func (q *Queries) DeleteTodo(ctx context.Context, id int64) (Todo, error)
  • func (q *Queries) GetTodo(ctx context.Context, id int64) (Todo, error)
  • func (q *Queries) ListTodos(ctx context.Context, arg ListTodosParams) ([]Todo, error)
  • func (q *Queries) UpdateTodo(ctx context.Context, arg UpdateTodoParams) (Todo, error)
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries
• type Todo
• type UpdateTodoParams

Types

type CreateTodoParams

type CreateTodoParams struct {
	Title       string `db:"title" json:"title"`
	IsCompleted bool   `db:"is_completed" json:"is_completed"`
}

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 ListTodosParams

type ListTodosParams struct {
	Limit  int32 `db:"limit" json:"limit"`
	Offset int32 `db:"offset" json:"offset"`
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateTodo

func (q *Queries) CreateTodo(ctx context.Context, arg CreateTodoParams) (Todo, error)

func (*Queries) DeleteTodo

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

func (*Queries) GetTodo

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

func (*Queries) ListTodos

func (q *Queries) ListTodos(ctx context.Context, arg ListTodosParams) ([]Todo, error)

func (*Queries) UpdateTodo

func (q *Queries) UpdateTodo(ctx context.Context, arg UpdateTodoParams) (Todo, error)

func (*Queries) WithTx

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

type Todo

type Todo struct {
	ID          int64  `db:"id" json:"id"`
	Title       string `db:"title" json:"title"`
	IsCompleted bool   `db:"is_completed" json:"is_completed"`
}

type UpdateTodoParams

type UpdateTodoParams struct {
	Title       string `db:"title" json:"title"`
	IsCompleted bool   `db:"is_completed" json:"is_completed"`
	ID          int64  `db:"id" json:"id"`
}