// 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:

// Comms Database Table View defintions

// 

//

/**

 @file

 @deprecated since v9.1. Functionality is replaced with commsdat.

*/

#include <cdbtemp.h>

#include "CDBSTD.H"

#include "Commsdat_Log.h"

#include "commdb_impl.H"

#include <metadatabase.h>

#include <commsdat_partner.h>

/**

Maps a bearer type and direction to a service table (Dialout,GPRS)

Used by `OpenIAPTableViewMatchingBearerSetLC()`.

@internalComponent

*/

struct TMapBearerToServiceType

	{

	TCommDbBearer				bearerMask;

	TCommDbConnectionDirection	direction;

	const TText*				serviceType;

	};

/**

Service Type

@internalComponent

*/

const TInt KNumServiceType = 13;

// used 1st DoInsertRecord parameter

const TBool KCreateCopyRecord 	= ETrue;

const TBool KCreateNewRecord 	= EFalse;

// used as 3th DoInsertRecord parameter

const TBool KUseTemplate 		= ETrue;

const TBool KDoNotUseTemplate 	= EFalse;

const TBool KDeleteFromContainerOnly = ETrue;

/**

Array of type TMapBearerToServiceType

@internalComponent

*/

const TMapBearerToServiceType KMap[KNumServiceType] =

	{

	{KCommDbBearerCSD,		ECommDbConnectionDirectionOutgoing, DIAL_OUT_ISP},

	{KCommDbBearerCSD,		ECommDbConnectionDirectionIncoming, DIAL_IN_ISP},

	{KCommDbBearerWcdma,	ECommDbConnectionDirectionOutgoing, OUTGOING_GPRS},

	 /** The following two mappings are only required for tornado */

	{KCommDbBearerWcdma,	ECommDbConnectionDirectionIncoming, INCOMING_GPRS},

	{KCommDbBearerLAN,		ECommDbConnectionDirectionIncoming,	LAN_SERVICE},

	{KCommDbBearerLAN,		ECommDbConnectionDirectionOutgoing,	LAN_SERVICE},

	{KCommDbBearerVirtual,		ECommDbConnectionDirectionIncoming,	VPN_SERVICE},

	{KCommDbBearerVirtual,		ECommDbConnectionDirectionOutgoing,	VPN_SERVICE},

	/** PAN profile uses LAN service table, plus an extension service table */

	{KCommDbBearerPAN,		ECommDbConnectionDirectionIncoming,	LAN_SERVICE},

	{KCommDbBearerPAN,		ECommDbConnectionDirectionOutgoing,	LAN_SERVICE},

	/** WLAN uses LAN service table, plus an extension service table */

	{KCommDbBearerWLAN,		ECommDbConnectionDirectionIncoming,	LAN_SERVICE},

	{KCommDbBearerWLAN,		ECommDbConnectionDirectionOutgoing,	LAN_SERVICE}

	};

/**

Index in RPointerArray where Template Record is stored

*/

using namespace CommsDat;

// CCommsDbTableView definitions

CCommsDbTableView* CCommsDbTableView::NewL(CCommsDatabaseBase& /*aDb*/,const TDesC& /*aTableName*/,const TDbQuery& /*aQuery*/,TBool /*aUseTemplate*/)

/** Internal low level view creation.

Not in use after shim is introduced

Use if CCommsDatabase::OpenTableLC() or CCommsDatabase::OpenViewLC...() are not sufficient.

Note that OpenTableLC() and OpenViewLC...() have been withdrawn in CCommsDatabase

and are now implemented in CCommsDatabaseBase.

@deprecated This method is deprecated from 9.1 and always returns/leaves with KErrNotSupported instead of describing past operation/parameters.

@param aDb Reference to the instance of the Comms Database to use.

@param aTableName Name of the table of view.

@param aQuery Query to perform.

@param aUseTemplate Use the template values from the database - defaults to ETrue.

@return A reference to the newly created view. */

	{

	User::Leave(KErrNotSupported);

	return NULL;

	}

/** Internal low level view creation.

Internal use as replacement for SQL queries.

Introduced with commdb shim

@param aDb Reference to the instance of the Comms Database to use.

@param aTableName Name of the table of view.

@param aIncludeHiddenRecords Value for Hidden attribute.

@return A reference to the newly created view. */

