Sayonara Player
Loading...
Searching...
No Matches
Public Member Functions | Protected Member Functions | List of all members
SC::LibraryDatabase Class Reference
Inheritance diagram for SC::LibraryDatabase:
DB::LibraryDatabase DB::Albums DB::Artists DB::Tracks DB::Module

Public Member Functions

 LibraryDatabase (const QString &connectionName, DbId databaseId, LibraryId libraryId)
 
QString fetchQueryAlbums (bool alsoEmpty=false) const override
 
QString fetchQueryArtists (bool alsoEmpty=false) const override
 
QString fetchQueryTracks (const QString &where) const override
 
bool dbFetchTracks (QSqlQuery &query, MetaDataList &result) const override
 
bool dbFetchAlbums (QSqlQuery &query, AlbumList &result) const override
 
bool dbFetchArtists (QSqlQuery &query, ArtistList &result) const override
 
ArtistId updateArtist (const Artist &artist)
 
ArtistId insertArtistIntoDatabase (const Artist &artist) override
 
ArtistId insertArtistIntoDatabase (const QString &artist) override
 
bool getAllAlbums (AlbumList &result, bool alsoEmpty) const override
 
AlbumId updateAlbum (const Album &album)
 
AlbumId insertAlbumIntoDatabase (const Album &album) override
 
AlbumId insertAlbumIntoDatabase (const QString &album) override
 
bool updateTrack (const MetaData &track) override
 
bool storeMetadata (const MetaDataList &tracks) override
 
bool insertTrackIntoDatabase (const MetaData &track, int artistId, int albumId, int albumArtistId) override
 
bool searchInformation (SC::SearchInformationList &searchInformation)
 
LibraryId libraryId () const override
 
bool fixEmptyAlbums ()
 
void updateSearchMode ()
 
void changeArtistIdField (ArtistIdInfo::ArtistIdField field)
 
MetaDataList insertMissingArtistsAndAlbums (const MetaDataList &tracks)
 
virtual void initViews ()
 
void initViews ()
 
virtual bool getAlbumByID (AlbumId id, Album &album) const
 
virtual bool getAlbumByID (AlbumId id, Album &album, bool alsoEmpty) const
 
virtual bool getAllAlbumsByArtist (const IdList &artists, AlbumList &result, const ::Library::Filter &filter) const
 
virtual bool getAllAlbumsBySearchString (const ::Library::Filter &filter, AlbumList &result) const
 
virtual AlbumId updateAlbumRating (AlbumId id, Rating rating)
 
virtual void deleteOrphanedAlbums ()
 
virtual ArtistId getArtistID (const QString &artist) const
 
virtual bool getArtistByID (ArtistId id, Artist &artist) const
 
virtual bool getArtistByID (ArtistId id, Artist &artist, bool alsoEmpty) const
 
virtual bool getAllArtists (ArtistList &result, bool alsoEmpty) const
 
virtual bool getAllArtistsBySearchString (const ::Library::Filter &filter, ArtistList &result) const
 
virtual bool deleteArtist (ArtistId id)
 
virtual int getNumTracks () const
 
virtual bool getAllTracks (MetaDataList &result) const
 
virtual bool getAllTracksByAlbum (const IdList &albumsIds, MetaDataList &result) const
 
virtual bool getAllTracksByAlbum (const IdList &track, MetaDataList &result, const ::Library::Filter &filter, int discnumber) const
 
virtual bool getAllTracksByArtist (const IdList &artistIds, MetaDataList &result) const
 
virtual bool getAllTracksByArtist (const IdList &artistIds, MetaDataList &result, const ::Library::Filter &filter) const
 
virtual bool getAllTracksBySearchString (const ::Library::Filter &filter, MetaDataList &result) const
 
virtual bool getAllTracksByPaths (const QStringList &paths, MetaDataList &tracks) const
 
virtual MetaData getTrackById (TrackID id) const
 
virtual MetaData getTrackByPath (const QString &path) const
 
virtual bool getMultipleTracksByPath (const QStringList &paths, MetaDataList &tracks) const
 
virtual bool insertTrackIntoDatabase (const MetaData &track, ArtistId artistId, AlbumId albumId, ArtistId albumArtistId)
 
