#include "stdafx.h"
#include "ParticleSTDTable.h"
#include "../myDBConst.h"

namespace OTSClassifyEngine
{
	using namespace OTSSQLITE;

	void CParticleSTDTable::AddColumn(ColumnDefine col)
	{
		return myTable->AddColumn(col);
	}

	int CParticleSTDTable::GetColumnCount()
	{
		return myTable->GetColumnCount();
	}

	CString CParticleSTDTable::GetTableName()
	{
		return myTable->GetTableName();
	}

	void CParticleSTDTable::SetTableName(LPCTSTR a_sTableName)
	{
		return myTable->SetTableName(a_sTableName);
	}

	CString CParticleSTDTable::GetColumnName(const int a_nColId)
	{
		return myTable->GetColumnName(a_nColId);
	}

	CString CParticleSTDTable::GetColumnFullName(const int a_nColId)
	{
		return myTable->GetColumnFullName(a_nColId);
	}

	CString CParticleSTDTable::GetColumnNames(const BOOL a_bWithPrimary /*= TRUE*/)
	{
		return myTable->GetColumnNames(a_bWithPrimary);
	}

	CString CParticleSTDTable::GetColumnFullNames(const BOOL a_bWithPrimary /*= TRUE*/)
	{
		return myTable->GetColumnFullNames(a_bWithPrimary);
	}

	OTSSQLITE::ColumnType CParticleSTDTable::GetColumnType(const int a_nColId)
	{
		return myTable->GetColumnType(a_nColId);
	}

	CString CParticleSTDTable::GetCreateTableCommandString()
	{
		return myTable->GetCreateTableCommandString();
	}

	CString CParticleSTDTable::GetDeleteTableCommandString()
	{
		return myTable->GetDeleteTableCommandString();
	}

	CString CParticleSTDTable::GetRemoveAllRowsCommandString()
	{
		return myTable->GetRemoveAllRowsCommandString();
	}

	CString CParticleSTDTable::GetInsertCommandFormatString(const BOOL a_bWithPrimary /*= FALSE*/)
	{
		return myTable->GetInsertCommandFormatString(a_bWithPrimary);
	}

	CString CParticleSTDTable::GetInsertCommandFormatString(std::vector<int>& a_colIndexes)
	{
		return myTable->GetInsertCommandFormatString(a_colIndexes);
	}

	CString CParticleSTDTable::GetUpdateCommandFormatString(std::vector<int>& a_updateColIndexes, const int a_nConditionColIndex)
	{
		return myTable->GetUpdateCommandFormatString(a_updateColIndexes, a_nConditionColIndex);
	}

	CParticleSTDTable::CParticleSTDTable()
	{
		myTable = CreateNewSQLiteTable();
		//m_listcolumnDefines.clear();

		myTable->AddColumn(std::make_pair(_T("STDId"), ColumnType(ColumnType::ID::INT, TRUE)));
		myTable->AddColumn(std::make_pair(_T("StrName"), ColumnType(ColumnType::ID::STRING)));
		myTable->AddColumn(std::make_pair(_T("Color"), ColumnType::ID::STRING));
		myTable->AddColumn(std::make_pair(_T("KeyElementList"), ColumnType::ID::STRING));
		myTable->AddColumn(std::make_pair(_T("SubElementList"), ColumnType::ID::STRING));
		myTable->AddColumn(std::make_pair(_T("UsingImgPropertyList"), ColumnType::ID::STRING));
		myTable->AddColumn(std::make_pair(_T("UsingOtherPropertyList"), ColumnType::ID::STRING));
		myTable->AddColumn(std::make_pair(_T("Expression"), ColumnType(ColumnType::ID::STRING)));
		myTable->AddColumn(std::make_pair(_T("Hardness"), ColumnType(ColumnType::ID::FLOAT)));
		myTable->AddColumn(std::make_pair(_T("Density"), ColumnType::ID::FLOAT));
		myTable->AddColumn(std::make_pair(_T("Electrical_conductivity"), ColumnType::ID::FLOAT));
		myTable->AddColumn(std::make_pair(_T("BSE"), ColumnType::ID::INT));
		myTable->AddColumn(std::make_pair(_T("Formula"), ColumnType::ID::STRING));
		myTable->AddColumn(std::make_pair(_T("Element"), ColumnType::ID::STRING));
		myTable->AddColumn(std::make_pair(_T("ListNum"), ColumnType::ID::INT));
		myTable->AddColumn(std::make_pair(_T("GroupId"), ColumnType::ID::INT));

		ASSERT(myTable->GetColumnCount() == ((int)ColumnID::MAX - (int)ColumnID::MIN) + 1);

		SetTableName(g_sParticleSTDLib);

	}


	CParticleSTDTable::~CParticleSTDTable()
	{
	}
}