database

Jul 1, 2026

Changes in this version

type BrowseCursor

+ DirName string

+ Phase string

+ TotalDirs int

+ type BrowseDirCountOptions struct

+ PathPrefix string

+ Systems []systemdefs.System

type BrowseDirectoriesOptions

+ AfterName string

+ Limit int

type MediaDBI

+ BrowseDirCount func(ctx context.Context, opts BrowseDirCountOptions) (int, error)

Jun 25, 2026

Changes in this version

+ const CorruptMarkerSuffix

+ const DefaultIntegrityReportRows

+ var TagTypeDisplayPriority = []string

+ func ClearCorruptMarker(dbPath string) error

+ func CorruptMarkerPath(dbPath string) string

+ func IntegrityReport(ctx context.Context, sqlDB *sql.DB, maxRows int) []string

+ func IsCorruptionError(err error) bool

+ func IsMarkedCorrupt(dbPath string) bool

+ func MarkCorrupt(dbPath, reason string, now time.Time)

+ func NoteCorruption(dbPath string, err error, now time.Time) bool

+ func RemoveSidecars(dbPath string)

+ func TagTypeDisplayRank(tagType string) int

+ type BackupInfo struct

+ CreatedAt time.Time

+ Manual bool

+ Name string

+ Path string

+ QuickCheck string

+ Reason string

+ Size int64

+ Valid bool

+ type BrowseIndexBucket struct

+ AtStart bool

+ Count int

+ Key string

+ LastID int64

+ Offset int

+ SortValue string

+ type BrowseIndexOptions struct

+ PathPrefix string

+ Sort string

+ Systems []systemdefs.System

+ type BrowseIndexResult struct

+ Buckets []BrowseIndexBucket

+ Scheme string

+ SortMode string

+ TotalFiles int

+ type Conn struct

+ func (c *Conn) Load() *sql.DB

+ func (c *Conn) Store(db *sql.DB)

type MediaDBI

+ BrowseIndex func(ctx context.Context, opts BrowseIndexOptions) (BrowseIndexResult, error)

+ ClearCorruptMarker func() error

+ FindMediaIDsByPaths func(ctx context.Context, paths []string) ([]MediaPathID, error)

+ FlushBatchInserters func() error

+ GetExistingMediaUserData func(ctx context.Context) ([]MediaUserData, error)

+ GetMediaWithTagsBySystemID func(systemID string, loadMediaTags bool) ([]MediaWithFullPath, error)

+ IntegrityReport func() []string

+ IsMarkedCorrupt func() bool

+ MarkCorrupt func(reason string)

+ NoteCorruption func(err error) bool

+ QuickCheck func() (bool, error)

+ RecomputeSystemDisambiguation func(ctx context.Context, systemDBIDs []int64) error

+ RecomputeTitleDisambiguation func(ctx context.Context, titleDBIDs []int64) error

+ RecreateAfterCorruption func(keepBackup bool) error

+ UpdateMediaTitleName func(titleDBID int64, name string) error

+ type MediaPathID struct

+ DBID int64

+ Path string

+ SystemID string

type MediaTitle

+ DisambiguationTypes string

+ type MediaUserData struct

+ CreatedAt int64

+ DBID int64

+ IsFavorite bool

+ LauncherOverride string

+ Path string

+ SystemID string

+ UpdatedAt int64

type MediaWithFullPath

+ TagIDs []int

+ type RestoreInfo struct

+ PreRestoreBackup *BackupInfo

+ RestoredFrom BackupInfo

type SearchResult

+ MediaID int64

type SearchResultWithCursor

+ DisambiguationTypes string

type UserDBI

+ Backup func(reason string, manual bool) (BackupInfo, error)

+ ClearCorruptMarker func() error

+ DeleteMediaUserData func(systemID, path string) error

+ EnsureRecentBackup func(maxAge time.Duration) (BackupInfo, bool, error)

