sqlite3.hxx

#pragma once
 
#include <StormByte/database/database.hxx>
#include <StormByte/database/sqlite/preparedSTMT.hxx>
#include <StormByte/database/sqlite/query.hxx>
#include <StormByte/database/sqlite/exception.hxx>
 
#include <filesystem>
#include <list>
#include <map>
#include <memory>
 
class sqlite3; // Forward declaration so we don't have to depend on sqlite3 headers
namespace StormByte::Database::SQLite {
    class STORMBYTE_DATABASE_PUBLIC SQLite3: public Database<Query, PreparedSTMT> {
        public:
            SQLite3(const SQLite3& db)                              = delete;
 
            SQLite3(SQLite3&& db) noexcept                          = default;
 
            SQLite3& operator=(const SQLite3& db)                   = delete;
 
            SQLite3& operator=(SQLite3&& db) noexcept               = default;
 
            virtual ~SQLite3() noexcept;
 
        protected:
            SQLite3();
 
            SQLite3(const std::filesystem::path& dbfile);
 
            SQLite3(std::filesystem::path&& dbfile);
 
            void                                                Connect() override;
 
            void                                                Disconnect() override;
 
            const std::string                                   LastError() const override;
 
        private:
            std::filesystem::path m_database_file;  
 
            sqlite3* m_database;                    
 
            void                                                EnableForeignKeys();
 
            void                                                InternalDisconnect();
 
            std::unique_ptr<PreparedSTMT>                       InternalPrepare(const std::string& name, const std::string& query) override;
 
            std::unique_ptr<Query>                              InternalQuery(const std::string& query) override;
    };
}