CCommsDbTableView* CCommsDbTableView::NewLC(CCommsDatabaseBase& aDb, const TDesC& aTableName, TBool aUseTemplate)

	{

	CCommsDbTableView* r = new(ELeave) CCommsDbTableView(aDb, aTableName);

	CleanupStack::PushL(r);

	r->ConstructL(aTableName,aDb.iShowHiddenRecords, aUseTemplate);

	// register view in Database

	aDb.iImpl->RegisterViewL(r);

	return r;

	}

/** Internal low level view creation.

Used only if is called from TemplateRecord class

@param aDb Reference to the instance of the Comms Database to use.

@param aTableName Name of the table of view.

@param aIncludeHiddenRecords Value for Hidden attribute.

@return A reference to the newly created view. */

CCommsDbTableView* CCommsDbTableView::NewLC(const TDesC& aTableName, CCommsDatabaseBase& aDb)

	{

	CCommsDbTableView* r = new(ELeave) CCommsDbTableView(aDb, aTableName);

	CleanupStack::PushL(r);

	r->ConstructL(aTableName);

	// register view in Database

	aDb.iImpl->RegisterViewL(r);

	return r;

	}

/** Internal low level view creation.

Use if CCommsDatabase::OpenTableLC() or CCommsDatabase::OpenViewLC...() are not sufficient.

Note that OpenTableLC() and OpenViewLC...() have been withdrawn in CCommsDatabase

and are now implemented in CCommsDatabaseBase.

@param aDb Reference to the instance of the Comms Database to use.

@param aTableName Name of the table of view.

@param aIncludeHiddenRecords Value for Hidden attribute.

@return A reference to the newly created view. */

CCommsDbTableView* CCommsDbTableView::NewL(CCommsDatabaseBase& aDb, const TDesC& aTableName, const TDesC& aColumnToMatch, const TDesC8& aValueToMatch)

	{

	CCommsDbTableView* r = new(ELeave) CCommsDbTableView(aDb,aTableName);

	CleanupStack::PushL(r);

	r->ConstructL(aTableName, aColumnToMatch, aValueToMatch);

	// register view in Database

	aDb.iImpl->RegisterViewL(r);

	CleanupStack::Pop(r);

	return r;

	}

/** Internal low level view creation.

Use if CCommsDatabase::OpenTableLC() or CCommsDatabase::OpenViewLC...() are not sufficient.

Note that OpenTableLC() and OpenViewLC...() have been withdrawn in CCommsDatabase

and are now implemented in CCommsDatabaseBase.

@param aDb Reference to the instance of the Comms Database to use.

@param aTableName Name of the table of view.

@param aIncludeHiddenRecords Value for Hidden attribute.

@return A reference to the newly created view. */

CCommsDbTableView* CCommsDbTableView::NewL(CCommsDatabaseBase& aDb, const TDesC& aTableName, const TDesC& aColumnToMatch, const TDesC16& aValueToMatch)

	{

	CCommsDbTableView* r = new(ELeave) CCommsDbTableView(aDb,aTableName);

	CleanupStack::PushL(r);

	r->ConstructL(aTableName, aColumnToMatch, aValueToMatch);

	// register view in Database

	aDb.iImpl->RegisterViewL(r);

	CleanupStack::Pop(r);

	return r;

	}

/** Internal low level view creation.

Use if CCommsDatabase::OpenTableLC() or CCommsDatabase::OpenViewLC...() are not sufficient.

Note that OpenTableLC() and OpenViewLC...() have been withdrawn in CCommsDatabase

and are now implemented in CCommsDatabaseBase.

@param aDb Reference to the instance of the Comms Database to use.

@param aTableName Name of the table of view.

@param aIncludeHiddenRecords Value for Hidden attribute.

@return A reference to the newly created view. */

CCommsDbTableView* CCommsDbTableView::NewL(CCommsDatabaseBase& aDb, const TDesC& aTableName, const TDesC& aColumnToMatch, TUint32 aValueToMatch)

	{

	CCommsDbTableView* r = new(ELeave) CCommsDbTableView(aDb,aTableName);

	CleanupStack::PushL(r);

	r->ConstructL(aTableName, aColumnToMatch, aValueToMatch);

	// register view in Database

	aDb.iImpl->RegisterViewL(r);

	CleanupStack::Pop(r);

	return r;

	}

