#pragma once
#include "DBBase.h"
#include "ParticleSTD.h"

namespace OTSClassifyEngine
{
	using namespace OTSSQLITE;
	class  __declspec(dllexport) CParticleSTDDB
	{
	public:
		CParticleSTDDB(CDBStoreBasePtr a_datastore);
		~CParticleSTDDB();

	

		virtual CDBTableBasePtr GetTableInfo() ;

		virtual BOOL Init(const BOOL a_bClean = FALSE) ;

		virtual BOOL CreateTable(const BOOL a_bForce = FALSE) ;

		virtual BOOL DeleteTable() ;

		virtual BOOL RemoveAllRows() ;

		virtual BOOL IsDBExist() ;

		virtual CDBStoreBasePtr GetDatastore() ;

		virtual CDBQueryBasePtr GetTableQuery(LPCTSTR a_sOrderColumnName = nullptr) ;

		

		ParticleSTDPtr GetPartSTDLib(ParticleSTDPtr partStd, BOOL bForce/* = FALSE*/);

	protected:
		
		PartSTDItemList ReadParticleSTDList(CDBQueryBasePtr a_query);
		BOOL ReadParticleSTDItem(CDBQueryBasePtr a_query, PartSTDItemPtr stdItem);


	protected:
		CDBTableBasePtr m_tableInfo;
		PartSTDItemPtr m_pSTDItem;
		PartSTDItemList m_listSTDItem;
	private:
		CDBBasePtr myDB;
	};

	typedef std::shared_ptr<CParticleSTDDB>  __declspec(dllexport) CParticleSTDDBPtr;
}