+ GetMediaUserData func(systemID, path string) (MediaUserData, bool, error)

+ IntegrityReport func() []string

+ IsMarkedCorrupt func() bool

+ ListBackups func() ([]BackupInfo, error)

+ ListMediaUserData func() ([]MediaUserData, error)

+ MarkCorrupt func(reason string)

+ NoteCorruption func(err error) bool

+ RecoverFromCorruption func() (RestoreInfo, error)

+ RestoreBackup func(name string) (RestoreInfo, error)

+ SetMediaUserFavorite func(systemID, path string, favorite bool) error

+ SetMediaUserLauncherOverride func(systemID, path, launcherID string) error

+ SumMediaPlayTimeForDay func(dayStart time.Time) (int64, error)

+ UpsertMediaUserData func(data *MediaUserData) error

Jun 11, 2026

Changes in this version

type Media

+ SortName string

type MediaDBI

+ AnalyzeApproximate func() error

+ ClearScrapeRunMarkers func(ctx context.Context, scraperID, runID string) error

+ CommitTransactionWithOptions func(options TransactionOptions) error

+ GetScrapeRunMediaIDs func(ctx context.Context, scraperID, runID string, systemDBID int64) (map[int64]struct{}, error)

+ ResolveSingletonContainerAliases func(ctx context.Context, systemDBID int64, candidates []SingletonAliasCandidate) ([]SingletonContainerAlias, error)

+ WALCheckpoint func() error

type MediaWithFullPath

+ SortName string

type ScanState

+ MediaNeedsSortName map[int]struct{}

+ MediaSortNames map[int]string

+ TitleNames map[int]string

type ScrapingOperation

+ RunID string

type SearchResultWithCursor

+ HasCover bool

+ type SingletonAliasCandidate struct

+ ChildDir string

+ FileCount int

+ type SingletonContainerAlias struct

+ ChildDir string

+ HasCover bool

+ Row MediaFullRow

+ Tags []TagInfo

+ ZapScriptTags []TagInfo

+ type TransactionOptions struct

+ WALCheckpoint WALCheckpointMode

+ type WALCheckpointMode int

+ const WALCheckpointAuto

+ const WALCheckpointForce

+ const WALCheckpointSkip

Jun 8, 2026

Changes in this version

type BrowseCursor

+ SortMode string

+ TotalFiles int

type MediaDBI

+ ClearScrapingOperation func() error

+ DeleteMediaTagsByTagIDs func(mediaDBID int64, tagDBIDs []int) error

+ FindSingleContainerLaunchMedia func(ctx context.Context, systemDBID int64, containerPath string) (*Media, error)

+ GetScannerMediaTagsBySystemID func(systemID string) ([]MediaTagLink, error)

+ GetScrapingOperation func() (ScrapingOperation, bool, error)

+ GetScrapingStatus func() (string, error)

+ SetScrapingOperation func(operation ScrapingOperation) error

+ SetScrapingStatus func(status string) error

+ type ScrapeResultBatchApplier interface

+ ApplyScrapeResults func(ctx context.Context, targets []ScrapeWriteTarget) error

+ type ScrapeWriteTarget struct

+ MediaDBID int64

+ MediaTitleDBID int64

+ Write *ScrapeWrite

+ type ScrapingOperation struct

+ Force bool

+ ScraperID string

+ Systems []string

type SearchResultWithCursor

+ MediaTitleID int64

+ SortMode string

+ SortValue string

type Tag

+ DisplayName string

type TagInfo

+ Label string

type UserDBI

+ GetLatestMediaHistory func() (MediaHistoryEntry, bool, error)

May 25, 2026

Changes in this version

+ const MaxMediaPropertyBinaryBytes

+ var ErrMediaBlobTooLarge = errors.New("media blob too large")

type MediaDBI

+ FindMediaBySystemAndPathSuffix func(ctx context.Context, systemDBID int64, filename string) ([]Media, error)

