* %version: 14.1.2 %

#include "eap_am_trace_symbian.h"

void EapSecurIDDbUtils::OpenDatabaseL(RDbNamedDatabase& aDatabase, RDbs& aSession, const TIndexType aIndexType,

	const TInt aIndex, const eap_type_value_e aTunnelingType)

#ifdef USE_EAP_EXPANDED_TYPES

	TUint aTunnelingVendorType = aTunnelingType.get_vendor_type();

#else

	TUint aTunnelingVendorType = static_cast<TUint>(aTunnelingType);

#endif //#ifdef USE_EAP_EXPANDED_TYPES

	// Connect to the DBMS server.

	User::LeaveIfError(aSession.Connect());		

	CleanupClosePushL(aSession);	

	// aSession and aDatabase are pushed to the cleanup stack even though they may be member

	// variables of the calling class and would be closed in the destructor anyway. This ensures

	// that if they are not member variables they will be closed. Closing the handle twice

	// does no harm.	

#ifdef SYMBIAN_SECURE_DBMS

	// Create the secure shared database with the specified secure policy.

	// Database will be created in the data caging path for DBMS (C:\private\100012a5).

	TInt err = aDatabase.Create(aSession, KDatabaseName, KSecureUIDFormat);

	EAP_TRACE_DEBUG_SYMBIAN((_L("EapSecurIDDbUtils::OpenDatabaseL - Created Secure DB for eapsecurid.dat. err=%d\n"), err));

	if(err == KErrNone)

	} else if (err != KErrAlreadyExists) 

		User::LeaveIfError(err);

	User::LeaveIfError(aDatabase.Open(aSession, KDatabaseName, KSecureUIDFormat));

	CleanupClosePushL(aDatabase);		

#else

	// For non-secured database. The database will be created in the old location (c:\system\data).

	RFs fsSession;		

	User::LeaveIfError(fsSession.Connect());

	CleanupClosePushL(fsSession);	

	TInt err = aDatabase.Create(fsSession, KDatabaseName);

	EAP_TRACE_DEBUG_SYMBIAN((_L("EapSecurIDDbUtils::OpenDatabaseL - Created Non-Secure DB for eapsecurid.dat. err=%d\n"), err));

	if(err == KErrNone)

	{

		aDatabase.Close();

	} else if (err != KErrAlreadyExists) 

	{

		User::LeaveIfError(err);

	}

	CleanupStack::PopAndDestroy(); // close fsSession

	User::LeaveIfError(aDatabase.Open(aSession, KDatabaseName));

	CleanupClosePushL(aDatabase);		

#endif // #ifdef SYMBIAN_SECURE_DBMS

	_LIT(KSQLCreateTable1, "CREATE TABLE %S (%S UNSIGNED INTEGER, \

											 %S UNSIGNED INTEGER, \

											 %S UNSIGNED INTEGER, \

											 %S VARCHAR(255))");

	sqlStatement.Format(KSQLCreateTable1, &KSecurIDTableName, &KServiceType, &KServiceIndex, &KTunnelingType, &cf_str_EAP_SECURID_identity_literal);

	err = aDatabase.Execute(sqlStatement);

	if (err != KErrNone && err != KErrAlreadyExists)

		User::Leave(err);

	_LIT(KSQLQueryRow, "SELECT %S FROM %S WHERE %S=%d AND %S=%d AND %S=%d");

	sqlStatement.Format(KSQLQueryRow, &cf_str_EAP_SECURID_identity_literal, &KSecurIDTableName, 

		&KServiceType, aIndexType, &KServiceIndex, aIndex, &KTunnelingType, aTunnelingVendorType);

	CleanupStack::PopAndDestroy(); // view

		view.SetColL(colSet->ColNo(KTunnelingType), aTunnelingVendorType);

	CleanupStack::PopAndDestroy(); // sqlStatement

	CleanupStack::Pop(2); // database, session