Sayonara Player
DatabaseTracks.h
1 /* DatabaseTracks.h */
2 
3 /* Copyright (C) 2011-2016 Lucio Carreras
4  *
5  * This file is part of sayonara player
6  *
7  * This program is free software: you can redistribute it and/or modify
8  * it under the terms of the GNU General Public License as published by
9  * the Free Software Foundation, either version 3 of the License, or
10  * (at your option) any later version.
11 
12  * This program is distributed in the hope that it will be useful,
13  * but WITHOUT ANY WARRANTY; without even the implied warranty of
14  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15  * GNU General Public License for more details.
16 
17  * You should have received a copy of the GNU General Public License
18  * along with this program. If not, see <http://www.gnu.org/licenses/>.
19  */
20 
21 
22 
23 #ifndef DATABASETRACKS_H
24 #define DATABASETRACKS_H
25 
26 #include "Components/Library/Sorting.h"
27 #include "Database/DatabaseModule.h"
28 #include "Helper/globals.h"
29 #include "Helper/Filter.h"
30 #include "Helper/LibrarySearchMode.h"
31 
32 class MetaData;
33 class MetaDataList;
34 class CustomPlaylist;
36 {
37 
38 private:
39  QString _fetch_query;
40 
41 protected:
42  void set_track_fetch_query(const QString& query);
43 
44 protected:
45  QString append_track_sort_string(QString querytext, SortOrder sort);
46 
47 public:
48  DatabaseTracks(QSqlDatabase db, quint8 db_id);
49 
50  virtual bool db_fetch_tracks(SayonaraQuery& q, MetaDataList& result);
51 
52  virtual bool getAllTracksByAlbum(int album, MetaDataList& result, Filter filter=Filter(), SortOrder sortorder = SortOrder::TrackArtistAsc, int discnumber=-1);
53  virtual bool getAllTracksByAlbum(IDList albums, MetaDataList& result, Filter filter=Filter(), SortOrder sortorder =SortOrder::TrackArtistAsc);
54 
55  virtual bool getAllTracksByArtist(int artist, MetaDataList& result, Filter filter=Filter(), SortOrder sortorder = SortOrder::TrackArtistAsc);
56  virtual bool getAllTracksByArtist(IDList artists, MetaDataList& result, Filter filter=Filter(), SortOrder sortorder =SortOrder::TrackArtistAsc);
57 
58  virtual bool getAllTracksBySearchString(Filter filter, MetaDataList& result, SortOrder sortorder = SortOrder::TrackArtistAsc);
59 
60  virtual bool insertTrackIntoDatabase (const MetaData& data,int artistID, int albumID);
61  virtual bool updateTrack(const MetaData& data);
62  virtual bool updateTracks(const MetaDataList& lst);
63 
64  virtual bool getTracksFromDatabase (MetaDataList& returndata, SortOrder sortorder = SortOrder::TrackArtistAsc);
65  virtual MetaData getTrackById(int id);
66  virtual MetaData getTrackByPath(const QString& path);
67  virtual bool getMultipleTracksByPath(const QStringList& paths, MetaDataList& v_md);
68 
69  virtual bool deleteTrack(int id);
70  virtual bool deleteTracks(const MetaDataList&);
71  virtual bool deleteTracks(const IDList& ids);
72  virtual bool deleteInvalidTracks();
73 
74  virtual QStringList getAllGenres();
75  virtual void updateTrackCissearch(LibraryHelper::SearchModeMask mode);
76 
77 };
78 
79 #endif // DATABASETRACKS_H
Definition: Filter.h:31
Definition: MetaData.h:49
Definition: MetaDataList.h:44
Definition: SayonaraQuery.h:32
Definition: DatabaseModule.h:54
Definition: DatabaseTracks.h:35
The CustomPlaylist class.
Definition: CustomPlaylist.h:50