/** Internal low level view creation.

Use if CCommsDatabase::OpenTableLC() or CCommsDatabase::OpenViewLC...() are not sufficient.

Note that OpenTableLC() and OpenViewLC...() have been withdrawn in CCommsDatabase

and are now implemented in CCommsDatabaseBase.

@param aDb Reference to the instance of the Comms Database to use.

@param aTableName Name of the table of view.

@param aIncludeHiddenRecords Value for Hidden attribute.

@return A reference to the newly created view. */

CCommsDbTableView*  CCommsDbTableView::NewLC(CCommsDatabaseBase& aDb, const TDesC& aTableName, const TDesC& aColumnToMatch, TBool aValueToMatch)

	{

	CCommsDbTableView* r = new(ELeave) CCommsDbTableView(aDb,aTableName);

	CleanupStack::PushL(r);

	r->ConstructL(aTableName, aColumnToMatch, aValueToMatch);

	// register view in Database

	aDb.iImpl->RegisterViewL(r);

	return r;

	}

// this two are for IAP table only so table name is not needed

/** Internal low level view creation.

Use if CCommsDatabase::OpenTableLC() or CCommsDatabase::OpenViewLC...() are not sufficient.

Note that OpenTableLC() and OpenViewLC...() have been withdrawn in CCommsDatabase

and are now implemented in CCommsDatabaseBase.

@param aDb Reference to the instance of the Comms Database to use.

@param aTableName Name of the table of view.

@param aIncludeHiddenRecords Value for Hidden attribute.

@return A reference to the newly created view. */

CCommsDbTableView* CCommsDbTableView::NewLC(CCommsDatabaseBase& aDb, TUint32 aBearerSet,	TCommDbConnectionDirection aDirection)

	{

	CCommsDbTableView* r = new(ELeave) CCommsDbTableView(aDb,TPtrC(KCDTypeNameIAP));

	CleanupStack::PushL(r);

	r->ConstructL(aBearerSet, aDirection);

	// register view in Database

	aDb.iImpl->RegisterViewL(r);

	return r;

	}

/** Internal low level view creation.

Use if CCommsDatabase::OpenTableLC() or CCommsDatabase::OpenViewLC...() are not sufficient.

Note that OpenTableLC() and OpenViewLC...() have been withdrawn in CCommsDatabase

and are now implemented in CCommsDatabaseBase.

@param aDb Reference to the instance of the Comms Database to use.

@param aTableName Name of the table of view.

@param aIncludeHiddenRecords Value for Hidden attribute.

@return A reference to the newly created view. */

CCommsDbTableView* CCommsDbTableView::NewLC(CCommsDatabaseBase& aDb, TUint32 aNetworkId)

	{

	CCommsDbTableView* r = new(ELeave) CCommsDbTableView(aDb,TPtrC(KCDTypeNameIAP));

	CleanupStack::PushL(r);

	r->ConstructL(aNetworkId);

	// register view in Database

	aDb.iImpl->RegisterViewL(r);

	return r;

	}

//  this one is for Proxie table only

/** Internal low level view creation.

Use if CCommsDatabase::OpenTableLC() or CCommsDatabase::OpenViewLC...() are not sufficient.

Note that OpenTableLC() and OpenViewLC...() have been withdrawn in CCommsDatabase

and are now implemented in CCommsDatabaseBase.

@param aDb Reference to the instance of the Comms Database to use.

@param aTableName Name of the table of view.

@param aIncludeHiddenRecords Value for Hidden attribute.

@return A reference to the newly created view. */

CCommsDbTableView* CCommsDbTableView::NewLC(CCommsDatabaseBase& aDb, TUint32 aServiceId, const TDesC& aServiceType)

	{

	CCommsDbTableView* r = new(ELeave) CCommsDbTableView(aDb,TPtrC(KCDTypeNameProxies));

	CleanupStack::PushL(r);

	r->ConstructL(aServiceId, aServiceType);

	// register view in Database

	aDb.iImpl->RegisterViewL(r);

	return r;

	}

CCommsDbTableView::CCommsDbTableView(CCommsDatabaseBase& aDb,const TDesC& aTableName)

	: iDb(aDb), iTableName(aTableName)

/** Internal constructor.

@param aDb Reference to the instance of the Comms Database.

@param aTableName The name of the table to view. */

	{

	}

void CCommsDbTableView::ConstructL(const TDbQuery& /*aQuery*/,TBool /*aUseTemplate*/)

