LotroDat/Source/Database.h

//
// Created by Иван_Архипов on 17.11.2017.
//

#ifndef LOTRO_DAT_PATCHER_DATABASE_H
#define LOTRO_DAT_PATCHER_DATABASE_H

#include "Common/SQLite/sqlite3.h"
#include <string>

extern  "C++"
{
namespace LOTRO_DAT
{
    class BinaryData;

    class Database {
    public:
        Database();
        explicit Database(const std::string &filename);

        ~Database();

        void InitDatabase(const std::string &filename);

        void PushTextFile(long long file_id, long long gossip_id, const char16_t *text, const char *args, int dat_id = 0);
        //BinaryData& GetTextFile(long long file_id);

        void PushBinaryFile(long long file_id, const BinaryData& data);
        //BinaryData& GetBinaryFile(long long file_id);


    private:
        void ExecSql(const std::string &sql);

        sqlite3* db_;
        sqlite3_stmt* insert_text_;
        sqlite3_stmt* insert_binary_;

        sqlite3_stmt* get_text_;
        sqlite3_stmt* get_binary_;

        unsigned long long query_size_;
        const unsigned long long QUERY_MAX_SIZE = 210241024;

        const std::string CreateBinaryTableCommand_ = "CREATE TABLE IF NOT EXISTS `binary_data` ( "
            "`file_id` INTEGER NOT NULL DEFAULT '0', "
            "`data` BLOB, "
            "`dat_id` INTEGER NOT NULL DEFAULT '-1', "
            "PRIMARY KEY (`file_id`));";

        const std::string CreateTextTableCommand_ = "CREATE TABLE IF NOT EXISTS `text_data` ( "
            "`file_id` INTEGER NOT NULL DEFAULT '0', "
            "`gossip_id` INTEGER NOT NULL DEFAULT '0', "
            "`content` TEXT, "
            "`args` TEXT, "
            "`args_order` TEXT, "
            "`dat_id` INTEGER NOT NULL DEFAULT '-1', "
            "PRIMARY KEY (`file_id`, `gossip_id`));";

        const std::string InsertTextCommand_ = "INSERT INTO text_data "
                "(file_id, gossip_id, content, args) "
                "VALUES (?, ?, ?, ?); ";

        const std::string InsertBinaryCommand_ = "INSERT INTO binary_data "
                "(file_id, data) "
                "VALUES (?, ?); ";

    };
}
}
#endif