virtual bool renameFilepaths (const QMap< QString, QString > &paths, LibraryId libraryId)
 
virtual bool renameFilepath (const QString &oldPath, const QString &newPath, LibraryId libraryId)
 
virtual bool deleteTrack (TrackID id)
 
virtual bool deleteTracks (const IdList &ids)
 
virtual bool deleteInvalidTracks (const QString &libraryPath, MetaDataList &doubleMetadata)
 
virtual Util::Set< GenregetAllGenres () const
 
void deleteAllTracks (bool alsoViews)
 
QSqlDatabase db () const
 
DbId databaseId () const
 
QString connectionName () const
 
QSqlQuery runQuery (const QString &query, const QString &errorText) const
 
QSqlQuery runQuery (const QString &query, const QPair< QString, QVariant > &bindings, const QString &errorText) const
 
QSqlQuery runQuery (const QString &query, const QMap< QString, QVariant > &bindings, const QString &errorText) const
 
QSqlQuery update (const QString &tablename, const QMap< QString, QVariant > &fieldBindings, const QPair< QString, QVariant > &whereBinding, const QString &errorMessage)
 
QSqlQuery insert (const QString &tablename, const QMap< QString, QVariant > &fieldBindings, const QString &errorMessage)
 
void transaction ()
 
void commit ()
 
void rollback ()
 

Protected Member Functions

virtual void deleteAllAlbums ()
 
virtual void updateAlbumCissearch ()
 
virtual void updateArtistCissearch ()
 
virtual void deleteAllArtists ()
 
virtual void updateTrackCissearch ()
 

Member Function Documentation

◆ dbFetchAlbums()

bool SC::LibraryDatabase::dbFetchAlbums ( QSqlQuery & query,
AlbumList & result ) const
overridevirtual

Reimplemented from DB::Albums.

◆ dbFetchArtists()

bool SC::LibraryDatabase::dbFetchArtists ( QSqlQuery & query,
ArtistList & result ) const
overridevirtual

Reimplemented from DB::Artists.

◆ dbFetchTracks()

bool SC::LibraryDatabase::dbFetchTracks ( QSqlQuery & query,
MetaDataList & result ) const
overridevirtual

Reimplemented from DB::Tracks.

◆ fetchQueryAlbums()

QString SC::LibraryDatabase::fetchQueryAlbums ( bool alsoEmpty = false) const
overridevirtual

Reimplemented from DB::Albums.

◆ fetchQueryArtists()

QString SC::LibraryDatabase::fetchQueryArtists ( bool alsoEmpty = false) const
overridevirtual

Reimplemented from DB::Artists.

◆ fetchQueryTracks()

QString SC::LibraryDatabase::fetchQueryTracks ( const QString & where) const
overridevirtual

Reimplemented from DB::Tracks.

◆ getAllAlbums()

bool SC::LibraryDatabase::getAllAlbums ( AlbumList & result,
bool alsoEmpty ) const
overridevirtual

Reimplemented from DB::Albums.

◆ insertAlbumIntoDatabase() [1/2]

AlbumId SC::LibraryDatabase::insertAlbumIntoDatabase ( const Album & album)
overridevirtual

Reimplemented from DB::Albums.

◆ insertAlbumIntoDatabase() [2/2]

AlbumId SC::LibraryDatabase::insertAlbumIntoDatabase ( const QString & album)
overridevirtual

Reimplemented from DB::Albums.

◆ insertArtistIntoDatabase() [1/2]

ArtistId SC::LibraryDatabase::insertArtistIntoDatabase ( const Artist & artist)
overridevirtual

Reimplemented from DB::Artists.

◆ insertArtistIntoDatabase() [2/2]

ArtistId SC::LibraryDatabase::insertArtistIntoDatabase ( const QString & artist)
overridevirtual

Reimplemented from DB::Artists.

◆ libraryId()

LibraryId DB::LibraryDatabase::libraryId ( ) const
overridevirtualinherited

Implements DB::Albums.

◆ storeMetadata()

bool SC::LibraryDatabase::storeMetadata ( const MetaDataList & tracks)
overridevirtual

Reimplemented from DB::LibraryDatabase.

◆ updateTrack()

bool SC::LibraryDatabase::updateTrack ( const MetaData & track)
overridevirtual

Reimplemented from DB::Tracks.