user_sql

Documentation

Index

• Constants
• type DBTX
• type InsertParams
• type Querier
• type Queries
  • func New() *Queries
  • func (q *Queries) DeleteAll(ctx context.Context, db DBTX) error
  • func (q *Queries) DeleteOne(ctx context.Context, db DBTX, id uuid.UUID) error
  • func (q *Queries) GetByEmail(ctx context.Context, db DBTX, email string) (*Users, error)
  • func (q *Queries) GetByID(ctx context.Context, db DBTX, id uuid.UUID) (*Users, error)
  • func (q *Queries) Insert(ctx context.Context, db DBTX, arg *InsertParams) (*Users, error)
  • func (q *Queries) Update(ctx context.Context, db DBTX, arg *UpdateParams) (*Users, error)
• type UpdateParams
• type Users

Constants

const DeleteAll = `-- name: DeleteAll :exec
DELETE FROM users
`

const DeleteOne = `-- name: DeleteOne :exec
DELETE FROM users
WHERE id = $1
`

const GetByEmail = `` /* 152-byte string literal not displayed */

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

const Insert = `` /* 303-byte string literal not displayed */

const Update = `` /* 413-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 InsertParams

type InsertParams struct {
	ID           uuid.UUID `json:"id"`
	Role         string    `json:"role"`
	Name         string    `json:"name"`
	Surname      string    `json:"surname"`
	Email        string    `json:"email"`
	PhoneNumber  string    `json:"phone_number"`
	PasswordHash string    `json:"password_hash"`
	CreatedAt    time.Time `json:"created_at"`
	UpdatedAt    time.Time `json:"updated_at"`
}

type Querier

type Querier interface {
	DeleteAll(ctx context.Context, db DBTX) error
	DeleteOne(ctx context.Context, db DBTX, id uuid.UUID) error
	GetByEmail(ctx context.Context, db DBTX, email string) (*Users, error)
	GetByID(ctx context.Context, db DBTX, id uuid.UUID) (*Users, error)
	Insert(ctx context.Context, db DBTX, arg *InsertParams) (*Users, error)
	Update(ctx context.Context, db DBTX, arg *UpdateParams) (*Users, error)
}

type Queries

type Queries struct {
}

func New

func New() *Queries

func (*Queries) DeleteAll

func (q *Queries) DeleteAll(ctx context.Context, db DBTX) error

func (*Queries) DeleteOne

func (q *Queries) DeleteOne(ctx context.Context, db DBTX, id uuid.UUID) error

func (*Queries) GetByEmail

func (q *Queries) GetByEmail(ctx context.Context, db DBTX, email string) (*Users, error)

func (*Queries) GetByID

func (q *Queries) GetByID(ctx context.Context, db DBTX, id uuid.UUID) (*Users, error)

func (*Queries) Insert

func (q *Queries) Insert(ctx context.Context, db DBTX, arg *InsertParams) (*Users, error)

func (*Queries) Update

func (q *Queries) Update(ctx context.Context, db DBTX, arg *UpdateParams) (*Users, error)

type UpdateParams

type UpdateParams struct {
	Name         pgtype.Text        `json:"name"`
	Surname      pgtype.Text        `json:"surname"`
	Role         pgtype.Text        `json:"role"`
	Email        pgtype.Text        `json:"email"`
	PhoneNumber  pgtype.Text        `json:"phone_number"`
	PasswordHash pgtype.Text        `json:"password_hash"`
	UpdatedAt    pgtype.Timestamptz `json:"updated_at"`
	ID           uuid.UUID          `json:"id"`
}

type Users

type Users struct {
	ID           uuid.UUID `json:"id"`
	Role         string    `json:"role"`
	Name         string    `json:"name"`
	Surname      string    `json:"surname"`
	Email        string    `json:"email"`
	PhoneNumber  string    `json:"phone_number"`
	PasswordHash string    `json:"password_hash"`
	CreatedAt    time.Time `json:"created_at"`
	UpdatedAt    time.Time `json:"updated_at"`
}