Sayonara Player
Tracks.h
1 /* DatabaseTracks.h */
2 
3 /* Copyright (C) 2011-2019 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/Pimpl.h"
26 
27 namespace Library
28 {
29  class Filter;
30 }
31 
32 class Genre;
33 
34 namespace DB
35 {
36  class Tracks :
37  private SearchableModule
38  {
39  PIMPL(Tracks)
40 
41  public:
42  Tracks(const QString& connection_name, DbId db_id, LibraryId _library_id);
43  ~Tracks() override;
44 
45  virtual bool db_fetch_tracks(Query& q, MetaDataList& result) const;
46 
47  virtual int getNumTracks() const;
48  virtual bool getAllTracks(MetaDataList& result) const;
49 
50  virtual bool getAllTracksByAlbum(const IdList& albumsIds, MetaDataList& result) const;
51  virtual bool getAllTracksByAlbum(const IdList& albumIds, MetaDataList& result,
52  const ::Library::Filter& filter, int discnumber) const;
53  virtual bool getAllTracksByArtist(const IdList& artistIds, MetaDataList& result) const;
54  virtual bool getAllTracksByArtist(const IdList& artistIds, MetaDataList& result,
55  const ::Library::Filter& filter) const;
56  virtual bool getAllTracksBySearchString(const ::Library::Filter& filter, MetaDataList& result) const;
57 
58 
59  virtual MetaData getTrackById(TrackID id) const;
60  virtual bool getTracksByIds(const QList<TrackID> &ids, MetaDataList &v_md) const;
61  virtual MetaData getTrackByPath(const QString& path) const;
62  virtual bool getMultipleTracksByPath(const QStringList& paths, MetaDataList& v_md) const;
63 
64  virtual bool insertTrackIntoDatabase(const MetaData& data, ArtistId artist_id, AlbumId album_id);
65  virtual bool insertTrackIntoDatabase(const MetaData& data, ArtistId artist_id, AlbumId album_id, ArtistId album_artist_id);
66  virtual bool updateTrack(const MetaData& data);
67  virtual bool updateTracks(const MetaDataList& lst);
68 
69  virtual bool deleteTrack(TrackID id);
70  virtual bool deleteTracks(const MetaDataList&);
71  virtual bool deleteTracks(const IdList& ids);
72 
73 
74  // some tracks may be inserted two times
75  // this function deletes BOTH copies but returns those tracks
76  // which were found twice. Those tracks should be inserted by the store_metadata()
77  // function of LibraryDatabase
78  virtual bool deleteInvalidTracks(const QString& library_path, MetaDataList& double_metadata);
79 
80  virtual QString fetch_query_tracks() const;
81 
82  virtual Util::Set<Genre> getAllGenres() const;
83  virtual void updateTrackCissearch();
84 
85  void deleteAllTracks(bool also_views);
86  void drop_track_view();
87  void drop_search_view();
88 
89  protected:
90  virtual QString artistid_field() const=0;
91  virtual QString artistname_field() const=0;
92 
93  private:
94  void create_track_view(const QString& select_statement);
95  void create_track_search_view(const QString& select_statement);
96  };
97 }
98 
99 #endif // DATABASETRACKS_H
Definition: Query.h:35
The MetaData class.
Definition: MetaData.h:44
Definition: Tracks.h:36
The MetaDataList class.
Definition: MetaDataList.h:37
Definition: SearchableModule.h:32
A set structure. Inherited from std::set with some useful methods. For integer and String this set is...
Definition: Set.h:35
Definition: Albums.h:30
Definition: Genre.h:30
An interface class needed when implementing a library plugin.
Definition: LocalLibraryWatcher.h:32
Definition: EngineUtils.h:33