sqlc

Documentation

Index

• type DBTX
• type ListTodoByUserIDRow
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) FindUserByID(ctx context.Context, id uuid.UUID) (User, error)
  • func (q *Queries) ListTodoByUserID(ctx context.Context, userID uuid.UUID) ([]ListTodoByUserIDRow, error)
  • func (q *Queries) ListTodos(ctx context.Context) ([]Todo, error)
  • func (q *Queries) ListUsers(ctx context.Context) ([]User, error)
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries
• type SchemaMigration
• type Todo
• type User

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 ListTodoByUserIDRow

type ListTodoByUserIDRow struct {
	ID        uuid.UUID
	CreatedAt pgtype.Timestamptz
	UpdatedAt pgtype.Timestamptz
	Title     string
	Completed bool
	UserID    uuid.UUID
	UserName  string
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) FindUserByID

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

func (*Queries) ListTodoByUserID

func (q *Queries) ListTodoByUserID(ctx context.Context, userID uuid.UUID) ([]ListTodoByUserIDRow, error)

func (*Queries) ListTodos

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

func (*Queries) ListUsers

func (q *Queries) ListUsers(ctx context.Context) ([]User, error)

func (*Queries) WithTx

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

type SchemaMigration

type SchemaMigration struct {
	Version string
}

type Todo

type Todo struct {
	ID        uuid.UUID
	CreatedAt pgtype.Timestamptz
	UpdatedAt pgtype.Timestamptz
	Title     string
	Completed bool
	UserID    uuid.UUID
}

type User

type User struct {
	ID        uuid.UUID
	Name      string
	CreatedAt pgtype.Timestamptz
	UpdatedAt pgtype.Timestamptz
}