KidsDBProvider.h

#pragma once
#include "ic/ParaDatabase.h"
#include "DataProviderManager.h"

#include "CharacterDBProvider.h"
#include "ChestDBProvider.h"
#include "FruitDBProvider.h"
#include "ItemDBProvider.h"
#include "PetAIDBProvider.h"
#include "PetDBProvider.h"
#include "PuzzleDBProvider.h"
#include "QuestDBProvider.h"
#include "StringTable.h"
#include "TitleDBProvider.h"

namespace ParaEngine
{
    class CCharacterDBProvider;
    class CChestDBProvider;
    class CFruitDBProvider;
    class CItemDBProvider;
    class CPetAIDBProvider;
    class CPetDBProvider;
    class CPuzzleDBProvider;
    class CQuestDBProvider;
    class CStringTableDB;
    class CTitleDBProvider;


    class CKidsDBProvider
    {
    public:
        CKidsDBProvider(void);
        ~CKidsDBProvider(void);

        // -------------------------------
        //      common function 
        // -------------------------------

        bool IsValid() {return m_pDataBase.get() !=0;};

        void Cleanup();
        DBEntity* GetDBEntity() {return m_pDataBase.get();};
        void SetDBEntity(const string& sConnectionstring);

        void ValidateDatabase() {assert(m_pDataBase.get()!=0);};

        // -------------------------------
        //      string table functions
        // -------------------------------

        static string GetStringbyID(int ID);

        static int InsertString(const char* strEN, const char * strCN);

        // -------------------------------
        //      Puzzle database functions
        // -------------------------------

        bool InsertPuzzleRecordFromString(const string& strRecord);

        bool DeletePuzzleRecordByID(int ID);

        // -------------------------------
        //      Item database functions
        // -------------------------------

        bool InsertItemRecordFromString(const string& strRecord);

        bool DeleteItemRecordByID(int ID);

        bool UpdateItemRecordFromString(const string& strRecord);

        const char * SelectItemRecordToString(__int64 ID);

        // -------------------------------
        //      Character database functions
        // -------------------------------

        bool InsertCharacterRecordFromString(const string& strRecord);

        bool DeleteCharacterRecordByID(int ID);

        // -------------------------------
        //      Chest database functions
        // -------------------------------

        bool InsertChestRecordFromString(const string& strRecord);

        bool DeleteChestRecordByID(int ID);

        // -------------------------------
        //      Fruit database functions
        // -------------------------------

        bool InsertFruitRecordFromString(const string& strRecord);

        bool DeleteFruitRecordByID(int ID);

        // -------------------------------
        //      PetAI database functions
        // -------------------------------

        bool InsertPetAIRecordFromString(const string& strRecord);

        bool DeletePetAIRecordByID(int ID);

        // -------------------------------
        //      Pet database functions
        // -------------------------------

        bool InsertPetRecordFromString(const string& strRecord);

        bool DeletePetRecordByID(int ID);

        // -------------------------------
        //      Quest database functions
        // -------------------------------

        bool InsertQuestRecordFromString(const string& strRecord);

        bool DeleteQuestRecordByID(int ID);

        // -------------------------------
        //      Title database functions
        // -------------------------------

        bool InsertTitleRecordFromString(const string& strRecord);

        bool DeleteTitleRecordByID(int ID);


#ifdef _DEBUG

        void TestDB();
#endif

    private:
        // FORMAT: parse record fields and link with ##
        void ParsePuzzleRecordToString(string& str, const stPuzzleDbRecord& record);
        void ParseStringToPuzzleRecord(const string& str, stPuzzleDbRecord& record);

        // Append string table record to str
        void AppendStringTableRecordToString(string& str, const stStringTableDbRecord& record);
        // Get string table record to record
        int GetStringTableRecordFromString(char* str, stStringTableDbRecord& record);

        // FORMAT: parse record fields and link with ##
        void ParseItemRecordToString(const stItemDbRecord& record);
        void ParseStringToItemRecord(const string& str, stItemDbRecord& record);

        const char * NumToString(__int64 num);
        const char * NumToString(int num);
        const char * NumToString(float num);
        const char * NumToString(bool num);

        char m_strSelectBuf[MAX_STRING_LENGTH];


        // FORMAT: parse record fields and link with ##
        void ParseCharacterRecordToString(string& str, const stCharacterDbRecord& record);
        void ParseStringToCharacterRecord(const string& str, stCharacterDbRecord& record);

        // FORMAT: parse record fields and link with ##
        void ParseChestRecordToString(string& str, const stChestDbRecord& record);
        void ParseStringToChestRecord(const string& str, stChestDbRecord& record);
        
        // FORMAT: parse record fields and link with ##
        void ParseFruitRecordToString(string& str, const stFruitDbRecord& record);
        void ParseStringToFruitRecord(const string& str, stFruitDbRecord& record);

        // FORMAT: parse record fields and link with ##
        void ParsePetAIRecordToString(string& str, const stPetAIDbRecord& record);
        void ParseStringToPetAIRecord(const string& str, stPetAIDbRecord& record);

        // FORMAT: parse record fields and link with ##
        void ParsePetRecordToString(string& str, const stPetDbRecord& record);
        void ParseStringToPetRecord(const string& str, stPetDbRecord& record);

        // FORMAT: parse record fields and link with ##
        void ParseQuestRecordToString(string& str, const stQuestDbRecord& record);
        void ParseStringToQuestRecord(const string& str, stQuestDbRecord& record);

        // FORMAT: parse record fields and link with ##
        void ParseTitleRecordToString(string& str, const stTitleDbRecord& record);
        void ParseStringToTitleRecord(const string& str, stTitleDbRecord& record);

        ParaEngine::asset_ptr<DBEntity> m_pDataBase;

        // database providers
        CCharacterDBProvider*   m_dbCharacter;
        CChestDBProvider*       m_dbChest;
        CFruitDBProvider*           m_dbFruit;
        CItemDBProvider*            m_dbItem;
        CPetAIDBProvider*       m_dbPetAI;
        CPetDBProvider*         m_dbPet;
        CPuzzleDBProvider*      m_dbPuzzle;
        CQuestDBProvider*       m_dbQuest;
        CStringTableDB*         m_dbStringTable;
        CTitleDBProvider*           m_dbTitle;
    };
}