SRKeyColumnUsage.h

/*
 * Copyright (C) 2008 Search Solution Corporation. All rights reserved by Search Solution. 
 *
 * Redistribution and use in source and binary forms, with or without modification, 
 * are permitted provided that the following conditions are met: 
 *
 * - Redistributions of source code must retain the above copyright notice, 
 *   this list of conditions and the following disclaimer. 
 *
 * - Redistributions in binary form must reproduce the above copyright notice, 
 *   this list of conditions and the following disclaimer in the documentation 
 *   and/or other materials provided with the distribution. 
 *
 * - Neither the name of the <ORGANIZATION> nor the names of its contributors 
 *   may be used to endorse or promote products derived from this software without 
 *   specific prior written permission. 
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND 
 * ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED 
 * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. 
 * IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, 
 * INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, 
 * BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, 
 * OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, 
 * WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) 
 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY 
 * OF SUCH DAMAGE. 
 *
 */

#pragma	   once

class CKeyColumnUsageRow
{
public:
	wchar_t constraintCatalog[127];
	wchar_t constraintSchema[127];
	wchar_t constraintName[127];
	wchar_t tableCatalog[127];
	wchar_t tableSchema[127];
	wchar_t tableName[127];
	wchar_t columnName[127];
	GUID columnGUID;
	ULONG columnPropID;
	ULONG ordinalPosition;

public:
	CKeyColumnUsageRow();

//	static void GetRestrictions(ULONG cRestrictions, const VARIANT *rgRestrictions, char *constraintName, char *tableName, char *columnName);

	void SetTableName(const wchar_t *tableName);
	void SetColumnName(const wchar_t *columnName);
	void SetOrdinalPosition(const int &ordinal);
	void SetConstraintName(const wchar_t *constraintName);

	const wchar_t *GetTableName(void);
	const wchar_t *GetColumnName(void);
	const int GetOrdinalPosition(void);
	const wchar_t *GetConstraintName(void);

	BEGIN_PROVIDER_COLUMN_MAP(CKeyColumnUsageRow)
		PROVIDER_COLUMN_ENTRY_WSTR("CONSTRAINT_CATALOG", 1, constraintCatalog)
		PROVIDER_COLUMN_ENTRY_WSTR("CONSTRAINT_SCHEMA", 2, constraintSchema)
		PROVIDER_COLUMN_ENTRY_WSTR("CONSTRAINT_NAME", 3, constraintName)
		PROVIDER_COLUMN_ENTRY_WSTR("TABLE_CATALOG", 4, tableCatalog)
		PROVIDER_COLUMN_ENTRY_WSTR("TABLE_SCHEMA", 5, tableSchema)
		PROVIDER_COLUMN_ENTRY_WSTR("TABLE_NAME", 6, tableName)
		PROVIDER_COLUMN_ENTRY_WSTR("COLUMN_NAME", 7, columnName)
		PROVIDER_COLUMN_ENTRY_TYPE_PS("COLUMN_GUID", 8, DBTYPE_GUID, 0xFF, 0xFF, columnGUID)
		PROVIDER_COLUMN_ENTRY_TYPE_PS("COLUMN_PROPID", 9, DBTYPE_UI4, 10, ~0, columnPropID)
		PROVIDER_COLUMN_ENTRY_TYPE_PS("ORDINAL_POSITION", 10, DBTYPE_UI4, 10, ~0, ordinalPosition)
	END_PROVIDER_COLUMN_MAP()
};

class CSRKeyColumnUsage : public CSchemaRowsetImpl<CSRKeyColumnUsage, CKeyColumnUsageRow, CCUBRIDSession>
{
public:
	~CSRKeyColumnUsage();

	SR_PROPSET_MAP(CSRKeyColumnUsage)

	HRESULT Execute(LONG* pcRowsAffected, ULONG cRestrictions, const VARIANT *rgRestrictions);
	DBSTATUS GetDBStatus(CSimpleRow*, ATLCOLUMNINFO* pInfo);

private:
	void ClearCurrentErrorObject(void);
	HRESULT FetchData(int cci_request_handle, UINT uCodepage, CKeyColumnUsageRow &newRow);
};