OTS/OTSCPP/OTSClassifyEngine/SpectrumCompareEngine/OTSSTDLibTable.cpp

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

namespace OTSClassifyEngine
{

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

	CSTDLibTable::CSTDLibTable()
	{
		myTable = CreateNewSQLiteTable();

		myTable->AddColumn(std::make_pair(_T("id"), ColumnType(ColumnType::ID::INT, TRUE)));
		myTable->AddColumn(std::make_pair(_T("name"), ColumnType(ColumnType::ID::STRING, FALSE)));

		myTable->AddColumn(std::make_pair(_T("chinesename"), ColumnType(ColumnType::ID::STRING, FALSE)));
		myTable->AddColumn(std::make_pair(_T("formula"), ColumnType(ColumnType::ID::STRING, FALSE)));
		myTable->AddColumn(std::make_pair(_T("density"), ColumnType(ColumnType::ID::FLOAT, FALSE)));
		
		myTable->AddColumn(std::make_pair(_T("averagez"), ColumnType(ColumnType::ID::FLOAT, FALSE)));
		myTable->AddColumn(std::make_pair(_T("bsevalue"), ColumnType(ColumnType::ID::INT, FALSE)));
		myTable->AddColumn(std::make_pair(_T("color"), ColumnType(ColumnType::ID::INT,FALSE)));
		
		myTable->AddColumn(std::make_pair(_T("spectrum"), ColumnType::ID::BLOB));
		int cols = myTable->GetColumnCount();
		ASSERT(cols== ((int)ColumnID::MAX - (int)ColumnID::MIN));

		SetTableName("item");
	}

	CSTDLibTable::~CSTDLibTable()
	{
	}
}