db

Documentation

Index

• func InitDB(ctx context.Context, postgresUrl string) (*pgx.Conn, error)
• type CreateUserParams
• type DBTX
• type ListUsersParams
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
  • func (q *Queries) DeleteUser(ctx context.Context, id int64) error
  • func (q *Queries) GetUser(ctx context.Context, id int64) (User, error)
  • func (q *Queries) ListUsers(ctx context.Context, arg ListUsersParams) ([]User, error)
  • func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) (User, error)
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries
• type UpdateUserParams
• type User

Functions

func InitDB

func InitDB(ctx context.Context, postgresUrl string) (*pgx.Conn, error)

Types

type CreateUserParams

type CreateUserParams struct {
	Name  string
	Other 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 ListUsersParams

type ListUsersParams struct {
	Limit  int32
	Offset int32
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateUser

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

func (*Queries) DeleteUser

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

func (*Queries) GetUser

func (q *Queries) GetUser(ctx context.Context, id int64) (User, error)

func (*Queries) ListUsers

func (q *Queries) ListUsers(ctx context.Context, arg ListUsersParams) ([]User, 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 UpdateUserParams

type UpdateUserParams struct {
	ID    int64
	Name  string
	Other pgtype.Text
}

type User

type User struct {
	ID        int64
	Name      string
	Other     pgtype.Text
	CreatedAt pgtype.Timestamp
	UpdatedAt pgtype.Timestamp
}