model

type AuthOptions struct {
	// Cookie if true will read in CookieName for a session ID.
	Cookie     bool
	CookieName string

	// Header if true will read in HeaderName for a request auth token.
	// Authorization already produces the user ID based on JWT claims.
	Header     bool
	HeaderName string

	// Query if true will read QueryName for a JWT token from URL query params.
	Query     bool
	QueryName string

	// This is a JWT specific option.
	HeaderSigningKey string

	// Optional if true will not block the request on auth failure.
	Optional bool
}

type Migrations struct {
	// Project
	Project string `db:"project" json:"project"`

	// Filename
	Filename string `db:"filename" json:"filename"`

	// Statement Index
	StatementIndex int64 `db:"statement_index" json:"statement_index"`

	// Status
	Status string `db:"status" json:"status"`
}

type PasskeyStorage interface {
	Create(ctx context.Context, passkey *UserPasskey) (*UserPasskey, error)
	Delete(ctx context.Context, id string) error
	ListByUser(ctx context.Context, userID string) ([]UserPasskey, error)
	GetByCredentialID(ctx context.Context, credentialID []byte) (*UserPasskey, error)
	UpdateSignCount(ctx context.Context, id string, signCount int64) error
}

type QueryConfig struct {
	Table       string
	Columns     []string
	Where       string
	OrderBy     string
	LimitStart  int
	LimitOffset int
	Statement   string
}

type QueryOption interface {
	WithTable(name string) QueryOption
	WithColumns(cols []string) QueryOption
	WithWhere(clause string) QueryOption
	WithOrderBy(clause string) QueryOption
	WithLimit(start, offset int) QueryOption
	WithStatement(stmt string) QueryOption
}

type SessionStorage interface {
	Create(ctx context.Context, userID string) (*UserSession, error)
	Get(ctx context.Context, sessionID string) (*UserSession, error)
	Delete(ctx context.Context, sessionID string) error
}

type User struct {
	// ID
	ID string `db:"id" json:"id"`

	// Full Name
	FullName string `db:"full_name" json:"full_name"`

	// Username
	Username string `db:"username" json:"username"`

	// Slug
	Slug string `db:"slug" json:"slug"`

	// Deleted At
	DeletedAt *time.Time `db:"deleted_at" json:"deleted_at"`

	// Created At
	CreatedAt *time.Time `db:"created_at" json:"created_at"`

	// Updated At
	UpdatedAt *time.Time `db:"updated_at" json:"updated_at"`
}

type UserAuth struct {
	// User ID
	UserID string `db:"user_id" json:"user_id"`

	// Email
	Email string `db:"email" json:"email"`

	// Password
	Password string `db:"password" json:"password"`

	// Created At
	CreatedAt *time.Time `db:"created_at" json:"created_at"`

	// Updated At
	UpdatedAt *time.Time `db:"updated_at" json:"updated_at"`

	// Activated At
	ActivatedAt *time.Time `db:"activated_at" json:"activated_at"`

	// Activation Token
	ActivationToken string `db:"activation_token" json:"activation_token"`

	// Activation Sent At
	ActivationSentAt *time.Time `db:"activation_sent_at" json:"activation_sent_at"`
}

type UserCreateRequest struct {
	FullName string `json:"full_name"`
	Email    string `json:"email"`
	Password string `json:"password"`
	Username string `json:"username,omitempty"`
}

type UserGroup struct {
	// ID
	ID string `db:"id" json:"id"`

	// Title
	Title string `db:"title" json:"title"`

	// Created At
	CreatedAt *time.Time `db:"created_at" json:"created_at"`

	// Updated At
	UpdatedAt *time.Time `db:"updated_at" json:"updated_at"`
}

type UserGroupMember struct {
	// User Group ID
	UserGroupID string `db:"user_group_id" json:"user_group_id"`

	// User ID
	UserID string `db:"user_id" json:"user_id"`

	// Joined At
	JoinedAt *time.Time `db:"joined_at" json:"joined_at"`
}

type UserPasskey struct {
	// ID
	ID string `db:"id" json:"id"`

	// User ID
	UserID string `db:"user_id" json:"user_id"`

	// Credential ID
	CredentialID []byte `db:"credential_id" json:"credential_id"`

	// Public Key
	PublicKey []byte `db:"public_key" json:"public_key"`

	// Attestation Type
	AttestationType string `db:"attestation_type" json:"attestation_type"`

	// Transport
	Transport string `db:"transport" json:"transport"`

	// Sign Count
	SignCount int64 `db:"sign_count" json:"sign_count"`

	// Created At
	CreatedAt *time.Time `db:"created_at" json:"created_at"`
}

type UserSession struct {
	// ID
	ID string `db:"id" json:"id"`

	// User ID
	UserID string `db:"user_id" json:"user_id"`

	// Expires At
	ExpiresAt *time.Time `db:"expires_at" json:"expires_at"`

	// Created At
	CreatedAt *time.Time `db:"created_at" json:"created_at"`
}

type UserStorage interface {
	Create(context.Context, *UserCreateRequest) (*User, error)
	Update(context.Context, *User) (*User, error)

	Get(context.Context, string) (*User, error)
	GetByUsername(context.Context, string) (*User, error)
	GetByStub(context.Context, string) (*User, error)

	GetGroups(context.Context, string) ([]UserGroup, error)

	List(context.Context) ([]User, error)

	Authenticate(context.Context, UserAuth) (*User, error)
	Activate(ctx context.Context, token string) (*User, error)

	ResetActivation(ctx context.Context, email string) error
}

type UserTokenRevoked struct {
	// Jti
	Jti string `db:"jti" json:"jti"`

	// User ID
	UserID string `db:"user_id" json:"user_id"`

	// Expires At
	ExpiresAt *time.Time `db:"expires_at" json:"expires_at"`

	// Created At
	CreatedAt *time.Time `db:"created_at" json:"created_at"`
}

type WebAuthnUser struct {
	*User
	Passkeys []UserPasskey
}