user_sql

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 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 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 struct {
}

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 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"`
}