/**

Prepares and evaluates the table view using the SQL query aQuery

@deprecated This method is deprecated from 9.1 and always returns/leaves with KErrNotSupported instead of describing past operation/parameters.

@param aQuery A reference to TDbQuery which contains the query to perform

@param aUseTemplate A boolean value whether to use template while creating the object or not

*/

	{

	User::Leave(KErrNotSupported);

	}

void CCommsDbTableView::ConstructL(const TDesC& aTableName, TBool aHidden, TBool aUseTemplate)

/**

Prepares and evaluates the table view

@param aTableName

@param aUseTemplate A boolean value whether to use template while creating the object or not

*/

	{

	if (iTableName.CompareF(TPtrC(KCDTypeNameConnectionPrefs)) == 0)

		{

		User::Leave(KErrAccessDenied);          // must use proper connection prefs class

		}

	if (iTableName.CompareF(TPtrC(KCDTypeNameGlobalSettings)) == 0)

		{

		User::Leave(KErrNotFound);          // must use proper connection prefs class

		}

	if (iTableName.Length() == 0)

		{

		User::Leave(KErrArgument);

		}

	if(aHidden)

		{

		iDb.iImpl->iDbs->SetAttributeMask(ECDHidden);

		}

	iTableExt = CCommDbTableExtension::NewL();

	// create container and load data

	iTableExt->SetRecordSetL(aTableName, *iDb.iImpl->iDbs, KDoNotPreparePriming, KLoadTable);

	if(TableWithTemplateRecord() && aUseTemplate)

		{

		iTemplate = CCommsDbTemplateRecord::NewL(&iDb,iTableName);

		}

	else

		{

		iTemplate = NULL;

		}

	if(aHidden)

		{

		iDb.iImpl->iDbs->ClearAttributeMask(ECDHidden);

		}

	iState=EOpenIdle;

	}

void CCommsDbTableView::ConstructL(const TDesC& aTableName, const TDesC& aColumnToMatch, const TDesC8& aValueToMatch)

/**

@param aTableName

@param aColumnToMatch

@param aValueToMatch

@param includeHiddenRecords

*/

	{

	CMDBRecordSetBase* rs(NULL);

	TInt type(0);

	iTableExt = CCommDbTableExtension::NewL();

	iTableExt->SetRecordSetL(aTableName, *iDb.iImpl->iDbs, KPreparePriming, KDoNotLoadTable);

	rs = iTableExt->GetRecordSetL();

	CMDBElement * dbElement = iTableExt->GetCurrentRecordL()->GetFieldByNameL(aColumnToMatch, type);

	//-- check if we try to write TDesC8 string to the field of type TDes16

	//-- if yes, we have to allow this by converting the type of the string to TDes16.

	//-- just to avoid Behaviour Break. Nasty.

	if(type == EText || type == EMedText || type == ELongText)

		{//-- the actual field type is TDes16

		TInt valLen = aValueToMatch.Length();

		RBuf16 convBuf;

		convBuf.CreateL(valLen);

		CleanupClosePushL(convBuf);

		convBuf.Copy(aValueToMatch); //--  convert the string to the 16bit representation

		CMDBField<TDesC>*   fieldDes16 = static_cast<CMDBField<TDesC>*>(dbElement);

		fieldDes16->SetMaxLengthL(convBuf.Length());

		*fieldDes16 = convBuf;

		CleanupStack::PopAndDestroy(&convBuf);

		}

	else

		{

		CMDBField<TDesC8>* fieldDes8 = static_cast<CMDBField<TDesC8>*>(dbElement);

		fieldDes8->SetMaxLengthL(aValueToMatch.Length());

		*fieldDes8 = aValueToMatch;

		}

	TBool searchResult = rs->FindL(*iDb.iImpl->iDbs);

	if(!searchResult)

		{

		// delete primed record and leave empty recordset

		iTableExt->ResetAndDestroyL();

		__FLOG_STATIC3(KLogComponent, KCommDbShim, _L("Table: %S with Column Name: %S, Hidden:%b is empty"),&aTableName,&aColumnToMatch,iDb.iShowHiddenRecords);

		}

	else

		{

		//-- aValueToMatch isn't logged here, because mixing _L and TDes8 kills the system

		__FLOG_STATIC3(KLogComponent, KCommDbShim, _L("Table: %S with Column Name: %S, Hidden:%b ..."), &aTableName,&aColumnToMatch,iDb.iShowHiddenRecords);

		__FLOG_STATIC1(KLogComponent, KCommDbShim, _L8("Table: ... ValueToMatch: %S"), &aValueToMatch);

		}

	TableWithTemplateRecord() ? iTemplate = CCommsDbTemplateRecord::NewL(&iDb,iTableName) : iTemplate = NULL;

	iState=EOpenIdle;

	}

