PuzzleDBProvider.h

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


namespace ParaEngine
{
    struct stPuzzleDbRecord
    {
        // TODO: change the db_puzzle.sql to new version

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

        int DifficultyRate;

        stStringTableDbRecord PuzzleDesc;   // record in string table
        int NumberOfChoices;    // Limit to 4 (ABCD)
        stStringTableDbRecord PuzzleAnswerA;    // record in string table
        stStringTableDbRecord PuzzleAnswerB;    // record in string table
        stStringTableDbRecord PuzzleAnswerC;    // record in string table
        stStringTableDbRecord PuzzleAnswerD;    // record in string table
        string PuzzleDescPicFilePath;

        int CorrectChoice;
        stStringTableDbRecord Explanation;  // record in string table
        string ExplanationPicFilePath;

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

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

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

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

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

    public:
        bool InsertPuzzleRecord(stPuzzleDbRecord& record);

        bool DeletePuzzleRecordByID(int ID);
    };
}