X-Git-Url: https://git.pterodactylus.net/?a=blobdiff_plain;f=src%2Fdb%2Fsqlite3db.cpp;fp=src%2Fdb%2Fsqlite3db.cpp;h=86a4f87f3a6e84d0eb8113a87e1d5fd2ac0c0dae;hb=dec33c63afafabf83c3039e916725cac6faef9b3;hp=edf2e8b3b0af39537e3484e8c9a2f69d2f8e1dbf;hpb=9b22dd53fe62e312c1647310b7ec43aa127090af;p=fms.git diff --git a/src/db/sqlite3db.cpp b/src/db/sqlite3db.cpp index edf2e8b..86a4f87 100644 --- a/src/db/sqlite3db.cpp +++ b/src/db/sqlite3db.cpp @@ -30,8 +30,7 @@ const bool DB::Close() { if(IsOpen()) { - //ZThread::Guard g(m_mutex); - PThread::Guard g(m_mutex); + Poco::ScopedLock g(m_mutex); m_lastresult=sqlite3_close(m_db); if(m_lastresult==SQLITE_OK) { @@ -53,8 +52,7 @@ const bool DB::Execute(const std::string &sql) { if(IsOpen()) { - //ZThread::Guard g(m_mutex); - PThread::Guard g(m_mutex); + Poco::ScopedLock g(m_mutex); m_lastresult=sqlite3_exec(m_db,sql.c_str(),NULL,NULL,NULL); if(m_lastresult==SQLITE_OK) { @@ -75,8 +73,7 @@ const bool DB::ExecuteInsert(const std::string &sql, long &insertid) { if(IsOpen()) { - //ZThread::Guard g(m_mutex); - PThread::Guard g(m_mutex); + Poco::ScopedLock g(m_mutex); m_lastresult=sqlite3_exec(m_db,sql.c_str(),NULL,NULL,NULL); if(m_lastresult==SQLITE_OK) { @@ -98,8 +95,7 @@ const int DB::GetLastError(std::string &errormessage) { if(IsOpen()) { - //ZThread::Guard g(m_mutex); - PThread::Guard g(m_mutex); + Poco::ScopedLock g(m_mutex); int errcode=sqlite3_errcode(m_db); const char *errmsg=sqlite3_errmsg(m_db); if(errmsg) @@ -122,8 +118,7 @@ void DB::Initialize() const bool DB::IsOpen() { - //ZThread::Guard g(m_mutex); - PThread::Guard g(m_mutex); + Poco::ScopedLock g(m_mutex); return m_db ? true : false; } @@ -135,8 +130,7 @@ const bool DB::Open(const std::string &filename) } if(IsOpen()==false) { - //ZThread::Guard g(m_mutex); - PThread::Guard g(m_mutex); + Poco::ScopedLock g(m_mutex); m_lastresult=sqlite3_open(filename.c_str(),&m_db); if(m_lastresult==SQLITE_OK) { @@ -157,8 +151,7 @@ Statement DB::Prepare(const std::string &sql) { if(IsOpen()) { - //ZThread::Guard g(m_mutex); - PThread::Guard g(m_mutex); + Poco::ScopedLock g(m_mutex); sqlite3_stmt *statement=NULL; m_lastresult=sqlite3_prepare_v2(m_db,sql.c_str(),sql.size(),&statement,NULL); if(m_lastresult==SQLITE_OK) @@ -180,8 +173,7 @@ Recordset DB::Query(const std::string &sql) { if(IsOpen()) { - //ZThread::Guard g(m_mutex); - PThread::Guard g(m_mutex); + Poco::ScopedLock g(m_mutex); char **rs=NULL; int rows,cols; m_lastresult=sqlite3_get_table(m_db,sql.c_str(),&rs,&rows,&cols,NULL); @@ -205,8 +197,7 @@ const int DB::SetBusyTimeout(const int ms) { if(IsOpen()) { - //ZThread::Guard g(m_mutex); - PThread::Guard g(m_mutex); + Poco::ScopedLock g(m_mutex); m_lastresult=sqlite3_busy_timeout(m_db,ms); return m_lastresult; }