+ FindMediaTitleBySystemAndSlug func(ctx context.Context, systemDBID int64, slug string) (*MediaTitle, error)

+ GetMediaBlobDataCapped func(ctx context.Context, blobDBID int64, maxBytes int64) ([]byte, string, error)

+ GetMediaPropertyMetadata func(ctx context.Context, mediaDBID int64) ([]MediaProperty, error)

+ GetMediaPropertyMetadataByMediaDBIDs func(ctx context.Context, mediaDBIDs []int64) (map[int64][]MediaProperty, error)

+ GetMediaTitlePropertyMetadata func(ctx context.Context, mediaTitleDBID int64) ([]MediaProperty, error)

+ GetMediaTitlePropertyMetadataByMediaTitleDBIDs func(ctx context.Context, mediaTitleDBIDs []int64) (map[int64][]MediaProperty, error)

type MediaProperty

+ BlobSize int64

May 9, 2026

Changes in this version

+ type BrowseDirectoriesOptions struct

+ PathPrefix string

+ Systems []systemdefs.System

type BrowseDirectoryResult

+ SystemIDs []string

+ type BrowseFileCountOptions struct

+ Letter *string

+ PathPrefix string

+ Systems []systemdefs.System

type BrowseFilesOptions

+ Systems []systemdefs.System

+ type BrowseRouteCount struct

+ FileCount int

+ Path string

+ SystemIDs []string

+ type BrowseRouteCountsOptions struct

+ Routes []string

+ Systems []systemdefs.System

+ type BrowseSystemRootCandidates struct

+ Children map[string][]string

+ HasMedia map[string]bool

+ type BrowseSystemRootCandidatesOptions struct

+ Roots []string

+ Systems []systemdefs.System

type BrowseVirtualScheme

+ SystemIDs []string

+ type BrowseVirtualSchemesOptions struct

+ Systems []systemdefs.System

+ type MediaBlob struct

+ ContentType string

+ DBID int64

+ Data []byte

+ Hash string

type MediaDBI

+ ApplyScrapeResult func(ctx context.Context, mediaDBID, mediaTitleDBID int64, write *ScrapeWrite) error

+ BrowseRouteCounts func(ctx context.Context, opts BrowseRouteCountsOptions) (map[string]BrowseRouteCount, error)

+ BrowseSystemRootCandidates func(ctx context.Context, opts BrowseSystemRootCandidatesOptions) (result BrowseSystemRootCandidates, cacheReady bool, err error)

+ BumpIndexGeneration func() (int64, error)

+ CleanMediaOrphans func(ctx context.Context) (int64, error)

+ DeleteMediaProperty func(ctx context.Context, mediaDBID int64, typeTagDBID int64) error

+ DeleteMediaTitleProperty func(ctx context.Context, mediaTitleDBID int64, typeTagDBID int64) error

+ FindMediaBySystemAndPath func(ctx context.Context, systemDBID int64, path string) (*Media, error)

+ FindMediaBySystemAndPathFold func(ctx context.Context, systemDBID int64, path string) (*Media, error)

+ FindMediaBySystemAndPaths func(ctx context.Context, systemDBID int64, paths []string) (map[string]Media, error)

+ FindMediaTitleByDBID func(ctx context.Context, dbid int64) (*MediaTitle, error)

+ FindMediaTitlesWithoutSentinel func(ctx context.Context, systemDBID int64, sentinelTag string) ([]MediaTitle, error)

+ GetMediaBlob func(ctx context.Context, blobDBID int64) (*MediaBlob, error)

+ GetMediaProperties func(ctx context.Context, mediaDBID int64) ([]MediaProperty, error)

+ GetMediaPropertiesByMediaDBIDs func(ctx context.Context, mediaDBIDs []int64) (map[int64][]MediaProperty, error)

+ GetMediaTagsByMediaDBID func(ctx context.Context, mediaDBID int64) ([]TagInfo, error)

