sqlcgen

package
v0.0.0-...-b140ed9 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: May 11, 2026 License: MIT Imports: 7 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type ActivityLog

type ActivityLog struct {
	ID        uuid.UUID          `json:"id"`
	AppID     uuid.UUID          `json:"app_id"`
	UserID    uuid.UUID          `json:"user_id"`
	EventType string             `json:"event_type"`
	Timestamp time.Time          `json:"timestamp"`
	IpAddress string             `json:"ip_address"`
	UserAgent string             `json:"user_agent"`
	Details   []byte             `json:"details"`
	Severity  string             `json:"severity"`
	ExpiresAt pgtype.Timestamptz `json:"expires_at"`
	IsAnomaly bool               `json:"is_anomaly"`
}

type AdminAccount

type AdminAccount struct {
	ID                  uuid.UUID          `json:"id"`
	Username            string             `json:"username"`
	Email               *string            `json:"email"`
	PasswordHash        string             `json:"password_hash"`
	TwoFaEnabled        bool               `json:"two_fa_enabled"`
	TwoFaMethod         *string            `json:"two_fa_method"`
	TwoFaSecret         *string            `json:"two_fa_secret"`
	TwoFaRecoveryCodes  []byte             `json:"two_fa_recovery_codes"`
	MagicLinkEnabled    bool               `json:"magic_link_enabled"`
	BackupEmail         string             `json:"backup_email"`
	BackupEmailVerified bool               `json:"backup_email_verified"`
	CreatedAt           time.Time          `json:"created_at"`
	UpdatedAt           time.Time          `json:"updated_at"`
	LastLoginAt         pgtype.Timestamptz `json:"last_login_at"`
}

type AdminAddAppToSessionGroupParams

type AdminAddAppToSessionGroupParams struct {
	SessionGroupID uuid.UUID `json:"session_group_id"`
	AppID          uuid.UUID `json:"app_id"`
}

type AdminAddRolePermissionParams

type AdminAddRolePermissionParams struct {
	RoleID       uuid.UUID `json:"role_id"`
	PermissionID uuid.UUID `json:"permission_id"`
}

type AdminCountActivityLogsParams

type AdminCountActivityLogsParams struct {
	EventType *string            `json:"event_type"`
	Severity  *string            `json:"severity"`
	AppID     pgtype.UUID        `json:"app_id"`
	Search    *string            `json:"search"`
	StartDate pgtype.Timestamptz `json:"start_date"`
	EndDate   pgtype.Timestamptz `json:"end_date"`
}

type AdminCountUserExistsForImportParams

type AdminCountUserExistsForImportParams struct {
	Email string    `json:"email"`
	AppID uuid.UUID `json:"app_id"`
}

type AdminCountUsersWithFiltersParams

type AdminCountUsersWithFiltersParams struct {
	AppID  pgtype.UUID `json:"app_id"`
	Search *string     `json:"search"`
}

type AdminCreateApiKeyParams

type AdminCreateApiKeyParams struct {
	ID          uuid.UUID          `json:"id"`
	KeyType     string             `json:"key_type"`
	Name        string             `json:"name"`
	Description string             `json:"description"`
	KeyHash     string             `json:"key_hash"`
	KeyPrefix   string             `json:"key_prefix"`
	KeySuffix   string             `json:"key_suffix"`
	AppID       pgtype.UUID        `json:"app_id"`
	Scopes      string             `json:"scopes"`
	ExpiresAt   pgtype.Timestamptz `json:"expires_at"`
	IsRevoked   bool               `json:"is_revoked"`
	CreatedAt   time.Time          `json:"created_at"`
	UpdatedAt   time.Time          `json:"updated_at"`
}

type AdminCreateAppParams

type AdminCreateAppParams struct {
	ID                        uuid.UUID `json:"id"`
	TenantID                  uuid.UUID `json:"tenant_id"`
	Name                      string    `json:"name"`
	Description               *string   `json:"description"`
	TwoFaIssuerName           string    `json:"two_fa_issuer_name"`
	TwoFaEnabled              bool      `json:"two_fa_enabled"`
	TwoFaRequired             bool      `json:"two_fa_required"`
	Email2faEnabled           bool      `json:"email_2fa_enabled"`
	TwoFaMethods              string    `json:"two_fa_methods"`
	Passkey2faEnabled         bool      `json:"passkey_2fa_enabled"`
	PasskeyLoginEnabled       bool      `json:"passkey_login_enabled"`
	MagicLinkEnabled          bool      `json:"magic_link_enabled"`
	LoginNotificationsEnabled bool      `json:"login_notifications_enabled"`
	SuspiciousActivityAlerts  bool      `json:"suspicious_activity_alerts"`
	Sms2faEnabled             bool      `json:"sms_2fa_enabled"`
	TrustedDeviceEnabled      bool      `json:"trusted_device_enabled"`
	TrustedDeviceMaxDays      int32     `json:"trusted_device_max_days"`
	OidcEnabled               bool      `json:"oidc_enabled"`
	OidcRsaPrivateKey         string    `json:"oidc_rsa_private_key"`
	OidcIDTokenTtl            int32     `json:"oidc_id_token_ttl"`
	OidcIssuerUrl             string    `json:"oidc_issuer_url"`
	FrontendUrl               string    `json:"frontend_url"`
	LoginLogoUrl              string    `json:"login_logo_url"`
	LoginTheme                string    `json:"login_theme"`
	LoginPrimaryColor         string    `json:"login_primary_color"`
	LoginSecondaryColor       string    `json:"login_secondary_color"`
	LoginDisplayName          string    `json:"login_display_name"`
	PwMinLength               int32     `json:"pw_min_length"`
	PwMaxLength               int32     `json:"pw_max_length"`
	PwRequireUpper            bool      `json:"pw_require_upper"`
	PwRequireLower            bool      `json:"pw_require_lower"`
	PwRequireDigit            bool      `json:"pw_require_digit"`
	PwRequireSymbol           bool      `json:"pw_require_symbol"`
	PwHistoryCount            int32     `json:"pw_history_count"`
	PwMaxAgeDays              int32     `json:"pw_max_age_days"`
	AccessTokenTtlMinutes     int32     `json:"access_token_ttl_minutes"`
	RefreshTokenTtlHours      int32     `json:"refresh_token_ttl_hours"`
	ResetPasswordPath         string    `json:"reset_password_path"`
	MagicLinkPath             string    `json:"magic_link_path"`
	VerifyEmailPath           string    `json:"verify_email_path"`
	CreatedAt                 time.Time `json:"created_at"`
	UpdatedAt                 time.Time `json:"updated_at"`
}

type AdminCreateImportUserParams

type AdminCreateImportUserParams struct {
	ID        uuid.UUID `json:"id"`
	AppID     uuid.UUID `json:"app_id"`
	Email     string    `json:"email"`
	Name      string    `json:"name"`
	FirstName string    `json:"first_name"`
	LastName  string    `json:"last_name"`
	Locale    string    `json:"locale"`
}

type AdminCreateOAuthConfigParams

type AdminCreateOAuthConfigParams struct {
	ID           uuid.UUID `json:"id"`
	AppID        uuid.UUID `json:"app_id"`
	Provider     string    `json:"provider"`
	ClientID     string    `json:"client_id"`
	ClientSecret string    `json:"client_secret"`
	RedirectUrl  string    `json:"redirect_url"`
	IsEnabled    bool      `json:"is_enabled"`
	CreatedAt    time.Time `json:"created_at"`
	UpdatedAt    time.Time `json:"updated_at"`
}

type AdminCreateRoleParams

type AdminCreateRoleParams struct {
	ID          uuid.UUID `json:"id"`
	AppID       uuid.UUID `json:"app_id"`
	Name        string    `json:"name"`
	Description *string   `json:"description"`
	IsSystem    bool      `json:"is_system"`
}

type AdminCreateSessionGroupParams

type AdminCreateSessionGroupParams struct {
	ID           uuid.UUID `json:"id"`
	TenantID     uuid.UUID `json:"tenant_id"`
	Name         string    `json:"name"`
	Description  string    `json:"description"`
	GlobalLogout bool      `json:"global_logout"`
	CreatedAt    time.Time `json:"created_at"`
	UpdatedAt    time.Time `json:"updated_at"`
}

type AdminCreateTenantParams

type AdminCreateTenantParams struct {
	ID        uuid.UUID `json:"id"`
	Name      string    `json:"name"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type AdminExportActivityLogsParams

type AdminExportActivityLogsParams struct {
	Limit     int32              `json:"limit"`
	EventType *string            `json:"event_type"`
	Severity  *string            `json:"severity"`
	AppID     pgtype.UUID        `json:"app_id"`
	Search    *string            `json:"search"`
	StartDate pgtype.Timestamptz `json:"start_date"`
	EndDate   pgtype.Timestamptz `json:"end_date"`
}

type AdminExportActivityLogsRow

type AdminExportActivityLogsRow struct {
	ID        uuid.UUID `json:"id"`
	AppID     uuid.UUID `json:"app_id"`
	AppName   string    `json:"app_name"`
	UserID    uuid.UUID `json:"user_id"`
	UserEmail string    `json:"user_email"`
	EventType string    `json:"event_type"`
	Severity  string    `json:"severity"`
	IpAddress string    `json:"ip_address"`
	UserAgent string    `json:"user_agent"`
	IsAnomaly bool      `json:"is_anomaly"`
	Timestamp time.Time `json:"timestamp"`
}

type AdminExportUsersParams

type AdminExportUsersParams struct {
	Limit  int32       `json:"limit"`
	AppID  pgtype.UUID `json:"app_id"`
	Search *string     `json:"search"`
}

type AdminExportUsersRow

type AdminExportUsersRow struct {
	ID              uuid.UUID `json:"id"`
	AppID           uuid.UUID `json:"app_id"`
	Email           string    `json:"email"`
	Name            string    `json:"name"`
	FirstName       string    `json:"first_name"`
	LastName        string    `json:"last_name"`
	Locale          string    `json:"locale"`
	EmailVerified   bool      `json:"email_verified"`
	IsActive        bool      `json:"is_active"`
	TwoFaEnabled    bool      `json:"two_fa_enabled"`
	TwoFaMethod     string    `json:"two_fa_method"`
	SocialProviders []byte    `json:"social_providers"`
	CreatedAt       time.Time `json:"created_at"`
	UpdatedAt       time.Time `json:"updated_at"`
}

type AdminGetActivityLogDetailRow

type AdminGetActivityLogDetailRow struct {
	ID        uuid.UUID          `json:"id"`
	AppID     uuid.UUID          `json:"app_id"`
	AppName   string             `json:"app_name"`
	UserID    uuid.UUID          `json:"user_id"`
	UserEmail string             `json:"user_email"`
	EventType string             `json:"event_type"`
	Severity  string             `json:"severity"`
	IpAddress string             `json:"ip_address"`
	UserAgent string             `json:"user_agent"`
	Details   interface{}        `json:"details"`
	IsAnomaly bool               `json:"is_anomaly"`
	ExpiresAt pgtype.Timestamptz `json:"expires_at"`
	Timestamp time.Time          `json:"timestamp"`
}

type AdminGetApiKeyUsageSummaryParams

type AdminGetApiKeyUsageSummaryParams struct {
	ApiKeyID   uuid.UUID   `json:"api_key_id"`
	PeriodDate pgtype.Date `json:"period_date"`
}

type AdminGetApiKeyUsageSummaryRow

type AdminGetApiKeyUsageSummaryRow struct {
	PeriodDate   pgtype.Date `json:"period_date"`
	RequestCount int64       `json:"request_count"`
}

type AdminGetAppNamesByIDsRow

type AdminGetAppNamesByIDsRow struct {
	ID   uuid.UUID `json:"id"`
	Name string    `json:"name"`
}

type AdminGetAppsInSessionGroupWithDetailsRow

type AdminGetAppsInSessionGroupWithDetailsRow struct {
	AppID      uuid.UUID `json:"app_id"`
	AppName    string    `json:"app_name"`
	TenantName *string   `json:"tenant_name"`
}

type AdminGetOAuthConfigByAppAndProviderParams

type AdminGetOAuthConfigByAppAndProviderParams struct {
	AppID    uuid.UUID `json:"app_id"`
	Provider string    `json:"provider"`
}

type AdminGetPeersForAppRow

type AdminGetPeersForAppRow struct {
	SgaAppID    string `json:"sga_app_id"`
	FrontendUrl string `json:"frontend_url"`
}

type AdminGetRoleByAppAndNameParams

type AdminGetRoleByAppAndNameParams struct {
	AppID uuid.UUID `json:"app_id"`
	Name  string    `json:"name"`
}

type AdminGetUserActiveAndAppIDRow

type AdminGetUserActiveAndAppIDRow struct {
	ID       uuid.UUID `json:"id"`
	IsActive bool      `json:"is_active"`
	AppID    uuid.UUID `json:"app_id"`
}

type AdminGetUserDetailByIDRow

type AdminGetUserDetailByIDRow struct {
	ID                  uuid.UUID          `json:"id"`
	Email               string             `json:"email"`
	Name                string             `json:"name"`
	FirstName           string             `json:"first_name"`
	LastName            string             `json:"last_name"`
	ProfilePicture      string             `json:"profile_picture"`
	Locale              string             `json:"locale"`
	AppID               uuid.UUID          `json:"app_id"`
	AppName             *string            `json:"app_name"`
	TenantName          string             `json:"tenant_name"`
	IsActive            bool               `json:"is_active"`
	EmailVerified       bool               `json:"email_verified"`
	TwoFaEnabled        bool               `json:"two_fa_enabled"`
	HasPassword         bool               `json:"has_password"`
	BackupEmail         string             `json:"backup_email"`
	BackupEmailVerified bool               `json:"backup_email_verified"`
	PhoneNumber         string             `json:"phone_number"`
	PhoneVerified       bool               `json:"phone_verified"`
	LockedAt            pgtype.Timestamptz `json:"locked_at"`
	LockReason          string             `json:"lock_reason"`
	LockExpiresAt       pgtype.Timestamptz `json:"lock_expires_at"`
	CreatedAt           time.Time          `json:"created_at"`
	UpdatedAt           time.Time          `json:"updated_at"`
}

type AdminGetUserEmailAndAppIDRow

type AdminGetUserEmailAndAppIDRow struct {
	ID    uuid.UUID `json:"id"`
	Email string    `json:"email"`
	AppID uuid.UUID `json:"app_id"`
}

type AdminGetUserEmailsByIDsRow

type AdminGetUserEmailsByIDsRow struct {
	ID    uuid.UUID `json:"id"`
	Email string    `json:"email"`
}

type AdminGetUserIDByEmailAndAppParams

type AdminGetUserIDByEmailAndAppParams struct {
	AppID uuid.UUID `json:"app_id"`
	Email string    `json:"email"`
}

type AdminGetUsersByEmailsAndAppParams

type AdminGetUsersByEmailsAndAppParams struct {
	Column1 []string  `json:"column_1"`
	AppID   uuid.UUID `json:"app_id"`
}

type AdminGetUsersByEmailsAndAppRow

type AdminGetUsersByEmailsAndAppRow struct {
	ID    uuid.UUID `json:"id"`
	Email string    `json:"email"`
}

type AdminIncrementDailyUsageParams

type AdminIncrementDailyUsageParams struct {
	ApiKeyID   uuid.UUID   `json:"api_key_id"`
	PeriodDate pgtype.Date `json:"period_date"`
}

type AdminListActivityLogsParams

type AdminListActivityLogsParams struct {
	Limit     int32              `json:"limit"`
	Offset    int32              `json:"offset"`
	EventType *string            `json:"event_type"`
	Severity  *string            `json:"severity"`
	AppID     pgtype.UUID        `json:"app_id"`
	Search    *string            `json:"search"`
	StartDate pgtype.Timestamptz `json:"start_date"`
	EndDate   pgtype.Timestamptz `json:"end_date"`
}

type AdminListActivityLogsRow

type AdminListActivityLogsRow struct {
	ID        uuid.UUID `json:"id"`
	AppID     uuid.UUID `json:"app_id"`
	AppName   string    `json:"app_name"`
	UserID    uuid.UUID `json:"user_id"`
	UserEmail string    `json:"user_email"`
	EventType string    `json:"event_type"`
	Severity  string    `json:"severity"`
	IpAddress string    `json:"ip_address"`
	IsAnomaly bool      `json:"is_anomaly"`
	Timestamp time.Time `json:"timestamp"`
}

type AdminListAllAppsWithTenantNameRow

type AdminListAllAppsWithTenantNameRow struct {
	ID         uuid.UUID `json:"id"`
	Name       string    `json:"name"`
	TenantName *string   `json:"tenant_name"`
}

type AdminListAllTenantsRow

type AdminListAllTenantsRow struct {
	ID   uuid.UUID `json:"id"`
	Name string    `json:"name"`
}

type AdminListApiKeysParams

type AdminListApiKeysParams struct {
	Limit   int32   `json:"limit"`
	Offset  int32   `json:"offset"`
	KeyType *string `json:"key_type"`
}

type AdminListApiKeysRow

type AdminListApiKeysRow struct {
	ID         uuid.UUID          `json:"id"`
	KeyType    string             `json:"key_type"`
	Name       string             `json:"name"`
	KeyPrefix  string             `json:"key_prefix"`
	KeySuffix  string             `json:"key_suffix"`
	Scopes     string             `json:"scopes"`
	AppID      pgtype.UUID        `json:"app_id"`
	ExpiresAt  pgtype.Timestamptz `json:"expires_at"`
	LastUsedAt pgtype.Timestamptz `json:"last_used_at"`
	IsRevoked  bool               `json:"is_revoked"`
	CreatedAt  time.Time          `json:"created_at"`
	AppName    string             `json:"app_name"`
	TenantName string             `json:"tenant_name"`
}

type AdminListAppsWithDetailsParams

type AdminListAppsWithDetailsParams struct {
	Limit    int32       `json:"limit"`
	Offset   int32       `json:"offset"`
	TenantID pgtype.UUID `json:"tenant_id"`
}

type AdminListAppsWithDetailsRow

type AdminListAppsWithDetailsRow struct {
	ID                  uuid.UUID `json:"id"`
	TenantID            uuid.UUID `json:"tenant_id"`
	Name                string    `json:"name"`
	Description         *string   `json:"description"`
	CreatedAt           time.Time `json:"created_at"`
	UpdatedAt           time.Time `json:"updated_at"`
	TwoFaEnabled        bool      `json:"two_fa_enabled"`
	TwoFaRequired       bool      `json:"two_fa_required"`
	Passkey2faEnabled   bool      `json:"passkey_2fa_enabled"`
	PasskeyLoginEnabled bool      `json:"passkey_login_enabled"`
	MagicLinkEnabled    bool      `json:"magic_link_enabled"`
	TenantName          *string   `json:"tenant_name"`
	OauthConfigCount    int64     `json:"oauth_config_count"`
}

type AdminListOAuthConfigsWithDetailsParams

type AdminListOAuthConfigsWithDetailsParams struct {
	Limit  int32       `json:"limit"`
	Offset int32       `json:"offset"`
	AppID  pgtype.UUID `json:"app_id"`
}

type AdminListOAuthConfigsWithDetailsRow

type AdminListOAuthConfigsWithDetailsRow struct {
	ID          uuid.UUID `json:"id"`
	AppID       uuid.UUID `json:"app_id"`
	Provider    string    `json:"provider"`
	ClientID    string    `json:"client_id"`
	RedirectUrl string    `json:"redirect_url"`
	IsEnabled   bool      `json:"is_enabled"`
	CreatedAt   time.Time `json:"created_at"`
	UpdatedAt   time.Time `json:"updated_at"`
	AppName     *string   `json:"app_name"`
	TenantName  *string   `json:"tenant_name"`
}

type AdminListSessionGroupsParams

type AdminListSessionGroupsParams struct {
	Limit  int32 `json:"limit"`
	Offset int32 `json:"offset"`
}

type AdminListSessionGroupsRow

type AdminListSessionGroupsRow struct {
	ID           uuid.UUID `json:"id"`
	TenantID     uuid.UUID `json:"tenant_id"`
	TenantName   *string   `json:"tenant_name"`
	Name         string    `json:"name"`
	Description  string    `json:"description"`
	GlobalLogout bool      `json:"global_logout"`
	CreatedAt    time.Time `json:"created_at"`
	AppCount     int64     `json:"app_count"`
}

type AdminListTenantsParams

type AdminListTenantsParams struct {
	Limit  int32 `json:"limit"`
	Offset int32 `json:"offset"`
}

type AdminListTenantsWithAppCountParams

type AdminListTenantsWithAppCountParams struct {
	Limit  int32 `json:"limit"`
	Offset int32 `json:"offset"`
}

type AdminListTenantsWithAppCountRow

type AdminListTenantsWithAppCountRow struct {
	ID        uuid.UUID `json:"id"`
	Name      string    `json:"name"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
	AppCount  int64     `json:"app_count"`
}

