CharacterDBProvider.h

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

#include ".\StringTable.h"

namespace ParaEngine
{
    struct stCharacterDbRecord
    {
        __int64 ID;
        stStringTableDbRecord CharacterName; // record in string table
        int NumberOfPets; // limit the pet number to 3
        __int64 MainPetIndex; // index in pet table
        __int64 SecondaryPetIndex;  // index in pet table
        __int64 ThirdPetIndex;      // index in pet table

        string AssetName;
        bool IsGlobal;
        bool IsSnapToTerrain;

        string CharacterModeFilePath;
        float CharacterModelScale;
        float CharacterRadius;
        float CharacterFacing;
        float posX;
        float posY;
        float posZ;

        float PerceptiveRadius;
        float SentientRadius;
        string OnLoadScript;

        __int64 CharacterTitleIndex;    // index in title table
        int ExperiencePt;
        int Orange;
        int Apple;
        int Peach;

        string Reserved1;
        string Reserved2;
        string Reserved3;
        string Reserved4;
        string Reserved5;
    };

    // Class CCharacterDBProvider: CCharacterDBProvider contains all functions to access the 
    //      character database and the user interface data of character control. 
    //      This is a singleton class. Call GetInstance() to use this class.
    class CCharacterDBProvider
    {
    public:
        CCharacterDBProvider(void);
        CCharacterDBProvider(ParaInfoCenter::DBEntity* pDb);
        ~CCharacterDBProvider(void);

    protected:
    private:

        ParaEngine::asset_ptr<ParaInfoCenter::DBEntity> m_pDataBase;

    public:     
        static CCharacterDBProvider & GetInstance();
        ParaInfoCenter::DBEntity* GetDBEntity();
        void SetDBEntity(ParaInfoCenter::DBEntity* pDb);

//#define TEST_CHARACTER
#ifdef TEST_CHARACTER
    public:
        // TODO: only for test
        void TestDB();
#endif

    public:
        bool InsertCharacterRecord(stCharacterDbRecord& record);

        bool DeleteCharacterRecordByID(int ID);
    };
}