repository

type ActivityFilter struct {
	UserID       *uint
	ActivityType *domain.ActivityType
	Limit        int
	Offset       int
}

type CollectionRepository interface {
	Create(ctx context.Context, collection *domain.Collection) error
	GetByID(ctx context.Context, id uint) (*domain.Collection, error)
	GetByUUID(ctx context.Context, uuid string) (*domain.Collection, error)
	GetByName(ctx context.Context, orgID uint, name string) (*domain.Collection, error)
	GetDefaultByOrganization(ctx context.Context, orgID uint) (*domain.Collection, error)
	ListByOrganization(ctx context.Context, orgID uint) ([]*domain.Collection, error)
	ListForUser(ctx context.Context, orgID, userID uint) ([]*domain.Collection, error)
	Update(ctx context.Context, collection *domain.Collection) error
	Delete(ctx context.Context, id uint) error
	SoftDelete(ctx context.Context, id uint) error

	// Stats
	GetItemCount(ctx context.Context, collectionID uint) (int, error)
	GetUserCount(ctx context.Context, collectionID uint) (int, error)
	GetTeamCount(ctx context.Context, collectionID uint) (int, error)
}

type CollectionTeamRepository interface {
	Create(ctx context.Context, ct *domain.CollectionTeam) error
	GetByID(ctx context.Context, id uint) (*domain.CollectionTeam, error)
	GetByCollectionAndTeam(ctx context.Context, collectionID, teamID uint) (*domain.CollectionTeam, error)
	ListByCollection(ctx context.Context, collectionID uint) ([]*domain.CollectionTeam, error)
	ListByTeam(ctx context.Context, teamID uint) ([]*domain.CollectionTeam, error)
	Update(ctx context.Context, ct *domain.CollectionTeam) error
	Delete(ctx context.Context, id uint) error
	DeleteByCollectionAndTeam(ctx context.Context, collectionID, teamID uint) error
}

type CollectionUserRepository interface {
	Create(ctx context.Context, cu *domain.CollectionUser) error
	GetByID(ctx context.Context, id uint) (*domain.CollectionUser, error)
	GetByCollectionAndOrgUser(ctx context.Context, collectionID, orgUserID uint) (*domain.CollectionUser, error)
	ListByCollection(ctx context.Context, collectionID uint) ([]*domain.CollectionUser, error)
	ListByOrgUser(ctx context.Context, orgUserID uint) ([]*domain.CollectionUser, error)
	Update(ctx context.Context, cu *domain.CollectionUser) error
	Delete(ctx context.Context, id uint) error
	DeleteByCollectionAndOrgUser(ctx context.Context, collectionID, orgUserID uint) error
}

type ExcludedDomainRepository interface {
	// Create adds a new excluded domain for a user
	Create(ctx context.Context, excludedDomain *domain.ExcludedDomain) error

	// GetByUserID returns all excluded domains for a user
	GetByUserID(ctx context.Context, userID uint) ([]*domain.ExcludedDomain, error)

	// GetByUserIDAndDomain checks if a domain is excluded for a user
	GetByUserIDAndDomain(ctx context.Context, userID uint, domain string) (*domain.ExcludedDomain, error)

	// Delete removes an excluded domain by ID (only if it belongs to the user)
	Delete(ctx context.Context, id uint, userID uint) error

	// DeleteByDomain removes an excluded domain by domain name (only if it belongs to the user)
	DeleteByDomain(ctx context.Context, userID uint, domain string) error
}

type InvitationRepository interface {
	Create(ctx context.Context, invitation *domain.Invitation) error
	GetByEmail(ctx context.Context, email string) (*domain.Invitation, error)
	GetByCode(ctx context.Context, code string) (*domain.Invitation, error)
	GetByID(ctx context.Context, id uint) (*domain.Invitation, error)
	GetAllByEmail(ctx context.Context, email string) ([]*domain.Invitation, error)
	GetByCreator(ctx context.Context, createdBy uint) ([]*domain.Invitation, error)
	Update(ctx context.Context, invitation *domain.Invitation) error
	Delete(ctx context.Context, id uint) error
	DeleteByEmail(ctx context.Context, email string) error
	DeleteExpired(ctx context.Context) error
}