type AdminListUsersWithDetailsParams

type AdminListUsersWithDetailsParams struct {
	Limit  int32       `json:"limit"`
	Offset int32       `json:"offset"`
	AppID  pgtype.UUID `json:"app_id"`
	Search *string     `json:"search"`
}

type AdminListUsersWithDetailsRow

type AdminListUsersWithDetailsRow struct {
	ID                 uuid.UUID          `json:"id"`
	Email              string             `json:"email"`
	Name               string             `json:"name"`
	AppID              uuid.UUID          `json:"app_id"`
	AppName            *string            `json:"app_name"`
	TenantName         string             `json:"tenant_name"`
	IsActive           bool               `json:"is_active"`
	EmailVerified      bool               `json:"email_verified"`
	TwoFaEnabled       bool               `json:"two_fa_enabled"`
	HasPassword        bool               `json:"has_password"`
	SocialAccountCount int64              `json:"social_account_count"`
	LockedAt           pgtype.Timestamptz `json:"locked_at"`
	LockExpiresAt      pgtype.Timestamptz `json:"lock_expires_at"`
	CreatedAt          time.Time          `json:"created_at"`
}

type AdminRemoveAppFromSessionGroupParams

type AdminRemoveAppFromSessionGroupParams struct {
	SessionGroupID uuid.UUID `json:"session_group_id"`
	AppID          uuid.UUID `json:"app_id"`
}

type AdminSetUserActiveParams

type AdminSetUserActiveParams struct {
	ID       uuid.UUID `json:"id"`
	IsActive bool      `json:"is_active"`
}

type AdminUpdateApiKeyScopesParams

type AdminUpdateApiKeyScopesParams struct {
	ID          uuid.UUID `json:"id"`
	Name        string    `json:"name"`
	Description string    `json:"description"`
	Scopes      string    `json:"scopes"`
}

type AdminUpdateAppCaptchaSecretKeyParams

type AdminUpdateAppCaptchaSecretKeyParams struct {
	ID                 uuid.UUID `json:"id"`
	BfCaptchaSecretKey *string   `json:"bf_captcha_secret_key"`
}

type AdminUpdateAppParams

type AdminUpdateAppParams struct {
	ID                    uuid.UUID `json:"id"`
	Name                  string    `json:"name"`
	Description           *string   `json:"description"`
	FrontendUrl           string    `json:"frontend_url"`
	TwoFaIssuerName       string    `json:"two_fa_issuer_name"`
	TwoFaEnabled          bool      `json:"two_fa_enabled"`
	TwoFaRequired         bool      `json:"two_fa_required"`
	Passkey2faEnabled     bool      `json:"passkey_2fa_enabled"`
	PasskeyLoginEnabled   bool      `json:"passkey_login_enabled"`
	MagicLinkEnabled      bool      `json:"magic_link_enabled"`
	OidcEnabled           bool      `json:"oidc_enabled"`
	BfLockoutEnabled      *bool     `json:"bf_lockout_enabled"`
	BfLockoutThreshold    *int32    `json:"bf_lockout_threshold"`
	BfLockoutDurations    *string   `json:"bf_lockout_durations"`
	BfLockoutWindow       *string   `json:"bf_lockout_window"`
	BfLockoutTierTtl      *string   `json:"bf_lockout_tier_ttl"`
	BfDelayEnabled        *bool     `json:"bf_delay_enabled"`
	BfDelayStartAfter     *int32    `json:"bf_delay_start_after"`
	BfDelayMaxSeconds     *int32    `json:"bf_delay_max_seconds"`
	BfDelayTierTtl        *string   `json:"bf_delay_tier_ttl"`
	BfCaptchaEnabled      *bool     `json:"bf_captcha_enabled"`
	BfCaptchaSiteKey      *string   `json:"bf_captcha_site_key"`
	BfCaptchaThreshold    *int32    `json:"bf_captcha_threshold"`
	LoginLogoUrl          string    `json:"login_logo_url"`
	LoginPrimaryColor     string    `json:"login_primary_color"`
	LoginSecondaryColor   string    `json:"login_secondary_color"`
	LoginDisplayName      string    `json:"login_display_name"`
	PwMinLength           int32     `json:"pw_min_length"`
	PwMaxLength           int32     `json:"pw_max_length"`
	PwRequireUpper        bool      `json:"pw_require_upper"`
	PwRequireLower        bool      `json:"pw_require_lower"`
	PwRequireDigit        bool      `json:"pw_require_digit"`
	PwRequireSymbol       bool      `json:"pw_require_symbol"`
	PwHistoryCount        int32     `json:"pw_history_count"`
	PwMaxAgeDays          int32     `json:"pw_max_age_days"`
	AccessTokenTtlMinutes int32     `json:"access_token_ttl_minutes"`
	RefreshTokenTtlHours  int32     `json:"refresh_token_ttl_hours"`
	ResetPasswordPath     string    `json:"reset_password_path"`
	MagicLinkPath         string    `json:"magic_link_path"`
	VerifyEmailPath       string    `json:"verify_email_path"`
}

type AdminUpdateAppSMSTrustedDeviceParams

type AdminUpdateAppSMSTrustedDeviceParams struct {
	ID                   uuid.UUID `json:"id"`
	Sms2faEnabled        bool      `json:"sms_2fa_enabled"`
	TrustedDeviceEnabled bool      `json:"trusted_device_enabled"`
	TrustedDeviceMaxDays int32     `json:"trusted_device_max_days"`
}

type AdminUpdateOAuthConfigByIDParams

type AdminUpdateOAuthConfigByIDParams struct {
	ID          uuid.UUID `json:"id"`
	ClientID    string    `json:"client_id"`
	RedirectUrl string    `json:"redirect_url"`
	IsEnabled   bool      `json:"is_enabled"`
}

type AdminUpdateOAuthConfigByIDWithSecretParams

type AdminUpdateOAuthConfigByIDWithSecretParams struct {
	ID           uuid.UUID `json:"id"`
	ClientID     string    `json:"client_id"`
	ClientSecret string    `json:"client_secret"`
	RedirectUrl  string    `json:"redirect_url"`
	IsEnabled    bool      `json:"is_enabled"`
}

type AdminUpdateOAuthConfigParams

type AdminUpdateOAuthConfigParams struct {
	ID           uuid.UUID `json:"id"`
	ClientID     string    `json:"client_id"`
	ClientSecret string    `json:"client_secret"`
	RedirectUrl  string    `json:"redirect_url"`
	IsEnabled    bool      `json:"is_enabled"`
}

type AdminUpdateSessionGroupParams

type AdminUpdateSessionGroupParams struct {
	ID           uuid.UUID `json:"id"`
	Name         string    `json:"name"`
	Description  string    `json:"description"`
	GlobalLogout bool      `json:"global_logout"`
}

type AdminUpdateTenantParams

type AdminUpdateTenantParams struct {
	ID   uuid.UUID `json:"id"`
	Name string    `json:"name"`
}

type ApiKey

type ApiKey struct {
	ID              uuid.UUID          `json:"id"`
	KeyType         string             `json:"key_type"`
	Name            string             `json:"name"`
	Description     string             `json:"description"`
	KeyHash         string             `json:"key_hash"`
	KeyPrefix       string             `json:"key_prefix"`
	KeySuffix       string             `json:"key_suffix"`
	AppID           pgtype.UUID        `json:"app_id"`
	Scopes          string             `json:"scopes"`
	ExpiresAt       pgtype.Timestamptz `json:"expires_at"`
	LastUsedAt      pgtype.Timestamptz `json:"last_used_at"`
	Notified7DaysAt pgtype.Timestamptz `json:"notified_7_days_at"`
	Notified1DayAt  pgtype.Timestamptz `json:"notified_1_day_at"`
	IsRevoked       bool               `json:"is_revoked"`
	CreatedAt       time.Time          `json:"created_at"`
	UpdatedAt       time.Time          `json:"updated_at"`
}

type ApiKeyUsage

type ApiKeyUsage struct {
	ID           int64       `json:"id"`
	ApiKeyID     uuid.UUID   `json:"api_key_id"`
	PeriodDate   pgtype.Date `json:"period_date"`
	RequestCount int64       `json:"request_count"`
	UpdatedAt    time.Time   `json:"updated_at"`
}

type Application

