db

Documentation

Index

• Constants
• type DBTX
• type InsertTaskParams
• type Priority
  • func (e *Priority) Scan(src interface{}) error
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) DeleteTask(ctx context.Context, id uuid.UUID) (uuid.UUID, error)
  • func (q *Queries) InsertTask(ctx context.Context, arg InsertTaskParams) (uuid.UUID, error)
  • func (q *Queries) SelectTask(ctx context.Context, id uuid.UUID) (Tasks, error)
  • func (q *Queries) UpdateTask(ctx context.Context, arg UpdateTaskParams) (uuid.UUID, error)
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries
• type Tasks
• type UpdateTaskParams

Constants

const DeleteTask = `-- name: DeleteTask :one
DELETE FROM
  tasks
WHERE
  id = $1
RETURNING id AS res
`

const InsertTask = `` /* 146-byte string literal not displayed */

const SelectTask = `` /* 142-byte string literal not displayed */

const UpdateTask = `` /* 175-byte string literal not displayed */

Types

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 InsertTaskParams

type InsertTaskParams struct {
	Description string
	Priority    Priority
	StartDate   sql.NullTime
	DueDate     sql.NullTime
}

type Priority

type Priority string

const (
	PriorityNone   Priority = "none"
	PriorityLow    Priority = "low"
	PriorityMedium Priority = "medium"
	PriorityHigh   Priority = "high"
)

func (*Priority) Scan

func (e *Priority) Scan(src interface{}) error

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) DeleteTask

func (q *Queries) DeleteTask(ctx context.Context, id uuid.UUID) (uuid.UUID, error)

func (*Queries) InsertTask

func (q *Queries) InsertTask(ctx context.Context, arg InsertTaskParams) (uuid.UUID, error)

func (*Queries) SelectTask

func (q *Queries) SelectTask(ctx context.Context, id uuid.UUID) (Tasks, error)

func (*Queries) UpdateTask

func (q *Queries) UpdateTask(ctx context.Context, arg UpdateTaskParams) (uuid.UUID, error)

func (*Queries) WithTx

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

type Tasks

type Tasks struct {
	ID          uuid.UUID
	Description string
	Priority    Priority
	StartDate   sql.NullTime
	DueDate     sql.NullTime
	Done        bool
}

type UpdateTaskParams

type UpdateTaskParams struct {
	Description string
	Priority    Priority
	StartDate   sql.NullTime
	DueDate     sql.NullTime
	Done        bool
	ID          uuid.UUID
}