Engine.h

[詳解]

 
 
#pragma once
 
#include <Windows.h>
#include "sqlite3.h"
#include "Core.h"
 
namespace alt
{
    namespace db
    {
        class Engine : public Core
        {
        public:
            Engine ()
                :Core ()
            {
                _engine = nullptr;
                _lastError = SQLITE_OK;
            }
 
            virtual ~Engine ()
            {
                if (_engine != nullptr) Close ();
            }
 
            LPCTSTR GetErrorMessage ()
            {
                return (LPCTSTR)::sqlite3_errmsg16 (_engine);
            }
 
            bool Create (LPCTSTR lpctszDBName)
            {
                _lastError = ::sqlite3_open16 (lpctszDBName, &_engine);
                return getResponse ();
            }
 
            bool Close ()
            {
                _lastError = ::sqlite3_close (_engine);
                _engine = nullptr;
                return getResponse ();
            }
 
            bool Execute (LPCSTR lpcszSQL)
            {
                _lastError = ::sqlite3_exec (_engine, lpcszSQL, nullptr, nullptr, nullptr);
                return getResponse ();
            }
 
            bool BeginTransaction ()
            {
                return Execute ("BEGIN;");
            }
 
            bool CommitTransaction ()
            {
                return Execute ("COMMIT;");
            }
 
            bool RollbackTransaction ()
            {
                return Execute ("ROLLBACK;");
            }
 
            bool Vacuum ()
            {
                return Execute ("VACUUM;");
            }
 
            ULONGLONG GetLastRowID ()
            {
                return ::sqlite3_last_insert_rowid (_engine);
            }
 
            sqlite3* GetEngine ()
            {
                return _engine;
            }
 
        protected:
            sqlite3* _engine;
        };
    }
}