type Application struct {
	ID                        uuid.UUID `json:"id"`
	TenantID                  uuid.UUID `json:"tenant_id"`
	Name                      string    `json:"name"`
	Description               *string   `json:"description"`
	TwoFaIssuerName           string    `json:"two_fa_issuer_name"`
	TwoFaEnabled              bool      `json:"two_fa_enabled"`
	TwoFaRequired             bool      `json:"two_fa_required"`
	Email2faEnabled           bool      `json:"email_2fa_enabled"`
	TwoFaMethods              string    `json:"two_fa_methods"`
	Passkey2faEnabled         bool      `json:"passkey_2fa_enabled"`
	PasskeyLoginEnabled       bool      `json:"passkey_login_enabled"`
	MagicLinkEnabled          bool      `json:"magic_link_enabled"`
	LoginNotificationsEnabled bool      `json:"login_notifications_enabled"`
	SuspiciousActivityAlerts  bool      `json:"suspicious_activity_alerts"`
	Sms2faEnabled             bool      `json:"sms_2fa_enabled"`
	TrustedDeviceEnabled      bool      `json:"trusted_device_enabled"`
	TrustedDeviceMaxDays      int32     `json:"trusted_device_max_days"`
	BfLockoutEnabled          *bool     `json:"bf_lockout_enabled"`
	BfLockoutThreshold        *int32    `json:"bf_lockout_threshold"`
	BfLockoutDurations        *string   `json:"bf_lockout_durations"`
	BfLockoutWindow           *string   `json:"bf_lockout_window"`
	BfLockoutTierTtl          *string   `json:"bf_lockout_tier_ttl"`
	BfDelayEnabled            *bool     `json:"bf_delay_enabled"`
	BfDelayStartAfter         *int32    `json:"bf_delay_start_after"`
	BfDelayMaxSeconds         *int32    `json:"bf_delay_max_seconds"`
	BfDelayTierTtl            *string   `json:"bf_delay_tier_ttl"`
	BfCaptchaEnabled          *bool     `json:"bf_captcha_enabled"`
	BfCaptchaSiteKey          *string   `json:"bf_captcha_site_key"`
	BfCaptchaSecretKey        *string   `json:"bf_captcha_secret_key"`
	BfCaptchaThreshold        *int32    `json:"bf_captcha_threshold"`
	OidcEnabled               bool      `json:"oidc_enabled"`
	OidcRsaPrivateKey         string    `json:"oidc_rsa_private_key"`
	OidcIDTokenTtl            int32     `json:"oidc_id_token_ttl"`
	OidcIssuerUrl             string    `json:"oidc_issuer_url"`
	FrontendUrl               string    `json:"frontend_url"`
	LoginLogoUrl              string    `json:"login_logo_url"`
	LoginTheme                string    `json:"login_theme"`
	LoginPrimaryColor         string    `json:"login_primary_color"`
	LoginSecondaryColor       string    `json:"login_secondary_color"`
	LoginDisplayName          string    `json:"login_display_name"`
	PwMinLength               int32     `json:"pw_min_length"`
	PwMaxLength               int32     `json:"pw_max_length"`
	PwRequireUpper            bool      `json:"pw_require_upper"`
	PwRequireLower            bool      `json:"pw_require_lower"`
	PwRequireDigit            bool      `json:"pw_require_digit"`
	PwRequireSymbol           bool      `json:"pw_require_symbol"`
	PwHistoryCount            int32     `json:"pw_history_count"`
	PwMaxAgeDays              int32     `json:"pw_max_age_days"`
	AccessTokenTtlMinutes     int32     `json:"access_token_ttl_minutes"`
	RefreshTokenTtlHours      int32     `json:"refresh_token_ttl_hours"`
	ResetPasswordPath         string    `json:"reset_password_path"`
	MagicLinkPath             string    `json:"magic_link_path"`
	VerifyEmailPath           string    `json:"verify_email_path"`
	CreatedAt                 time.Time `json:"created_at"`
	UpdatedAt                 time.Time `json:"updated_at"`
}

type CountAllActivityLogsParams

type CountAllActivityLogsParams struct {
	EventType *string            `json:"event_type"`
	StartDate pgtype.Timestamptz `json:"start_date"`
	EndDate   pgtype.Timestamptz `json:"end_date"`
}

type CountTrustedDevicesByUserAndAppParams

type CountTrustedDevicesByUserAndAppParams struct {
	UserID uuid.UUID `json:"user_id"`
	AppID  uuid.UUID `json:"app_id"`
}

type CountUserActivityLogsParams

type CountUserActivityLogsParams struct {
	UserID    uuid.UUID          `json:"user_id"`
	EventType *string            `json:"event_type"`
	StartDate pgtype.Timestamptz `json:"start_date"`
	EndDate   pgtype.Timestamptz `json:"end_date"`
}

type CountWebAuthnCredentialsByUserAndAppParams

type CountWebAuthnCredentialsByUserAndAppParams struct {
	UserID pgtype.UUID `json:"user_id"`
	AppID  pgtype.UUID `json:"app_id"`
}

type CreateActivityLogParams

type CreateActivityLogParams struct {
	AppID     uuid.UUID          `json:"app_id"`
	UserID    uuid.UUID          `json:"user_id"`
	EventType string             `json:"event_type"`
	Timestamp time.Time          `json:"timestamp"`
	IpAddress string             `json:"ip_address"`
	UserAgent string             `json:"user_agent"`
	Details   []byte             `json:"details"`
	Severity  string             `json:"severity"`
	ExpiresAt pgtype.Timestamptz `json:"expires_at"`
	IsAnomaly bool               `json:"is_anomaly"`
}

type CreateAdminAccountParams

type CreateAdminAccountParams struct {
	Username     string  `json:"username"`
	Email        *string `json:"email"`
	PasswordHash string  `json:"password_hash"`
}

type CreateEmailTypeParams

type CreateEmailTypeParams struct {
	ID             uuid.UUID `json:"id"`
	Code           string    `json:"code"`
	Name           string    `json:"name"`
	Description    *string   `json:"description"`
	DefaultSubject *string   `json:"default_subject"`
	Variables      []byte    `json:"variables"`
	IsSystem       bool      `json:"is_system"`
	IsActive       bool      `json:"is_active"`
	CreatedAt      time.Time `json:"created_at"`
	UpdatedAt      time.Time `json:"updated_at"`
}

type CreateOIDCAuthCodeParams

type CreateOIDCAuthCodeParams struct {
	ID                  uuid.UUID `json:"id"`
	AppID               uuid.UUID `json:"app_id"`
	ClientID            string    `json:"client_id"`
	UserID              uuid.UUID `json:"user_id"`
	Code                string    `json:"code"`
	RedirectUri         string    `json:"redirect_uri"`
	Scopes              string    `json:"scopes"`
	Nonce               string    `json:"nonce"`
	CodeChallenge       string    `json:"code_challenge"`
	CodeChallengeMethod string    `json:"code_challenge_method"`
	ExpiresAt           time.Time `json:"expires_at"`
	Used                bool      `json:"used"`
	CreatedAt           time.Time `json:"created_at"`
}

type CreateOIDCClientParams

type CreateOIDCClientParams struct {
	ID                uuid.UUID `json:"id"`
	AppID             uuid.UUID `json:"app_id"`
	Name              string    `json:"name"`
	Description       string    `json:"description"`
	ClientID          string    `json:"client_id"`
	ClientSecretHash  string    `json:"client_secret_hash"`
	RedirectUris      string    `json:"redirect_uris"`
	AllowedGrantTypes string    `json:"allowed_grant_types"`
	AllowedScopes     string    `json:"allowed_scopes"`
	RequireConsent    bool      `json:"require_consent"`
	IsConfidential    bool      `json:"is_confidential"`
	PkceRequired      bool      `json:"pkce_required"`
	IsActive          bool      `json:"is_active"`
	LogoUrl           string    `json:"logo_url"`
	LoginTheme        string    `json:"login_theme"`
	LoginPrimaryColor string    `json:"login_primary_color"`
	CreatedAt         time.Time `json:"created_at"`
	UpdatedAt         time.Time `json:"updated_at"`
}

type CreatePermissionParams

type CreatePermissionParams struct {
	ID          uuid.UUID `json:"id"`
	Resource    string    `json:"resource"`
	Action      string    `json:"action"`
	Description *string   `json:"description"`
	CreatedAt   time.Time `json:"created_at"`
}

type CreateRoleParams

type CreateRoleParams struct {
	ID          uuid.UUID `json:"id"`
	AppID       uuid.UUID `json:"app_id"`
	Name        string    `json:"name"`
	Description *string   `json:"description"`
	IsSystem    bool      `json:"is_system"`
	CreatedAt   time.Time `json:"created_at"`
	UpdatedAt   time.Time `json:"updated_at"`
}

type CreateServerConfigParams

type CreateServerConfigParams struct {
	ID           uuid.UUID   `json:"id"`
	AppID        pgtype.UUID `json:"app_id"`
	Name         string      `json:"name"`
	SmtpHost     string      `json:"smtp_host"`
	SmtpPort     int32       `json:"smtp_port"`
	SmtpUsername *string     `json:"smtp_username"`
	SmtpPassword *string     `json:"smtp_password"`
	FromAddress  string      `json:"from_address"`
	FromName     *string     `json:"from_name"`
	UseTls       bool        `json:"use_tls"`
	IsActive     bool        `json:"is_active"`
	IsDefault    bool        `json:"is_default"`
	CreatedAt    time.Time   `json:"created_at"`
	UpdatedAt    time.Time   `json:"updated_at"`
}

type CreateSocialAccountParams

type CreateSocialAccountParams struct {
	ID             uuid.UUID          `json:"id"`
	AppID          uuid.UUID          `json:"app_id"`
	UserID         uuid.UUID          `json:"user_id"`
	Provider       string             `json:"provider"`
	ProviderUserID string             `json:"provider_user_id"`
	Email          string             `json:"email"`
	Name           string             `json:"name"`
	FirstName      string             `json:"first_name"`
	LastName       string             `json:"last_name"`
	ProfilePicture string             `json:"profile_picture"`
	Username       string             `json:"username"`
	Locale         string             `json:"locale"`
	RawData        []byte             `json:"raw_data"`
	AccessToken    string             `json:"access_token"`
	RefreshToken   string             `json:"refresh_token"`
	ExpiresAt      pgtype.Timestamptz `json:"expires_at"`
	CreatedAt      time.Time          `json:"created_at"`
	UpdatedAt      time.Time          `json:"updated_at"`
}

type CreateTemplateParams

type CreateTemplateParams struct {
	ID             uuid.UUID   `json:"id"`
	AppID          pgtype.UUID `json:"app_id"`
	EmailTypeID    uuid.UUID   `json:"email_type_id"`
	ServerConfigID pgtype.UUID `json:"server_config_id"`
	Name           string      `json:"name"`
	Subject        string      `json:"subject"`
	BodyHtml       *string     `json:"body_html"`
	BodyText       *string     `json:"body_text"`
	FromEmail      *string     `json:"from_email"`
	FromName       *string     `json:"from_name"`
	TemplateEngine string      `json:"template_engine"`
	IsActive       bool        `json:"is_active"`
	CreatedAt      time.Time   `json:"created_at"`
	UpdatedAt      time.Time   `json:"updated_at"`
}

type CreateTrustedDeviceParams

type CreateTrustedDeviceParams struct {
	ID         uuid.UUID `json:"id"`
	UserID     uuid.UUID `json:"user_id"`
	AppID      uuid.UUID `json:"app_id"`
	TokenHash  string    `json:"token_hash"`
	Name       *string   `json:"name"`
	UserAgent  *string   `json:"user_agent"`
	IpAddress  *string   `json:"ip_address"`
	LastUsedAt time.Time `json:"last_used_at"`
	ExpiresAt  time.Time `json:"expires_at"`
	CreatedAt  time.Time `json:"created_at"`
}

type CreateUserParams

type CreateUserParams struct {
	ID                  uuid.UUID          `json:"id"`
	AppID               uuid.UUID          `json:"app_id"`
	Email               string             `json:"email"`
	PasswordHash        string             `json:"password_hash"`
	EmailVerified       bool               `json:"email_verified"`
	IsActive            bool               `json:"is_active"`
	Name                string             `json:"name"`
	FirstName           string             `json:"first_name"`
	LastName            string             `json:"last_name"`
	ProfilePicture      string             `json:"profile_picture"`
	Locale              string             `json:"locale"`
	TwoFaEnabled        bool               `json:"two_fa_enabled"`
	TwoFaMethod         string             `json:"two_fa_method"`
	TwoFaSecret         string             `json:"two_fa_secret"`
	TwoFaRecoveryCodes  json.RawMessage    `json:"two_fa_recovery_codes"`
	BackupEmail         string             `json:"backup_email"`
	BackupEmailVerified bool               `json:"backup_email_verified"`
	TwoFaPreviousMethod string             `json:"two_fa_previous_method"`
	TwoFaPreviousSecret string             `json:"two_fa_previous_secret"`
	PhoneNumber         string             `json:"phone_number"`
	PhoneVerified       bool               `json:"phone_verified"`
	LockedAt            pgtype.Timestamptz `json:"locked_at"`
	LockReason          string             `json:"lock_reason"`
	LockExpiresAt       pgtype.Timestamptz `json:"lock_expires_at"`
	PasswordHistory     []byte             `json:"password_history"`
	PasswordChangedAt   pgtype.Timestamptz `json:"password_changed_at"`
	CreatedAt           time.Time          `json:"created_at"`
	UpdatedAt           time.Time          `json:"updated_at"`
}

type CreateUserRoleParams

type CreateUserRoleParams struct {
	UserID     uuid.UUID   `json:"user_id"`
	RoleID     uuid.UUID   `json:"role_id"`
	AppID      uuid.UUID   `json:"app_id"`
	AssignedAt time.Time   `json:"assigned_at"`
	AssignedBy pgtype.UUID `json:"assigned_by"`
}

type CreateWebAuthnCredentialParams

type CreateWebAuthnCredentialParams struct {
	ID              uuid.UUID          `json:"id"`
	UserID          pgtype.UUID        `json:"user_id"`
	AppID           pgtype.UUID        `json:"app_id"`
	AdminID         pgtype.UUID        `json:"admin_id"`
	CredentialID    []byte             `json:"credential_id"`
	PublicKey       []byte             `json:"public_key"`
	AttestationType *string            `json:"attestation_type"`
	Aaguid          []byte             `json:"aaguid"`
	SignCount       int32              `json:"sign_count"`
	Name            *string            `json:"name"`
	Transports      *string            `json:"transports"`
	BackupEligible  bool               `json:"backup_eligible"`
	BackupState     bool               `json:"backup_state"`
	LastUsedAt      pgtype.Timestamptz `json:"last_used_at"`
	CreatedAt       time.Time          `json:"created_at"`
}

type CreateWebhookDeliveryParams

type CreateWebhookDeliveryParams struct {
	ID           uuid.UUID          `json:"id"`
	EndpointID   uuid.UUID          `json:"endpoint_id"`
	AppID        uuid.UUID          `json:"app_id"`
	EventType    string             `json:"event_type"`
	Payload      string             `json:"payload"`
	Attempt      int32              `json:"attempt"`
	StatusCode   *int32             `json:"status_code"`
	ResponseBody *string            `json:"response_body"`
	LatencyMs    *int64             `json:"latency_ms"`
	Success      bool               `json:"success"`
	ErrorMessage *string            `json:"error_message"`
	NextRetryAt  pgtype.Timestamptz `json:"next_retry_at"`
	CreatedAt    time.Time          `json:"created_at"`
}

type CreateWebhookEndpointParams

