mediadb

func (*MediaDB) Allocate ¶

func (db *MediaDB) Allocate() error

func (*MediaDB) BeginTransaction ¶

func (db *MediaDB) BeginTransaction() error

func (*MediaDB) Close ¶

func (db *MediaDB) Close() error

func (*MediaDB) CommitTransaction ¶

func (db *MediaDB) CommitTransaction() error

func (*MediaDB) Exists ¶

func (db *MediaDB) Exists() bool

func (*MediaDB) FindMedia ¶

func (db *MediaDB) FindMedia(row database.Media) (database.Media, error)

func (*MediaDB) FindMediaTag ¶

func (db *MediaDB) FindMediaTag(row database.MediaTag) (database.MediaTag, error)

func (*MediaDB) FindMediaTitle ¶

func (db *MediaDB) FindMediaTitle(row database.MediaTitle) (database.MediaTitle, error)

func (*MediaDB) FindOrInsertMedia ¶

func (db *MediaDB) FindOrInsertMedia(row database.Media) (database.Media, error)

func (*MediaDB) FindOrInsertMediaTag ¶

func (db *MediaDB) FindOrInsertMediaTag(row database.MediaTag) (database.MediaTag, error)

func (*MediaDB) FindOrInsertMediaTitle ¶

func (db *MediaDB) FindOrInsertMediaTitle(row database.MediaTitle) (database.MediaTitle, error)

func (*MediaDB) FindOrInsertSystem ¶

func (db *MediaDB) FindOrInsertSystem(row database.System) (database.System, error)

func (*MediaDB) FindOrInsertTag ¶

func (db *MediaDB) FindOrInsertTag(row database.Tag) (database.Tag, error)

func (*MediaDB) FindOrInsertTagType ¶

func (db *MediaDB) FindOrInsertTagType(row database.TagType) (database.TagType, error)

func (*MediaDB) FindSystem ¶

func (db *MediaDB) FindSystem(row database.System) (database.System, error)

func (*MediaDB) FindTag ¶

func (db *MediaDB) FindTag(row database.Tag) (database.Tag, error)

func (*MediaDB) FindTagType ¶

func (db *MediaDB) FindTagType(row database.TagType) (database.TagType, error)

func (*MediaDB) GetDBPath ¶

func (db *MediaDB) GetDBPath() string

func (*MediaDB) GetLastGenerated ¶

func (db *MediaDB) GetLastGenerated() (time.Time, error)

func (*MediaDB) IndexedSystems ¶

func (db *MediaDB) IndexedSystems() ([]string, error)

IndexedSystems returns all systems indexed in the media database.

func (*MediaDB) InsertMedia ¶

func (db *MediaDB) InsertMedia(row database.Media) (database.Media, error)

func (*MediaDB) InsertMediaTag ¶

func (db *MediaDB) InsertMediaTag(row database.MediaTag) (database.MediaTag, error)

func (*MediaDB) InsertMediaTitle ¶

func (db *MediaDB) InsertMediaTitle(row database.MediaTitle) (database.MediaTitle, error)

func (*MediaDB) InsertSystem ¶

func (db *MediaDB) InsertSystem(row database.System) (database.System, error)

func (*MediaDB) InsertTag ¶

func (db *MediaDB) InsertTag(row database.Tag) (database.Tag, error)

func (*MediaDB) InsertTagType ¶

func (db *MediaDB) InsertTagType(row database.TagType) (database.TagType, error)

func (*MediaDB) MigrateUp ¶

func (db *MediaDB) MigrateUp() error

func (*MediaDB) Open ¶

func (db *MediaDB) Open() error

func (*MediaDB) RandomGame ¶

func (db *MediaDB) RandomGame(systems []systemdefs.System) (database.SearchResult, error)

RandomGame returns a random game from specified systems.

func (*MediaDB) ReindexTables ¶

func (db *MediaDB) ReindexTables() error

func (*MediaDB) RollbackTransaction ¶

func (db *MediaDB) RollbackTransaction() error

RollbackTransaction rolls back the current transaction and cleans up resources

func (*MediaDB) SearchMediaPathExact ¶

func (db *MediaDB) SearchMediaPathExact(systems []systemdefs.System, query string) ([]database.SearchResult, error)

SearchMediaPathExact returns indexed names matching an exact query (case-insensitive).

func (*MediaDB) SearchMediaPathGlob ¶

func (db *MediaDB) SearchMediaPathGlob(systems []systemdefs.System, query string) ([]database.SearchResult, error)

func (*MediaDB) SearchMediaPathWords ¶

func (db *MediaDB) SearchMediaPathWords(systems []systemdefs.System, query string) ([]database.SearchResult, error)

SearchMediaPathWords returns indexed names that include every word in a query (case-insensitive).

func (*MediaDB) SetSQLForTesting ¶

func (db *MediaDB) SetSQLForTesting(ctx context.Context, sqlDB *sql.DB, platform platforms.Platform) error

SetSQLForTesting allows injection of a sql.DB instance for testing purposes. This method should only be used in tests to set up in-memory databases.

func (*MediaDB) SystemIndexed ¶

func (db *MediaDB) SystemIndexed(system systemdefs.System) bool

SystemIndexed returns true if a specific system is indexed in the media database.

func (*MediaDB) Truncate ¶

func (db *MediaDB) Truncate() error

func (*MediaDB) UnsafeGetSQLDb ¶

func (db *MediaDB) UnsafeGetSQLDb() *sql.DB

func (*MediaDB) UpdateLastGenerated ¶

func (db *MediaDB) UpdateLastGenerated() error

func (*MediaDB) Vacuum ¶

func (db *MediaDB) Vacuum() error