+ GetMediaTagsByMediaDBIDs func(ctx context.Context, mediaDBIDs []int64) (map[int64][]TagInfo, error)

+ GetMediaTitleProperties func(ctx context.Context, mediaTitleDBID int64) ([]MediaProperty, error)

+ GetMediaTitlePropertiesByMediaTitleDBIDs func(ctx context.Context, mediaTitleDBIDs []int64) (map[int64][]MediaProperty, error)

+ GetMediaTitleTagsByMediaTitleDBID func(ctx context.Context, mediaTitleDBID int64) ([]TagInfo, error)

+ GetMediaTitleTagsByMediaTitleDBIDs func(ctx context.Context, mediaTitleDBIDs []int64) (map[int64][]TagInfo, error)

+ GetMediaWithTitleAndSystem func(ctx context.Context, mediaDBID int64) (*MediaFullRow, error)

+ GetMediaWithTitleAndSystemByIDs func(ctx context.Context, mediaDBIDs []int64) (map[int64]MediaFullRow, error)

+ GetScrapedMediaCount func(ctx context.Context, scraperID string) (int, error)

+ GetScrapedMediaIDs func(ctx context.Context, scraperID string, systemDBID int64) (map[int64]struct{}, error)

+ GetTotalScrapedMediaCount func(ctx context.Context) (int, error)

+ IndexGeneration func() (int64, error)

+ LoadCachedSlugSearchCache func() (bool, error)

+ LoadCachedTagCache func() (bool, error)

+ MediaHasTag func(ctx context.Context, mediaDBID int64, tagValue string) (bool, error)

+ PersistSlugSearchCache func() error

+ PersistTagCache func() error

+ PruneOrphanedBlobs func(ctx context.Context) (int64, error)

+ TemporaryRepairJobsPending func(ctx context.Context) (bool, error)

+ UpdateMediaParentDir func(mediaDBID int64, parentDir string) error

+ UpsertMediaBlob func(ctx context.Context, contentType string, data []byte) (int64, error)

+ UpsertMediaProperties func(ctx context.Context, mediaDBID int64, props []MediaProperty) error

+ UpsertMediaTags func(ctx context.Context, mediaDBID int64, tags []TagInfo) error

+ UpsertMediaTitleProperties func(ctx context.Context, mediaTitleDBID int64, props []MediaProperty) error

+ UpsertMediaTitleTags func(ctx context.Context, mediaTitleDBID int64, tags []TagInfo) error

+ type MediaFullRow struct

+ System System

+ Title MediaTitle

+ type MediaProperty struct

+ Binary []byte

+ BlobDBID *int64

+ ContentType string

+ Text string

+ TypeTag string

+ TypeTagDBID int64

type MediaWithFullPath

+ ParentDir string

type ScanState

+ MediaParentDirs map[int]string

+ UserOwnedTagIDs map[int]bool

+ type ScrapeWrite struct

+ MediaProps []MediaProperty

+ MediaTags []TagInfo

+ Sentinel TagInfo

+ TitleProps []MediaProperty

+ TitleTags []TagInfo

type TagType

+ IsExclusive bool

Apr 27, 2026

Changes in this version

+ var ErrSchemaAhead = errors.New("database schema is newer than this binary supports")

+ func CheckSchemaVersion(db *sql.DB, migrationFiles embed.FS, migrationDir string) error

+ type Client struct

+ AuthToken string

+ ClientID string

+ ClientName string

+ CreatedAt int64

+ DBID int64

+ LastSeenAt int64

+ PairingKey []byte

type Media

+ IsMissing bool

type MediaDBI

+ BulkSetMediaMissing func(dbids map[int]struct{}) error

+ DeleteMediaTag func(mediaDBID, tagDBID int64) error

+ DeleteMediaTags func(mediaDBID int64) error

+ GetMediaTagsBySystemID func(systemID string) ([]MediaTagLink, error)

