ItemDBProvider.h

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

namespace ParaEngine
{
    struct stItemDbRecord
    {
        // TODO: change the db_item.sql to new version

        __int64 ID;
        stStringTableDbRecord ItemName; // record in string table

        string IconAssetName;
        string DescTextAssetName;
        bool IsGlobal; // stored in db 0/1

        string IconFilePath;
        stStringTableDbRecord Desc; // record in string table
        string ModelFilePath;

        int ItemType;
        bool IsObtained; // stored in db 0/1
        bool IsUnique; // stored in db 0/1
        int CostExperiencePt; // stored in db 0/1
        int CostOrange;
        int CostApple;
        int CostPeach;

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

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

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

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

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

    public:
        bool InsertItemRecord(stItemDbRecord& record);

        bool DeleteItemRecordByID(int ID);

        bool UpdateItemRecord(stItemDbRecord& record);

        bool SelectItemRecordByID(stItemDbRecord& record, __int64 ID);
    };
}