type CreateWebhookEndpointParams struct {
	ID        uuid.UUID `json:"id"`
	AppID     uuid.UUID `json:"app_id"`
	EventType string    `json:"event_type"`
	Url       string    `json:"url"`
	Secret    string    `json:"secret"`
	IsActive  bool      `json:"is_active"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

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 DeleteAllTrustedDevicesForUserParams

type DeleteAllTrustedDevicesForUserParams struct {
	UserID uuid.UUID `json:"user_id"`
	AppID  uuid.UUID `json:"app_id"`
}

type DeleteTrustedDevicesByUserAppAndUserAgentParams

type DeleteTrustedDevicesByUserAppAndUserAgentParams struct {
	UserID    uuid.UUID `json:"user_id"`
	AppID     uuid.UUID `json:"app_id"`
	UserAgent *string   `json:"user_agent"`
}

type DeleteUserRoleParams

type DeleteUserRoleParams struct {
	UserID uuid.UUID `json:"user_id"`
	RoleID uuid.UUID `json:"role_id"`
}

type DeleteWebAuthnAdminCredentialParams

type DeleteWebAuthnAdminCredentialParams struct {
	ID      uuid.UUID   `json:"id"`
	AdminID pgtype.UUID `json:"admin_id"`
}

type DeleteWebAuthnCredentialParams

type DeleteWebAuthnCredentialParams struct {
	ID     uuid.UUID   `json:"id"`
	UserID pgtype.UUID `json:"user_id"`
}

type EmailServerConfig

type EmailServerConfig struct {
	ID           uuid.UUID   `json:"id"`
	AppID        pgtype.UUID `json:"app_id"`
	Name         string      `json:"name"`
	SmtpHost     string      `json:"smtp_host"`
	SmtpPort     int32       `json:"smtp_port"`
	SmtpUsername *string     `json:"smtp_username"`
	SmtpPassword *string     `json:"smtp_password"`
	FromAddress  string      `json:"from_address"`
	FromName     *string     `json:"from_name"`
	UseTls       bool        `json:"use_tls"`
	IsActive     bool        `json:"is_active"`
	IsDefault    bool        `json:"is_default"`
	CreatedAt    time.Time   `json:"created_at"`
	UpdatedAt    time.Time   `json:"updated_at"`
}

type EmailTemplate

type EmailTemplate struct {
	ID             uuid.UUID   `json:"id"`
	AppID          pgtype.UUID `json:"app_id"`
	EmailTypeID    uuid.UUID   `json:"email_type_id"`
	ServerConfigID pgtype.UUID `json:"server_config_id"`
	Name           string      `json:"name"`
	Subject        string      `json:"subject"`
	BodyHtml       *string     `json:"body_html"`
	BodyText       *string     `json:"body_text"`
	FromEmail      *string     `json:"from_email"`
	FromName       *string     `json:"from_name"`
	TemplateEngine string      `json:"template_engine"`
	IsActive       bool        `json:"is_active"`
	CreatedAt      time.Time   `json:"created_at"`
	UpdatedAt      time.Time   `json:"updated_at"`
}

type EmailType

type EmailType struct {
	ID             uuid.UUID `json:"id"`
	Code           string    `json:"code"`
	Name           string    `json:"name"`
	Description    *string   `json:"description"`
	DefaultSubject *string   `json:"default_subject"`
	Variables      []byte    `json:"variables"`
	IsSystem       bool      `json:"is_system"`
	IsActive       bool      `json:"is_active"`
	CreatedAt      time.Time `json:"created_at"`
	UpdatedAt      time.Time `json:"updated_at"`
}

type Enable2FAWithMethodParams

type Enable2FAWithMethodParams struct {
	ID                 uuid.UUID       `json:"id"`
	TwoFaSecret        string          `json:"two_fa_secret"`
	TwoFaRecoveryCodes json.RawMessage `json:"two_fa_recovery_codes"`
	TwoFaMethod        string          `json:"two_fa_method"`
}

type EnableAdminAccount2FAParams

type EnableAdminAccount2FAParams struct {
	ID                 uuid.UUID `json:"id"`
	TwoFaMethod        *string   `json:"two_fa_method"`
	TwoFaSecret        *string   `json:"two_fa_secret"`
	TwoFaRecoveryCodes []byte    `json:"two_fa_recovery_codes"`
}

type ExportAllActivityLogsParams

type ExportAllActivityLogsParams struct {
	EventType *string            `json:"event_type"`
	StartDate pgtype.Timestamptz `json:"start_date"`
	EndDate   pgtype.Timestamptz `json:"end_date"`
	LimitVal  int32              `json:"limit_val"`
}

type ExportUserActivityLogsParams

type ExportUserActivityLogsParams struct {
	UserID    uuid.UUID          `json:"user_id"`
	EventType *string            `json:"event_type"`
	StartDate pgtype.Timestamptz `json:"start_date"`
	EndDate   pgtype.Timestamptz `json:"end_date"`
	LimitVal  int32              `json:"limit_val"`
}

type FindTrustedDevicesByUserAndAppParams

type FindTrustedDevicesByUserAndAppParams struct {
	UserID uuid.UUID `json:"user_id"`
	AppID  uuid.UUID `json:"app_id"`
}

type GetActiveWebhookEndpointsForEventParams

type GetActiveWebhookEndpointsForEventParams struct {
	AppID     uuid.UUID `json:"app_id"`
	EventType string    `json:"event_type"`
}

type GetGlobalDefaultTemplatesRow

type GetGlobalDefaultTemplatesRow struct {
	ID               uuid.UUID   `json:"id"`
	AppID            pgtype.UUID `json:"app_id"`
	EmailTypeID      uuid.UUID   `json:"email_type_id"`
	ServerConfigID   pgtype.UUID `json:"server_config_id"`
	Name             string      `json:"name"`
	Subject          string      `json:"subject"`
	BodyHtml         *string     `json:"body_html"`
	BodyText         *string     `json:"body_text"`
	FromEmail        *string     `json:"from_email"`
	FromName         *string     `json:"from_name"`
	TemplateEngine   string      `json:"template_engine"`
	IsActive         bool        `json:"is_active"`
	CreatedAt        time.Time   `json:"created_at"`
	UpdatedAt        time.Time   `json:"updated_at"`
	EtID             uuid.UUID   `json:"et_id"`
	EtCode           string      `json:"et_code"`
	EtName           string      `json:"et_name"`
	EtDescription    *string     `json:"et_description"`
	EtDefaultSubject *string     `json:"et_default_subject"`
	EtVariables      []byte      `json:"et_variables"`
	EtIsSystem       bool        `json:"et_is_system"`
	EtIsActive       bool        `json:"et_is_active"`
	EtCreatedAt      time.Time   `json:"et_created_at"`
	EtUpdatedAt      time.Time   `json:"et_updated_at"`
}

type GetOAuthProviderConfigParams

type GetOAuthProviderConfigParams struct {
	AppID    uuid.UUID `json:"app_id"`
	Provider string    `json:"provider"`
}

type GetPendingWebhookRetriesParams

type GetPendingWebhookRetriesParams struct {
	NextRetryAt pgtype.Timestamptz `json:"next_retry_at"`
	Limit       int32              `json:"limit"`
}

type GetRoleByNameParams

type GetRoleByNameParams struct {
	AppID uuid.UUID `json:"app_id"`
	Name  string    `json:"name"`
}

type GetRolesForUserInAppParams

type GetRolesForUserInAppParams struct {
	AppID  uuid.UUID `json:"app_id"`
	UserID uuid.UUID `json:"user_id"`
}

type GetSocialAccountByProviderAndUserIDParams

type GetSocialAccountByProviderAndUserIDParams struct {
	AppID          uuid.UUID `json:"app_id"`
	Provider       string    `json:"provider"`
	ProviderUserID string    `json:"provider_user_id"`
}

type GetTemplateByAppAndTypeIDParams

type GetTemplateByAppAndTypeIDParams struct {
	AppID       pgtype.UUID `json:"app_id"`
	EmailTypeID uuid.UUID   `json:"email_type_id"`
}

type GetTemplateByAppAndTypeParams

type GetTemplateByAppAndTypeParams struct {
	AppID       pgtype.UUID `json:"app_id"`
	EmailTypeID uuid.UUID   `json:"email_type_id"`
}

type GetTemplateByIDRow

type GetTemplateByIDRow struct {
	ID               uuid.UUID   `json:"id"`
	AppID            pgtype.UUID `json:"app_id"`
	EmailTypeID      uuid.UUID   `json:"email_type_id"`
	ServerConfigID   pgtype.UUID `json:"server_config_id"`
	Name             string      `json:"name"`
	Subject          string      `json:"subject"`
	BodyHtml         *string     `json:"body_html"`
	BodyText         *string     `json:"body_text"`
	FromEmail        *string     `json:"from_email"`
	FromName         *string     `json:"from_name"`
	TemplateEngine   string      `json:"template_engine"`
	IsActive         bool        `json:"is_active"`
	CreatedAt        time.Time   `json:"created_at"`
	UpdatedAt        time.Time   `json:"updated_at"`
	EtID             uuid.UUID   `json:"et_id"`
	EtCode           string      `json:"et_code"`
	EtName           string      `json:"et_name"`
	EtDescription    *string     `json:"et_description"`
	EtDefaultSubject *string     `json:"et_default_subject"`
	EtVariables      []byte      `json:"et_variables"`
	EtIsSystem       bool        `json:"et_is_system"`
	EtIsActive       bool        `json:"et_is_active"`
	EtCreatedAt      time.Time   `json:"et_created_at"`
	EtUpdatedAt      time.Time   `json:"et_updated_at"`
}

type GetTemplatesByAppRow

type GetTemplatesByAppRow struct {
	ID               uuid.UUID   `json:"id"`
	AppID            pgtype.UUID `json:"app_id"`
	EmailTypeID      uuid.UUID   `json:"email_type_id"`
	ServerConfigID   pgtype.UUID `json:"server_config_id"`
	Name             string      `json:"name"`
	Subject          string      `json:"subject"`
	BodyHtml         *string     `json:"body_html"`
	BodyText         *string     `json:"body_text"`
	FromEmail        *string     `json:"from_email"`
	FromName         *string     `json:"from_name"`
	TemplateEngine   string      `json:"template_engine"`
	IsActive         bool        `json:"is_active"`
	CreatedAt        time.Time   `json:"created_at"`
	UpdatedAt        time.Time   `json:"updated_at"`
	EtID             uuid.UUID   `json:"et_id"`
	EtCode           string      `json:"et_code"`
	EtName           string      `json:"et_name"`
	EtDescription    *string     `json:"et_description"`
	EtDefaultSubject *string     `json:"et_default_subject"`
	EtVariables      []byte      `json:"et_variables"`
	EtIsSystem       bool        `json:"et_is_system"`
	EtIsActive       bool        `json:"et_is_active"`
	EtCreatedAt      time.Time   `json:"et_created_at"`
	EtUpdatedAt      time.Time   `json:"et_updated_at"`
}

type GetUserByEmailForOIDCParams

type GetUserByEmailForOIDCParams struct {
	AppID uuid.UUID `json:"app_id"`
	Email string    `json:"email"`
}

type GetUserByEmailParams

type GetUserByEmailParams struct {
	AppID uuid.UUID `json:"app_id"`
	Email string    `json:"email"`
}

type GetUserPermissionsParams

type GetUserPermissionsParams struct {
	AppID  uuid.UUID `json:"app_id"`
	UserID uuid.UUID `json:"user_id"`
}

type GetUserPermissionsRow

type GetUserPermissionsRow struct {
	Resource string `json:"resource"`
	Action   string `json:"action"`
}

type GetUserRoleNamesParams

type GetUserRoleNamesParams struct {
	AppID  uuid.UUID `json:"app_id"`
	UserID uuid.UUID `json:"user_id"`
}

type GetUserRolesForUserInAppParams

type GetUserRolesForUserInAppParams struct {
	AppID  uuid.UUID `json:"app_id"`
	UserID uuid.UUID `json:"user_id"`
}

type GetUserTwoFAPreviousFieldsRow

type GetUserTwoFAPreviousFieldsRow struct {
	TwoFaPreviousMethod string `json:"two_fa_previous_method"`
	TwoFaPreviousSecret string `json:"two_fa_previous_secret"`
}

type GetUsersWithRoleInAppParams

type GetUsersWithRoleInAppParams struct {
	AppID  uuid.UUID `json:"app_id"`
	Limit  int32     `json:"limit"`
	Offset int32     `json:"offset"`
}

type GetUsersWithRoleInAppRow

type GetUsersWithRoleInAppRow struct {
	UserID     uuid.UUID `json:"user_id"`
	RoleID     uuid.UUID `json:"role_id"`
	AppID      uuid.UUID `json:"app_id"`
	AssignedAt time.Time `json:"assigned_at"`
	UserEmail  string    `json:"user_email"`
	UserName   string    `json:"user_name"`
	RoleName   string    `json:"role_name"`
}

type GetWebAuthnCredentialByAdminAndCredentialIDParams

type GetWebAuthnCredentialByAdminAndCredentialIDParams struct {
	AdminID      pgtype.UUID `json:"admin_id"`
	CredentialID []byte      `json:"credential_id"`
}

type GetWebAuthnCredentialByAppAndCredentialIDParams

type GetWebAuthnCredentialByAppAndCredentialIDParams struct {
	AppID        pgtype.UUID `json:"app_id"`
	CredentialID []byte      `json:"credential_id"`
}

type GetWebAuthnCredentialsByUserAndAppParams

type GetWebAuthnCredentialsByUserAndAppParams struct {
	UserID pgtype.UUID `json:"user_id"`
	AppID  pgtype.UUID `json:"app_id"`
}

type GetWebhookEndpointByAppAndEventParams

type GetWebhookEndpointByAppAndEventParams struct {
	AppID     uuid.UUID `json:"app_id"`
	EventType string    `json:"event_type"`
}

type InsertRolePermissionParams

type InsertRolePermissionParams struct {
	RoleID       uuid.UUID `json:"role_id"`
	PermissionID uuid.UUID `json:"permission_id"`
}

type IpRule

type IpRule struct {
	ID          uuid.UUID `json:"id"`
	AppID       uuid.UUID `json:"app_id"`
	RuleType    string    `json:"rule_type"`
	MatchType   string    `json:"match_type"`
	Value       string    `json:"value"`
	Description string    `json:"description"`
	IsActive    bool      `json:"is_active"`
	CreatedAt   time.Time `json:"created_at"`
	UpdatedAt   time.Time `json:"updated_at"`
}

type ListAllActivityLogsParams

type ListAllActivityLogsParams struct {
	EventType *string            `json:"event_type"`
	StartDate pgtype.Timestamptz `json:"start_date"`
	EndDate   pgtype.Timestamptz `json:"end_date"`
	OffsetVal int32              `json:"offset_val"`
	LimitVal  int32              `json:"limit_val"`
}

type ListAllAppsRow

type ListAllAppsRow struct {
	ID   uuid.UUID `json:"id"`
	Name string    `json:"name"`
}

type ListAllWebhookEndpointsParams

type ListAllWebhookEndpointsParams struct {
	Limit  int32 `json:"limit"`
	Offset int32 `json:"offset"`
}

type ListUserActivityLogsParams

type ListUserActivityLogsParams struct {
	UserID    uuid.UUID          `json:"user_id"`
	EventType *string            `json:"event_type"`
	StartDate pgtype.Timestamptz `json:"start_date"`
	EndDate   pgtype.Timestamptz `json:"end_date"`
	OffsetVal int32              `json:"offset_val"`
	LimitVal  int32              `json:"limit_val"`
}

type ListWebhookDeliveriesByAppParams

type ListWebhookDeliveriesByAppParams struct {
	AppID  uuid.UUID `json:"app_id"`
	Limit  int32     `json:"limit"`
	Offset int32     `json:"offset"`
}

type ListWebhookDeliveriesByEndpointParams

type ListWebhookDeliveriesByEndpointParams struct {
	EndpointID uuid.UUID `json:"endpoint_id"`
	Limit      int32     `json:"limit"`
	Offset     int32     `json:"offset"`
}

type ListWebhookEndpointsByAppParams

type ListWebhookEndpointsByAppParams struct {
	AppID  uuid.UUID `json:"app_id"`
	Limit  int32     `json:"limit"`
	Offset int32     `json:"offset"`
}

type LockUserByEmailParams

type LockUserByEmailParams struct {
	LockedAt      pgtype.Timestamptz `json:"locked_at"`
	LockReason    string             `json:"lock_reason"`
	LockExpiresAt pgtype.Timestamptz `json:"lock_expires_at"`
	AppID         uuid.UUID          `json:"app_id"`
	Email         string             `json:"email"`
}

type OauthProviderConfig

type OauthProviderConfig struct {
	ID           uuid.UUID `json:"id"`
	AppID        uuid.UUID `json:"app_id"`
	Provider     string    `json:"provider"`
	ClientID     string    `json:"client_id"`
	ClientSecret string    `json:"client_secret"`
	RedirectUrl  string    `json:"redirect_url"`
	IsEnabled    bool      `json:"is_enabled"`
	CreatedAt    time.Time `json:"created_at"`
	UpdatedAt    time.Time `json:"updated_at"`
}

type OidcAuthCode

type OidcAuthCode struct {
	ID                  uuid.UUID `json:"id"`
	AppID               uuid.UUID `json:"app_id"`
	ClientID            string    `json:"client_id"`
	UserID              uuid.UUID `json:"user_id"`
	Code                string    `json:"code"`
	RedirectUri         string    `json:"redirect_uri"`
	Scopes              string    `json:"scopes"`
	Nonce               string    `json:"nonce"`
	CodeChallenge       string    `json:"code_challenge"`
	CodeChallengeMethod string    `json:"code_challenge_method"`
	ExpiresAt           time.Time `json:"expires_at"`
	Used                bool      `json:"used"`
	CreatedAt           time.Time `json:"created_at"`
}

type OidcClient

type OidcClient struct {
	ID                uuid.UUID `json:"id"`
	AppID             uuid.UUID `json:"app_id"`
	Name              string    `json:"name"`
	Description       string    `json:"description"`
	ClientID          string    `json:"client_id"`
	ClientSecretHash  string    `json:"client_secret_hash"`
	RedirectUris      string    `json:"redirect_uris"`
	AllowedGrantTypes string    `json:"allowed_grant_types"`
	AllowedScopes     string    `json:"allowed_scopes"`
	RequireConsent    bool      `json:"require_consent"`
	IsConfidential    bool      `json:"is_confidential"`
	PkceRequired      bool      `json:"pkce_required"`
	IsActive          bool      `json:"is_active"`
	LogoUrl           string    `json:"logo_url"`
	LoginTheme        string    `json:"login_theme"`
	LoginPrimaryColor string    `json:"login_primary_color"`
	CreatedAt         time.Time `json:"created_at"`
	UpdatedAt         time.Time `json:"updated_at"`
}

type Permission

type Permission struct {
	ID          uuid.UUID `json:"id"`
	Resource    string    `json:"resource"`
	Action      string    `json:"action"`
	Description *string   `json:"description"`
	CreatedAt   time.Time `json:"created_at"`
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) AdminAddAppToSessionGroup

func (q *Queries) AdminAddAppToSessionGroup(ctx context.Context, arg AdminAddAppToSessionGroupParams) error

func (*Queries) AdminAddRolePermission

func (q *Queries) AdminAddRolePermission(ctx context.Context, arg AdminAddRolePermissionParams) error

func (*Queries) AdminCountActiveOIDCClients

func (q *Queries) AdminCountActiveOIDCClients(ctx context.Context, appID uuid.UUID) (int64, error)

============ OIDC CLIENTS ============

func (*Queries) AdminCountActiveTrustedDevices

func (q *Queries) AdminCountActiveTrustedDevices(ctx context.Context) (int64, error)

func (*Queries) AdminCountActiveUsers

func (q *Queries) AdminCountActiveUsers(ctx context.Context) (int64, error)

func (*Queries) AdminCountActivityLogs

func (q *Queries) AdminCountActivityLogs(ctx context.Context, arg AdminCountActivityLogsParams) (int64, error)

============ ACTIVITY LOGS ============

func (*Queries) AdminCountApiKeys

func (q *Queries) AdminCountApiKeys(ctx context.Context, keyType *string) (int64, error)

func (*Queries) AdminCountApps

func (q *Queries) AdminCountApps(ctx context.Context) (int64, error)

func (*Queries) AdminCountAppsWithTenantFilter

func (q *Queries) AdminCountAppsWithTenantFilter(ctx context.Context, tenantID pgtype.UUID) (int64, error)

func (*Queries) AdminCountInactiveUsers

func (q *Queries) AdminCountInactiveUsers(ctx context.Context) (int64, error)

func (*Queries) AdminCountOAuthConfigs

func (q *Queries) AdminCountOAuthConfigs(ctx context.Context, appID pgtype.UUID) (int64, error)

func (*Queries) AdminCountRecentActivityLogs

func (q *Queries) AdminCountRecentActivityLogs(ctx context.Context, timestamp time.Time) (int64, error)

func (*Queries) AdminCountSessionGroups

func (q *Queries) AdminCountSessionGroups(ctx context.Context) (int64, error)

func (*Queries) AdminCountSocialAccountsByUserID

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

func (*Queries) AdminCountTenants

func (q *Queries) AdminCountTenants(ctx context.Context) (int64, error)

func (*Queries) AdminCountTotalUsers

func (q *Queries) AdminCountTotalUsers(ctx context.Context) (int64, error)

============ DASHBOARD ============

func (*Queries) AdminCountUserExistsForImport

func (q *Queries) AdminCountUserExistsForImport(ctx context.Context, arg AdminCountUserExistsForImportParams) (int64, error)

func (*Queries) AdminCountUsersWithFilters

func (q *Queries) AdminCountUsersWithFilters(ctx context.Context, arg AdminCountUsersWithFiltersParams) (int64, error)

============ USERS ============

func (*Queries) AdminCountVerifiedPhoneUsers

func (q *Queries) AdminCountVerifiedPhoneUsers(ctx context.Context) (int64, error)

func (*Queries) AdminCreateApiKey

func (q *Queries) AdminCreateApiKey(ctx context.Context, arg AdminCreateApiKeyParams) (ApiKey, error)

============ API KEYS ============

func (*Queries) AdminCreateApp

func (q *Queries) AdminCreateApp(ctx context.Context, arg AdminCreateAppParams) (Application, error)

============ APPLICATIONS ============

func (*Queries) AdminCreateImportUser

func (q *Queries) AdminCreateImportUser(ctx context.Context, arg AdminCreateImportUserParams) (User, error)

func (*Queries) AdminCreateOAuthConfig

func (q *Queries) AdminCreateOAuthConfig(ctx context.Context, arg AdminCreateOAuthConfigParams) (OauthProviderConfig, error)

func (*Queries) AdminCreateRole

func (q *Queries) AdminCreateRole(ctx context.Context, arg AdminCreateRoleParams) (Role, error)

func (*Queries) AdminCreateSessionGroup

func (q *Queries) AdminCreateSessionGroup(ctx context.Context, arg AdminCreateSessionGroupParams) (SessionGroup, error)

============ SESSION GROUPS ============

func (*Queries) AdminCreateTenant

func (q *Queries) AdminCreateTenant(ctx context.Context, arg AdminCreateTenantParams) (Tenant, error)

============ TENANTS ============

func (*Queries) AdminDeleteApiKey

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

func (*Queries) AdminDeleteApp

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

func (*Queries) AdminDeleteOAuthConfig

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

func (*Queries) AdminDeleteRolePermissions

func (q *Queries) AdminDeleteRolePermissions(ctx context.Context, roleID uuid.UUID) error

func (*Queries) AdminDeleteSessionGroup

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

func (*Queries) AdminDeleteSessionGroupApps

func (q *Queries) AdminDeleteSessionGroupApps(ctx context.Context, sessionGroupID uuid.UUID) error

func (*Queries) AdminDeleteSocialAccount

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

func (*Queries) AdminDeleteTenant

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

func (*Queries) AdminDeleteWebAuthnCredential

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

func (*Queries) AdminExportActivityLogs

func (q *Queries) AdminExportActivityLogs(ctx context.Context, arg AdminExportActivityLogsParams) ([]AdminExportActivityLogsRow, error)

func (*Queries) AdminExportUsers

func (q *Queries) AdminExportUsers(ctx context.Context, arg AdminExportUsersParams) ([]AdminExportUsersRow, error)

============ USER EXPORT ============

func (*Queries) AdminFindActiveKeyByHash

func (q *Queries) AdminFindActiveKeyByHash(ctx context.Context, keyHash string) (ApiKey, error)

func (*Queries) AdminGetActivityLogDetail

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

func (*Queries) AdminGetApiKeyByID

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

func (*Queries) AdminGetApiKeyTotalUsage

func (q *Queries) AdminGetApiKeyTotalUsage(ctx context.Context, apiKeyID uuid.UUID) (int64, error)

func (*Queries) AdminGetApiKeyUsageSummary

func (q *Queries) AdminGetApiKeyUsageSummary(ctx context.Context, arg AdminGetApiKeyUsageSummaryParams) ([]AdminGetApiKeyUsageSummaryRow, error)

func (*Queries) AdminGetAppByID

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

func (*Queries) AdminGetAppNamesByIDs

func (q *Queries) AdminGetAppNamesByIDs(ctx context.Context, dollar_1 []uuid.UUID) ([]AdminGetAppNamesByIDsRow, error)

func (*Queries) AdminGetAppOAuthConfigs

func (q *Queries) AdminGetAppOAuthConfigs(ctx context.Context, appID uuid.UUID) ([]OauthProviderConfig, error)

func (*Queries) AdminGetAppsInSessionGroup

func (q *Queries) AdminGetAppsInSessionGroup(ctx context.Context, sessionGroupID uuid.UUID) ([]uuid.UUID, error)

func (*Queries) AdminGetAppsInSessionGroupWithDetails

func (q *Queries) AdminGetAppsInSessionGroupWithDetails(ctx context.Context, sessionGroupID uuid.UUID) ([]AdminGetAppsInSessionGroupWithDetailsRow, error)

func (*Queries) AdminGetEnabledOAuthProviders

func (q *Queries) AdminGetEnabledOAuthProviders(ctx context.Context, appID uuid.UUID) ([]string, error)

func (*Queries) AdminGetFirstActiveOIDCClientLoginTheme

func (q *Queries) AdminGetFirstActiveOIDCClientLoginTheme(ctx context.Context, appID uuid.UUID) (string, error)

func (*Queries) AdminGetKeysExpiringWithin

func (q *Queries) AdminGetKeysExpiringWithin(ctx context.Context, expiresAt pgtype.Timestamptz) ([]ApiKey, error)

func (*Queries) AdminGetOAuthConfigByAppAndProvider

func (q *Queries) AdminGetOAuthConfigByAppAndProvider(ctx context.Context, arg AdminGetOAuthConfigByAppAndProviderParams) (OauthProviderConfig, error)

============ OAUTH CONFIGS ============

func (*Queries) AdminGetOAuthConfigByID

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

func (*Queries) AdminGetPeersForApp

func (q *Queries) AdminGetPeersForApp(ctx context.Context, appID uuid.UUID) ([]AdminGetPeersForAppRow, error)

func (*Queries) AdminGetRecentActivity

func (q *Queries) AdminGetRecentActivity(ctx context.Context, limit int32) ([]ActivityLog, error)

func (*Queries) AdminGetRoleByAppAndName

func (q *Queries) AdminGetRoleByAppAndName(ctx context.Context, arg AdminGetRoleByAppAndNameParams) (Role, error)

func (*Queries) AdminGetSessionGroupByID

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

func (*Queries) AdminGetSessionGroupForApp

func (q *Queries) AdminGetSessionGroupForApp(ctx context.Context, appID uuid.UUID) (SessionGroup, error)

func (*Queries) AdminGetSocialAccountByID

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

============ SOCIAL ACCOUNTS ============

func (*Queries) AdminGetSocialAccountsByUserID

func (q *Queries) AdminGetSocialAccountsByUserID(ctx context.Context, userID uuid.UUID) ([]SocialAccount, error)

func (*Queries) AdminGetTenantApps

func (q *Queries) AdminGetTenantApps(ctx context.Context, tenantID uuid.UUID) ([]Application, error)

func (*Queries) AdminGetTenantByID

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

func (*Queries) AdminGetUserActiveAndAppID

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

func (*Queries) AdminGetUserDetailByID

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

func (*Queries) AdminGetUserEmailAndAppID

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

func (*Queries) AdminGetUserEmailsByIDs

func (q *Queries) AdminGetUserEmailsByIDs(ctx context.Context, dollar_1 []uuid.UUID) ([]AdminGetUserEmailsByIDsRow, error)

func (*Queries) AdminGetUserIDByEmailAndApp

func (q *Queries) AdminGetUserIDByEmailAndApp(ctx context.Context, arg AdminGetUserIDByEmailAndAppParams) (uuid.UUID, error)

func (*Queries) AdminGetWebAuthnCredentialByID

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

============ WEBAUTHN CREDENTIALS ============

func (*Queries) AdminGetWebAuthnCredentialsByUserID

func (q *Queries) AdminGetWebAuthnCredentialsByUserID(ctx context.Context, userID pgtype.UUID) ([]WebauthnCredential, error)

func (*Queries) AdminIncrementDailyUsage

func (q *Queries) AdminIncrementDailyUsage(ctx context.Context, arg AdminIncrementDailyUsageParams) error

func (*Queries) AdminListActivityLogs

func (q *Queries) AdminListActivityLogs(ctx context.Context, arg AdminListActivityLogsParams) ([]AdminListActivityLogsRow, error)

func (*Queries) AdminListAllAppIDs

func (q *Queries) AdminListAllAppIDs(ctx context.Context) ([]string, error)

func (*Queries) AdminListAllAppsWithTenantName

func (q *Queries) AdminListAllAppsWithTenantName(ctx context.Context) ([]AdminListAllAppsWithTenantNameRow, error)

func (*Queries) AdminListAllPermissions

func (q *Queries) AdminListAllPermissions(ctx context.Context) ([]Permission, error)

============ PERMISSIONS & ROLES (for SeedDefaultRolesForApp) ============

func (*Queries) AdminListAllTenants

func (q *Queries) AdminListAllTenants(ctx context.Context) ([]AdminListAllTenantsRow, error)

func (*Queries) AdminListApiKeys

func (q *Queries) AdminListApiKeys(ctx context.Context, arg AdminListApiKeysParams) ([]AdminListApiKeysRow, error)

func (*Queries) AdminListAppsByTenant

func (q *Queries) AdminListAppsByTenant(ctx context.Context, tenantID uuid.UUID) ([]Application, error)

func (*Queries) AdminListAppsWithDetails

func (q *Queries) AdminListAppsWithDetails(ctx context.Context, arg AdminListAppsWithDetailsParams) ([]AdminListAppsWithDetailsRow, error)

func (*Queries) AdminListDistinctEventTypes

func (q *Queries) AdminListDistinctEventTypes(ctx context.Context) ([]string, error)

func (*Queries) AdminListDistinctSeverities

func (q *Queries) AdminListDistinctSeverities(ctx context.Context) ([]string, error)

func (*Queries) AdminListSessionGroups

func (q *Queries) AdminListSessionGroups(ctx context.Context, arg AdminListSessionGroupsParams) ([]AdminListSessionGroupsRow, error)

func (*Queries) AdminListTenants

func (q *Queries) AdminListTenants(ctx context.Context, arg AdminListTenantsParams) ([]Tenant, error)

func (*Queries) AdminListUsersWithDetails

func (q *Queries) AdminListUsersWithDetails(ctx context.Context, arg AdminListUsersWithDetailsParams) ([]AdminListUsersWithDetailsRow, error)

func (*Queries) AdminMarkApiKeyNotified1Day

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

func (*Queries) AdminMarkApiKeyNotified7Days

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

func (*Queries) AdminRemoveAppFromSessionGroup

func (q *Queries) AdminRemoveAppFromSessionGroup(ctx context.Context, arg AdminRemoveAppFromSessionGroupParams) error

func (*Queries) AdminRevokeApiKey

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

func (*Queries) AdminSetUserActive

func (q *Queries) AdminSetUserActive(ctx context.Context, arg AdminSetUserActiveParams) error

func (*Queries) AdminToggleOAuthConfigEnabled

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

func (*Queries) AdminUnlockUser

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

func (*Queries) AdminUpdateApiKeyLastUsed

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

func (*Queries) AdminUpdateApiKeyScopes

func (q *Queries) AdminUpdateApiKeyScopes(ctx context.Context, arg AdminUpdateApiKeyScopesParams) error

func (*Queries) AdminUpdateApp

func (q *Queries) AdminUpdateApp(ctx context.Context, arg AdminUpdateAppParams) error

func (*Queries) AdminUpdateAppCaptchaSecretKey

func (q *Queries) AdminUpdateAppCaptchaSecretKey(ctx context.Context, arg AdminUpdateAppCaptchaSecretKeyParams) error

func (*Queries) AdminUpdateAppSMSTrustedDevice

func (q *Queries) AdminUpdateAppSMSTrustedDevice(ctx context.Context, arg AdminUpdateAppSMSTrustedDeviceParams) error

func (*Queries) AdminUpdateOAuthConfig

func (q *Queries) AdminUpdateOAuthConfig(ctx context.Context, arg AdminUpdateOAuthConfigParams) error

func (*Queries) AdminUpdateOAuthConfigByID

func (q *Queries) AdminUpdateOAuthConfigByID(ctx context.Context, arg AdminUpdateOAuthConfigByIDParams) error

func (*Queries) AdminUpdateOAuthConfigByIDWithSecret

func (q *Queries) AdminUpdateOAuthConfigByIDWithSecret(ctx context.Context, arg AdminUpdateOAuthConfigByIDWithSecretParams) error

func (*Queries) AdminUpdateSessionGroup

func (q *Queries) AdminUpdateSessionGroup(ctx context.Context, arg AdminUpdateSessionGroupParams) error

func (*Queries) AdminUpdateTenant

func (q *Queries) AdminUpdateTenant(ctx context.Context, arg AdminUpdateTenantParams) error

func (*Queries) ClearAdminAccountBackupEmail

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

func (*Queries) ClearBackupEmail

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

func (*Queries) ClearDefaultFlagByApp

func (q *Queries) ClearDefaultFlagByApp(ctx context.Context, appID pgtype.UUID) error

func (*Queries) ClearDefaultFlagGlobal

func (q *Queries) ClearDefaultFlagGlobal(ctx context.Context) error

func (*Queries) ClearLockout

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

func (*Queries) ClearPhone

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

func (*Queries) ClearUserLockout

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

func (*Queries) ClearWebhookRetrySchedule

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

func (*Queries) CountAdminAccounts

func (q *Queries) CountAdminAccounts(ctx context.Context) (int64, error)

func (*Queries) CountAllActiveTrustedDevices

func (q *Queries) CountAllActiveTrustedDevices(ctx context.Context) (int64, error)

func (*Queries) CountAllActivityLogs

func (q *Queries) CountAllActivityLogs(ctx context.Context, arg CountAllActivityLogsParams) (int64, error)

func (*Queries) CountAllWebhookEndpoints

func (q *Queries) CountAllWebhookEndpoints(ctx context.Context) (int64, error)

func (*Queries) CountSocialAccountsByUserID

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

func (*Queries) CountTrustedDevicesByUserAndApp

func (q *Queries) CountTrustedDevicesByUserAndApp(ctx context.Context, arg CountTrustedDevicesByUserAndAppParams) (int64, error)

func (*Queries) CountUserActivityLogs

func (q *Queries) CountUserActivityLogs(ctx context.Context, arg CountUserActivityLogsParams) (int64, error)

func (*Queries) CountUsersWithRoleInApp

func (q *Queries) CountUsersWithRoleInApp(ctx context.Context, appID uuid.UUID) (int64, error)

func (*Queries) CountWebAuthnCredentialsByUserAndApp

func (q *Queries) CountWebAuthnCredentialsByUserAndApp(ctx context.Context, arg CountWebAuthnCredentialsByUserAndAppParams) (int64, error)

func (*Queries) CountWebhookDeliveriesByApp

func (q *Queries) CountWebhookDeliveriesByApp(ctx context.Context, appID uuid.UUID) (int64, error)

func (*Queries) CountWebhookDeliveriesByEndpoint

func (q *Queries) CountWebhookDeliveriesByEndpoint(ctx context.Context, endpointID uuid.UUID) (int64, error)

func (*Queries) CountWebhookEndpointsByApp

func (q *Queries) CountWebhookEndpointsByApp(ctx context.Context, appID uuid.UUID) (int64, error)

func (*Queries) CreateActivityLog

func (q *Queries) CreateActivityLog(ctx context.Context, arg CreateActivityLogParams) error

func (*Queries) CreateAdminAccount

func (q *Queries) CreateAdminAccount(ctx context.Context, arg CreateAdminAccountParams) (AdminAccount, error)

func (*Queries) CreateEmailType

func (q *Queries) CreateEmailType(ctx context.Context, arg CreateEmailTypeParams) error

func (*Queries) CreateOIDCAuthCode

func (q *Queries) CreateOIDCAuthCode(ctx context.Context, arg CreateOIDCAuthCodeParams) error

func (*Queries) CreateOIDCClient

func (q *Queries) CreateOIDCClient(ctx context.Context, arg CreateOIDCClientParams) error

func (*Queries) CreatePermission

func (q *Queries) CreatePermission(ctx context.Context, arg CreatePermissionParams) error

func (*Queries) CreateRole

func (q *Queries) CreateRole(ctx context.Context, arg CreateRoleParams) error

func (*Queries) CreateServerConfig

func (q *Queries) CreateServerConfig(ctx context.Context, arg CreateServerConfigParams) error

func (*Queries) CreateSocialAccount

func (q *Queries) CreateSocialAccount(ctx context.Context, arg CreateSocialAccountParams) error

func (*Queries) CreateTemplate

func (q *Queries) CreateTemplate(ctx context.Context, arg CreateTemplateParams) error

func (*Queries) CreateTrustedDevice

func (q *Queries) CreateTrustedDevice(ctx context.Context, arg CreateTrustedDeviceParams) error

func (*Queries) CreateUser

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

func (*Queries) CreateUserRole

func (q *Queries) CreateUserRole(ctx context.Context, arg CreateUserRoleParams) error

func (*Queries) CreateWebAuthnCredential

func (q *Queries) CreateWebAuthnCredential(ctx context.Context, arg CreateWebAuthnCredentialParams) error

func (*Queries) CreateWebhookDelivery

func (q *Queries) CreateWebhookDelivery(ctx context.Context, arg CreateWebhookDeliveryParams) error

============================================================================ Delivery operations ============================================================================

func (*Queries) CreateWebhookEndpoint

func (q *Queries) CreateWebhookEndpoint(ctx context.Context, arg CreateWebhookEndpointParams) error

============================================================================ Endpoint operations ============================================================================

func (*Queries) DeleteAdminAccountByID

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

func (*Queries) DeleteAllTrustedDevicesForUser

func (q *Queries) DeleteAllTrustedDevicesForUser(ctx context.Context, arg DeleteAllTrustedDevicesForUserParams) error

func (*Queries) DeleteAllTrustedDevicesForUserAllApps

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

func (*Queries) DeleteExpiredOIDCAuthCodes

func (q *Queries) DeleteExpiredOIDCAuthCodes(ctx context.Context) error

func (*Queries) DeleteExpiredTrustedDevices

func (q *Queries) DeleteExpiredTrustedDevices(ctx context.Context) (int64, error)

func (*Queries) DeleteNonSystemEmailType

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

func (*Queries) DeleteOIDCClient

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

func (*Queries) DeleteRoleByID

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

func (*Queries) DeleteRolePermissions

func (q *Queries) DeleteRolePermissions(ctx context.Context, roleID uuid.UUID) error

============================================================================ Role-Permission operations ============================================================================

func (*Queries) DeleteServerConfigByApp

func (q *Queries) DeleteServerConfigByApp(ctx context.Context, appID pgtype.UUID) error

func (*Queries) DeleteServerConfigByID

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

func (*Queries) DeleteSetting

func (q *Queries) DeleteSetting(ctx context.Context, key string) error

func (*Queries) DeleteSocialAccount

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

func (*Queries) DeleteTemplateByID

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

func (*Queries) DeleteTemplatesByEmailTypeID

func (q *Queries) DeleteTemplatesByEmailTypeID(ctx context.Context, emailTypeID uuid.UUID) error

func (*Queries) DeleteTrustedDeviceByID

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

func (*Queries) DeleteTrustedDevicesByUserAppAndUserAgent

func (q *Queries) DeleteTrustedDevicesByUserAppAndUserAgent(ctx context.Context, arg DeleteTrustedDevicesByUserAppAndUserAgentParams) error

func (*Queries) DeleteUserByID

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

func (*Queries) DeleteUserRole

func (q *Queries) DeleteUserRole(ctx context.Context, arg DeleteUserRoleParams) error

func (*Queries) DeleteWebAuthnAdminCredential

func (q *Queries) DeleteWebAuthnAdminCredential(ctx context.Context, arg DeleteWebAuthnAdminCredentialParams) error

func (*Queries) DeleteWebAuthnCredential

func (q *Queries) DeleteWebAuthnCredential(ctx context.Context, arg DeleteWebAuthnCredentialParams) error

func (*Queries) Disable2FA

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

func (*Queries) DisableAdminAccount2FA

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

func (*Queries) Enable2FAWithMethod

func (q *Queries) Enable2FAWithMethod(ctx context.Context, arg Enable2FAWithMethodParams) error

func (*Queries) EnableAdminAccount2FA

func (q *Queries) EnableAdminAccount2FA(ctx context.Context, arg EnableAdminAccount2FAParams) error

func (*Queries) ExportAllActivityLogs

func (q *Queries) ExportAllActivityLogs(ctx context.Context, arg ExportAllActivityLogsParams) ([]ActivityLog, error)

func (*Queries) ExportUserActivityLogs

func (q *Queries) ExportUserActivityLogs(ctx context.Context, arg ExportUserActivityLogsParams) ([]ActivityLog, error)

func (*Queries) FindAllTrustedDevicesForUser

func (q *Queries) FindAllTrustedDevicesForUser(ctx context.Context, userID uuid.UUID) ([]TrustedDevice, error)

func (*Queries) FindTrustedDeviceByID

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

func (*Queries) FindTrustedDeviceByTokenHash

func (q *Queries) FindTrustedDeviceByTokenHash(ctx context.Context, tokenHash string) (TrustedDevice, error)

func (*Queries) FindTrustedDevicesByUserAndApp

func (q *Queries) FindTrustedDevicesByUserAndApp(ctx context.Context, arg FindTrustedDevicesByUserAndAppParams) ([]TrustedDevice, error)

func (*Queries) GetActiveEmailTypes

func (q *Queries) GetActiveEmailTypes(ctx context.Context) ([]EmailType, error)

func (*Queries) GetActiveWebhookEndpointsForEvent

func (q *Queries) GetActiveWebhookEndpointsForEvent(ctx context.Context, arg GetActiveWebhookEndpointsForEventParams) ([]WebhookEndpoint, error)

func (*Queries) GetActivityLogByID

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

============================================================================ Activity log queries ============================================================================

func (*Queries) GetAdminAccountByEmail

func (q *Queries) GetAdminAccountByEmail(ctx context.Context, email *string) (AdminAccount, error)

func (*Queries) GetAdminAccountByID

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

func (*Queries) GetAdminAccountByUsername

func (q *Queries) GetAdminAccountByUsername(ctx context.Context, username string) (AdminAccount, error)

func (*Queries) GetAdminAccountByUsernameOrEmail

func (q *Queries) GetAdminAccountByUsernameOrEmail(ctx context.Context, username string) (AdminAccount, error)

func (*Queries) GetAllEmailTypes

func (q *Queries) GetAllEmailTypes(ctx context.Context) ([]EmailType, error)

============================================================================ Email Type queries ============================================================================

func (*Queries) GetAllPermissions

func (q *Queries) GetAllPermissions(ctx context.Context) ([]Permission, error)

============================================================================ Permission operations ============================================================================

func (*Queries) GetAllServerConfigs

func (q *Queries) GetAllServerConfigs(ctx context.Context) ([]EmailServerConfig, error)

func (*Queries) GetAllSettings

func (q *Queries) GetAllSettings(ctx context.Context) ([]SystemSetting, error)

func (*Queries) GetApplicationForOIDC

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

func (*Queries) GetEmailTypeByCode

func (q *Queries) GetEmailTypeByCode(ctx context.Context, code string) (EmailType, error)

func (*Queries) GetEmailTypeByID

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

func (*Queries) GetGlobalDefaultTemplates

func (q *Queries) GetGlobalDefaultTemplates(ctx context.Context) ([]GetGlobalDefaultTemplatesRow, error)

func (*Queries) GetGlobalServerConfigActiveAny

func (q *Queries) GetGlobalServerConfigActiveAny(ctx context.Context) (EmailServerConfig, error)

func (*Queries) GetGlobalServerConfigActiveDefault

func (q *Queries) GetGlobalServerConfigActiveDefault(ctx context.Context) (EmailServerConfig, error)

func (*Queries) GetOAuthProviderConfig

func (q *Queries) GetOAuthProviderConfig(ctx context.Context, arg GetOAuthProviderConfigParams) (OauthProviderConfig, error)

func (*Queries) GetOIDCAuthCode

func (q *Queries) GetOIDCAuthCode(ctx context.Context, code string) (OidcAuthCode, error)

func (*Queries) GetOIDCClientByClientID

func (q *Queries) GetOIDCClientByClientID(ctx context.Context, clientID string) (OidcClient, error)

func (*Queries) GetOIDCClientByID

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

func (*Queries) GetPendingWebhookRetries

func (q *Queries) GetPendingWebhookRetries(ctx context.Context, arg GetPendingWebhookRetriesParams) ([]WebhookDelivery, error)

func (*Queries) GetPermissionByID

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

func (*Queries) GetPermissionsByIDs

func (q *Queries) GetPermissionsByIDs(ctx context.Context, dollar_1 []uuid.UUID) ([]Permission, error)

func (*Queries) GetPermissionsByRoleID

func (q *Queries) GetPermissionsByRoleID(ctx context.Context, roleID uuid.UUID) ([]Permission, error)

func (*Queries) GetRoleByID

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

func (*Queries) GetRoleByName

func (q *Queries) GetRoleByName(ctx context.Context, arg GetRoleByNameParams) (Role, error)

func (*Queries) GetRolesByAppID

func (q *Queries) GetRolesByAppID(ctx context.Context, appID uuid.UUID) ([]Role, error)

============================================================================ Role operations ============================================================================

func (*Queries) GetRolesForUserInApp

func (q *Queries) GetRolesForUserInApp(ctx context.Context, arg GetRolesForUserInAppParams) ([]Role, error)

func (*Queries) GetServerConfigActiveAny

func (q *Queries) GetServerConfigActiveAny(ctx context.Context, appID pgtype.UUID) (EmailServerConfig, error)

func (*Queries) GetServerConfigActiveDefault

func (q *Queries) GetServerConfigActiveDefault(ctx context.Context, appID pgtype.UUID) (EmailServerConfig, error)

============================================================================ Email Server Config queries ============================================================================

func (*Queries) GetServerConfigAnyByApp

func (q *Queries) GetServerConfigAnyByApp(ctx context.Context, appID pgtype.UUID) (EmailServerConfig, error)

func (*Queries) GetServerConfigByID

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

func (*Queries) GetServerConfigsByApp

func (q *Queries) GetServerConfigsByApp(ctx context.Context, appID pgtype.UUID) ([]EmailServerConfig, error)

func (*Queries) GetSettingByKey

func (q *Queries) GetSettingByKey(ctx context.Context, key string) (SystemSetting, error)

func (*Queries) GetSettingsByCategory

func (q *Queries) GetSettingsByCategory(ctx context.Context, category string) ([]SystemSetting, error)

func (*Queries) GetSocialAccountByID

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

func (*Queries) GetSocialAccountByProviderAndUserID

func (q *Queries) GetSocialAccountByProviderAndUserID(ctx context.Context, arg GetSocialAccountByProviderAndUserIDParams) (SocialAccount, error)

func (*Queries) GetSocialAccountsByUserID

func (q *Queries) GetSocialAccountsByUserID(ctx context.Context, userID uuid.UUID) ([]SocialAccount, error)

func (*Queries) GetTemplateByAppAndType

func (q *Queries) GetTemplateByAppAndType(ctx context.Context, arg GetTemplateByAppAndTypeParams) (EmailTemplate, error)

============================================================================ Email Template queries ============================================================================

func (*Queries) GetTemplateByAppAndTypeID

func (q *Queries) GetTemplateByAppAndTypeID(ctx context.Context, arg GetTemplateByAppAndTypeIDParams) (EmailTemplate, error)

func (*Queries) GetTemplateByID

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

func (*Queries) GetTemplateGlobalByType

func (q *Queries) GetTemplateGlobalByType(ctx context.Context, emailTypeID uuid.UUID) (EmailTemplate, error)

func (*Queries) GetTemplateGlobalByTypeID

func (q *Queries) GetTemplateGlobalByTypeID(ctx context.Context, emailTypeID uuid.UUID) (EmailTemplate, error)

func (*Queries) GetTemplatesByApp

func (q *Queries) GetTemplatesByApp(ctx context.Context, appID pgtype.UUID) ([]GetTemplatesByAppRow, error)

func (*Queries) GetUserByEmail

func (q *Queries) GetUserByEmail(ctx context.Context, arg GetUserByEmailParams) (User, error)

func (*Queries) GetUserByEmailForOIDC

func (q *Queries) GetUserByEmailForOIDC(ctx context.Context, arg GetUserByEmailForOIDCParams) (User, error)

func (*Queries) GetUserByID

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

func (*Queries) GetUserByIDForOIDC

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

func (*Queries) GetUserPermissions

func (q *Queries) GetUserPermissions(ctx context.Context, arg GetUserPermissionsParams) ([]GetUserPermissionsRow, error)

func (*Queries) GetUserRoleNames

func (q *Queries) GetUserRoleNames(ctx context.Context, arg GetUserRoleNamesParams) ([]string, error)

============================================================================ User-Role operations ============================================================================

func (*Queries) GetUserRolesForUserInApp

func (q *Queries) GetUserRolesForUserInApp(ctx context.Context, arg GetUserRolesForUserInAppParams) ([]UserRole, error)

func (*Queries) GetUserTwoFAPreviousFields

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

func (*Queries) GetUsersWithRoleInApp

func (q *Queries) GetUsersWithRoleInApp(ctx context.Context, arg GetUsersWithRoleInAppParams) ([]GetUsersWithRoleInAppRow, error)

func (*Queries) GetWebAuthnCredentialByAdminAndCredentialID

func (q *Queries) GetWebAuthnCredentialByAdminAndCredentialID(ctx context.Context, arg GetWebAuthnCredentialByAdminAndCredentialIDParams) (WebauthnCredential, error)

func (*Queries) GetWebAuthnCredentialByAppAndCredentialID

func (q *Queries) GetWebAuthnCredentialByAppAndCredentialID(ctx context.Context, arg GetWebAuthnCredentialByAppAndCredentialIDParams) (WebauthnCredential, error)

func (*Queries) GetWebAuthnCredentialByCredentialID

func (q *Queries) GetWebAuthnCredentialByCredentialID(ctx context.Context, credentialID []byte) (WebauthnCredential, error)

func (*Queries) GetWebAuthnCredentialByID

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

func (*Queries) GetWebAuthnCredentialsByAdminID

func (q *Queries) GetWebAuthnCredentialsByAdminID(ctx context.Context, adminID pgtype.UUID) ([]WebauthnCredential, error)

func (*Queries) GetWebAuthnCredentialsByUserAndApp

func (q *Queries) GetWebAuthnCredentialsByUserAndApp(ctx context.Context, arg GetWebAuthnCredentialsByUserAndAppParams) ([]WebauthnCredential, error)

func (*Queries) GetWebAuthnCredentialsByUserID

func (q *Queries) GetWebAuthnCredentialsByUserID(ctx context.Context, userID pgtype.UUID) ([]WebauthnCredential, error)

func (*Queries) GetWebhookEndpointByAppAndEvent

func (q *Queries) GetWebhookEndpointByAppAndEvent(ctx context.Context, arg GetWebhookEndpointByAppAndEventParams) (WebhookEndpoint, error)

func (*Queries) GetWebhookEndpointByID

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

func (*Queries) InsertRolePermission

func (q *Queries) InsertRolePermission(ctx context.Context, arg InsertRolePermissionParams) error

func (*Queries) ListAllActiveServerConfigs

func (q *Queries) ListAllActiveServerConfigs(ctx context.Context) ([]EmailServerConfig, error)

func (*Queries) ListAllActivityLogs

func (q *Queries) ListAllActivityLogs(ctx context.Context, arg ListAllActivityLogsParams) ([]ActivityLog, error)

func (*Queries) ListAllAdminAccounts

func (q *Queries) ListAllAdminAccounts(ctx context.Context) ([]AdminAccount, error)

func (*Queries) ListAllApps

func (q *Queries) ListAllApps(ctx context.Context) ([]ListAllAppsRow, error)

============================================================================ Application operations ============================================================================

func (*Queries) ListAllWebhookEndpoints

func (q *Queries) ListAllWebhookEndpoints(ctx context.Context, arg ListAllWebhookEndpointsParams) ([]WebhookEndpoint, error)

func (*Queries) ListOIDCClientsByApp

func (q *Queries) ListOIDCClientsByApp(ctx context.Context, appID uuid.UUID) ([]OidcClient, error)

func (*Queries) ListUserActivityLogs

func (q *Queries) ListUserActivityLogs(ctx context.Context, arg ListUserActivityLogsParams) ([]ActivityLog, error)

func (*Queries) ListWebhookDeliveriesByApp

func (q *Queries) ListWebhookDeliveriesByApp(ctx context.Context, arg ListWebhookDeliveriesByAppParams) ([]WebhookDelivery, error)

func (*Queries) ListWebhookDeliveriesByEndpoint

func (q *Queries) ListWebhookDeliveriesByEndpoint(ctx context.Context, arg ListWebhookDeliveriesByEndpointParams) ([]WebhookDelivery, error)

func (*Queries) ListWebhookEndpointsByApp

func (q *Queries) ListWebhookEndpointsByApp(ctx context.Context, arg ListWebhookEndpointsByAppParams) ([]WebhookEndpoint, error)

func (*Queries) LockUserByEmail

func (q *Queries) LockUserByEmail(ctx context.Context, arg LockUserByEmailParams) (int64, error)

func (*Queries) MarkOIDCAuthCodeUsed

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

func (*Queries) RenameWebAuthnAdminCredential

func (q *Queries) RenameWebAuthnAdminCredential(ctx context.Context, arg RenameWebAuthnAdminCredentialParams) (int64, error)

func (*Queries) RenameWebAuthnCredential

func (q *Queries) RenameWebAuthnCredential(ctx context.Context, arg RenameWebAuthnCredentialParams) (int64, error)

func (*Queries) RestorePreviousTwoFAMethod

func (q *Queries) RestorePreviousTwoFAMethod(ctx context.Context, arg RestorePreviousTwoFAMethodParams) error

func (*Queries) SaveAndSwitchToBackupEmail2FA

func (q *Queries) SaveAndSwitchToBackupEmail2FA(ctx context.Context, arg SaveAndSwitchToBackupEmail2FAParams) error

func (*Queries) SaveOIDCRSAPrivateKey

func (q *Queries) SaveOIDCRSAPrivateKey(ctx context.Context, arg SaveOIDCRSAPrivateKeyParams) error

func (*Queries) SetAdminAccountBackupEmail

func (q *Queries) SetAdminAccountBackupEmail(ctx context.Context, arg SetAdminAccountBackupEmailParams) error

func (*Queries) SetBackupEmail

func (q *Queries) SetBackupEmail(ctx context.Context, arg SetBackupEmailParams) error

func (*Queries) SetPhoneNumber

func (q *Queries) SetPhoneNumber(ctx context.Context, arg SetPhoneNumberParams) error

func (*Queries) SoftDeleteWebhookEndpoint

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

func (*Queries) TouchTrustedDeviceLastUsed

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

func (*Queries) UpdateAdminAccountEmail

func (q *Queries) UpdateAdminAccountEmail(ctx context.Context, arg UpdateAdminAccountEmailParams) error

func (*Queries) UpdateAdminAccountLastLogin

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

func (*Queries) UpdateAdminAccountMagicLinkEnabled

func (q *Queries) UpdateAdminAccountMagicLinkEnabled(ctx context.Context, arg UpdateAdminAccountMagicLinkEnabledParams) error

func (*Queries) UpdateAdminAccountPassword

func (q *Queries) UpdateAdminAccountPassword(ctx context.Context, arg UpdateAdminAccountPasswordParams) error

func (*Queries) UpdateAdminAccountRecoveryCodes

func (q *Queries) UpdateAdminAccountRecoveryCodes(ctx context.Context, arg UpdateAdminAccountRecoveryCodesParams) error

func (*Queries) UpdateEmailType

func (q *Queries) UpdateEmailType(ctx context.Context, arg UpdateEmailTypeParams) error

func (*Queries) UpdateOIDCClient

func (q *Queries) UpdateOIDCClient(ctx context.Context, arg UpdateOIDCClientParams) error

func (*Queries) UpdateRecoveryCodes

func (q *Queries) UpdateRecoveryCodes(ctx context.Context, arg UpdateRecoveryCodesParams) error

func (*Queries) UpdateRole

func (q *Queries) UpdateRole(ctx context.Context, arg UpdateRoleParams) error

func (*Queries) UpdateServerConfig

func (q *Queries) UpdateServerConfig(ctx context.Context, arg UpdateServerConfigParams) error

func (*Queries) UpdateSocialAccount

func (q *Queries) UpdateSocialAccount(ctx context.Context, arg UpdateSocialAccountParams) error

func (*Queries) UpdateSocialAccountTokens

func (q *Queries) UpdateSocialAccountTokens(ctx context.Context, arg UpdateSocialAccountTokensParams) error

func (*Queries) UpdateTemplate

func (q *Queries) UpdateTemplate(ctx context.Context, arg UpdateTemplateParams) error

func (*Queries) UpdateUser

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

func (*Queries) UpdateUserEmail

func (q *Queries) UpdateUserEmail(ctx context.Context, arg UpdateUserEmailParams) error

func (*Queries) UpdateUserEmailVerified

func (q *Queries) UpdateUserEmailVerified(ctx context.Context, arg UpdateUserEmailVerifiedParams) error

func (*Queries) UpdateUserPassword

func (q *Queries) UpdateUserPassword(ctx context.Context, arg UpdateUserPasswordParams) error

func (*Queries) UpdateUserPasswordWithHistory

func (q *Queries) UpdateUserPasswordWithHistory(ctx context.Context, arg UpdateUserPasswordWithHistoryParams) error

func (*Queries) UpdateUserProfile

func (q *Queries) UpdateUserProfile(ctx context.Context, arg UpdateUserProfileParams) error

func (*Queries) UpdateWebAuthnCredentialSignCount

func (q *Queries) UpdateWebAuthnCredentialSignCount(ctx context.Context, arg UpdateWebAuthnCredentialSignCountParams) error

func (*Queries) UpdateWebhookEndpointActive

func (q *Queries) UpdateWebhookEndpointActive(ctx context.Context, arg UpdateWebhookEndpointActiveParams) error

func (*Queries) UpsertSetting

func (q *Queries) UpsertSetting(ctx context.Context, arg UpsertSettingParams) error

func (*Queries) VerifyBackupEmail

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

func (*Queries) VerifyPhoneNumber

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

func (*Queries) WithTx

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

type RenameWebAuthnAdminCredentialParams

type RenameWebAuthnAdminCredentialParams struct {
	ID      uuid.UUID   `json:"id"`
	AdminID pgtype.UUID `json:"admin_id"`
	Name    *string     `json:"name"`
}

type RenameWebAuthnCredentialParams

type RenameWebAuthnCredentialParams struct {
	ID     uuid.UUID   `json:"id"`
	UserID pgtype.UUID `json:"user_id"`
	Name   *string     `json:"name"`
}

type RestorePreviousTwoFAMethodParams

type RestorePreviousTwoFAMethodParams struct {
	ID           uuid.UUID `json:"id"`
	TwoFaMethod  string    `json:"two_fa_method"`
	TwoFaSecret  string    `json:"two_fa_secret"`
	TwoFaEnabled bool      `json:"two_fa_enabled"`
}

type Role

type Role struct {
	ID          uuid.UUID `json:"id"`
	AppID       uuid.UUID `json:"app_id"`
	Name        string    `json:"name"`
	Description *string   `json:"description"`
	IsSystem    bool      `json:"is_system"`
	CreatedAt   time.Time `json:"created_at"`
	UpdatedAt   time.Time `json:"updated_at"`
}

type RolePermission

type RolePermission struct {
	RoleID       uuid.UUID `json:"role_id"`
	PermissionID uuid.UUID `json:"permission_id"`
}

type SaveAndSwitchToBackupEmail2FAParams

type SaveAndSwitchToBackupEmail2FAParams struct {
	ID                  uuid.UUID       `json:"id"`
	TwoFaPreviousMethod string          `json:"two_fa_previous_method"`
	TwoFaPreviousSecret string          `json:"two_fa_previous_secret"`
	TwoFaRecoveryCodes  json.RawMessage `json:"two_fa_recovery_codes"`
}

type SaveOIDCRSAPrivateKeyParams

type SaveOIDCRSAPrivateKeyParams struct {
	ID                uuid.UUID `json:"id"`
	OidcRsaPrivateKey string    `json:"oidc_rsa_private_key"`
}

type SchemaMigration

type SchemaMigration struct {
	ID              int32     `json:"id"`
	Version         string    `json:"version"`
	Name            string    `json:"name"`
	AppliedAt       time.Time `json:"applied_at"`
	ExecutionTimeMs *int32    `json:"execution_time_ms"`
	Success         bool      `json:"success"`
	ErrorMessage    *string   `json:"error_message"`
	Checksum        *string   `json:"checksum"`
}

type SessionGroup

type SessionGroup struct {
	ID           uuid.UUID `json:"id"`
	TenantID     uuid.UUID `json:"tenant_id"`
	Name         string    `json:"name"`
	Description  string    `json:"description"`
	GlobalLogout bool      `json:"global_logout"`
	CreatedAt    time.Time `json:"created_at"`
	UpdatedAt    time.Time `json:"updated_at"`
}

type SessionGroupApp

type SessionGroupApp struct {
	SessionGroupID uuid.UUID `json:"session_group_id"`
	AppID          uuid.UUID `json:"app_id"`
	AddedAt        time.Time `json:"added_at"`
}

type SetAdminAccountBackupEmailParams

type SetAdminAccountBackupEmailParams struct {
	ID          uuid.UUID `json:"id"`
	BackupEmail string    `json:"backup_email"`
}

type SetBackupEmailParams

type SetBackupEmailParams struct {
	ID          uuid.UUID `json:"id"`
	BackupEmail string    `json:"backup_email"`
}

type SetPhoneNumberParams

type SetPhoneNumberParams struct {
	ID          uuid.UUID `json:"id"`
	PhoneNumber string    `json:"phone_number"`
}

type SocialAccount

type SocialAccount struct {
	ID             uuid.UUID          `json:"id"`
	AppID          uuid.UUID          `json:"app_id"`
	UserID         uuid.UUID          `json:"user_id"`
	Provider       string             `json:"provider"`
	ProviderUserID string             `json:"provider_user_id"`
	Email          string             `json:"email"`
	Name           string             `json:"name"`
	FirstName      string             `json:"first_name"`
	LastName       string             `json:"last_name"`
	ProfilePicture string             `json:"profile_picture"`
	Username       string             `json:"username"`
	Locale         string             `json:"locale"`
	RawData        []byte             `json:"raw_data"`
	AccessToken    string             `json:"access_token"`
	RefreshToken   string             `json:"refresh_token"`
	ExpiresAt      pgtype.Timestamptz `json:"expires_at"`
	CreatedAt      time.Time          `json:"created_at"`
	UpdatedAt      time.Time          `json:"updated_at"`
}

type SystemSetting

type SystemSetting struct {
	Key       string    `json:"key"`
	Value     string    `json:"value"`
	Category  string    `json:"category"`
	UpdatedAt time.Time `json:"updated_at"`
}

type Tenant

type Tenant struct {
	ID        uuid.UUID `json:"id"`
	Name      string    `json:"name"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type TrustedDevice

type TrustedDevice struct {
	ID         uuid.UUID `json:"id"`
	UserID     uuid.UUID `json:"user_id"`
	AppID      uuid.UUID `json:"app_id"`
	TokenHash  string    `json:"token_hash"`
	Name       *string   `json:"name"`
	UserAgent  *string   `json:"user_agent"`
	IpAddress  *string   `json:"ip_address"`
	LastUsedAt time.Time `json:"last_used_at"`
	ExpiresAt  time.Time `json:"expires_at"`
	CreatedAt  time.Time `json:"created_at"`
}

type UpdateAdminAccountEmailParams

type UpdateAdminAccountEmailParams struct {
	ID    uuid.UUID `json:"id"`
	Email *string   `json:"email"`
}

type UpdateAdminAccountMagicLinkEnabledParams

type UpdateAdminAccountMagicLinkEnabledParams struct {
	ID               uuid.UUID `json:"id"`
	MagicLinkEnabled bool      `json:"magic_link_enabled"`
}

type UpdateAdminAccountPasswordParams

type UpdateAdminAccountPasswordParams struct {
	ID           uuid.UUID `json:"id"`
	PasswordHash string    `json:"password_hash"`
}

type UpdateAdminAccountRecoveryCodesParams

type UpdateAdminAccountRecoveryCodesParams struct {
	ID                 uuid.UUID `json:"id"`
	TwoFaRecoveryCodes []byte    `json:"two_fa_recovery_codes"`
}

type UpdateEmailTypeParams

type UpdateEmailTypeParams struct {
	ID             uuid.UUID `json:"id"`
	Code           string    `json:"code"`
	Name           string    `json:"name"`
	Description    *string   `json:"description"`
	DefaultSubject *string   `json:"default_subject"`
	Variables      []byte    `json:"variables"`
	IsSystem       bool      `json:"is_system"`
	IsActive       bool      `json:"is_active"`
	UpdatedAt      time.Time `json:"updated_at"`
}

type UpdateOIDCClientParams

type UpdateOIDCClientParams struct {
	ID                uuid.UUID `json:"id"`
	AppID             uuid.UUID `json:"app_id"`
	Name              string    `json:"name"`
	Description       string    `json:"description"`
	ClientID          string    `json:"client_id"`
	ClientSecretHash  string    `json:"client_secret_hash"`
	RedirectUris      string    `json:"redirect_uris"`
	AllowedGrantTypes string    `json:"allowed_grant_types"`
	AllowedScopes     string    `json:"allowed_scopes"`
	RequireConsent    bool      `json:"require_consent"`
	IsConfidential    bool      `json:"is_confidential"`
	PkceRequired      bool      `json:"pkce_required"`
	IsActive          bool      `json:"is_active"`
	LogoUrl           string    `json:"logo_url"`
	LoginTheme        string    `json:"login_theme"`
	LoginPrimaryColor string    `json:"login_primary_color"`
}

type UpdateRecoveryCodesParams

type UpdateRecoveryCodesParams struct {
	ID                 uuid.UUID       `json:"id"`
	TwoFaRecoveryCodes json.RawMessage `json:"two_fa_recovery_codes"`
}

type UpdateRoleParams

type UpdateRoleParams struct {
	ID          uuid.UUID `json:"id"`
	Name        string    `json:"name"`
	Description *string   `json:"description"`
}

type UpdateServerConfigParams

type UpdateServerConfigParams struct {
	ID           uuid.UUID   `json:"id"`
	AppID        pgtype.UUID `json:"app_id"`
	Name         string      `json:"name"`
	SmtpHost     string      `json:"smtp_host"`
	SmtpPort     int32       `json:"smtp_port"`
	SmtpUsername *string     `json:"smtp_username"`
	SmtpPassword *string     `json:"smtp_password"`
	FromAddress  string      `json:"from_address"`
	FromName     *string     `json:"from_name"`
	UseTls       bool        `json:"use_tls"`
	IsActive     bool        `json:"is_active"`
	IsDefault    bool        `json:"is_default"`
	UpdatedAt    time.Time   `json:"updated_at"`
}

type UpdateSocialAccountParams

type UpdateSocialAccountParams struct {
	ID             uuid.UUID          `json:"id"`
	AppID          uuid.UUID          `json:"app_id"`
	UserID         uuid.UUID          `json:"user_id"`
	Provider       string             `json:"provider"`
	ProviderUserID string             `json:"provider_user_id"`
	Email          string             `json:"email"`
	Name           string             `json:"name"`
	FirstName      string             `json:"first_name"`
	LastName       string             `json:"last_name"`
	ProfilePicture string             `json:"profile_picture"`
	Username       string             `json:"username"`
	Locale         string             `json:"locale"`
	RawData        []byte             `json:"raw_data"`
	AccessToken    string             `json:"access_token"`
	RefreshToken   string             `json:"refresh_token"`
	ExpiresAt      pgtype.Timestamptz `json:"expires_at"`
}

type UpdateSocialAccountTokensParams

type UpdateSocialAccountTokensParams struct {
	ID           uuid.UUID `json:"id"`
	AccessToken  string    `json:"access_token"`
	RefreshToken string    `json:"refresh_token"`
}

type UpdateTemplateParams

type UpdateTemplateParams struct {
	ID             uuid.UUID   `json:"id"`
	AppID          pgtype.UUID `json:"app_id"`
	EmailTypeID    uuid.UUID   `json:"email_type_id"`
	ServerConfigID pgtype.UUID `json:"server_config_id"`
	Name           string      `json:"name"`
	Subject        string      `json:"subject"`
	BodyHtml       *string     `json:"body_html"`
	BodyText       *string     `json:"body_text"`
	FromEmail      *string     `json:"from_email"`
	FromName       *string     `json:"from_name"`
	TemplateEngine string      `json:"template_engine"`
	IsActive       bool        `json:"is_active"`
	UpdatedAt      time.Time   `json:"updated_at"`
}

type UpdateUserEmailParams

type UpdateUserEmailParams struct {
	ID    uuid.UUID `json:"id"`
	Email string    `json:"email"`
}

type UpdateUserEmailVerifiedParams

type UpdateUserEmailVerifiedParams struct {
	ID            uuid.UUID `json:"id"`
	EmailVerified bool      `json:"email_verified"`
}

type UpdateUserParams

type UpdateUserParams struct {
	ID                  uuid.UUID          `json:"id"`
	AppID               uuid.UUID          `json:"app_id"`
	Email               string             `json:"email"`
	PasswordHash        string             `json:"password_hash"`
	EmailVerified       bool               `json:"email_verified"`
	IsActive            bool               `json:"is_active"`
	Name                string             `json:"name"`
	FirstName           string             `json:"first_name"`
	LastName            string             `json:"last_name"`
	ProfilePicture      string             `json:"profile_picture"`
	Locale              string             `json:"locale"`
	TwoFaEnabled        bool               `json:"two_fa_enabled"`
	TwoFaMethod         string             `json:"two_fa_method"`
	TwoFaSecret         string             `json:"two_fa_secret"`
	TwoFaRecoveryCodes  json.RawMessage    `json:"two_fa_recovery_codes"`
	BackupEmail         string             `json:"backup_email"`
	BackupEmailVerified bool               `json:"backup_email_verified"`
	TwoFaPreviousMethod string             `json:"two_fa_previous_method"`
	TwoFaPreviousSecret string             `json:"two_fa_previous_secret"`
	PhoneNumber         string             `json:"phone_number"`
	PhoneVerified       bool               `json:"phone_verified"`
	LockedAt            pgtype.Timestamptz `json:"locked_at"`
	LockReason          string             `json:"lock_reason"`
	LockExpiresAt       pgtype.Timestamptz `json:"lock_expires_at"`
	PasswordHistory     []byte             `json:"password_history"`
	PasswordChangedAt   pgtype.Timestamptz `json:"password_changed_at"`
}

type UpdateUserPasswordParams

type UpdateUserPasswordParams struct {
	ID           uuid.UUID `json:"id"`
	PasswordHash string    `json:"password_hash"`
}

type UpdateUserPasswordWithHistoryParams

type UpdateUserPasswordWithHistoryParams struct {
	ID                uuid.UUID          `json:"id"`
	PasswordHash      string             `json:"password_hash"`
	PasswordHistory   []byte             `json:"password_history"`
	PasswordChangedAt pgtype.Timestamptz `json:"password_changed_at"`
}

type UpdateUserProfileParams

type UpdateUserProfileParams struct {
	ID             uuid.UUID `json:"id"`
	Name           string    `json:"name"`
	FirstName      string    `json:"first_name"`
	LastName       string    `json:"last_name"`
	ProfilePicture string    `json:"profile_picture"`
	Locale         string    `json:"locale"`
}

type UpdateWebAuthnCredentialSignCountParams

type UpdateWebAuthnCredentialSignCountParams struct {
	ID        uuid.UUID `json:"id"`
	SignCount int32     `json:"sign_count"`
}

type UpdateWebhookEndpointActiveParams

type UpdateWebhookEndpointActiveParams struct {
	ID       uuid.UUID `json:"id"`
	IsActive bool      `json:"is_active"`
}

type UpsertSettingParams

type UpsertSettingParams struct {
	Key      string `json:"key"`
	Value    string `json:"value"`
	Category string `json:"category"`
}

type User

type User struct {
	ID                  uuid.UUID          `json:"id"`
	AppID               uuid.UUID          `json:"app_id"`
	Email               string             `json:"email"`
	PasswordHash        string             `json:"password_hash"`
	EmailVerified       bool               `json:"email_verified"`
	IsActive            bool               `json:"is_active"`
	Name                string             `json:"name"`
	FirstName           string             `json:"first_name"`
	LastName            string             `json:"last_name"`
	ProfilePicture      string             `json:"profile_picture"`
	Locale              string             `json:"locale"`
	TwoFaEnabled        bool               `json:"two_fa_enabled"`
	TwoFaMethod         string             `json:"two_fa_method"`
	TwoFaSecret         string             `json:"two_fa_secret"`
	TwoFaRecoveryCodes  json.RawMessage    `json:"two_fa_recovery_codes"`
	BackupEmail         string             `json:"backup_email"`
	BackupEmailVerified bool               `json:"backup_email_verified"`
	TwoFaPreviousMethod string             `json:"two_fa_previous_method"`
	TwoFaPreviousSecret string             `json:"two_fa_previous_secret"`
	PhoneNumber         string             `json:"phone_number"`
	PhoneVerified       bool               `json:"phone_verified"`
	LockedAt            pgtype.Timestamptz `json:"locked_at"`
	LockReason          string             `json:"lock_reason"`
	LockExpiresAt       pgtype.Timestamptz `json:"lock_expires_at"`
	PasswordHistory     []byte             `json:"password_history"`
	PasswordChangedAt   pgtype.Timestamptz `json:"password_changed_at"`
	CreatedAt           time.Time          `json:"created_at"`
	UpdatedAt           time.Time          `json:"updated_at"`
}

type UserRole

type UserRole struct {
	UserID     uuid.UUID   `json:"user_id"`
	RoleID     uuid.UUID   `json:"role_id"`
	AppID      uuid.UUID   `json:"app_id"`
	AssignedAt time.Time   `json:"assigned_at"`
	AssignedBy pgtype.UUID `json:"assigned_by"`
}

type WebauthnCredential

type WebauthnCredential struct {
	ID              uuid.UUID          `json:"id"`
	UserID          pgtype.UUID        `json:"user_id"`
	AppID           pgtype.UUID        `json:"app_id"`
	AdminID         pgtype.UUID        `json:"admin_id"`
	CredentialID    []byte             `json:"credential_id"`
	PublicKey       []byte             `json:"public_key"`
	AttestationType *string            `json:"attestation_type"`
	Aaguid          []byte             `json:"aaguid"`
	SignCount       int32              `json:"sign_count"`
	Name            *string            `json:"name"`
	Transports      *string            `json:"transports"`
	BackupEligible  bool               `json:"backup_eligible"`
	BackupState     bool               `json:"backup_state"`
	LastUsedAt      pgtype.Timestamptz `json:"last_used_at"`
	CreatedAt       time.Time          `json:"created_at"`
}

type WebhookDelivery

type WebhookDelivery struct {
	ID           uuid.UUID          `json:"id"`
	EndpointID   uuid.UUID          `json:"endpoint_id"`
	AppID        uuid.UUID          `json:"app_id"`
	EventType    string             `json:"event_type"`
	Payload      string             `json:"payload"`
	Attempt      int32              `json:"attempt"`
	StatusCode   *int32             `json:"status_code"`
	ResponseBody *string            `json:"response_body"`
	LatencyMs    *int64             `json:"latency_ms"`
	Success      bool               `json:"success"`
	ErrorMessage *string            `json:"error_message"`
	NextRetryAt  pgtype.Timestamptz `json:"next_retry_at"`
	CreatedAt    time.Time          `json:"created_at"`
}

type WebhookEndpoint

type WebhookEndpoint struct {
	ID        uuid.UUID          `json:"id"`
	AppID     uuid.UUID          `json:"app_id"`
	EventType string             `json:"event_type"`
	Url       string             `json:"url"`
	Secret    string             `json:"secret"`
	IsActive  bool               `json:"is_active"`
	CreatedAt time.Time          `json:"created_at"`
	UpdatedAt time.Time          `json:"updated_at"`
	DeletedAt pgtype.Timestamptz `json:"deleted_at"`
}

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL