db

type ActOnInvitationParams struct {
	Accept bool      `db:"accept" json:"accept"`
	ID     uuid.UUID `db:"id" json:"id"`
}

type AddMFAFactorParams struct {
	ID         uuid.UUID `db:"id" json:"id"`
	UserID     uuid.UUID `db:"user_id" json:"userId"`
	FactorType MfaType   `db:"factor_type" json:"factorType"`
	Name       string    `db:"name" json:"name"`
	Secret     string    `db:"secret" json:"secret"`
	Verified   *bool     `db:"verified" json:"verified"`
}

type AddUserToOrgParams struct {
	UserID     uuid.UUID `db:"user_id" json:"userId"`
	OrgID      uuid.UUID `db:"org_id" json:"orgId"`
	IsOrgAdmin bool      `db:"is_org_admin" json:"isOrgAdmin"`
}

type AssignRolesToUsersInOrgParams struct {
	OrgID   uuid.UUID   `db:"org_id" json:"orgId"`
	RoleIds []uuid.UUID `db:"role_ids" json:"roleIds"`
	UserIds []uuid.UUID `db:"user_ids" json:"userIds"`
}

type AuditLog struct {
	ID        uuid.UUID   `db:"id" json:"id"`
	OrgID     *uuid.UUID  `db:"org_id" json:"orgId"`
	Actor     string      `db:"actor" json:"actor"`
	LogAction string      `db:"log_action" json:"logAction"`
	Entity    string      `db:"entity" json:"entity"`
	EntityID  *uuid.UUID  `db:"entity_id" json:"entityId"`
	Details   []byte      `db:"details" json:"details"`
	Ip        *netip.Addr `db:"ip" json:"ip"`
	UserAgent *string     `db:"user_agent" json:"userAgent"`
	CreatedAt time.Time   `db:"created_at" json:"createdAt"`
}

type CheckPendingInviteByEmailParams struct {
	Email string    `db:"email" json:"email"`
	OrgID uuid.UUID `db:"org_id" json:"orgId"`
}

type CheckUserMembershipEmailParams struct {
	Email string    `db:"email" json:"email"`
	OrgID uuid.UUID `db:"org_id" json:"orgId"`
}

type CheckUserMembershipIDParams struct {
	UserID uuid.UUID `db:"user_id" json:"userId"`
	OrgID  uuid.UUID `db:"org_id" json:"orgId"`
}

type CountValidUsersInOrgParams struct {
	OrgID   uuid.UUID   `db:"org_id" json:"orgId"`
	UserIds []uuid.UUID `db:"user_ids" json:"userIds"`
}

type CreateAuditLogParams struct {
	ID        uuid.UUID   `db:"id" json:"id"`
	OrgID     *uuid.UUID  `db:"org_id" json:"orgId"`
	Actor     string      `db:"actor" json:"actor"`
	LogAction string      `db:"log_action" json:"logAction"`
	Entity    string      `db:"entity" json:"entity"`
	EntityID  *uuid.UUID  `db:"entity_id" json:"entityId"`
	Details   []byte      `db:"details" json:"details"`
	Ip        *netip.Addr `db:"ip" json:"ip"`
	UserAgent *string     `db:"user_agent" json:"userAgent"`
}

type CreateInvitationsParams struct {
	ID            uuid.UUID   `db:"id" json:"id"`
	OrgID         uuid.UUID   `db:"org_id" json:"orgId"`
	Email         string      `db:"email" json:"email"`
	InvitedBy     *uuid.UUID  `db:"invited_by" json:"invitedBy"`
	TokenHash     []byte      `db:"token_hash" json:"tokenHash"`
	ExpiresAt     time.Time   `db:"expires_at" json:"expiresAt"`
	RoleIds       []uuid.UUID `db:"role_ids" json:"roleIds"`
	InviteAsAdmin bool        `db:"invite_as_admin" json:"inviteAsAdmin"`
}

type CreateOrgDomainParams struct {
	Domain          string      `db:"domain" json:"domain"`
	OrgID           uuid.UUID   `db:"org_id" json:"orgId"`
	AutoJoin        bool        `db:"auto_join" json:"autoJoin"`
	AutoJoinRoleIds []uuid.UUID `db:"auto_join_role_ids" json:"autoJoinRoleIds"`
}

type CreateOrgParams struct {
	ID          uuid.UUID          `db:"id" json:"id"`
	Slug        string             `db:"slug" json:"slug"`
	Name        string             `db:"name" json:"name"`
	Description *string            `db:"description" json:"description"`
	AvatarUrl   *string            `db:"avatar_url" json:"avatarUrl"`
	Settings    models.OrgSettings `db:"settings" json:"settings"`
}

type CreateRolesParams struct {
	ID          uuid.UUID `db:"id" json:"id"`
	RoleName    string    `db:"role_name" json:"roleName"`
	Permissions []string  `db:"permissions" json:"permissions"`
	RoleDesc    *string   `db:"role_desc" json:"roleDesc"`
}

type CreateSessionParams struct {
	ID               uuid.UUID  `db:"id" json:"id"`
	UserID           uuid.UUID  `db:"user_id" json:"userId"`
	OrgID            uuid.UUID  `db:"org_id" json:"orgId"`
	SessionTokenHash []byte     `db:"session_token_hash" json:"sessionTokenHash"`
	RefreshTokenHash []byte     `db:"refresh_token_hash" json:"refreshTokenHash"`
	IpAddress        netip.Addr `db:"ip_address" json:"ipAddress"`
	UserAgent        string     `db:"user_agent" json:"userAgent"`
	ExpiresAt        time.Time  `db:"expires_at" json:"expiresAt"`
	MfaVerifiedAt    time.Time  `db:"mfa_verified_at" json:"mfaVerifiedAt"`
}

type CreateUserParams struct {
	ID           uuid.UUID `db:"id" json:"id"`
	Email        string    `db:"email" json:"email"`
	Name         string    `db:"name" json:"name"`
	PasswordHash *string   `db:"password_hash" json:"passwordHash"`
	AvatarUrl    *string   `db:"avatar_url" json:"avatarUrl"`
	ExtID        *string   `db:"ext_id" json:"extId"`
}

type CreateVerificationTokenParams struct {
	ID        uuid.UUID             `db:"id" json:"id"`
	UserID    uuid.UUID             `db:"user_id" json:"userId"`
	Email     *string               `db:"email" json:"email"`
	TokenType VerificationTokenType `db:"token_type" json:"tokenType"`
	TokenHash []byte                `db:"token_hash" json:"tokenHash"`
	ExpiresAt time.Time             `db:"expires_at" json:"expiresAt"`
}

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
	CopyFrom(ctx context.Context, tableName pgx.Identifier, columnNames []string, rowSrc pgx.CopyFromSource) (int64, error)
}

type DeleteMFAFactorParams struct {
	ID     uuid.UUID `db:"id" json:"id"`
	UserID uuid.UUID `db:"user_id" json:"userId"`
}

type DeleteMFAFactorsWhereEmailNotParams struct {
	UserID uuid.UUID `db:"user_id" json:"userId"`
	Email  string    `db:"email" json:"email"`
}

type DisassignRolesFromUsersInOrgParams struct {
	OrgID   uuid.UUID   `db:"org_id" json:"orgId"`
	RoleIds []uuid.UUID `db:"role_ids" json:"roleIds"`
	UserIds []uuid.UUID `db:"user_ids" json:"userIds"`
}

type ExpandedInvitation struct {
	ID             uuid.UUID        `db:"id" json:"id"`
	OrgID          uuid.UUID        `db:"org_id" json:"orgId"`
	Email          string           `db:"email" json:"email"`
	InviteAsAdmin  bool             `db:"invite_as_admin" json:"inviteAsAdmin"`
	RoleIds        []uuid.UUID      `db:"role_ids" json:"roleIds"`
	InvitedBy      *uuid.UUID       `db:"invited_by" json:"invitedBy"`
	TokenHash      []byte           `db:"token_hash" json:"tokenHash"`
	ExpiresAt      time.Time        `db:"expires_at" json:"expiresAt"`
	ActedAt        *time.Time       `db:"acted_at" json:"actedAt"`
	CreatedAt      time.Time        `db:"created_at" json:"createdAt"`
	InviteStatus   InvitationStatus `db:"invite_status" json:"inviteStatus"`
	InvitedByName  *string          `db:"invited_by_name" json:"invitedByName"`
	InvitedOrgName *string          `db:"invited_org_name" json:"invitedOrgName"`
	InviteRoles    []byte           `db:"invite_roles" json:"inviteRoles"`
}

type GetBackupCodeStatsRow struct {
	Total int32 `db:"total" json:"total"`
	Used  int64 `db:"used" json:"used"`
}

type GetInfoForSessionRefreshParams struct {
	UserID uuid.UUID `db:"user_id" json:"userId"`
	OrgID  uuid.UUID `db:"org_id" json:"orgId"`
}

type GetInfoForSessionRefreshRow struct {
	User           User `db:"user" json:"user"`
	Org            Org  `db:"org" json:"org"`
	UserIsOrgAdmin bool `db:"user_is_org_admin" json:"userIsOrgAdmin"`
}

type GetInvitationByEmailParams struct {
	Email string    `db:"email" json:"email"`
	OrgID uuid.UUID `db:"org_id" json:"orgId"`
}

type GetInvitationParams struct {
	ID        *uuid.UUID         `db:"id" json:"id"`
	TokenHash []byte             `db:"token_hash" json:"tokenHash"`
	Statuses  []InvitationStatus `db:"statuses" json:"statuses"`
}

type GetInvitationsForUserParams struct {
	Email          string             `db:"email" json:"email"`
	IncludeExpired bool               `db:"include_expired" json:"includeExpired"`
	Statuses       []InvitationStatus `db:"statuses" json:"statuses"`
}

type GetInvitationsForUserRow struct {
	Invitation        Invitation `db:"invitation" json:"invitation"`
	UserInvitedByName *string    `db:"user_invited_by_name" json:"userInvitedByName"`
	OrgName           string     `db:"org_name" json:"orgName"`
	InviteRoles       []byte     `db:"invite_roles" json:"inviteRoles"`
}

type GetMFAFactorsParams struct {
	UserID     uuid.UUID  `db:"user_id" json:"userId"`
	ID         *uuid.UUID `db:"id" json:"id"`
	Verified   *bool      `db:"verified" json:"verified"`
	FactorType *MfaType   `db:"factor_type" json:"factorType"`
	Secret     *string    `db:"secret" json:"secret"`
}

type GetOrgUsageRow struct {
	TotalUsers     int64     `db:"total_users" json:"totalUsers"`
	ActiveUsers    int64     `db:"active_users" json:"activeUsers"`
	BannedUsers    int64     `db:"banned_users" json:"bannedUsers"`
	PendingInvites int64     `db:"pending_invites" json:"pendingInvites"`
	ExpiredInvites int64     `db:"expired_invites" json:"expiredInvites"`
	OrgID          uuid.UUID `db:"org_id" json:"orgId"`
	OrgName        string    `db:"org_name" json:"orgName"`
	OrgSlug        string    `db:"org_slug" json:"orgSlug"`
}

type GetRolesMinimalRow struct {
	ID        uuid.UUID `db:"id" json:"id"`
	RoleName  string    `db:"role_name" json:"roleName"`
	RoleDesc  *string   `db:"role_desc" json:"roleDesc"`
	CreatedAt time.Time `db:"created_at" json:"createdAt"`
	UpdatedAt time.Time `db:"updated_at" json:"updatedAt"`
}

type GetSessionParams struct {
	ID               *uuid.UUID `db:"id" json:"id"`
	RefreshTokenHash []byte     `db:"refresh_token_hash" json:"refreshTokenHash"`
}

type GetSessionsForUserInOrgParams struct {
	UserID uuid.UUID `db:"user_id" json:"userId"`
	OrgID  uuid.UUID `db:"org_id" json:"orgId"`
}

type GetUserByEmailRow struct {
	ID                    uuid.UUID `db:"id" json:"id"`
	Email                 string    `db:"email" json:"email"`
	EmailVerified         bool      `db:"email_verified" json:"emailVerified"`
	BackupCodesDownloaded bool      `db:"backup_codes_downloaded" json:"backupCodesDownloaded"`
	Name                  string    `db:"name" json:"name"`
	AvatarUrl             *string   `db:"avatar_url" json:"avatarUrl"`
	ExtID                 *string   `db:"ext_id" json:"extId"`
	CreatedAt             time.Time `db:"created_at" json:"createdAt"`
	UpdatedAt             time.Time `db:"updated_at" json:"updatedAt"`
}

type GetUserByIDRow struct {
	ID                    uuid.UUID `db:"id" json:"id"`
	Email                 string    `db:"email" json:"email"`
	EmailVerified         bool      `db:"email_verified" json:"emailVerified"`
	BackupCodesDownloaded bool      `db:"backup_codes_downloaded" json:"backupCodesDownloaded"`
	Name                  string    `db:"name" json:"name"`
	AvatarUrl             *string   `db:"avatar_url" json:"avatarUrl"`
	ExtID                 *string   `db:"ext_id" json:"extId"`
	CreatedAt             time.Time `db:"created_at" json:"createdAt"`
	UpdatedAt             time.Time `db:"updated_at" json:"updatedAt"`
}

type GetUserInfoParams struct {
	UserID uuid.UUID  `db:"user_id" json:"userId"`
	OrgID  *uuid.UUID `db:"org_id" json:"orgId"`
}

type GetUserLoginInfoRow struct {
	ID                    uuid.UUID `db:"id" json:"id"`
	Email                 string    `db:"email" json:"email"`
	EmailVerified         bool      `db:"email_verified" json:"emailVerified"`
	BackupCodesDownloaded bool      `db:"backup_codes_downloaded" json:"backupCodesDownloaded"`
	PasswordHash          *string   `db:"password_hash" json:"passwordHash"`
	Name                  string    `db:"name" json:"name"`
	AvatarUrl             *string   `db:"avatar_url" json:"avatarUrl"`
	ExtID                 *string   `db:"ext_id" json:"extId"`
	CreatedAt             time.Time `db:"created_at" json:"createdAt"`
	UpdatedAt             time.Time `db:"updated_at" json:"updatedAt"`
}

type GetUserOrgsParams struct {
	UserID    *uuid.UUID `db:"user_id" json:"userId"`
	UserEmail *string    `db:"user_email" json:"userEmail"`
}

type GetUserOrgsRow struct {
	Org Org `db:"org" json:"org"`
}

type GetUserPermissionsParams struct {
	UserID uuid.UUID `db:"user_id" json:"userId"`
	OrgID  uuid.UUID `db:"org_id" json:"orgId"`
}

type GetVerificationTokenParams struct {
	TokenHash []byte                `db:"token_hash" json:"tokenHash"`
	TokenType VerificationTokenType `db:"token_type" json:"tokenType"`
}

type Invitation struct {
	ID            uuid.UUID        `db:"id" json:"id"`
	OrgID         uuid.UUID        `db:"org_id" json:"orgId"`
	Email         string           `db:"email" json:"email"`
	InviteAsAdmin bool             `db:"invite_as_admin" json:"inviteAsAdmin"`
	RoleIds       []uuid.UUID      `db:"role_ids" json:"roleIds"`
	InvitedBy     *uuid.UUID       `db:"invited_by" json:"invitedBy"`
	TokenHash     []byte           `db:"token_hash" json:"tokenHash"`
	ExpiresAt     time.Time        `db:"expires_at" json:"expiresAt"`
	ActedAt       *time.Time       `db:"acted_at" json:"actedAt"`
	CreatedAt     time.Time        `db:"created_at" json:"createdAt"`
	InviteStatus  InvitationStatus `db:"invite_status" json:"inviteStatus"`
}

type InvitationStatus string

type MfaFactor struct {
	ID         uuid.UUID `db:"id" json:"id"`
	UserID     uuid.UUID `db:"user_id" json:"userId"`
	FactorType MfaType   `db:"factor_type" json:"factorType"`
	Name       string    `db:"name" json:"name"`
	Secret     string    `db:"secret" json:"secret"`
	Verified   bool      `db:"verified" json:"verified"`
	CreatedAt  time.Time `db:"created_at" json:"createdAt"`
	UpdatedAt  time.Time `db:"updated_at" json:"updatedAt"`
}

type MfaType string

type NullInvitationStatus struct {
	InvitationStatus InvitationStatus `json:"invitationStatus"`
	Valid            bool             `json:"valid"` // Valid is true if InvitationStatus is not NULL
}

type NullMfaType struct {
	MfaType MfaType `json:"mfaType"`
	Valid   bool    `json:"valid"` // Valid is true if MfaType is not NULL
}

type NullVerificationTokenType struct {
	VerificationTokenType VerificationTokenType `json:"verificationTokenType"`
	Valid                 bool                  `json:"valid"` // Valid is true if VerificationTokenType is not NULL
}

type Org struct {
	ID                       uuid.UUID          `db:"id" json:"id"`
	Slug                     string             `db:"slug" json:"slug"`
	Name                     string             `db:"name" json:"name"`
	Description              *string            `db:"description" json:"description"`
	AvatarUrl                *string            `db:"avatar_url" json:"avatarUrl"`
	DomainVerificationSecret []byte             `db:"domain_verification_secret" json:"-"`
	Settings                 models.OrgSettings `db:"settings" json:"settings"`
	CreatedAt                time.Time          `db:"created_at" json:"createdAt"`
	UpdatedAt                time.Time          `db:"updated_at" json:"updatedAt"`
}

type OrgDomain struct {
	Domain          string      `db:"domain" json:"domain"`
	OrgID           uuid.UUID   `db:"org_id" json:"orgId"`
	Verified        bool        `db:"verified" json:"verified"`
	VerifiedAt      *time.Time  `db:"verified_at" json:"verifiedAt"`
	AutoJoin        bool        `db:"auto_join" json:"autoJoin"`
	AutoJoinRoleIds []uuid.UUID `db:"auto_join_role_ids" json:"autoJoinRoleIds"`
	CreatedAt       time.Time   `db:"created_at" json:"createdAt"`
	UpdatedAt       time.Time   `db:"updated_at" json:"updatedAt"`
}

type Querier interface {
	ActOnInvitation(ctx context.Context, arg ActOnInvitationParams) (uuid.UUID, error)
	AddMFAFactor(ctx context.Context, arg AddMFAFactorParams) error
	AddUserToOrg(ctx context.Context, arg AddUserToOrgParams) error
	AssignRolesToUsersInOrg(ctx context.Context, arg AssignRolesToUsersInOrgParams) error
	CheckPendingInviteByEmail(ctx context.Context, arg CheckPendingInviteByEmailParams) (bool, error)
	CheckUserMembershipEmail(ctx context.Context, arg CheckUserMembershipEmailParams) (bool, error)
	CheckUserMembershipID(ctx context.Context, arg CheckUserMembershipIDParams) (bool, error)
	CleanupOldAuditLogs(ctx context.Context, days *string) error
	CountValidRoles(ctx context.Context, roleIds []uuid.UUID) (int64, error)
	CountValidUsersInOrg(ctx context.Context, arg CountValidUsersInOrgParams) (int64, error)
	CountVerifiedMFAFactorsForUser(ctx context.Context, userID uuid.UUID) (int64, error)
	CreateAuditLog(ctx context.Context, arg CreateAuditLogParams) error
	CreateInvitations(ctx context.Context, arg []CreateInvitationsParams) (int64, error)
	CreateOrg(ctx context.Context, arg CreateOrgParams) error
	CreateOrgDomain(ctx context.Context, arg CreateOrgDomainParams) (OrgDomain, error)
	CreateRoles(ctx context.Context, arg []CreateRolesParams) (int64, error)
	CreateSession(ctx context.Context, arg CreateSessionParams) error
	CreateUser(ctx context.Context, arg CreateUserParams) error
	CreateVerificationToken(ctx context.Context, arg CreateVerificationTokenParams) error
	DeleteExpiredSessions(ctx context.Context) error
	DeleteExpiredVerificationTokens(ctx context.Context) error
	DeleteMFAFactor(ctx context.Context, arg DeleteMFAFactorParams) (MfaFactor, error)
	DeleteMFAFactorsWhereEmailNot(ctx context.Context, arg DeleteMFAFactorsWhereEmailNotParams) error
	DeleteOrg(ctx context.Context, id uuid.UUID) (Org, error)
	DeleteRole(ctx context.Context, id uuid.UUID) (Role, error)
	DeleteSession(ctx context.Context, id uuid.UUID) (Session, error)
	DeleteUserByID(ctx context.Context, id uuid.UUID) (User, error)
	DeleteVerificationToken(ctx context.Context, id uuid.UUID) error
	DisassignRolesFromUsersInOrg(ctx context.Context, arg DisassignRolesFromUsersInOrgParams) error
	GetBackupCodeStats(ctx context.Context, userID uuid.UUID) (GetBackupCodeStatsRow, error)
	GetBackupCodes(ctx context.Context, id uuid.UUID) ([]models.BackupCode, error)
	GetInfoForSessionRefresh(ctx context.Context, arg GetInfoForSessionRefreshParams) (GetInfoForSessionRefreshRow, error)
	GetInvitation(ctx context.Context, arg GetInvitationParams) (Invitation, error)
	GetInvitationByEmail(ctx context.Context, arg GetInvitationByEmailParams) (Invitation, error)
	GetInvitationsForUser(ctx context.Context, arg GetInvitationsForUserParams) ([]GetInvitationsForUserRow, error)
	GetMFAFactorWithEmail(ctx context.Context, secret string) (bool, error)
	GetMFAFactors(ctx context.Context, arg GetMFAFactorsParams) ([]MfaFactor, error)
	GetMFAFactorsByUserID(ctx context.Context, userID uuid.UUID) ([]MfaFactor, error)
	GetOrg(ctx context.Context, id uuid.UUID) (Org, error)
	GetOrgDomain(ctx context.Context, domain string) (OrgDomain, error)
	GetOrgDomains(ctx context.Context, orgID uuid.UUID) ([]OrgDomain, error)
	GetOrgIDByDomain(ctx context.Context, domain string) (OrgDomain, error)
	GetOrgUsage(ctx context.Context, orgID uuid.UUID) (GetOrgUsageRow, error)
	GetRoleByID(ctx context.Context, id uuid.UUID) (Role, error)
	GetRolesMinimal(ctx context.Context) ([]GetRolesMinimalRow, error)
	GetSession(ctx context.Context, arg GetSessionParams) (Session, error)
	GetSessionsForOrg(ctx context.Context, orgID uuid.UUID) ([]Session, error)
	GetSessionsForUser(ctx context.Context, userID uuid.UUID) ([]Session, error)
	GetSessionsForUserInOrg(ctx context.Context, arg GetSessionsForUserInOrgParams) ([]Session, error)
	GetUserByEmail(ctx context.Context, email string) (GetUserByEmailRow, error)
	GetUserByID(ctx context.Context, id uuid.UUID) (GetUserByIDRow, error)
	GetUserEmail(ctx context.Context, id uuid.UUID) (string, error)
	GetUserInfo(ctx context.Context, arg GetUserInfoParams) ([]byte, error)
	GetUserLoginInfo(ctx context.Context, email string) (GetUserLoginInfoRow, error)
	GetUserOrgs(ctx context.Context, arg GetUserOrgsParams) ([]GetUserOrgsRow, error)
	GetUserPermissions(ctx context.Context, arg GetUserPermissionsParams) ([]string, error)
	GetVerificationToken(ctx context.Context, arg GetVerificationTokenParams) (VerificationToken, error)
	MarkUserEmailVerified(ctx context.Context, id uuid.UUID) error
	RefreshSession(ctx context.Context, arg RefreshSessionParams) error
	RemoveAllRolesFromUserInOrg(ctx context.Context, arg RemoveAllRolesFromUserInOrgParams) error
	RemoveDomainFromOrg(ctx context.Context, arg RemoveDomainFromOrgParams) (OrgDomain, error)
	RemoveUserFromOrg(ctx context.Context, arg RemoveUserFromOrgParams) (UserOrg, error)
	RevokeAllSessionsForUser(ctx context.Context, userID uuid.UUID) error
	RevokeAllSessionsForUserInOrg(ctx context.Context, arg RevokeAllSessionsForUserInOrgParams) error
	RevokeInvitation(ctx context.Context, arg RevokeInvitationParams) (uuid.UUID, error)
	UpdateBackupCodes(ctx context.Context, arg UpdateBackupCodesParams) error
	UpdateBackupCodesByEmail(ctx context.Context, arg UpdateBackupCodesByEmailParams) error
	UpdateMFAFactorName(ctx context.Context, arg UpdateMFAFactorNameParams) (string, error)
	UpdateMFAFactorVerification(ctx context.Context, arg UpdateMFAFactorVerificationParams) error
	UpdateOrg(ctx context.Context, arg UpdateOrgParams) ([]byte, error)
	UpdateOrgDomain(ctx context.Context, arg UpdateOrgDomainParams) ([]byte, error)
	UpdateOrgDomainVerification(ctx context.Context, arg UpdateOrgDomainVerificationParams) error
	UpdateRole(ctx context.Context, arg UpdateRoleParams) ([]byte, error)
	UpdateSessionMFA(ctx context.Context, arg UpdateSessionMFAParams) error
	UpdateUser(ctx context.Context, arg UpdateUserParams) error
	UpdateUserBanInOrg(ctx context.Context, arg UpdateUserBanInOrgParams) error
	UpdateUserOrgAdmin(ctx context.Context, arg UpdateUserOrgAdminParams) error
	UpdateUserPassword(ctx context.Context, arg UpdateUserPasswordParams) error
	ValidateInviteEmails(ctx context.Context, arg ValidateInviteEmailsParams) ([]ValidateInviteEmailsRow, error)
}

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

type RefreshSessionParams struct {
	ID               uuid.UUID  `db:"id" json:"id"`
	SessionTokenHash []byte     `db:"session_token_hash" json:"sessionTokenHash"`
	RefreshTokenHash []byte     `db:"refresh_token_hash" json:"refreshTokenHash"`
	ExpiresAt        time.Time  `db:"expires_at" json:"expiresAt"`
	UserAgent        string     `db:"user_agent" json:"userAgent"`
	IpAddress        netip.Addr `db:"ip_address" json:"ipAddress"`
}

type RemoveAllRolesFromUserInOrgParams struct {
	UserID uuid.UUID `db:"user_id" json:"userId"`
	OrgID  uuid.UUID `db:"org_id" json:"orgId"`
}

type RemoveDomainFromOrgParams struct {
	OrgID  uuid.UUID `db:"org_id" json:"orgId"`
	Domain string    `db:"domain" json:"domain"`
}

type RemoveUserFromOrgParams struct {
	UserID uuid.UUID `db:"user_id" json:"userId"`
	OrgID  uuid.UUID `db:"org_id" json:"orgId"`
}

type RevokeAllSessionsForUserInOrgParams struct {
	UserID uuid.UUID `db:"user_id" json:"userId"`
	OrgID  uuid.UUID `db:"org_id" json:"orgId"`
}

