#include "stdafx.h"
#include "ConstantsDataDb.h"
#include "ConstantsDataTable.h"

namespace OTSClassifyEngine
{
	using namespace OTSSQLITE;
	CConstantsDataDb::CConstantsDataDb(CDBStoreBasePtr a_datastore)
	{
		m_tableInfo.reset(new CConstantsDataTable());
		myDB = CreateNewSQLiteDB(a_datastore, m_tableInfo);
	}

	CConstantsDataDb::~CConstantsDataDb()
	{
	}

	

	CDBTableBasePtr CConstantsDataDb::GetTableInfo()
	{
		/*if (!m_tableInfo)
		{
			m_tableInfo.reset(new CSTDDataTable);
		}*/

		return m_tableInfo;
	}

	BOOL CConstantsDataDb::Init(const BOOL a_bClean /*= FALSE*/)
	{
		return myDB->Init(a_bClean);
	}

	BOOL CConstantsDataDb::CreateTable(const BOOL a_bForce /*= FALSE*/)
	{
		return myDB->CreateTable(a_bForce);
	}

	BOOL CConstantsDataDb::DeleteTable()
	{
		return myDB->DeleteTable();
	}

	BOOL CConstantsDataDb::RemoveAllRows()
	{
		return myDB->RemoveAllRows();
	}

	BOOL CConstantsDataDb::IsDBExist()
	{
		return myDB->IsDBExist();
	}

	OTSSQLITE::CDBStoreBasePtr CConstantsDataDb::GetDatastore()
	{
		return myDB->GetDatastore();
	}

	OTSSQLITE::CDBQueryBasePtr CConstantsDataDb::GetTableQuery(LPCTSTR a_sOrderColumnName /*= nullptr*/)
	{
		return myDB->GetTableQuery(a_sOrderColumnName);
	}

	std::string CConstantsDataDb::GetConstantsLib(BOOL bForce /*= FALSE*/)
	{
		//ParticleSTDPtr partStd = ParticleSTDPtr(new ParticleSTD());
		
		auto query = GetTableQuery("value");
		ASSERT(query);
		if (!query)
		{
			return FALSE;
		}

		auto xConstantsStr = ReadConstantsDataItem(query);
		std::string constantsstr = xConstantsStr;

		//m_pOretype->SetName(_T(""));
		return constantsstr;
	}

	CString CConstantsDataDb::ReadConstantsDataItem(CDBQueryBasePtr a_query)
	{
		int nCol;
		CString svalue;
		nCol = (int)CConstantsDataTable::ColumnID::S_value - (int)CConstantsDataTable::ColumnID::MIN;
		svalue = a_query->GetColStringValue(nCol, _T(""));

		return svalue;
	}
}