Sayonara Player
Public Types | Public Member Functions | Protected Member Functions | Protected Attributes | List of all members
SoundcloudData Class Reference

Public Types

enum  ArtistIDField : quint8 {
  AlbumArtistID,
  ArtistID
}
 

Public Member Functions

bool db_fetch_tracks (SayonaraQuery &q, MetaDataList &result) override
 
bool db_fetch_albums (SayonaraQuery &q, AlbumList &result) override
 
bool db_fetch_artists (SayonaraQuery &q, ArtistList &result) override
 
int updateArtist (const Artist &artist) override
 
int insertArtistIntoDatabase (const Artist &artist) override
 
int insertArtistIntoDatabase (const QString &artist) override
 
int updateAlbum (const Album &album) override
 
int insertAlbumIntoDatabase (const Album &album) override
 
int insertAlbumIntoDatabase (const QString &album) override
 
bool updateTrack (const MetaData &md) override
 
bool storeMetadata (const MetaDataList &v_md) override
 
bool insertTrackIntoDatabase (const MetaData &md, int artist_id, int album_id, int album_artist_id) override
 
bool insertTrackIntoDatabase (const MetaData &md, int artist_id, int album_id) override
 
bool apply_fixes () override
 
QString load_setting (const QString &key)
 
bool save_setting (const QString &key, const QString &value)
 
QString fetch_query_albums (bool also_empty=false) const override
 
QString fetch_query_artists (bool also_empty=false) const override
 
QString fetch_query_tracks () const override
 
void change_artistid_field (ArtistIDField field)
 
virtual void close_db ()
 
virtual bool is_initialized ()
 
virtual void transaction ()
 
virtual void commit ()
 
virtual void rollback ()
 
quint8 get_id ()
 
virtual int getAlbumID (const QString &album)
 
virtual bool getAlbumByID (const int &id, Album &album, bool also_empty=false)
 
virtual bool getAllAlbums (AlbumList &result, bool also_empty)
 
virtual bool getAllAlbums (AlbumList &result, Library::SortOrder sortorder=Library::SortOrder::AlbumNameAsc, bool also_empty=false)
 
virtual bool getAllAlbumsByArtist (int artist, AlbumList &result)
 
virtual bool getAllAlbumsByArtist (int artist, AlbumList &result, const Library::Filter &filter, Library::SortOrder sortorder=Library::SortOrder::AlbumNameAsc)
 
virtual bool getAllAlbumsByArtist (IDList artists, AlbumList &result)
 
virtual bool getAllAlbumsByArtist (IDList artists, AlbumList &result, const Library::Filter &filter, Library::SortOrder sortorder=Library::SortOrder::AlbumNameAsc)
 
virtual bool getAllAlbumsBySearchString (const Library::Filter &filter, AlbumList &result, Library::SortOrder sortorder=Library::SortOrder::AlbumNameAsc)
 
virtual void updateAlbumCissearch ()
 
Library::SearchModeMask search_mode ()
 
Library::SearchModeMask search_mode ()
 
void update_search_mode ()
 
void update_search_mode ()
 
virtual int getArtistID (const QString &artist)
 
virtual bool getArtistByID (int id, Artist &artist, bool also_empty=false)
 
virtual bool getAllArtists (ArtistList &result, bool also_empty)
 
virtual bool getAllArtists (ArtistList &result, Library::SortOrder sortorder=Library::SortOrder::ArtistNameAsc, bool also_empty=false)
 
virtual bool getAllArtistsBySearchString (const Library::Filter &filter, ArtistList &result, Library::SortOrder sortorder=Library::SortOrder::ArtistNameAsc)
 
virtual void updateArtistCissearch ()
 
virtual bool getAllTracksByAlbum (int album, MetaDataList &result)
 
virtual bool getAllTracksByAlbum (int album, MetaDataList &result, const Library::Filter &filter, Library::SortOrder sortorder=Library::SortOrder::TrackArtistAsc, int discnumber=-1)
 
virtual bool getAllTracksByAlbum (IDList albums, MetaDataList &result)
 
virtual bool getAllTracksByAlbum (IDList albums, MetaDataList &result, const Library::Filter &filter, Library::SortOrder sortorder=Library::SortOrder::TrackArtistAsc)
 
virtual bool getAllTracksByArtist (int artist, MetaDataList &result)
 
virtual bool getAllTracksByArtist (int artist, MetaDataList &result, const Library::Filter &filter, Library::SortOrder sortorder=Library::SortOrder::TrackArtistAsc)
 
virtual bool getAllTracksByArtist (IDList artists, MetaDataList &result)
 
virtual bool getAllTracksByArtist (IDList artists, MetaDataList &result, const Library::Filter &filter, Library::SortOrder sortorder=Library::SortOrder::TrackArtistAsc)
 
virtual bool getAllTracksBySearchString (const Library::Filter &filter, MetaDataList &result, Library::SortOrder sortorder=Library::SortOrder::TrackArtistAsc)
 
virtual bool updateTracks (const MetaDataList &lst)
 
virtual bool getAllTracks (MetaDataList &returndata, Library::SortOrder sortorder=Library::SortOrder::TrackArtistAsc)
 
virtual MetaData getTrackById (int id)
 
virtual MetaData getTrackByPath (const QString &path)
 
virtual bool getMultipleTracksByPath (const QStringList &paths, MetaDataList &v_md)
 
virtual bool deleteTrack (int id)
 
virtual bool deleteTracks (const MetaDataList &)
 
virtual bool deleteTracks (const IDList &ids)
 
virtual bool deleteInvalidTracks ()
 
virtual QStringList getAllGenres ()
 
virtual void updateTrackCissearch ()
 
bool updateTrackDates ()
 
virtual void dropIndexes ()
 
virtual void createIndexes ()
 
virtual void addAlbumArtists ()
 

Protected Member Functions

void change_artistid_field (const QString &field)
 
void change_artistid_field (const QString &field)
 
void change_artistid_field (const QString &field)
 
virtual bool exists ()
 
virtual bool create_db ()
 
virtual bool open_db ()
 
virtual bool check_and_insert_column (const QString &tablename, const QString &column, const QString &sqltype, const QString &default_value=QString())
 
virtual bool check_and_create_table (const QString &tablename, const QString &sql_create_str)
 
virtual bool check_and_drop_table (const QString &tablename)
 
QString append_track_sort_string (QString querytext, Library::SortOrder sort)
 

Protected Attributes

QSqlDatabase _database
 
QString _db_path
 
QString _db_name
 
QString _db_dir
 
quint8 _db_id
 
bool _initialized
 
QSqlDatabase _db
 
QSqlDatabase _db
 
QSqlDatabase _db
 
quint8 _module_db_id
 
quint8 _module_db_id
 
quint8 _module_db_id
 

Member Data Documentation

◆ _initialized

bool AbstractDatabase::_initialized
protectedinherited

Check if db of m_databaseFileContainer is existent

Returns
true if we can load the db false if not
Inheritance diagram for SoundcloudData:
LibraryDatabase AbstractDatabase DatabaseAlbums DatabaseArtists DatabaseTracks DatabaseLibrary DatabaseModule DatabaseSearchMode DatabaseModule DatabaseSearchMode DatabaseModule DatabaseSearchMode DatabaseModule