#pragma once
#include "DBBase.h"
#include "OTSSTDLib.h"
//#include "STDGroupDB.h"
using namespace OTSSQLITE;
namespace OTSClassifyEngine
{
	class  __declspec(dllexport) CSTDLibDB 
	{
	public:
		CSTDLibDB(CDBStoreBasePtr a_datastore);
		CSTDLibDB(CDBStoreBasePtr a_datastore, CString strFileName);
		~CSTDLibDB();
		CSpectrumSTDItemList GetSTDItems(BOOL 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:
		
		CSpectrumSTDItemPtr ReadSTDItem(CDBQueryBasePtr a_query);
		
	



	protected:
		CString m_strFileName;
		CDBTableBasePtr m_tableInfo;
		CSTDLibPtr m_pSTDLib;
		
	

	private:
		CDBBasePtr myDB;
	};

	typedef std::shared_ptr<CSTDLibDB>  __declspec(dllexport) CSTDLibDBPtr;
}