src/drift/DB_SQLite.h

//@[email protected]@
/***********************************************************************\
|                    Drift Standard Libraries v1.01                     |
|            Copyright 2010-2020 Drift Solutions / Indy Sams            |
| Docs and more information available at https://www.driftsolutions.dev |
|          This file released under the 3-clause BSD license,           |
|            see included DSL.LICENSE.TXT file for details.             |
\***********************************************************************/
//@[email protected]@

#ifndef _INCLUDE_SQLITECONX_H_
#define _INCLUDE_SQLITECONX_H_

#include <drift/DB_Common.h>
#include <sqlite3.h>

#if defined(DSL_DLL) && defined(WIN32)
        #if defined(DSL_SQLITE_EXPORTS)
                #define DSL_SQLITE_API extern "C" __declspec(dllexport)
                #define DSL_SQLITE_API_CLASS __declspec(dllexport)
        #else
                #define DSL_SQLITE_API extern "C" __declspec(dllimport)
                #define DSL_SQLITE_API_CLASS __declspec(dllimport)
        #endif
#else
        #define DSL_SQLITE_API
        #define DSL_SQLITE_API_CLASS
#endif

class DSL_SQLITE_API_CLASS SQLite_Result {
public:
        size_t ind = 0;
        vector<SC_Row> rows;
};

class DSL_SQLITE_API_CLASS DB_SQLite: public SQLConx {
public:
        DB_SQLite();
        ~DB_SQLite();

        bool Open(std::string filename);
        bool IsOpen();
        void Close();

        std::string GetErrorString();
        int GetError();

        SQLite_Result * Query(std::string query, uint32_t len = 0);
        size_t NumRows(SQLite_Result *result);
        bool FetchRow(SQLite_Result *result, SC_Row& retRow);
        bool FreeResult(SQLite_Result *result);

        uint32_t InsertID();
        int64_t InsertID64();
        int AffectedRows();
        uint32_t GetQueryCount();

        std::string EscapeString(std::string str);
        std::string MPrintf(const char * str, ...);
        sqlite3 * GetHandle();

        SQLConxMulti * MultiStart();
        bool MultiSend(SQLConxMulti *);
        bool MultiEnd(SQLConxMulti *);
        void SCM_Query(std::string query, uint32_t len = 0);

private:
        sqlite3 * handle;
        uint32_t query_count = 0;
};

#endif //_INCLUDE_SQLITECONX_H_

---