Sayonara Player
Tracks.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/SearchableModule.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 SearchableModule
42  {
43  PIMPL(Tracks)
44 
45  public:
46  Tracks(const QString& connection_name, DbId db_id, LibraryId _library_id);
47  ~Tracks();
48 
49  virtual bool db_fetch_tracks(Query& q, MetaDataList& result);
50 
51  virtual bool getAllTracksByAlbum(AlbumId album, MetaDataList& result);
52  virtual bool getAllTracksByAlbum(AlbumId album, MetaDataList& result, const ::Library::Filter& filter, ::Library::SortOrder sortorder = ::Library::SortOrder::TrackArtistAsc, int discnumber=-1);
53  virtual bool getAllTracksByAlbum(IdList albums, MetaDataList& result);
54  virtual bool getAllTracksByAlbum(IdList albums, MetaDataList& result, const ::Library::Filter& filter, ::Library::SortOrder sortorder = ::Library::SortOrder::TrackArtistAsc);
55 
56  virtual bool getAllTracksByArtist(ArtistId artist, MetaDataList& result);
57  virtual bool getAllTracksByArtist(ArtistId artist, MetaDataList& result, const ::Library::Filter& filter, ::Library::SortOrder sortorder = ::Library::SortOrder::TrackArtistAsc);
58  virtual bool getAllTracksByArtist(IdList artists, MetaDataList& result);
59  virtual bool getAllTracksByArtist(IdList artists, MetaDataList& result, const ::Library::Filter& filter, ::Library::SortOrder sortorder = ::Library::SortOrder::TrackArtistAsc);
60 
61  virtual bool getAllTracksBySearchString(const ::Library::Filter& filter, MetaDataList& result, ::Library::SortOrder sortorder = ::Library::SortOrder::TrackArtistAsc);
62 
63  virtual bool insertTrackIntoDatabase (const MetaData& data, ArtistId artist_id, AlbumId album_id);
64  virtual bool insertTrackIntoDatabase (const MetaData& data, ArtistId artist_id, AlbumId album_id, ArtistId album_artist_id);
65  virtual bool updateTrack(const MetaData& data);
66  virtual bool updateTracks(const MetaDataList& lst);
67 
68  virtual bool getAllTracks(MetaDataList& returndata, ::Library::SortOrder sortorder = ::Library::SortOrder::TrackArtistAsc);
69  virtual MetaData getTrackById(int id);
70  virtual MetaData getTrackByPath(const QString& path);
71  virtual bool getMultipleTracksByPath(const QStringList& paths, MetaDataList& v_md);
72 
73  virtual bool deleteTrack(TrackID id);
74  virtual bool deleteTracks(const MetaDataList&);
75  virtual bool deleteTracks(const IdList& ids);
76 
77 
78  // some tracks may be inserted two times
79  // this function deletes BOTH copies but returns those tracks
80  // which were found twice. Those tracks should be inserted by the store_metadata()
81  // function of LibraryDatabase
82  virtual bool deleteInvalidTracks(const QString& library_path, MetaDataList& double_metadata);
83 
84  virtual QString fetch_query_tracks() const;
85 
86  virtual SP::Set<Genre> getAllGenres();
87  virtual void updateTrackCissearch();
88 
89  void deleteAllTracks(bool also_views);
90  void drop_track_view();
91  void drop_search_view();
92 
93  protected:
94  virtual QString artistid_field() const=0;
95  virtual QString artistname_field() const=0;
96 
97  private:
98  void create_track_view(const QString& select_statement);
99  void create_track_search_view(const QString& select_statement);
100 
101 
102  QString append_track_sort_string(QString querytext, ::Library::SortOrder sort);
103  };
104 }
105 
106 #endif // DATABASETRACKS_H
Definition: Query.h:36
The MetaData class.
Definition: MetaData.h:48
Definition: Tracks.h:40
The MetaDataList class.
Definition: MetaDataList.h:38
Definition: SearchableModule.h:32
Definition: Albums.h:31
Definition: Genre.h:29
An interface class needed when implementing a library plugin.
Definition: CachingThread.h:31
A set structure. Inherited from std::set with some useful methods. For integer and String this set is...
Definition: AbstractPlaylist.h:38
Definition: org_mpris_media_player2_adaptor.h:20