type ItemFilter struct {
	ItemType   *domain.ItemType
	IsFavorite *bool
	FolderID   *uint
	Tags       []string
	Search     string
	// URIHints filters by metadata.uri_hint (domain only, no paths).
	// If multiple are provided, the result matches ANY of them.
	URIHints  []string
	AutoFill  *bool
	AutoLogin *bool
	Page      int
	PerPage   int
}

type ItemRepository interface {
	Create(ctx context.Context, schema string, item *domain.Item) error
	FindByID(ctx context.Context, schema string, id uint) (*domain.Item, error)
	FindByUUID(ctx context.Context, schema string, uuid string) (*domain.Item, error)
	FindBySupportID(ctx context.Context, schema string, supportID int64) (*domain.Item, error)
	FindAll(ctx context.Context, schema string, filter ItemFilter) ([]*domain.Item, int64, error)
	Update(ctx context.Context, schema string, item *domain.Item) error
	Delete(ctx context.Context, schema string, id uint) error
	HardDelete(ctx context.Context, schema string, id uint) error
}

type ItemShareRepository interface {
	Create(ctx context.Context, share *domain.ItemShare) error
	GetByID(ctx context.Context, id uint) (*domain.ItemShare, error)
	GetByUUID(ctx context.Context, uuid string) (*domain.ItemShare, error)
	ListByItemUUID(ctx context.Context, itemUUID uuid.UUID) ([]*domain.ItemShare, error)
	ListByOwner(ctx context.Context, ownerID uint) ([]*domain.ItemShare, error)
	ListSharedWithUser(ctx context.Context, userID uint) ([]*domain.ItemShare, error)
	ListSharedWithTeam(ctx context.Context, teamID uint) ([]*domain.ItemShare, error)
	Update(ctx context.Context, share *domain.ItemShare) error
	Delete(ctx context.Context, id uint) error
	DeleteBySharedWithUser(ctx context.Context, userID uint) error
	DeleteExpired(ctx context.Context) (int64, error)
}

type ListFilter struct {
	Search string
	Limit  int
	Offset int
	Sort   string
	Order  string
}

type ListResult struct {
	Total    int64
	Filtered int64
}

type OrganizationFolderRepository interface {
	Create(ctx context.Context, folder *domain.OrganizationFolder) error
	GetByID(ctx context.Context, id uint) (*domain.OrganizationFolder, error)
	GetByOrganization(ctx context.Context, orgID uint) ([]*domain.OrganizationFolder, error)
	GetByOrganizationAndName(ctx context.Context, orgID uint, name string) (*domain.OrganizationFolder, error)
	Update(ctx context.Context, folder *domain.OrganizationFolder) error
	Delete(ctx context.Context, id uint) error
}

type OrganizationItemFilter struct {
	OrganizationID uint
	CollectionID   *uint
	ItemType       *domain.ItemType
	IsFavorite     *bool
	FolderID       *uint
	AutoFill       *bool
	AutoLogin      *bool
	Search         string
	Tags           []string
	Page           int
	PerPage        int
}

type OrganizationItemRepository interface {
	Create(ctx context.Context, item *domain.OrganizationItem) error
	GetByID(ctx context.Context, id uint) (*domain.OrganizationItem, error)
	GetByUUID(ctx context.Context, uuid string) (*domain.OrganizationItem, error)
	GetBySupportID(ctx context.Context, supportID int64) (*domain.OrganizationItem, error)
	ListByOrganization(ctx context.Context, filter OrganizationItemFilter) ([]*domain.OrganizationItem, int64, error)
	ListByCollection(ctx context.Context, collectionID uint) ([]*domain.OrganizationItem, error)
	MoveItemsToCollection(ctx context.Context, fromCollectionID uint, toCollectionID uint) error
	Update(ctx context.Context, item *domain.OrganizationItem) error
	Delete(ctx context.Context, id uint) error
	SoftDelete(ctx context.Context, id uint) error
	HardDelete(ctx context.Context, id uint) error
}

