gen

Documentation

Index

• type CreateItemParams
• type CreateUserParams
• type DBTX
• type Item
• type ListItemsByOwnerParams
• type ListUsersParams
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CleanupItems(ctx context.Context) error
  • func (q *Queries) CleanupUsers(ctx context.Context) error
  • func (q *Queries) CreateItem(ctx context.Context, arg CreateItemParams) (Item, error)
  • func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
  • func (q *Queries) DeleteItem(ctx context.Context, id uuid.UUID) error
  • func (q *Queries) DeleteUser(ctx context.Context, id uuid.UUID) error
  • func (q *Queries) GetItemByID(ctx context.Context, id uuid.UUID) (Item, error)
  • func (q *Queries) GetUserByEmail(ctx context.Context, email string) (User, error)
  • func (q *Queries) GetUserByID(ctx context.Context, id uuid.UUID) (User, error)
  • func (q *Queries) IsUserEmailExists(ctx context.Context, email string) (bool, error)
  • func (q *Queries) ListItemsByOwner(ctx context.Context, arg ListItemsByOwnerParams) ([]Item, error)
  • func (q *Queries) ListUsers(ctx context.Context, arg ListUsersParams) ([]User, error)
  • func (q *Queries) UpdateItem(ctx context.Context, arg UpdateItemParams) (Item, error)
  • func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) (User, error)
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries
• type UpdateItemParams
• type UpdateUserParams
• type User

Types

type CreateItemParams

type CreateItemParams struct {
	ID          uuid.UUID
	OwnerID     uuid.UUID
	Title       string
	Description pgtype.Text
}

type CreateUserParams

type CreateUserParams struct {
	ID             uuid.UUID
	Email          string
	HashedPassword string
	IsActive       bool
	IsSuperuser    bool
	FullName       pgtype.Text
}

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 Item

type Item struct {
	ID          uuid.UUID
	OwnerID     uuid.UUID
	Title       string
	Description pgtype.Text
	CreatedAt   pgtype.Timestamptz
	UpdatedAt   pgtype.Timestamptz
}

type ListItemsByOwnerParams

type ListItemsByOwnerParams struct {
	OwnerID uuid.UUID
	Limit   int64
	Offset  int64
}

type ListUsersParams

type ListUsersParams struct {
	Limit  int64
	Offset int64
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CleanupItems

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

func (*Queries) CleanupUsers

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

func (*Queries) CreateItem

func (q *Queries) CreateItem(ctx context.Context, arg CreateItemParams) (Item, error)

func (*Queries) CreateUser

func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)

func (*Queries) DeleteItem

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

func (*Queries) DeleteUser

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

func (*Queries) GetItemByID

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

func (*Queries) GetUserByEmail

func (q *Queries) GetUserByEmail(ctx context.Context, email string) (User, error)

func (*Queries) GetUserByID

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

func (*Queries) IsUserEmailExists

func (q *Queries) IsUserEmailExists(ctx context.Context, email string) (bool, error)

func (*Queries) ListItemsByOwner

func (q *Queries) ListItemsByOwner(ctx context.Context, arg ListItemsByOwnerParams) ([]Item, error)

func (*Queries) ListUsers

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

func (*Queries) UpdateItem

func (q *Queries) UpdateItem(ctx context.Context, arg UpdateItemParams) (Item, error)

func (*Queries) UpdateUser

func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) (User, error)

func (*Queries) WithTx

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

type UpdateItemParams

type UpdateItemParams struct {
	ID          uuid.UUID
	Title       string
	Description pgtype.Text
}

type UpdateUserParams

type UpdateUserParams struct {
	ID             uuid.UUID
	Email          pgtype.Text
	FullName       pgtype.Text
	IsActive       pgtype.Bool
	IsSuperuser    pgtype.Bool
	HashedPassword pgtype.Text
}

type User

type User struct {
	ID             uuid.UUID
	Email          string
	HashedPassword string
	IsActive       bool
	IsSuperuser    bool
	FullName       pgtype.Text
	CreatedAt      pgtype.Timestamptz
	UpdatedAt      pgtype.Timestamptz
}