void CCommsDbTableView::ConstructL(const TDesC& aTableName, const TDesC& aColumnToMatch, const TDesC16& aValueToMatch)

/**

@param aTableName

@param aColumnToMatch

@param aValueToMatch

@param includeHiddenRecords

*/

	{

	CMDBRecordSetBase* rs(NULL);

	TInt type(0);

	iTableExt = CCommDbTableExtension::NewL();

	iTableExt->SetRecordSetL(aTableName, *iDb.iImpl->iDbs, KPreparePriming, KDoNotLoadTable);

	rs = iTableExt->GetRecordSetL();

	CMDBElement * dbElement = iTableExt->GetCurrentRecordL()->GetFieldByNameL(aColumnToMatch, type);

	//-- check if we try to write TDesC16 string to the field of type TDes8

	//-- if yes, we have to allow this by converting the type of the string to TDes8.

	//-- just to avoid Behaviour Break. Nasty.

	if(type == EDesC8)

		{

		TInt valLen = aValueToMatch.Length();

		RBuf8 convBuf;

		convBuf.CreateL(valLen);

		CleanupClosePushL(convBuf);

		convBuf.Copy(aValueToMatch); //--  convert the string to the 8bit representation

		CMDBField<TDesC8>* fieldDes8 = static_cast<CMDBField<TDesC8>*>(dbElement);

		fieldDes8->SetMaxLengthL(aValueToMatch.Length());

		*fieldDes8 = convBuf;

		CleanupStack::PopAndDestroy(&convBuf);

		}

	else

		{//-- types match OK.

		CMDBField<TDesC>*   fieldDes16 = static_cast<CMDBField<TDesC>*>(dbElement);

		fieldDes16->SetMaxLengthL(aValueToMatch.Length());

		*fieldDes16 = aValueToMatch;

		}

	TBool searchResult = rs->FindL(*iDb.iImpl->iDbs);

	if(!searchResult)

		{

		// delete primed record and leave empty recordset

		iTableExt->ResetAndDestroyL();

		__FLOG_STATIC4(KLogComponent, KCommDbShim, _L("Table: %S with Column Name: %S, Value:%S, Hidden:%b is empty"),

						&aTableName,&aColumnToMatch,&aValueToMatch,iDb.iShowHiddenRecords);

		}

	else

		{

		__FLOG_STATIC4(KLogComponent, KCommDbShim, _L("Table: %S with Column Name: %S, Value:%S, Hidden:%b"),

					&aTableName,&aColumnToMatch,&aValueToMatch,iDb.iShowHiddenRecords);

		}

	TableWithTemplateRecord() ? iTemplate = CCommsDbTemplateRecord::NewL(&iDb,iTableName) : iTemplate = NULL;

	iState=EOpenIdle;

	}

void CCommsDbTableView::ConstructL(const TDesC& aTableName, const TDesC& aColumnToMatch, TUint32 aValueToMatch)

/**

@param aTableName

@param aColumnToMatch

@param aValueToMatch

@param includeHiddenRecords

*/

	{

	CMDBRecordSetBase* rs(NULL);

	TInt type(0);

	iTableExt = CCommDbTableExtension::NewL();

	iTableExt->SetRecordSetL(aTableName, *iDb.iImpl->iDbs, KPreparePriming, KDoNotLoadTable);

	rs = iTableExt->GetRecordSetL();

	TBool searchResult(EFalse);

	if(aColumnToMatch.CompareF(TPtrC(COMMDB_ID)) == 0)

		{

		rs->iRecords[0]->SetRecordId(aValueToMatch);

		TRAPD(err, rs->iRecords[0]->LoadL(*iDb.iImpl->iDbs));

		if(err == KErrNone)

			{

			searchResult = ETrue;

			}

		else if(err == KErrNotFound)	// returning an empty record set is DBMS-compatible

			{

			searchResult = EFalse;

			}

		else

			{

			User::Leave(err);

			}

		}

	else

		{