+ PopulateSystemTagsCacheForSystems func(ctx context.Context, systems []systemdefs.System) error

+ RefreshSlugSearchCacheForSystems func(ctx context.Context, systemIDs []string) error

+ ResetMissingFlags func(systemDBIDs []int) error

+ UpdateMediaTitle func(mediaDBID, mediaTitleDBID int64) error

+ type MediaTagLink struct

+ MediaDBID int64

+ TagDBID int64

type ScanState

+ MediaTagIDs map[int]map[int]struct{}

+ MediaTitleIDs map[int]int

+ MissingMedia map[int]struct{}

type TagInfo

+ Count int64

type UserDBI

+ CountClients func() (int, error)

+ CreateClient func(c *Client) error

+ DeleteClient func(clientID string) error

+ GetClientByToken func(authToken string) (*Client, error)

+ ListClients func() ([]Client, error)

+ UpdateClientLastSeen func(authToken string, lastSeenAt int64) error

Mar 29, 2026

Changes in this version

+ var ZapScriptTagTypes = []string

+ func BuildTitleZapScript(systemID, name string, tags []TagInfo) string

+ type BrowseCursor struct

+ LastID int64

+ SortValue string

+ type BrowseDirectoryResult struct

+ FileCount int

+ Name string

+ type BrowseFilesOptions struct

+ Cursor *BrowseCursor

+ Letter *string

+ Limit int

+ PathPrefix string

+ Sort string

+ type BrowseVirtualScheme struct

+ FileCount int

+ Scheme string

type Media

+ ParentDir string

type MediaDBI

+ BrowseDirectories func(ctx context.Context, pathPrefix string) ([]BrowseDirectoryResult, error)

+ BrowseFileCount func(ctx context.Context, pathPrefix string, letter *string) (int, error)

+ BrowseFiles func(ctx context.Context, opts *BrowseFilesOptions) ([]SearchResultWithCursor, error)

+ BrowseRootCounts func(ctx context.Context, rootDirs []string) (map[string]*int, error)

+ BrowseVirtualSchemes func(ctx context.Context) ([]BrowseVirtualScheme, error)

+ CreateSecondaryIndexes func() error

+ DropSecondaryIndexes func() error

+ GetZapScriptTagsBySystemAndPath func(ctx context.Context, systemID, path string) ([]TagInfo, error)

+ PopulateBrowseCache func(ctx context.Context) error

+ RebuildSlugSearchCache func() error

+ RebuildTagCache func() error

+ SetIndexingCacheSize func(enable bool)

+ type MediaHistoryTopEntry struct

+ LastPlayedAt time.Time

+ MediaName string

+ MediaPath string

+ SessionCount int

+ SystemID string

+ SystemName string

+ TotalPlayTime int

type SearchResultWithCursor

+ ZapScriptTags []TagInfo

+ func (r *SearchResultWithCursor) ZapScript() string

type UserDBI

+ GetMediaHistoryTop func(systemIDs []string, since *time.Time, limit int) ([]MediaHistoryTopEntry, error)

Feb 12, 2026

Changes in this version

+ func MediaKey(systemID, path string) string

+ func TagKey(tagType, tagValue string) string

+ func TitleKey(systemID, slug string) string

type MediaDBI

+ GetMediaBySystemID func(systemID string) ([]MediaWithFullPath, error)

+ GetTitlesBySystemID func(systemID string) ([]TitleWithSystem, error)

Jan 22, 2026

Changes in this version

type MediaDBI

+ GetYearBySystemAndPath func(ctx context.Context, systemID, path string) (string, error)

Jan 1, 2026

Changes in this version

+ type InboxMessage struct

+ Body string

+ Category string

+ CreatedAt time.Time

+ DBID int64

+ ProfileID int64

+ Severity int

+ Title string

type UserDBI

+ AddInboxMessage func(msg *InboxMessage) (*InboxMessage, error)

+ DeleteAllInboxMessages func() (int64, error)