type OrganizationRepository interface {
	Create(ctx context.Context, org *domain.Organization) error
	GetByID(ctx context.Context, id uint) (*domain.Organization, error)
	GetByUUID(ctx context.Context, uuid string) (*domain.Organization, error)
	GetDefaultByOwnerID(ctx context.Context, ownerUserID uint) (*domain.Organization, error)
	List(ctx context.Context, filter ListFilter) ([]*domain.Organization, *ListResult, error)
	ListForUser(ctx context.Context, userID uint) ([]*domain.Organization, error)
	Update(ctx context.Context, org *domain.Organization) error
	Delete(ctx context.Context, id uint) error

	// Stats
	GetMemberCount(ctx context.Context, orgID uint) (int, error)
	GetTeamCount(ctx context.Context, orgID uint) (int, error)
	GetCollectionCount(ctx context.Context, orgID uint) (int, error)
	GetItemCount(ctx context.Context, orgID uint) (int, error)
}

type OrganizationUserRepository interface {
	Create(ctx context.Context, orgUser *domain.OrganizationUser) error
	GetByID(ctx context.Context, id uint) (*domain.OrganizationUser, error)
	GetByUUID(ctx context.Context, uuid string) (*domain.OrganizationUser, error)
	GetByOrgAndUser(ctx context.Context, orgID, userID uint) (*domain.OrganizationUser, error)
	ListByOrganization(ctx context.Context, orgID uint) ([]*domain.OrganizationUser, error)
	ListByUser(ctx context.Context, userID uint) ([]*domain.OrganizationUser, error)
	Update(ctx context.Context, orgUser *domain.OrganizationUser) error
	Delete(ctx context.Context, id uint) error

	// Invitations
	CountInvited(ctx context.Context, orgID uint) (int, error)
	ListPendingInvitations(ctx context.Context, userEmail string) ([]*domain.OrganizationUser, error)
}

type PermissionRepository interface {
	GetByID(ctx context.Context, id uint) (*domain.Permission, error)
	GetByName(ctx context.Context, name string) (*domain.Permission, error)
	List(ctx context.Context) ([]*domain.Permission, error)
	Migrate() error
}

type PreferencesRepository interface {
	ListByOwner(ctx context.Context, ownerType string, ownerID uint, section string) ([]*domain.Preference, error)
	UpsertMany(ctx context.Context, prefs []*domain.Preference) error
}

type RoleRepository interface {
	GetByID(ctx context.Context, id uint) (*domain.Role, error)
	GetByName(ctx context.Context, name string) (*domain.Role, error)
	List(ctx context.Context) ([]*domain.Role, error)
	GetPermissions(ctx context.Context, roleID uint) ([]string, error)
	Migrate() error
}

type SCIMTokenRepository interface {
	Create(ctx context.Context, token *domain.SCIMToken) error
	GetByID(ctx context.Context, id uint) (*domain.SCIMToken, error)
	GetByTokenHash(ctx context.Context, tokenHash string) (*domain.SCIMToken, error)
	ListByOrganization(ctx context.Context, orgID uint) ([]*domain.SCIMToken, error)
	Update(ctx context.Context, token *domain.SCIMToken) error
	Delete(ctx context.Context, id uint) error
}

type SSOConnectionRepository interface {
	Create(ctx context.Context, conn *domain.SSOConnection) error
	GetByID(ctx context.Context, id uint) (*domain.SSOConnection, error)
	GetByUUID(ctx context.Context, uuid string) (*domain.SSOConnection, error)
	GetAnyByDomain(ctx context.Context, domain string) (*domain.SSOConnection, error)
	GetByDomain(ctx context.Context, domain string) (*domain.SSOConnection, error)
	GetByOrganizationID(ctx context.Context, orgID uint) (*domain.SSOConnection, error)
	ListByOrganization(ctx context.Context, orgID uint) ([]*domain.SSOConnection, error)
	Update(ctx context.Context, conn *domain.SSOConnection) error
	Delete(ctx context.Context, id uint) error
}

type SSOStateRepository interface {
	Create(ctx context.Context, state *domain.SSOState) error
	GetByState(ctx context.Context, state string) (*domain.SSOState, error)
	Delete(ctx context.Context, id uint) error
	DeleteExpired(ctx context.Context) (int64, error)
}

