db

Documentation

Index

• type CreateEmailValidationParams
• type CreateUserParams
• type DBTX
• type EmailValidations
• type GetLoginAttemptRow
• type GetUsersRow
• type LoginAttempts
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateEmailValidation(ctx context.Context, arg CreateEmailValidationParams) error
  • func (q *Queries) CreateLoginAttempts(ctx context.Context, userID uuid.UUID) error
  • func (q *Queries) CreateTokens(ctx context.Context, userID uuid.UUID) error
  • func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (uuid.UUID, error)
  • func (q *Queries) DeleteEmailValidation(ctx context.Context, userID uuid.UUID) error
  • func (q *Queries) DeleteLoginAttempt(ctx context.Context, userID uuid.UUID) error
  • func (q *Queries) DeleteTokens(ctx context.Context, userID uuid.UUID) error
  • func (q *Queries) DeleteUser(ctx context.Context, id uuid.UUID) error
  • func (q *Queries) GetAllTokens(ctx context.Context) ([]Tokens, error)
  • func (q *Queries) GetEmailValidation(ctx context.Context, verificationCode string) (EmailValidations, error)
  • func (q *Queries) GetEmailValidations(ctx context.Context) ([]EmailValidations, error)
  • func (q *Queries) GetLoginAttempt(ctx context.Context, userID uuid.UUID) (GetLoginAttemptRow, error)
  • func (q *Queries) GetLoginAttempts(ctx context.Context) ([]LoginAttempts, error)
  • func (q *Queries) GetLoginFullAttempt(ctx context.Context, userID uuid.UUID) (LoginAttempts, error)
  • func (q *Queries) GetTokens(ctx context.Context, userID uuid.UUID) (Tokens, error)
  • func (q *Queries) GetUser(ctx context.Context, id uuid.UUID) (Users, error)
  • func (q *Queries) GetUserByEmail(ctx context.Context, email string) (Users, error)
  • func (q *Queries) GetUsers(ctx context.Context) ([]GetUsersRow, error)
  • func (q *Queries) IncrementLoginAttemptCounter(ctx context.Context, userID uuid.UUID) error
  • func (q *Queries) ResetLoginAttempts(ctx context.Context, userID uuid.UUID) error
  • func (q *Queries) UpdateTokens(ctx context.Context, arg UpdateTokensParams) error
  • func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) error
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type Tokens
• type UpdateTokensParams
• type UpdateUserParams
• type Users

Types

type CreateEmailValidationParams

type CreateEmailValidationParams struct {
	UserID           uuid.UUID `json:"user_id"`
	VerificationCode string    `json:"verification_code"`
	ExpirationTime   int32     `json:"expiration_time"`
}

type CreateUserParams

type CreateUserParams struct {
	Name       string   `json:"name"`
	Age        int32    `json:"age"`
	Email      string   `json:"email"`
	ValidEmail bool     `json:"valid_email"`
	Password   string   `json:"password"`
	Roles      []string `json:"roles"`
}

type DBTX

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type EmailValidations

type EmailValidations struct {
	UserID           uuid.UUID `json:"user_id"`
	VerificationCode string    `json:"verification_code"`
	ExpirationTime   int32     `json:"expiration_time"`
	CreatedAt        time.Time `json:"created_at"`
}

type GetLoginAttemptRow

type GetLoginAttemptRow struct {
	Attempts            int32     `json:"attempts"`
	LastFailedLoginDate time.Time `json:"last_failed_login_date"`
}

type GetUsersRow

type GetUsersRow struct {
	ID         uuid.UUID `json:"id"`
	Name       string    `json:"name"`
	Age        int32     `json:"age"`
	Email      string    `json:"email"`
	ValidEmail bool      `json:"valid_email"`
	Roles      []string  `json:"roles"`
	CreatedAt  time.Time `json:"created_at"`
	UpdatedAt  time.Time `json:"updated_at"`
}

type LoginAttempts