type RevokeInvitationParams struct {
	ID    uuid.UUID  `db:"id" json:"id"`
	OrgID *uuid.UUID `db:"org_id" json:"orgId"`
}

type Role struct {
	ID          uuid.UUID `db:"id" json:"id"`
	RoleName    string    `db:"role_name" json:"roleName"`
	RoleDesc    *string   `db:"role_desc" json:"roleDesc"`
	Permissions []string  `db:"permissions" json:"permissions"`
	CreatedAt   time.Time `db:"created_at" json:"createdAt"`
	UpdatedAt   time.Time `db:"updated_at" json:"updatedAt"`
}

type Session struct {
	ID               uuid.UUID  `db:"id" json:"id"`
	UserID           uuid.UUID  `db:"user_id" json:"userId"`
	OrgID            uuid.UUID  `db:"org_id" json:"orgId"`
	SessionTokenHash []byte     `db:"session_token_hash" json:"sessionTokenHash"`
	RefreshTokenHash []byte     `db:"refresh_token_hash" json:"refreshTokenHash"`
	IpAddress        netip.Addr `db:"ip_address" json:"ipAddress"`
	UserAgent        string     `db:"user_agent" json:"userAgent"`
	MfaVerifiedAt    time.Time  `db:"mfa_verified_at" json:"mfaVerifiedAt"`
	ExpiresAt        time.Time  `db:"expires_at" json:"expiresAt"`
	CreatedAt        time.Time  `db:"created_at" json:"createdAt"`
}

type UpdateBackupCodesByEmailParams struct {
	Email                 string              `db:"email" json:"email"`
	BackupCodes           []models.BackupCode `db:"backup_codes" json:"backupCodes"`
	BackupCodesDownloaded bool                `db:"backup_codes_downloaded" json:"backupCodesDownloaded"`
}

type UpdateBackupCodesParams struct {
	ID                    uuid.UUID           `db:"id" json:"id"`
	BackupCodes           []models.BackupCode `db:"backup_codes" json:"backupCodes"`
	BackupCodesDownloaded bool                `db:"backup_codes_downloaded" json:"backupCodesDownloaded"`
}

type UpdateMFAFactorNameParams struct {
	ID     uuid.UUID `db:"id" json:"id"`
	UserID uuid.UUID `db:"user_id" json:"userId"`
	Name   string    `db:"name" json:"name"`
}

type UpdateMFAFactorVerificationParams struct {
	ID       uuid.UUID `db:"id" json:"id"`
	UserID   uuid.UUID `db:"user_id" json:"userId"`
	Verified bool      `db:"verified" json:"verified"`
}

type UpdateOrgDomainParams struct {
	OrgID           uuid.UUID   `db:"org_id" json:"orgId"`
	Domain          string      `db:"domain" json:"domain"`
	AutoJoin        *bool       `db:"auto_join" json:"autoJoin"`
	AutoJoinRoleIds []uuid.UUID `db:"auto_join_role_ids" json:"autoJoinRoleIds"`
}

type UpdateOrgDomainVerificationParams struct {
	OrgID    uuid.UUID `db:"org_id" json:"orgId"`
	Domain   string    `db:"domain" json:"domain"`
	Verified bool      `db:"verified" json:"verified"`
}