+ DeleteInboxMessage func(id int64) error

+ GetInboxMessages func() ([]InboxMessage, error)

+ GetSupportedZapLinkHosts func() ([]string, error)

+ PruneExpiredZapLinkHosts func(olderThan time.Duration) (int64, error)

Dec 8, 2025

Changes in this version

type MediaDBI

+ BackgroundOperationDone func()

+ TrackBackgroundOperation func()

Nov 25, 2025

Changes in this version

+ func MigrateUp(db *sql.DB, migrationFiles embed.FS, migrationDir string) error

type HistoryEntry

+ BootUUID string

+ ClockReliable bool

+ CreatedAt time.Time

+ DeviceID *string

+ ID string

+ IsDeleted bool

+ MonotonicStart int64

+ SyncedAt *time.Time

+ type JournalMode string

+ const JournalModeDELETE

+ const JournalModeWAL

type Media

+ SystemDBID int64

type MediaDBI

+ FindSystemBySystemID func(systemID string) (System, error)

+ GetAllMedia func() ([]Media, error)

+ GetAllMediaTitles func() ([]MediaTitle, error)

+ GetAllSystems func() ([]System, error)

+ GetAllTagTypes func() ([]TagType, error)

+ GetAllTags func() ([]Tag, error)

+ GetAllUsedTags func(ctx context.Context) ([]TagInfo, error)

+ GetCachedSlugResolution func(ctx context.Context, systemID, slug string, tagFilters []TagFilter) (int64, string, bool)

+ GetIndexingStatus func() (string, error)

+ GetIndexingSystems func() ([]string, error)

+ GetLastIndexedSystem func() (string, error)

+ GetLaunchCommandForMedia func(ctx context.Context, systemID, path string) (string, error)

+ GetMaxMediaID func() (int64, error)

+ GetMaxMediaTagID func() (int64, error)

+ GetMaxSystemID func() (int64, error)

+ GetMaxTagID func() (int64, error)

+ GetMaxTagTypeID func() (int64, error)

+ GetMaxTitleID func() (int64, error)

+ GetMediaByDBID func(ctx context.Context, mediaDBID int64) (SearchResultWithCursor, error)

+ GetMediaWithFullPath func() ([]MediaWithFullPath, error)

+ GetMediaWithFullPathExcluding func(excludeSystemIDs []string) ([]MediaWithFullPath, error)

+ GetOptimizationStatus func() (string, error)

+ GetOptimizationStep func() (string, error)

+ GetSystemTagsCached func(ctx context.Context, systems []systemdefs.System) ([]TagInfo, error)

+ GetSystemsExcluding func(excludeSystemIDs []string) ([]System, error)

+ GetTags func(ctx context.Context, systems []systemdefs.System) ([]TagInfo, error)

+ GetTitlesWithPreFilter func(ctx context.Context, systemID string, ...) ([]MediaTitle, error)

+ GetTitlesWithSystems func() ([]TitleWithSystem, error)

+ GetTitlesWithSystemsExcluding func(excludeSystemIDs []string) ([]TitleWithSystem, error)

+ GetTotalMediaCount func() (int, error)

+ InvalidateCountCache func() error

+ InvalidateSlugCache func(ctx context.Context) error

+ InvalidateSlugCacheForSystems func(ctx context.Context, systemIDs []string) error

+ InvalidateSystemTagsCache func(ctx context.Context, systems []systemdefs.System) error

+ PopulateSystemTagsCache func(ctx context.Context) error

+ RandomGameWithQuery func(query *MediaQuery) (SearchResult, error)

+ RunBackgroundOptimization func(statusCallback func(optimizing bool))

+ SearchMediaBySecondarySlug func(ctx context.Context, systemID string, secondarySlug string, tags []TagFilter) ([]SearchResultWithCursor, error)

+ SearchMediaBySlug func(ctx context.Context, systemID string, slug string, tags []TagFilter) ([]SearchResultWithCursor, error)

