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

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

		CSTDItemPtr GetSTDItemById(const long a_nIncAId);
		CSTDItemsList& GetSTDItemList(const BOOL a_bForce = FALSE);
		
		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) ;

	protected:
		BOOL ReadSTDItemList();
		CSTDItemsList ReadSTDItemList(CDBQueryBasePtr a_query);
		BOOL ReadSTDItem(CDBQueryBasePtr a_query);
		CDBQueryBasePtr GetQueryById(const long a_nIncAId);

	protected:
		CDBTableBasePtr m_tableInfo;
		CSTDItemPtr m_pSTDItem;
		CSTDItemsList m_listSTDItem;
	private:
		CDBBasePtr myDB;
	};

	typedef std::shared_ptr<CSTDDataDB>  __declspec(dllexport) CSTDDataDBPtr;
}