SQLiteDatabaseModel.h

#pragma once
 
#include "Import/WebFrameworkCore.h"
 
#include "SQLiteDatabase.h"
#include "SQLiteResult.h"
 
#define DECLARE_DATABASE_NAME(DatabaseName) public: static constexpr std::string_view databaseName = DatabaseName; inline std::string_view getDatabaseName() const override { return databaseName; }
#define DECLARE_TABLE_NAME(TableName) public: static constexpr std::string_view tableName = TableName; inline std::string_view getTableName() const override { return tableName; }
#define DECLARE_DATABASE_AND_TABLE_NAME(DatabaseName, TableName) DECLARE_DATABASE_NAME(DatabaseName); \
                                                                 DECLARE_TABLE_NAME(TableName);
 
namespace framework
{
    namespace sqlite
    {
        class WEB_FRAMEWORK_API SQLiteDatabaseModel
        {
        public:
            static constexpr std::string_view databaseName = "";
            static constexpr std::string_view tableName = "";
 
        protected:
            std::shared_ptr<SQLiteDatabase> database;
 
        private:
            std::shared_ptr<SQLiteDatabase> databaseConstructor;
 
        protected:
            static bool isNumber(std::string_view source);
 
            static std::string convertToValue(std::string_view source);
 
        protected:
            utility::SQLiteResult execute(const std::string& query);
 
        public:
            SQLiteDatabaseModel();
 
            SQLiteDatabaseModel(const SQLiteDatabaseModel&) = delete;
 
            SQLiteDatabaseModel& operator = (const SQLiteDatabaseModel&) = delete;
 
            SQLiteDatabaseModel(SQLiteDatabaseModel&& other) noexcept = default;
 
            SQLiteDatabaseModel& operator = (SQLiteDatabaseModel&& other) noexcept = default;
 
            utility::SQLiteResult raw(const std::string& query);
 
            virtual void createTable(const std::vector<std::pair<std::string, std::string>>& attributes = {});
 
            virtual void dropTable();
 
            virtual void recreateTable(const std::vector<std::pair<std::string, std::string>>& attributes = {});
 
            virtual utility::SQLiteResult insert(const std::unordered_map<std::string, std::string>& attributes = {});
 
            virtual void update(const std::unordered_map<std::string, std::string>& attributes, const std::string& fieldName, const std::string& fieldValue);
 
            virtual void deleteQuery(const std::string& fieldName, const std::string& fieldValue);
 
            virtual void deleteQuery(const std::unordered_map<std::string, std::string>& attributes = {});
 
            utility::SQLiteResult selectAll();
 
            virtual utility::SQLiteResult selectByField(const std::string& fieldName, const std::string& fieldValue);
 
            virtual utility::SQLiteResult selectByField(const std::unordered_map<std::string, std::string>& attributes);
 
            virtual std::string_view getDatabaseName() const = 0;
 
            virtual std::string_view getTableName() const = 0;
 
            virtual ~SQLiteDatabaseModel() = default;
 
            friend class SQLiteManager;
        };
    }
}