Skip to content
sqlite.cpp 5.16 KiB
Newer Older
jan.koester's avatar
jan.koester committed
/*******************************************************************************
 * Copyright (c) 2023, Jan Koester jan.koester@gmx.net
 * All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions are met:
 * Redistributions of source code must retain the above copyright
 *      notice, this list of conditions and the following disclaimer.
 * Redistributions in binary form must reproduce the above copyright
 *      notice, this list of conditions and the following disclaimer in the
 *      documentation and/or other materials provided with the distribution.
 * Neither the name of the <organization> nor the
 *      names of its contributors may be used to endorse or promote products
 *      derived from this software without specific prior written permission.
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
 * ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
 * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
 * DISCLAIMED. IN NO EVENT SHALL <COPYRIGHT HOLDER> BE LIABLE FOR ANY
 * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
 * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
 * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
 * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
 * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *******************************************************************************/

jan.koester's avatar
jan.koester committed
#include <iostream>
jan.koester's avatar
jan.koester committed
#include <atomic>

jan.koester's avatar
jan.koester committed
#include <httppp/exception.h>

#include <sqlite3.h>

#include "../database.h"

namespace blogi {
jan.koester's avatar
jan.koester committed

    std::atomic<bool> sqllock(false);

jan.koester's avatar
jan.koester committed
    class SQLite : public Database{
    public:
        SQLite(const char *constr) : Database (constr) {
jan.koester's avatar
jan.koester committed
            while( sqllock.exchange(true, std::memory_order_acquire) );
jan.koester's avatar
jan.koester committed
            int status=sqlite3_open(constr,&_dbconn);
            if (status != SQLITE_OK ){
jan.koester's avatar
jan.koester committed
                libhttppp::HTTPException exp;
                exp[libhttppp::HTTPException::Critical] << sqlite3_errmsg(_dbconn);
                sqlite3_close(_dbconn);
                throw exp;
            }
jan.koester's avatar
jan.koester committed
            sqllock.store(false);

jan.koester's avatar
jan.koester committed
        }

        ~SQLite(){
            sqlite3_close(_dbconn);
        }

jan.koester's avatar
jan.koester committed
        int exec(SQL *sql,DBResult &res) override{
jan.koester's avatar
jan.koester committed
            while( sqllock.exchange(true, std::memory_order_acquire) );
jan.koester's avatar
jan.koester committed
            char *ssql;
            ssql=new char[sql->length()];
            memcpy(ssql,sql->c_str(),sql->length());
jan.koester's avatar
jan.koester committed
            sqlite3_stmt *prep;
jan.koester's avatar
jan.koester committed
            int rcount = 0;
jan.koester's avatar
jan.koester committed

jan.koester's avatar
jan.koester committed
            res.clear();
jan.koester's avatar
jan.koester committed

jan.koester's avatar
jan.koester committed
            DBResult::Data *lastdat;
jan.koester's avatar
jan.koester committed

jan.koester's avatar
jan.koester committed
            const char *cssql=ssql;
jan.koester's avatar
jan.koester committed

jan.koester's avatar
jan.koester committed
            do{
jan.koester's avatar
jan.koester committed
                const char *sqlptr=nullptr;
jan.koester's avatar
ok  
jan.koester committed
                int pstate=sqlite3_prepare_v3(_dbconn,cssql,sql->length(),0,&prep,&sqlptr);
jan.koester's avatar
jan.koester committed

                cssql=sqlptr;
jan.koester's avatar
jan.koester committed

jan.koester's avatar
jan.koester committed
                if(pstate == SQLITE_ERROR) {
jan.koester's avatar
jan.koester committed
                    std::cerr << sqlite3_errmsg(_dbconn) << std::endl;
jan.koester's avatar
jan.koester committed
                    continue;
jan.koester's avatar
jan.koester committed
                if(!prep)
jan.koester's avatar
jan.koester committed
                    continue;

jan.koester's avatar
jan.koester committed
                int pcode;
jan.koester's avatar
jan.koester committed

root's avatar
root committed
                while( ( pcode = sqlite3_step(prep) ) !=SQLITE_DONE ) {

                   if(pcode==SQLITE_ERROR){
jan.koester's avatar
jan.koester committed
                        libhttppp::HTTPException exp;
                        exp[libhttppp::HTTPException::Critical] << sqlite3_errmsg(_dbconn);
                        delete[] ssql;
jan.koester's avatar
jan.koester committed
                        sqllock.store(false);
jan.koester's avatar
jan.koester committed
                        throw exp;
                    }
jan.koester's avatar
jan.koester committed

root's avatar
root committed
                    if(pcode==SQLITE_ROW){
                         int i;
                         for(i=0; i < sqlite3_column_count(prep); ++i){
                            if(!res.firstRow){
                                res.firstRow = new DBResult::Data(rcount,i,(const char*)sqlite3_column_text(prep,i),sqlite3_column_bytes(prep,i));
                                lastdat=res.firstRow;
                            }else{
                                lastdat->nextData=new DBResult::Data(rcount,i,(const char*)sqlite3_column_text(prep,i),sqlite3_column_bytes(prep,i));
                                lastdat=lastdat->nextData;
                            }
jan.koester's avatar
jan.koester committed
                        }
jan.koester's avatar
jan.koester committed
                        ++rcount;
jan.koester's avatar
jan.koester committed
                    }
root's avatar
root committed
          
                } 
                sqlite3_finalize(prep);
            }while(cssql != ssql+sql->length());
jan.koester's avatar
jan.koester committed

jan.koester's avatar
jan.koester committed
            sqllock.store(false);
jan.koester's avatar
jan.koester committed
            delete[] ssql;
jan.koester's avatar
jan.koester committed
            return rcount;
        };

        const char *getDriverName() override{
jan.koester's avatar
jan.koester committed
            return "sqlite";
        };

        const char *autoincrement() override{
jan.koester's avatar
jan.koester committed
            return "AUTOINCREMENT";
        }

        bool isConnected() override{
            int current,high;
            if(sqlite3_db_status(_dbconn,0,&current,&high,0)==SQLITE_OK)
                return true;
            return false;
        }

        void reset() override{
            int current,high;
            sqlite3_db_status(_dbconn,0,&current,&high,1);
        }

jan.koester's avatar
jan.koester committed
    private:

        sqlite3  *_dbconn;
    };
}