+ SearchMediaBySlugIn func(ctx context.Context, systemID string, slugs []string, tags []TagFilter) ([]SearchResultWithCursor, error)

+ SearchMediaBySlugPrefix func(ctx context.Context, systemID string, slugPrefix string, tags []TagFilter) ([]SearchResultWithCursor, error)

+ SearchMediaWithFilters func(ctx context.Context, filters *SearchFilters) ([]SearchResultWithCursor, error)

+ SetCachedSlugResolution func(ctx context.Context, systemID, slug string, tagFilters []TagFilter, ...) error

+ SetIndexingStatus func(status string) error

+ SetIndexingSystems func(systemIDs []string) error

+ SetLastIndexedSystem func(systemID string) error

+ SetOptimizationStatus func(status string) error

+ SetOptimizationStep func(step string) error

+ TruncateSystems func(systemIDs []string) error

+ WaitForBackgroundOperations func()

+ type MediaHistoryEntry struct

+ BootUUID string

+ ClockReliable bool

+ ClockSource string

+ CreatedAt time.Time

+ DBID int64

+ DeviceID *string

+ DurationSec int

+ EndTime *time.Time

+ ID string

+ IsDeleted bool

+ LauncherID string

+ MediaName string

+ MediaPath string

+ MonotonicStart int64

+ PlayTime int

+ StartTime time.Time

+ SyncedAt *time.Time

+ SystemID string

+ SystemName string

+ TimeSkewFlag bool

+ UpdatedAt time.Time

+ WallDuration int

+ type MediaQuery struct

+ PathGlob string

+ PathPrefix string

+ Systems []string

+ Tags []TagFilter

type MediaTitle

+ SecondarySlug sql.NullString

+ SlugLength int

+ SlugWordCount int

+ type MediaWithFullPath struct

+ DBID int64

+ MediaTitleDBID int64

+ Path string

+ SystemID string

+ TitleSlug string

+ type SearchFilters struct

+ Cursor *int64

+ Letter *string

+ Limit int

+ Query string

+ Systems []systemdefs.System

+ Tags []TagFilter

+ type SearchResultWithCursor struct

+ MediaID int64

+ Name string

+ Path string

+ SystemID string

+ Tags []TagInfo

+ Year *string

+ type TagFilter struct

+ Operator TagOperator

+ Type string

+ Value string

+ func GroupTagFiltersByOperator(filters []TagFilter) (and, not, or []TagFilter)

+ type TagInfo struct

+ Tag string

+ Type string

+ type TagOperator string

+ const TagOperatorAND

+ const TagOperatorNOT

+ const TagOperatorOR

+ type TitleWithSystem struct

+ DBID int64

+ Name string

+ Slug string

+ SystemDBID int64

+ SystemID string

type UserDBI

+ AddMediaHistory func(entry *MediaHistoryEntry) (int64, error)

+ CleanupHistory func(retentionDays int) (int64, error)

+ CleanupMediaHistory func(retentionDays int) (int64, error)

+ CloseHangingMediaHistory func() error

+ CloseMediaHistory func(dbid int64, endTime time.Time, playTime int) error

+ GetMediaHistory func(lastID, limit int) ([]MediaHistoryEntry, error)

+ HealTimestamps func(bootUUID string, trueBootTime time.Time) (int64, error)

+ UpdateMediaHistoryTime func(dbid int64, playTime int) error

Sep 13, 2025

Changes in this version

+ type Database struct

+ MediaDB MediaDBI

+ UserDB UserDBI

+ type FileInfo struct

+ Name string

+ Path string

+ SystemID string

+ type GenericDBI interface

+ Allocate func() error

+ Close func() error

+ GetDBPath func() string

+ MigrateUp func() error

+ Open func() error

+ Truncate func() error

+ UnsafeGetSQLDb func() *sql.DB

+ Vacuum func() error

+ type HistoryEntry struct

