database

Documentation

Index

• func Migrate(config pgx.ConnConfig) error
• func Transaction[T any](ctx context.Context, conn Connection, options pgx.TxOptions, ...) (T, error)
• type Connection
• type DBTX
• type InsertListParams
• type InsertTaskParams
• type List
• type Querier
• type Queries
  • func New() *Queries
  • func (q *Queries) DeleteList(ctx context.Context, db DBTX, id int64) error
  • func (q *Queries) DeleteTask(ctx context.Context, db DBTX, id int64) error
  • func (q *Queries) InsertList(ctx context.Context, db DBTX, arg InsertListParams) (List, error)
  • func (q *Queries) InsertTask(ctx context.Context, db DBTX, arg InsertTaskParams) (Task, error)
  • func (q *Queries) SelectList(ctx context.Context, db DBTX, id int64) (List, error)
  • func (q *Queries) SelectLists(ctx context.Context, db DBTX) ([]List, error)
  • func (q *Queries) SelectTasksForList(ctx context.Context, db DBTX, listID int64) ([]Task, error)
  • func (q *Queries) UpdateList(ctx context.Context, db DBTX, arg UpdateListParams) (List, error)
  • func (q *Queries) UpdateTaskSetCompletedAtNow(ctx context.Context, db DBTX, id int64) (Task, error)
• type Task
• type UpdateListParams

Functions

func Migrate

func Migrate(config pgx.ConnConfig) error

func Transaction

func Transaction[T any](ctx context.Context, conn Connection, options pgx.TxOptions, do func(context.Context, DBTX) (T, error)) (T, error)

Types

type Connection

type Connection interface {
	DBTX
	BeginTx(context.Context, pgx.TxOptions) (pgx.Tx, error)
}

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 InsertListParams

type InsertListParams struct {
	Name        string
	Description string
}

type InsertTaskParams

type InsertTaskParams struct {
	ListID      int64
	Description string
}

type List

type List struct {
	ID          int64
	Name        string
	Description string
}

type Querier

type Querier interface {
	DeleteList(ctx context.Context, db DBTX, id int64) error
	DeleteTask(ctx context.Context, db DBTX, id int64) error
	InsertList(ctx context.Context, db DBTX, arg InsertListParams) (List, error)
	InsertTask(ctx context.Context, db DBTX, arg InsertTaskParams) (Task, error)
	SelectList(ctx context.Context, db DBTX, id int64) (List, error)
	SelectLists(ctx context.Context, db DBTX) ([]List, error)
	SelectTasksForList(ctx context.Context, db DBTX, listID int64) ([]Task, error)
	UpdateList(ctx context.Context, db DBTX, arg UpdateListParams) (List, error)
	UpdateTaskSetCompletedAtNow(ctx context.Context, db DBTX, id int64) (Task, error)
}

type Queries

type Queries struct {
}

func New

func New() *Queries

func (*Queries) DeleteList

func (q *Queries) DeleteList(ctx context.Context, db DBTX, id int64) error

func (*Queries) DeleteTask

func (q *Queries) DeleteTask(ctx context.Context, db DBTX, id int64) error

func (*Queries) InsertList

func (q *Queries) InsertList(ctx context.Context, db DBTX, arg InsertListParams) (List, error)

func (*Queries) InsertTask

func (q *Queries) InsertTask(ctx context.Context, db DBTX, arg InsertTaskParams) (Task, error)

func (*Queries) SelectList

func (q *Queries) SelectList(ctx context.Context, db DBTX, id int64) (List, error)

func (*Queries) SelectLists

func (q *Queries) SelectLists(ctx context.Context, db DBTX) ([]List, error)

func (*Queries) SelectTasksForList

func (q *Queries) SelectTasksForList(ctx context.Context, db DBTX, listID int64) ([]Task, error)

func (*Queries) UpdateList

func (q *Queries) UpdateList(ctx context.Context, db DBTX, arg UpdateListParams) (List, error)

func (*Queries) UpdateTaskSetCompletedAtNow

func (q *Queries) UpdateTaskSetCompletedAtNow(ctx context.Context, db DBTX, id int64) (Task, error)

type Task

type Task struct {
	ID          int64
	ListID      int64
	Description string
	CreatedAt   pgtype.Timestamp
	CompletedAt pgtype.Timestamp
}

type UpdateListParams

type UpdateListParams struct {
	ID          int64
	Name        string
	Description string
}