PlaylistDao.hpp

#pragma once
 
#include <SQLiteCpp/SQLiteCpp.h>
 
#include <vector>

struct DBPlaylist
{
public:
    struct BasedOn
    {
        std::string fromType;
        std::string locationId;
        std::string fsPath;
        std::string name;
    };
 
public:
    DBPlaylist(int id, const std::string& name);
    DBPlaylist(int id, const std::string& name, std::vector<int> trackOrder,
        std::vector<BasedOn> basedOnList);
 
public:
    int                  id;
    std::string          name;
    std::vector<int>     trackOrder;
    std::vector<BasedOn> basedOnList;
};

class PlaylistDao
{
public:
    PlaylistDao(SQLite::Database& database);
 
    void                    Init() const;
    int                     AddPlaylist(const std::string& name) const;
    int                     AddNewOrGetPlaylist(const std::string& name) const;
    void                    RenamePlaylist(int id, const std::string& newName) const;
    std::vector<DBPlaylist> FetchAll() const;
 
    void AddTracksToPlaylist(int playlistId, std::vector<int> trackIds) const;
    void AddTrackToPlaylist(int playlistId, int trackId) const;
 
private:
    SQLite::Database& mDatabase;
};