type TeamRepository interface {
	Create(ctx context.Context, team *domain.Team) error
	GetByID(ctx context.Context, id uint) (*domain.Team, error)
	GetByUUID(ctx context.Context, uuid string) (*domain.Team, error)
	GetByName(ctx context.Context, orgID uint, name string) (*domain.Team, error)
	GetDefaultByOrganization(ctx context.Context, orgID uint) (*domain.Team, error)
	ListByOrganization(ctx context.Context, orgID uint) ([]*domain.Team, error)
	Update(ctx context.Context, team *domain.Team) error
	Delete(ctx context.Context, id uint) error

	// Stats
	GetMemberCount(ctx context.Context, teamID uint) (int, error)
}

type TeamUserRepository interface {
	Create(ctx context.Context, teamUser *domain.TeamUser) error
	GetByID(ctx context.Context, id uint) (*domain.TeamUser, error)
	GetByTeamAndOrgUser(ctx context.Context, teamID, orgUserID uint) (*domain.TeamUser, error)
	ListByTeam(ctx context.Context, teamID uint) ([]*domain.TeamUser, error)
	ListByOrgUser(ctx context.Context, orgUserID uint) ([]*domain.TeamUser, error)
	Update(ctx context.Context, teamUser *domain.TeamUser) error
	Delete(ctx context.Context, id uint) error
	DeleteByTeamAndOrgUser(ctx context.Context, teamID, orgUserID uint) error
}

type TokenRepository interface {
	Create(ctx context.Context, userID int, sessionUUID uuid.UUID, deviceID uuid.UUID, app string, kind string, tokenUUID uuid.UUID, token string, expiresAt time.Time) error
	GetByUUID(ctx context.Context, uuid string) (*domain.Token, error)
	CountActiveSessionsByUserID(ctx context.Context, userID int) (int, error)
	Delete(ctx context.Context, userID int) error
	DeleteByUUID(ctx context.Context, uuid string) error
	DeleteBySessionUUID(ctx context.Context, sessionUUID string) error
	DeleteExpired(ctx context.Context) (int64, error)
	Cleanup(ctx context.Context) error
	Migrate() error
}

type UserActivityRepository interface {
	Create(ctx context.Context, activity *domain.UserActivity) error
	GetByUserID(ctx context.Context, userID uint, limit int) ([]*domain.UserActivity, error)
	GetLastActivity(ctx context.Context, userID uint, activityType domain.ActivityType) (*domain.UserActivity, error)
	List(ctx context.Context, filter ActivityFilter) ([]*domain.UserActivity, int64, error)
	ListByUserIDs(ctx context.Context, userIDs []uint, limit int, offset int) ([]*domain.UserActivity, error)
	DeleteByUserID(ctx context.Context, userID uint) error
	DeleteOldActivities(ctx context.Context, olderThan time.Duration) (int64, error)
}

type UserAppearancePreferencesRepository interface {
	GetByUserID(ctx context.Context, userID uint) (*domain.UserAppearancePreferences, error)
	Upsert(ctx context.Context, prefs *domain.UserAppearancePreferences) error
}

type UserNotificationPreferencesRepository interface {
	GetByUserID(ctx context.Context, userID uint) (*domain.UserNotificationPreferences, error)
	Upsert(ctx context.Context, prefs *domain.UserNotificationPreferences) error
}

type UserRepository interface {
	GetByID(ctx context.Context, id uint) (*domain.User, error)
	GetByUUID(ctx context.Context, uuid string) (*domain.User, error)
	GetByEmail(ctx context.Context, email string) (*domain.User, error)
	GetBySchema(ctx context.Context, schema string) (*domain.User, error)
	List(ctx context.Context, filter ListFilter) ([]*domain.User, *ListResult, error)
	GetItemCount(ctx context.Context, schema string) (int, error)
	Create(ctx context.Context, user *domain.User) error
	Update(ctx context.Context, user *domain.User) error
	Delete(ctx context.Context, id uint, schema string) error
	Migrate() error
	CreateSchema(schema string) error
	MigrateUserSchema(schema string) error
}

type VerificationRepository interface {
	Create(ctx context.Context, code *domain.VerificationCode) error
	GetByEmailAndCode(ctx context.Context, email, code string) (*domain.VerificationCode, error)
	DeleteByEmail(ctx context.Context, email string) error
	DeleteExpired(ctx context.Context) (int64, error)
	Migrate() error
}