type LoginAttempts struct {
	UserID              uuid.UUID `json:"user_id"`
	Attempts            int32     `json:"attempts"`
	LastFailedLoginDate time.Time `json:"last_failed_login_date"`
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateEmailValidation

func (q *Queries) CreateEmailValidation(ctx context.Context, arg CreateEmailValidationParams) error

func (*Queries) CreateLoginAttempts

func (q *Queries) CreateLoginAttempts(ctx context.Context, userID uuid.UUID) error

func (*Queries) CreateTokens

func (q *Queries) CreateTokens(ctx context.Context, userID uuid.UUID) error

func (*Queries) CreateUser

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

func (*Queries) DeleteEmailValidation

func (q *Queries) DeleteEmailValidation(ctx context.Context, userID uuid.UUID) error

func (*Queries) DeleteLoginAttempt

func (q *Queries) DeleteLoginAttempt(ctx context.Context, userID uuid.UUID) error

func (*Queries) DeleteTokens

func (q *Queries) DeleteTokens(ctx context.Context, userID uuid.UUID) error

func (*Queries) DeleteUser

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

func (*Queries) GetAllTokens

func (q *Queries) GetAllTokens(ctx context.Context) ([]Tokens, error)

func (*Queries) GetEmailValidation

func (q *Queries) GetEmailValidation(ctx context.Context, verificationCode string) (EmailValidations, error)

func (*Queries) GetEmailValidations

func (q *Queries) GetEmailValidations(ctx context.Context) ([]EmailValidations, error)

func (*Queries) GetLoginAttempt

func (q *Queries) GetLoginAttempt(ctx context.Context, userID uuid.UUID) (GetLoginAttemptRow, error)

func (*Queries) GetLoginAttempts

func (q *Queries) GetLoginAttempts(ctx context.Context) ([]LoginAttempts, error)

func (*Queries) GetLoginFullAttempt

func (q *Queries) GetLoginFullAttempt(ctx context.Context, userID uuid.UUID) (LoginAttempts, error)

func (*Queries) GetTokens

func (q *Queries) GetTokens(ctx context.Context, userID uuid.UUID) (Tokens, error)

func (*Queries) GetUser

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

func (*Queries) GetUserByEmail

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

func (*Queries) GetUsers

func (q *Queries) GetUsers(ctx context.Context) ([]GetUsersRow, error)

func (*Queries) IncrementLoginAttemptCounter

func (q *Queries) IncrementLoginAttemptCounter(ctx context.Context, userID uuid.UUID) error

func (*Queries) ResetLoginAttempts

func (q *Queries) ResetLoginAttempts(ctx context.Context, userID uuid.UUID) error

func (*Queries) UpdateTokens

func (q *Queries) UpdateTokens(ctx context.Context, arg UpdateTokensParams) error

func (*Queries) UpdateUser

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

func (*Queries) WithTx

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

type Tokens

type Tokens struct {
	UserID       uuid.UUID `json:"user_id"`
	AccessToken  string    `json:"access_token"`
	RefreshToken string    `json:"refresh_token"`
	UpdatedAt    time.Time `json:"updated_at"`
}

type UpdateTokensParams

type UpdateTokensParams struct {
	UserID       uuid.UUID `json:"user_id"`
	AccessToken  string    `json:"access_token"`
	RefreshToken string    `json:"refresh_token"`
}

type UpdateUserParams

type UpdateUserParams struct {
	ID         uuid.UUID      `json:"id"`
	Name       sql.NullString `json:"name"`
	Age        sql.NullInt32  `json:"age"`
	Email      sql.NullString `json:"email"`
	ValidEmail sql.NullBool   `json:"valid_email"`
	Password   sql.NullString `json:"password"`
	Roles      []string       `json:"roles"`
}

type Users

type Users struct {
	ID         uuid.UUID `json:"id"`
	Name       string    `json:"name"`
	Age        int32     `json:"age"`
	Email      string    `json:"email"`
	ValidEmail bool      `json:"valid_email"`
	Password   string    `json:"password"`
	Roles      []string  `json:"roles"`
	CreatedAt  time.Time `json:"created_at"`
	UpdatedAt  time.Time `json:"updated_at"`
}