AttributeProvider.h

#pragma once
#include "ic/ParaDatabase.h"
#include "IAttributeFields.h"
#include <vector>
#include <string>
namespace ParaEngine
{
    using namespace std;
    struct CAttributeDbItem
    {
        string m_sName;
        //string m_sInstanceName;
        int m_nType;
        string m_sValue;
        string m_sDescription;
        string m_sSchematics;
        CAttributeDbItem():m_nType(0){};
    };

    class AttributeProvider
    {
    public:
        AttributeProvider(void);
        ~AttributeProvider(void);
    public:
        // common function 

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

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

        void ValidateDatabase();

#ifdef _DEBUG

        void TestDB();
#endif

    public:
        // query functions 

        bool SaveAttributeObject(const char*  sTableName, IAttributeFields* pAttributeObject);

        bool LoadAttributeObject(const char*  sTableName, IAttributeFields* pAttributeObject);

        void SetTableName(const char*  sName);

        const string& GetTableName(){return m_sCurrentTableName;};

        bool  ResetTable(const char*  sName);

        //void SetObjectName(const char*  sName) { m_sObjectName = sName;}
        //const string& GetObjectName() { return m_sObjectName;}

        bool DoesAttributeExists(const char*  sName);

        bool GetAttribute(const char*  sName, string& sOut);

        bool GetAttribute(CAttributeDbItem& inout);

        bool InsertAttribute(CAttributeDbItem& sIn);

        bool InsertAttribute(const char*  sName, const char*  sValue);

        bool UpdateAttribute(const char*  sName, const char*  sIn);

        bool DeleteAttribute(const char*  sName);

        bool CreateTableIfNotExists();

    private:
        ParaEngine::asset_ptr<DBEntity> m_pDataBase;
        CDBRecordSet* m_pProcSelectAttribute;
        CDBRecordSet* m_pProcAttributeExists;
        CDBRecordSet* m_pProcUpdateAttribute;
        CDBRecordSet* m_pProcInsertAttribute;
        CDBRecordSet* m_pProcDeleteAttribute;

        void ReleaseStoredProcedures();
        string m_sCurrentTableName;
        //string m_sObjectName;
    };
}