Program Listing for File trackDB.cpp

↰ Return to documentation for file (include/db/trackDB.cpp)

#include "trackDB.hpp"
// #include "errorTable.hpp"


#define CHK_BIND(res)\
if(res != SQLITE_OK){\
return false;\
}
// errpdje::ereport("sql bind errno: " + std::to_string(SQLITE_LAST_ERRNO), errpdje::ERR_TYPE::SQL_ERROR, ("trackDB bind " + std::string(error_type)));}


trackdata::trackdata(stmt* dbstate)
{
    trackTitle = dbstate->colGet<COL_TYPE::TEXT, std::string>(0);

    mixBinary = dbstate->colGet<COL_TYPE::BLOB, BIN>(1);

    noteBinary = dbstate->colGet<COL_TYPE::BLOB, BIN>(2);

    cachedMixList = dbstate->colGet<COL_TYPE::TEXT, std::string>(3);

}

trackdata::trackdata(const std::string& trackTitle__)
:trackTitle(trackTitle__)
{

}

bool
trackdata::GenSearchSTMT(stmt& dbstate, sqlite3* db)
{
    dbstate.placeHold
    =
    "SELECT * FROM TRACK "
    "WHERE (? = -1 OR TrackTitle = ?);"
    ;
    if(!dbstate.activate(db)){
        return false;
    }
    if(trackTitle == ""){
        CHK_BIND((dbstate.bind_int(1, -1)))
    }
    CHK_BIND(
    dbstate.bind_text(2, trackTitle)
    )

    return true;
}


bool
trackdata::GenInsertSTMT(stmt& dbstate, sqlite3* db)
{
    dbstate.placeHold
    =
    "INSERT INTO TRACK "
    "(TrackTitle, MixBinary, NoteBinary, CachedMixList) "
    "VALUES "
    "(?, ?, ?, ?); ";
    if(!dbstate.activate(db)){
        return false;
    }
    CHK_BIND( dbstate.bind_text(1, trackTitle));
    CHK_BIND( dbstate.bind_blob(2, mixBinary));
    CHK_BIND( dbstate.bind_blob(3, noteBinary));
    CHK_BIND( dbstate.bind_text(4, cachedMixList));
    return true;
}


bool
trackdata::GenEditSTMT(stmt& dbstate, sqlite3* db, trackdata& toEdit)
{
    dbstate.placeHold
    =
    "UPDATE TRACK "
    "SET TrackTitle = ?, MixBinary = ?, NoteBinary = ?, CachedMixList = ? "
    "WHERE TrackTitle = ?; ";

    if(!dbstate.activate(db)) return false;

    CHK_BIND(dbstate.bind_text  (1, toEdit.trackTitle   ))
    CHK_BIND(dbstate.bind_blob  (2, toEdit.mixBinary    ))
    CHK_BIND(dbstate.bind_blob  (3, toEdit.noteBinary   ))
    CHK_BIND(dbstate.bind_text  (4, toEdit.cachedMixList))
    CHK_BIND(dbstate.bind_text  (5, trackTitle          ))

    return true;

}


bool
trackdata::GenDeleteSTMT(stmt& dbstate, sqlite3* db)
{
    dbstate.placeHold
    =
    "DELETE FROM TRACK "
    "WHERE TrackTitle = ?; ";

    if(!dbstate.activate(db)) return false;

    CHK_BIND(dbstate.bind_text(1, trackTitle))

    return true;
}

#undef CHK_BIND