+ DBID int64

+ Success bool

+ Time time.Time

+ TokenData string

+ TokenID string

+ TokenValue string

+ Type string

+ type Mapping struct

+ Added int64

+ DBID int64

+ Enabled bool

+ Label string

+ Match string

+ Override string

+ Pattern string

+ Type string

+ type Media struct

+ DBID int64

+ MediaTitleDBID int64

+ Path string

+ type MediaDBI interface

+ BeginTransaction func() error

+ CommitTransaction func() error

+ Exists func() bool

+ FindMedia func(row Media) (Media, error)

+ FindMediaTag func(row MediaTag) (MediaTag, error)

+ FindMediaTitle func(row MediaTitle) (MediaTitle, error)

+ FindOrInsertMedia func(row Media) (Media, error)

+ FindOrInsertMediaTag func(row MediaTag) (MediaTag, error)

+ FindOrInsertMediaTitle func(row MediaTitle) (MediaTitle, error)

+ FindOrInsertSystem func(row System) (System, error)

+ FindOrInsertTag func(row Tag) (Tag, error)

+ FindOrInsertTagType func(row TagType) (TagType, error)

+ FindSystem func(row System) (System, error)

+ FindTag func(row Tag) (Tag, error)

+ FindTagType func(row TagType) (TagType, error)

+ GetLastGenerated func() (time.Time, error)

+ IndexedSystems func() ([]string, error)

+ InsertMedia func(row Media) (Media, error)

+ InsertMediaTag func(row MediaTag) (MediaTag, error)

+ InsertMediaTitle func(row MediaTitle) (MediaTitle, error)

+ InsertSystem func(row System) (System, error)

+ InsertTag func(row Tag) (Tag, error)

+ InsertTagType func(row TagType) (TagType, error)

+ RandomGame func(systems []systemdefs.System) (SearchResult, error)

+ ReindexTables func() error

+ RollbackTransaction func() error

+ SearchMediaPathExact func(systems []systemdefs.System, query string) ([]SearchResult, error)

+ SearchMediaPathGlob func(systems []systemdefs.System, query string) ([]SearchResult, error)

+ SearchMediaPathWords func(systems []systemdefs.System, query string) ([]SearchResult, error)

+ SystemIndexed func(system systemdefs.System) bool

+ UpdateLastGenerated func() error

+ type MediaTag struct

+ DBID int64

+ MediaDBID int64

+ TagDBID int64

+ type MediaTitle struct

+ DBID int64

+ Name string

+ Slug string

+ SystemDBID int64

+ type ScanState struct

+ MediaIDs map[string]int

+ MediaIndex int

+ MediaTagsIndex int

+ SystemIDs map[string]int

+ SystemsIndex int

+ TagIDs map[string]int

+ TagTypeIDs map[string]int

+ TagTypesIndex int

+ TagsIndex int

+ TitleIDs map[string]int

+ TitlesIndex int

+ type SearchResult struct

+ Name string

+ Path string

+ SystemID string

+ type System struct

+ DBID int64

+ Name string

+ SystemID string

+ type Tag struct

+ DBID int64

+ Tag string

+ TypeDBID int64

+ type TagType struct

+ DBID int64

+ Type string

+ type UserDBI interface

+ AddHistory func(entry *HistoryEntry) error

+ AddMapping func(m *Mapping) error

+ DeleteMapping func(id int64) error

+ GetAllMappings func() ([]Mapping, error)

+ GetEnabledMappings func() ([]Mapping, error)

+ GetHistory func(lastID int) ([]HistoryEntry, error)

+ GetMapping func(id int64) (Mapping, error)

+ GetZapLinkCache func(url string) (string, error)

+ GetZapLinkHost func(host string) (bool, bool, error)

+ UpdateMapping func(id int64, m *Mapping) error

+ UpdateZapLinkCache func(url string, zapscript string) error

+ UpdateZapLinkHost func(host string, zapscript int) error