db

type AuditLog struct {
	ID           pgtype.UUID        `json:"id"`
	UserID       pgtype.UUID        `json:"user_id"`
	Action       string             `json:"action"`
	ResourceType string             `json:"resource_type"`
	ResourceID   pgtype.UUID        `json:"resource_id"`
	Metadata     []byte             `json:"metadata"`
	IpAddress    *netip.Addr        `json:"ip_address"`
	UserAgent    pgtype.Text        `json:"user_agent"`
	Timestamp    pgtype.Timestamptz `json:"timestamp"`
}

type BackupRecoveryCode struct {
	ID                  pgtype.UUID        `json:"id"`
	UserID              pgtype.UUID        `json:"user_id"`
	EncryptedBackupData []byte             `json:"encrypted_backup_data"`
	RecoveryCodeHash    []byte             `json:"recovery_code_hash"`
	IsUsed              pgtype.Bool        `json:"is_used"`
	CreatedAt           pgtype.Timestamptz `json:"created_at"`
	UsedAt              pgtype.Timestamptz `json:"used_at"`
}

type CreateAuditLogParams struct {
	UserID       pgtype.UUID `json:"user_id"`
	Action       string      `json:"action"`
	ResourceType string      `json:"resource_type"`
	ResourceID   pgtype.UUID `json:"resource_id"`
	Metadata     []byte      `json:"metadata"`
	IpAddress    *netip.Addr `json:"ip_address"`
	UserAgent    pgtype.Text `json:"user_agent"`
}

type CreateBackupRecoveryCodeParams struct {
	UserID              pgtype.UUID `json:"user_id"`
	EncryptedBackupData []byte      `json:"encrypted_backup_data"`
	RecoveryCodeHash    []byte      `json:"recovery_code_hash"`
}

type CreateDeviceSessionParams struct {
	UserID            pgtype.UUID `json:"user_id"`
	DeviceFingerprint string      `json:"device_fingerprint"`
	DeviceName        pgtype.Text `json:"device_name"`
}

type CreateEncryptedTOTPSeedParams struct {
	UserID            pgtype.UUID `json:"user_id"`
	ServiceName       string      `json:"service_name"`
	AccountIdentifier string      `json:"account_identifier"`
	EncryptedSecret   []byte      `json:"encrypted_secret"`
	Algorithm         string      `json:"algorithm"`
	Digits            int32       `json:"digits"`
	Period            int32       `json:"period"`
	Issuer            pgtype.Text `json:"issuer"`
	IconUrl           pgtype.Text `json:"icon_url"`
	IsActive          pgtype.Bool `json:"is_active"`
}

type CreateSyncOperationParams struct {
	UserID            pgtype.UUID `json:"user_id"`
	OperationType     string      `json:"operation_type"`
	EntityType        string      `json:"entity_type"`
	EntityID          pgtype.UUID `json:"entity_id"`
	OperationData     []byte      `json:"operation_data"`
	DeviceFingerprint string      `json:"device_fingerprint"`
}

type CreateUserEncryptionKeyParams struct {
	UserID               pgtype.UUID `json:"user_id"`
	WebauthnCredentialID pgtype.UUID `json:"webauthn_credential_id"`
	EncryptedDek         []byte      `json:"encrypted_dek"`
	KeyVersion           int32       `json:"key_version"`
}

type CreateUserParams struct {
	Username    string `json:"username"`
	Email       string `json:"email"`
	DisplayName string `json:"display_name"`
}

type CreateWebAuthnCredentialParams struct {
	UserID          pgtype.UUID `json:"user_id"`
	CredentialID    []byte      `json:"credential_id"`
	PublicKey       []byte      `json:"public_key"`
	AttestationType string      `json:"attestation_type"`
	Transport       []string    `json:"transport"`
	Flags           []byte      `json:"flags"`
	Authenticator   []byte      `json:"authenticator"`
	DeviceName      pgtype.Text `json:"device_name"`
	Aaguid          pgtype.UUID `json:"aaguid"`
	CloneWarning    bool        `json:"clone_warning"`
	SignCount       int64       `json:"sign_count"`
	Attachment      pgtype.Text `json:"attachment"`
	BackupEligible  bool        `json:"backup_eligible"`
	BackupState     bool        `json:"backup_state"`
}

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 DeleteEncryptedTOTPSeedParams struct {
	ID     pgtype.UUID `json:"id"`
	UserID pgtype.UUID `json:"user_id"`
}

type DeleteWebAuthnCredentialParams struct {
	CredentialID []byte      `json:"credential_id"`
	UserID       pgtype.UUID `json:"user_id"`
}

type DeviceSession struct {
	ID                pgtype.UUID        `json:"id"`
	UserID            pgtype.UUID        `json:"user_id"`
	DeviceFingerprint string             `json:"device_fingerprint"`
	DeviceName        pgtype.Text        `json:"device_name"`
	LastSyncAt        pgtype.Timestamptz `json:"last_sync_at"`
	CreatedAt         pgtype.Timestamptz `json:"created_at"`
}

type EncryptedTotpSeed struct {
	ID                pgtype.UUID        `json:"id"`
	UserID            pgtype.UUID        `json:"user_id"`
	ServiceName       string             `json:"service_name"`
	AccountIdentifier string             `json:"account_identifier"`
	EncryptedSecret   []byte             `json:"encrypted_secret"`
	Algorithm         string             `json:"algorithm"`
	Digits            int32              `json:"digits"`
	Period            int32              `json:"period"`
	Issuer            pgtype.Text        `json:"issuer"`
	IconUrl           pgtype.Text        `json:"icon_url"`
	IsActive          pgtype.Bool        `json:"is_active"`
	CreatedAt         pgtype.Timestamptz `json:"created_at"`
	UpdatedAt         pgtype.Timestamptz `json:"updated_at"`
}

type GetAuditLogsByActionParams struct {
	Action      string             `json:"action"`
	Timestamp   pgtype.Timestamptz `json:"timestamp"`
	Timestamp_2 pgtype.Timestamptz `json:"timestamp_2"`
	Limit       int32              `json:"limit"`
	Offset      int32              `json:"offset"`
}

type GetAuditLogsByUserIDParams struct {
	UserID pgtype.UUID `json:"user_id"`
	Limit  int32       `json:"limit"`
	Offset int32       `json:"offset"`
}

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

type GetDeviceSessionParams struct {
	UserID            pgtype.UUID `json:"user_id"`
	DeviceFingerprint string      `json:"device_fingerprint"`
}

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

type GetEncryptedTOTPSeedsByUserIDSinceParams struct {
	UserID    pgtype.UUID        `json:"user_id"`
	UpdatedAt pgtype.Timestamptz `json:"updated_at"`
}

type GetRecentAuditLogsParams struct {
	Timestamp pgtype.Timestamptz `json:"timestamp"`
	Limit     int32              `json:"limit"`
	Offset    int32              `json:"offset"`
}

type GetRecentAuditLogsRow struct {
	ID           pgtype.UUID        `json:"id"`
	UserID       pgtype.UUID        `json:"user_id"`
	Action       string             `json:"action"`
	ResourceType string             `json:"resource_type"`
	ResourceID   pgtype.UUID        `json:"resource_id"`
	Metadata     []byte             `json:"metadata"`
	IpAddress    *netip.Addr        `json:"ip_address"`
	UserAgent    pgtype.Text        `json:"user_agent"`
	Timestamp    pgtype.Timestamptz `json:"timestamp"`
	Username     pgtype.Text        `json:"username"`
	Email        pgtype.Text        `json:"email"`
}

type GetSyncOperationsSinceParams struct {
	UserID    pgtype.UUID        `json:"user_id"`
	Timestamp pgtype.Timestamptz `json:"timestamp"`
}

type GetSyncOperationsSinceRow struct {
	ID                pgtype.UUID        `json:"id"`
	UserID            pgtype.UUID        `json:"user_id"`
	OperationType     string             `json:"operation_type"`
	EntityType        string             `json:"entity_type"`
	EntityID          pgtype.UUID        `json:"entity_id"`
	OperationData     []byte             `json:"operation_data"`
	DeviceFingerprint string             `json:"device_fingerprint"`
	Timestamp         pgtype.Timestamptz `json:"timestamp"`
	DeviceName        pgtype.Text        `json:"device_name"`
}

type GetUserEncryptionKeyByCredentialParams struct {
	UserID               pgtype.UUID `json:"user_id"`
	WebauthnCredentialID pgtype.UUID `json:"webauthn_credential_id"`
}

type GetUserEncryptionKeyByVersionParams struct {
	UserID     pgtype.UUID `json:"user_id"`
	KeyVersion int32       `json:"key_version"`
}

type LinkingCode struct {
	ID        pgtype.UUID        `json:"id"`
	UserID    pgtype.UUID        `json:"user_id"`
	Code      string             `json:"code"`
	IsUsed    bool               `json:"is_used"`
	ExpiresAt time.Time          `json:"expires_at"`
	UsedAt    pgtype.Timestamptz `json:"used_at"`
	CreatedAt time.Time          `json:"created_at"`
	UpdatedAt time.Time          `json:"updated_at"`
}

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

type Querier interface {
	CountUsers(ctx context.Context) (int64, error)
	CreateAuditLog(ctx context.Context, arg CreateAuditLogParams) (AuditLog, error)
	CreateBackupRecoveryCode(ctx context.Context, arg CreateBackupRecoveryCodeParams) (BackupRecoveryCode, error)
	CreateDeviceSession(ctx context.Context, arg CreateDeviceSessionParams) (DeviceSession, error)
	CreateEncryptedTOTPSeed(ctx context.Context, arg CreateEncryptedTOTPSeedParams) (EncryptedTotpSeed, error)
	CreateSyncOperation(ctx context.Context, arg CreateSyncOperationParams) (SyncOperation, error)
	CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
	CreateUserEncryptionKey(ctx context.Context, arg CreateUserEncryptionKeyParams) (UserEncryptionKey, error)
	CreateWebAuthnCredential(ctx context.Context, arg CreateWebAuthnCredentialParams) (WebauthnCredential, error)
	DeactivateUser(ctx context.Context, id pgtype.UUID) error
	DeleteEncryptedTOTPSeed(ctx context.Context, arg DeleteEncryptedTOTPSeedParams) error
	DeleteUser(ctx context.Context, id pgtype.UUID) error
	DeleteWebAuthnCredential(ctx context.Context, arg DeleteWebAuthnCredentialParams) error
	GetActiveBackupRecoveryCode(ctx context.Context, userID pgtype.UUID) (BackupRecoveryCode, error)
	GetActiveDeviceSessionsByUserID(ctx context.Context, userID pgtype.UUID) ([]DeviceSession, error)
	GetActiveUserEncryptionKey(ctx context.Context, userID pgtype.UUID) (UserEncryptionKey, error)
	GetAuditLogsByAction(ctx context.Context, arg GetAuditLogsByActionParams) ([]AuditLog, error)
	GetAuditLogsByUserID(ctx context.Context, arg GetAuditLogsByUserIDParams) ([]AuditLog, error)
	GetBackupRecoveryCodeByID(ctx context.Context, arg GetBackupRecoveryCodeByIDParams) (BackupRecoveryCode, error)
	GetDeviceSession(ctx context.Context, arg GetDeviceSessionParams) (DeviceSession, error)
	GetEncryptedTOTPSeedByID(ctx context.Context, arg GetEncryptedTOTPSeedByIDParams) (EncryptedTotpSeed, error)
	GetEncryptedTOTPSeedsByUserID(ctx context.Context, userID pgtype.UUID) ([]EncryptedTotpSeed, error)
	GetEncryptedTOTPSeedsByUserIDSince(ctx context.Context, arg GetEncryptedTOTPSeedsByUserIDSinceParams) ([]EncryptedTotpSeed, error)
	GetLatestSyncTimestamp(ctx context.Context, userID pgtype.UUID) (interface{}, error)
	GetRecentAuditLogs(ctx context.Context, arg GetRecentAuditLogsParams) ([]GetRecentAuditLogsRow, error)
	GetSyncOperationsSince(ctx context.Context, arg GetSyncOperationsSinceParams) ([]GetSyncOperationsSinceRow, error)
	GetTOTPSeedsCountByUser(ctx context.Context, userID pgtype.UUID) (int64, error)
	GetUserByEmail(ctx context.Context, email string) (User, error)
	GetUserByID(ctx context.Context, id pgtype.UUID) (User, error)
	GetUserByUsername(ctx context.Context, username string) (User, error)
	GetUserEncryptionKeyByCredential(ctx context.Context, arg GetUserEncryptionKeyByCredentialParams) (UserEncryptionKey, error)
	GetUserEncryptionKeyByVersion(ctx context.Context, arg GetUserEncryptionKeyByVersionParams) (UserEncryptionKey, error)
	GetUserEncryptionKeys(ctx context.Context, userID pgtype.UUID) ([]UserEncryptionKey, error)
	GetWebAuthnCredentialByID(ctx context.Context, credentialID []byte) (WebauthnCredential, error)
	GetWebAuthnCredentialsByUserID(ctx context.Context, userID pgtype.UUID) ([]WebauthnCredential, error)
	ListUsers(ctx context.Context, arg ListUsersParams) ([]User, error)
	SearchEncryptedTOTPSeeds(ctx context.Context, arg SearchEncryptedTOTPSeedsParams) ([]EncryptedTotpSeed, error)
	UpdateDeviceSessionLastSync(ctx context.Context, arg UpdateDeviceSessionLastSyncParams) error
	UpdateEncryptedTOTPSeed(ctx context.Context, arg UpdateEncryptedTOTPSeedParams) (EncryptedTotpSeed, error)
	UpdateTOTPSeedSyncTimestamp(ctx context.Context, arg UpdateTOTPSeedSyncTimestampParams) error
	UpdateUser(ctx context.Context, arg UpdateUserParams) (User, error)
	UpdateUserLastLogin(ctx context.Context, id pgtype.UUID) error
	UpdateWebAuthnCredentialCloneWarning(ctx context.Context, arg UpdateWebAuthnCredentialCloneWarningParams) error
	UpdateWebAuthnCredentialLastUsed(ctx context.Context, credentialID []byte) error
	UpdateWebAuthnCredentialSignCount(ctx context.Context, arg UpdateWebAuthnCredentialSignCountParams) error
	UseBackupRecoveryCode(ctx context.Context, arg UseBackupRecoveryCodeParams) error
}

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

type SearchEncryptedTOTPSeedsParams struct {
	UserID  pgtype.UUID `json:"user_id"`
	Column2 pgtype.Text `json:"column_2"`
}

type SyncOperation struct {
	ID                pgtype.UUID        `json:"id"`
	UserID            pgtype.UUID        `json:"user_id"`
	OperationType     string             `json:"operation_type"`
	EntityType        string             `json:"entity_type"`
	EntityID          pgtype.UUID        `json:"entity_id"`
	OperationData     []byte             `json:"operation_data"`
	DeviceFingerprint string             `json:"device_fingerprint"`
	Timestamp         pgtype.Timestamptz `json:"timestamp"`
}

type UpdateDeviceSessionLastSyncParams struct {
	UserID            pgtype.UUID `json:"user_id"`
	DeviceFingerprint string      `json:"device_fingerprint"`
}

type UpdateEncryptedTOTPSeedParams struct {
	ID                pgtype.UUID `json:"id"`
	UserID            pgtype.UUID `json:"user_id"`
	ServiceName       pgtype.Text `json:"service_name"`
	AccountIdentifier pgtype.Text `json:"account_identifier"`
	EncryptedSecret   []byte      `json:"encrypted_secret"`
	Algorithm         pgtype.Text `json:"algorithm"`
	Digits            pgtype.Int4 `json:"digits"`
	Period            pgtype.Int4 `json:"period"`
	Issuer            pgtype.Text `json:"issuer"`
	IconUrl           pgtype.Text `json:"icon_url"`
}

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

type UpdateUserParams struct {
	ID          pgtype.UUID `json:"id"`
	Username    string      `json:"username"`
	Email       string      `json:"email"`
	DisplayName string      `json:"display_name"`
}

type UpdateWebAuthnCredentialCloneWarningParams struct {
	CredentialID []byte `json:"credential_id"`
	CloneWarning bool   `json:"clone_warning"`
}

type UpdateWebAuthnCredentialSignCountParams struct {
	CredentialID []byte `json:"credential_id"`
	SignCount    int64  `json:"sign_count"`
}

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

type User struct {
	ID          pgtype.UUID        `json:"id"`
	Username    string             `json:"username"`
	Email       string             `json:"email"`
	DisplayName string             `json:"display_name"`
	CreatedAt   pgtype.Timestamptz `json:"created_at"`
	UpdatedAt   pgtype.Timestamptz `json:"updated_at"`
	LastLoginAt pgtype.Timestamptz `json:"last_login_at"`
	IsActive    pgtype.Bool        `json:"is_active"`
}

type UserEncryptionKey struct {
	ID                   pgtype.UUID        `json:"id"`
	UserID               pgtype.UUID        `json:"user_id"`
	WebauthnCredentialID pgtype.UUID        `json:"webauthn_credential_id"`
	EncryptedDek         []byte             `json:"encrypted_dek"`
	KeyVersion           int32              `json:"key_version"`
	CreatedAt            pgtype.Timestamptz `json:"created_at"`
}

type WebauthnCredential struct {
	ID              pgtype.UUID        `json:"id"`
	UserID          pgtype.UUID        `json:"user_id"`
	CredentialID    []byte             `json:"credential_id"`
	PublicKey       []byte             `json:"public_key"`
	AttestationType string             `json:"attestation_type"`
	Transport       []string           `json:"transport"`
	Flags           []byte             `json:"flags"`
	Authenticator   []byte             `json:"authenticator"`
	DeviceName      pgtype.Text        `json:"device_name"`
	CreatedAt       pgtype.Timestamptz `json:"created_at"`
	LastUsedAt      pgtype.Timestamptz `json:"last_used_at"`
	Aaguid          pgtype.UUID        `json:"aaguid"`
	CloneWarning    bool               `json:"clone_warning"`
	SignCount       int64              `json:"sign_count"`
	Attachment      pgtype.Text        `json:"attachment"`
	BackupEligible  bool               `json:"backup_eligible"`
	BackupState     bool               `json:"backup_state"`
}