1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
|
#pragma once
#include <QHash>
#include <QObject>
#include <QSqlDatabase>
#include <QSet>
#include "library/dao/dao.h"
#include "track/trackid.h"
#include "util/class.h"
#define PLAYLIST_TABLE "Playlists"
#define PLAYLIST_TRACKS_TABLE "PlaylistTracks"
const QString PLAYLISTTABLE_ID = "id";
const QString PLAYLISTTABLE_NAME = "name";
const QString PLAYLISTTABLE_POSITION = "position";
const QString PLAYLISTTABLE_HIDDEN = "hidden";
const QString PLAYLISTTABLE_DATECREATED = "date_created";
const QString PLAYLISTTABLE_DATEMODIFIED = "date_modified";
const QString PLAYLISTTRACKSTABLE_TRACKID = "track_id";
const QString PLAYLISTTRACKSTABLE_POSITION = "position";
const QString PLAYLISTTRACKSTABLE_PLAYLISTID = "playlist_id";
const QString PLAYLISTTRACKSTABLE_DATETIMEADDED = "pl_datetime_added";
#define AUTODJ_TABLE "Auto DJ"
class AutoDJProcessor;
class PlaylistDAO : public QObject, public virtual DAO {
Q_OBJECT
public:
enum HiddenType {
PLHT_NOT_HIDDEN = 0,
PLHT_AUTO_DJ = 1,
PLHT_SET_LOG = 2,
PLHT_UNKNOWN = -1
};
enum class AutoDJSendLoc {
TOP,
BOTTOM,
REPLACE,
};
PlaylistDAO();
~PlaylistDAO() override = default;
void initialize(const QSqlDatabase& database) override;
// Create a playlist, fails with -1 if already exists
int createPlaylist(const QString& name, const HiddenType type = PLHT_NOT_HIDDEN);
// Create a playlist, appends "(n)" if already exists, name becomes the new name
int createUniquePlaylist(QString* pName, const HiddenType type = PLHT_NOT_HIDDEN);
// Delete a playlist
void deletePlaylist(const int playlistId);
// Rename a playlist
void renamePlaylist(const int playlistId, const QString& newName);
// Lock or unlock a playlist
bool setPlaylistLocked(const int playlistId, const bool locked);
// Find out the state of a playlist lock
bool isPlaylistLocked(const int playlistId) const;
// Append a list of tracks to a playlist
bool appendTracksToPlaylist(const QList<TrackId>& trackIds, const int playlistId);
// Append a track to a playlist
bool appendTrackToPlaylist(TrackId trackId, const int playlistId);
// Find out how many playlists exist.
unsigned int playlistCount() const;
// Find out the name of the playlist at the given Id
QString getPlaylistName(const int playlistId) const;
// Get the playlist id by its name
int getPlaylistIdFromName(const QString& name) const;
// Get the id of the playlist at index. Note that the index is the natural
// position in the database table, not the display order position column
// stored in the database.
int getPlaylistId(const int index) const;
QList<TrackId> getTrackIds(const int playlistId) const;
// Returns true if the playlist with playlistId is hidden
bool isHidden(const int playlistId) const;
// Returns the HiddenType of playlistId
HiddenType getHiddenType(const int playlistId) const;
// Returns the maximum position of the given playlist
int getMaxPosition(const int playlistId) const;
// Remove a track from all playlists
void removeTracksFromPlaylists(const QList<TrackId>& trackIds);
// removes all hidden and purged Tracks from the playlist
void removeHiddenTracks(const int playlistId);
// Remove a track from a playlist
void removeTrackFromPlaylist(int playlistId, int position);
void removeTracksFromPlaylist(int playlistId, const QList<int>& positions);
void removeTracksFromPlaylistById(int playlistId, TrackId trackId);
// Insert a track into a specific position in a playlist
bool insertTrackIntoPlaylist(TrackId trackId, int playlistId, int position);
// Inserts a list of tracks into playlist
int insertTracksIntoPlaylist(const QList<TrackId>& trackIds, const int playlistId, int position);
// Add a playlist to the Auto-DJ Queue
void addPlaylistToAutoDJQueue(const int playlistId, AutoDJSendLoc loc);
// Add a list of tracks to the Auto-DJ Queue
void addTracksToAutoDJQueue(const QList<TrackId>& trackIds, AutoDJSendLoc loc);
// Get the preceding playlist of currentPlaylistId with the HiddenType
// hidden. Returns -1 if no such playlist exists.
int getPreviousPlaylist(const int currentPlaylistId, HiddenType hidden) const;
// Append all the tracks in the source playlist to the target playlist.
bool copyPlaylistTracks(const int sourcePlaylistID, const int targetPlaylistID);
// Returns the number of tracks in the given playlist.
int tracksInPlaylist(const int playlistId) const;
// moved Track to a new position
void moveTrack(const int playlistId,
const int oldPosition, const int newPosition);
// shuffles all tracks in the position List
void shuffleTracks(const int playlistId, const QList<int>& positions, const QHash<int,TrackId>& allIds);
bool isTrackInPlaylist(TrackId trackId, const int playlistId) const;
void getPlaylistsTrackIsIn(TrackId trackId, QSet<int>* playlistSet) const;
void setAutoDJProcessor(AutoDJProcessor* pAutoDJProcessor);
signals:
void added(int playlistId);
void deleted(int playlistId);
void renamed(int playlistId, const QString& newName);
void lockChanged(int playlistId);
void trackAdded(int playlistId, TrackId trackId, int position);
void trackRemoved(int playlistId, TrackId trackId, int position);
void tracksChanged(const QSet<int>& playlistIds); // added/removed/reordered
private:
bool removeTracksFromPlaylist(int playlistId, int startIndex);
void removeTracksFromPlaylistInner(int playlistId, int position);
void removeTracksFromPlaylistByIdInner(int playlistId, TrackId trackId);
void searchForDuplicateTrack(const int fromPosition,
const int toPosition,
TrackId trackID,
const int excludePosition,
const int otherTrackPosition,
const QHash<int,TrackId>* pTrackPositionIds,
int* pTrackDistance);
void populatePlaylistMembershipCache();
QMultiHash<TrackId, int> m_playlistsTrackIsIn;
AutoDJProcessor* m_pAutoDJProcessor;
DISALLOW_COPY_AND_ASSIGN(PlaylistDAO);
};
|
