sqldatabase.h

Go to the documentation of this file.

 
#ifndef SQLDATABASE_H
#define SQLDATABASE_H
 
#ifndef SQLITE_HAS_CODEC
#define SQLITE_HAS_CODEC
#endif
 
#include <filesystem>
#include <functional>
#include <memory>
#include <mutex>
#include <string>
#include <unordered_map>
#ifdef _WIN32
#include <sqlcipher/sqlite3.h>
#else
#include "sqlite3.h"
#endif
#include "sqlcontext.h"
#include "sqlstatement.h"
 
namespace Nickvision::Database
{
    using SqliteCustomFunction = std::function<void(SqlContext&)>;
 
    class SqlDatabase
    {
    public:
        SqlDatabase(const std::filesystem::path& path, int flags);
        SqlDatabase(const SqlDatabase& database);
        SqlDatabase(SqlDatabase&& database) noexcept;
        const std::filesystem::path& getPath() const;
        bool isEncrypted() const;
        sqlite3* c_obj();
        bool unlock(const std::string& password);
        bool changePassword(const std::string& password);
        bool exec(const std::string& command);
        SqlStatement createStatement(const std::string& command);
        bool registerFunction(const std::string& name, const SqliteCustomFunction& func, int expectedArgs = -1);
        SqlDatabase& operator=(const SqlDatabase& database);
        SqlDatabase& operator=(SqlDatabase&& database) noexcept;
        operator bool() const;
 
    private:
        mutable std::mutex m_mutex;
        std::filesystem::path m_path;
        int m_flags;
        bool m_isEncrypted;
        std::shared_ptr<sqlite3> m_database;
        bool m_isUnlocked;
        std::unordered_map<std::string, SqliteCustomFunction> m_custom;
    };
}
 
#endif //SQLDATABASE_H