db

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

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 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 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 struct {
	Attempts            int32     `json:"attempts"`
	LastFailedLoginDate time.Time `json:"last_failed_login_date"`
}

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 struct {
	UserID              uuid.UUID `json:"user_id"`
	Attempts            int32     `json:"attempts"`
	LastFailedLoginDate time.Time `json:"last_failed_login_date"`
}

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

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 struct {
	UserID       uuid.UUID `json:"user_id"`
	AccessToken  string    `json:"access_token"`
	RefreshToken string    `json:"refresh_token"`
}

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