TrackDao.hpp

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

struct DBTrack
{
    DBTrack() = default;
    DBTrack(int id, int playlistId, std::string fromType, std::string locationId,
        std::string fsPath, std::string name, int inode);
 
    int         id;
    int         playlistId;
    std::string fromType;
    std::string locationId;
    std::string fsPath;
    std::string name;
    int         inode;
};

class TrackDao
{
public:
    TrackDao(SQLite::Database& database);
    void                 Init() const;
    std::vector<DBTrack> FetchAllFromPlaylist(int playlist_id) const;
    std::vector<DBTrack> FetchAll() const;
    DBTrack               FetchOneByID(int playlist_id) const;
    DBTrack               FetchOneByYaID(const std::string& location_id) const;
    DBTrack               FetchOneByPath(const std::string& fs_path) const;
    int                  AddTrack(DBTrack track) const;
    std::vector<int>     AddTracks(std::vector<DBTrack> tracks) const;
 
private:
    SQLite::Database& mDatabase;
};