type UpdateOrgParams struct {
	ID          uuid.UUID          `db:"id" json:"id"`
	Name        *string            `db:"name" json:"name"`
	Description *string            `db:"description" json:"description"`
	AvatarUrl   *string            `db:"avatar_url" json:"avatarUrl"`
	Settings    models.OrgSettings `db:"settings" json:"settings"`
}

type UpdateRoleParams struct {
	ID                uuid.UUID `db:"id" json:"id"`
	RoleName          *string   `db:"role_name" json:"roleName"`
	RoleDesc          *string   `db:"role_desc" json:"roleDesc"`
	PermissionsAdd    []string  `db:"permissions_add" json:"permissionsAdd"`
	PermissionsRemove []string  `db:"permissions_remove" json:"permissionsRemove"`
}

type UpdateSessionMFAParams struct {
	ID            uuid.UUID  `db:"id" json:"id"`
	MfaVerifiedAt *time.Time `db:"mfa_verified_at" json:"mfaVerifiedAt"`
}

type UpdateUserBanInOrgParams struct {
	UserID   uuid.UUID `db:"user_id" json:"userId"`
	OrgID    uuid.UUID `db:"org_id" json:"orgId"`
	IsBanned bool      `db:"is_banned" json:"isBanned"`
}

type UpdateUserOrgAdminParams struct {
	UserID     uuid.UUID `db:"user_id" json:"userId"`
	OrgID      uuid.UUID `db:"org_id" json:"orgId"`
	IsOrgAdmin bool      `db:"is_org_admin" json:"isOrgAdmin"`
}

type UpdateUserParams struct {
	ID        uuid.UUID `db:"id" json:"id"`
	Name      *string   `db:"name" json:"name"`
	AvatarUrl *string   `db:"avatar_url" json:"avatarUrl"`
	ExtID     *string   `db:"ext_id" json:"extId"`
}

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

type User struct {
	ID                    uuid.UUID           `db:"id" json:"id"`
	ExtID                 *string             `db:"ext_id" json:"extId"`
	Email                 string              `db:"email" json:"email"`
	EmailVerified         bool                `db:"email_verified" json:"emailVerified"`
	PasswordHash          *string             `db:"password_hash" json:"passwordHash"`
	BackupCodes           []models.BackupCode `db:"backup_codes" json:"backupCodes"`
	BackupCodesDownloaded bool                `db:"backup_codes_downloaded" json:"backupCodesDownloaded"`
	Name                  string              `db:"name" json:"name"`
	AvatarUrl             *string             `db:"avatar_url" json:"avatarUrl"`
	CreatedAt             time.Time           `db:"created_at" json:"createdAt"`
	UpdatedAt             time.Time           `db:"updated_at" json:"updatedAt"`
}

type UserOrg struct {
	UserID     uuid.UUID `db:"user_id" json:"userId"`
	OrgID      uuid.UUID `db:"org_id" json:"orgId"`
	IsOrgAdmin bool      `db:"is_org_admin" json:"isOrgAdmin"`
	JoinedAt   time.Time `db:"joined_at" json:"joinedAt"`
	UpdatedAt  time.Time `db:"updated_at" json:"updatedAt"`
	IsBanned   bool      `db:"is_banned" json:"isBanned"`
}

type UserRole struct {
	UserID uuid.UUID `db:"user_id" json:"userId"`
	OrgID  uuid.UUID `db:"org_id" json:"orgId"`
	RoleID uuid.UUID `db:"role_id" json:"roleId"`
}

type ValidateInviteEmailsParams struct {
	OrgID  uuid.UUID `db:"org_id" json:"orgId"`
	Emails []string  `db:"emails" json:"emails"`
}

type ValidateInviteEmailsRow struct {
	Email          string `db:"email" json:"email"`
	UserExists     bool   `db:"user_exists" json:"userExists"`
	UsedForMfa     bool   `db:"used_for_mfa" json:"usedForMfa"`
	AlreadyInvited bool   `db:"already_invited" json:"alreadyInvited"`
	AlreadyMember  bool   `db:"already_member" json:"alreadyMember"`
}

type VerificationToken struct {
	ID        uuid.UUID             `db:"id" json:"id"`
	UserID    uuid.UUID             `db:"user_id" json:"userId"`
	Email     *string               `db:"email" json:"email"`
	TokenType VerificationTokenType `db:"token_type" json:"tokenType"`
	TokenHash []byte                `db:"token_hash" json:"tokenHash"`
	ExpiresAt time.Time             `db:"expires_at" json:"expiresAt"`
	CreatedAt time.Time             `db:"created_at" json:"createdAt"`
}

type VerificationTokenType string