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 class MetaData;
31 class MetaDataList;
32 class CustomPlaylist;
34 {
35 
36 private:
37  QString _fetch_query;
38 
39 protected:
40  void set_track_fetch_query(const QString& query);
41 
42 protected:
43  QString append_track_sort_string(QString querytext, SortOrder sort);
44 
45 public:
46  DatabaseTracks(QSqlDatabase db, quint8 db_id);
47 
48  virtual bool db_fetch_tracks(SayonaraQuery& q, MetaDataList& result);
49 
50  virtual bool getAllTracksByAlbum(int album, MetaDataList& result, Filter filter=Filter(), SortOrder sortorder = SortOrder::TrackArtistAsc, int discnumber=-1);
51  virtual bool getAllTracksByAlbum(IDList albums, MetaDataList& result, Filter filter=Filter(), SortOrder sortorder =SortOrder::TrackArtistAsc);
52 
53  virtual bool getAllTracksByArtist(int artist, MetaDataList& result, Filter filter=Filter(), SortOrder sortorder = SortOrder::TrackArtistAsc);
54  virtual bool getAllTracksByArtist(IDList artists, MetaDataList& result, Filter filter=Filter(), SortOrder sortorder =SortOrder::TrackArtistAsc);
55 
56  virtual bool getAllTracksBySearchString(Filter filter, MetaDataList& result, SortOrder sortorder = SortOrder::TrackArtistAsc);
57 
58  virtual bool insertTrackIntoDatabase (const MetaData& data,int artistID, int albumID);
59  virtual bool updateTrack(const MetaData& data);
60  virtual bool updateTracks(const MetaDataList& lst);
61 
62  virtual bool getTracksFromDatabase (MetaDataList& returndata, SortOrder sortorder = SortOrder::TrackArtistAsc);
63  virtual MetaData getTrackById(int id);
64  virtual MetaData getTrackByPath(const QString& path);
65  virtual bool getMultipleTracksByPath(const QStringList& paths, MetaDataList& v_md);
66 
67  virtual bool deleteTrack(int id);
68  virtual bool deleteTracks(const MetaDataList&);
69  virtual bool deleteTracks(const IDList& ids);
70  virtual bool deleteInvalidTracks();
71 
72  virtual QStringList getAllGenres();
73 
74 };
75 
76 #endif // DATABASETRACKS_H
Definition: Filter.h:31
Definition: MetaData.h:49
Definition: MetaDataList.h:46
Definition: SayonaraQuery.h:32
Definition: DatabaseModule.h:54
Definition: DatabaseTracks.h:33
The CustomPlaylist class.
Definition: CustomPlaylist.h:50