// Copyright (c) 2006-2009 Nokia Corporation and/or its subsidiary(-ies).

// All rights reserved.

// This component and the accompanying materials are made available

// under the terms of "Eclipse Public License v1.0"

// which accompanies this distribution, and is available

// at the URL "http://www.eclipse.org/legal/epl-v10.html".

//

// Initial Contributors:

// Nokia Corporation - initial contribution.

//

// Contributors:

//

// Description:

//

#include "dbutility.h"

#include "d32dbms.h"

/**

Check if the table exists in the database.

@param aDatabase  the database to use

@param aTableName the table name to check

@return ETrue if exists, otherwise, EFalse

*/

TBool DBUtility::IsTableExistsL(RDbDatabase& aDatabase, const TDesC& aTableName)

	{

	TBool result = EFalse;

	CDbTableNames* tableNames = aDatabase.TableNamesL();

	CleanupStack::PushL(tableNames);

	if(tableNames)

		{

		const TInt count = tableNames->Count();

		for(TInt i = 0; i < count; i++)

			{

			if((*tableNames)[i] == aTableName)

				{

				result = ETrue;

				break;

				}

			}

		}

	CleanupStack::PopAndDestroy(tableNames);

	return result;	

	}

/**

Check if the specified index exists in the table.

@param aDatabase  the database to use

@param aTableName the table name to use

@param aIndexName the index name to check

@return ETrue if the index exists, otherwise, EFalse

*/

TBool DBUtility::IsIndexExistsL(RDbDatabase& aDatabase, const TDesC& aTableName, const TDesC& aIndexName)

	{

	TBool result = EFalse;

	CDbIndexNames* indexNames = aDatabase.IndexNamesL(aTableName);

	CleanupStack::PushL(indexNames);

	if(indexNames)

		{

		const TInt count = indexNames->Count();

		for(TInt i = 0; i < count; i++)

			{

			if((*indexNames)[i] == aIndexName)

				{

				result = ETrue;

				break;

				}

			}

		}

	CleanupStack::PopAndDestroy(indexNames);

	return result;	

	}