Sayonara Player
DatabaseTracks.h
1 /* DatabaseTracks.h */
2 
3 /* Copyright (C) 2011-2017 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 #ifndef DATABASETRACKS_H
22 #define DATABASETRACKS_H
23 
24 #include "Database/DatabaseSearchMode.h"
25 #include "Utils/Library/Sortorder.h"
26 #include "Utils/Pimpl.h"
27 #include "Utils/SetFwd.h"
28 
29 #include <QString>
30 #include <QList>
31 
32 namespace Library {class Filter;}
33 
34 class Genre;
35 class MetaData;
36 class MetaDataList;
37 
38 namespace DB
39 {
40  class Tracks :
41  private SearchMode
42  {
43  PIMPL(Tracks)
44 
45  protected:
46  void change_artistid_field(const QString& id, const QString& name);
47  void change_track_lookup_field(const QString& track_lookup_field);
48 
49  void check_track_views(LibraryId library_id);
50  void check_track_view(LibraryId library_id);
51  void check_track_search_view(const QString& track_view, const QString& track_search_view);
52 
53  protected:
54  QString append_track_sort_string(QString querytext, ::Library::SortOrder sort);
55 
56  public:
57  Tracks(const QSqlDatabase& db, DbId db_id, LibraryId _library_id);
58  ~Tracks();
59 
60  virtual bool db_fetch_tracks(Query& q, MetaDataList& result);
61 
62  virtual bool getAllTracksByAlbum(int album, MetaDataList& result);
63  virtual bool getAllTracksByAlbum(int album, MetaDataList& result, const ::Library::Filter& filter, ::Library::SortOrder sortorder = ::Library::SortOrder::TrackArtistAsc, int discnumber=-1);
64  virtual bool getAllTracksByAlbum(IdList albums, MetaDataList& result);
65  virtual bool getAllTracksByAlbum(IdList albums, MetaDataList& result, const ::Library::Filter& filter, ::Library::SortOrder sortorder = ::Library::SortOrder::TrackArtistAsc);
66 
67  virtual bool getAllTracksByArtist(int artist, MetaDataList& result);
68  virtual bool getAllTracksByArtist(int artist, MetaDataList& result, const ::Library::Filter& filter, ::Library::SortOrder sortorder = ::Library::SortOrder::TrackArtistAsc);
69  virtual bool getAllTracksByArtist(IdList artists, MetaDataList& result);
70  virtual bool getAllTracksByArtist(IdList artists, MetaDataList& result, const ::Library::Filter& filter, ::Library::SortOrder sortorder = ::Library::SortOrder::TrackArtistAsc);
71 
72  virtual bool getAllTracksBySearchString(const ::Library::Filter& filter, MetaDataList& result, ::Library::SortOrder sortorder = ::Library::SortOrder::TrackArtistAsc);
73 
74  virtual bool insertTrackIntoDatabase (const MetaData& data,int artist_id, int album_id);
75  virtual bool insertTrackIntoDatabase (const MetaData& data,int artist_id, int album_id, int album_artist_id);
76  virtual bool updateTrack(const MetaData& data);
77  virtual bool updateTracks(const MetaDataList& lst);
78 
79  virtual bool getAllTracks(MetaDataList& returndata, ::Library::SortOrder sortorder = ::Library::SortOrder::TrackArtistAsc);
80  virtual MetaData getTrackById(int id);
81  virtual MetaData getTrackByPath(const QString& path);
82  virtual bool getMultipleTracksByPath(const QStringList& paths, MetaDataList& v_md);
83 
84  virtual bool deleteTrack(int id);
85  virtual bool deleteTracks(const MetaDataList&);
86  virtual bool deleteTracks(const IdList& ids);
87 
88 
89  // some tracks may be inserted two times
90  // this function deletes BOTH copies but returns those tracks
91  // which were found twice. Those tracks should be inserted by the store_metadata()
92  // function of LibraryDatabase
93  virtual bool deleteInvalidTracks(const QString& library_path, MetaDataList& double_metadata);
94 
95  virtual QString fetch_query_tracks() const;
96 
97  virtual SP::Set<Genre> getAllGenres();
98  virtual void updateTrackCissearch();
99 
100  void deleteAllTracks();
101  };
102 }
103 
104 #endif // DATABASETRACKS_H
Definition: SayonaraQuery.h:36
Definition: DatabaseSearchMode.h:32
The MetaData class.
Definition: MetaData.h:48
Definition: DatabaseTracks.h:40
The MetaDataList class.
Definition: MetaDataList.h:38
Definition: AbstractDatabase.h:29
Definition: Genre.h:27
An interface class needed when implementing a library plugin.
Definition: LibraryManager.h:36
A set structure. Inherited from std::set with some useful methods. For integer and String this set is...
Definition: AbstractPlaylist.h:36