MCL/sf/mw/accesssec: eapol/eapol_framework/eapol_symbian/am/type/gsmsim/symbian/plugin/src/EapSimDbUtils.cpp@bad0cc58d154 (annotated)

0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	1	/*
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	2	* Copyright (c) 2001-2006 Nokia Corporation and/or its subsidiary(-ies).
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	3	* All rights reserved.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	4	* This component and the accompanying materials are made available
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	5	* under the terms of the License "Eclipse Public License v1.0"
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	6	* which accompanies this distribution, and is available
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	7	* at the URL "http://www.eclipse.org/legal/epl-v10.html".
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	8	*
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	9	* Initial Contributors:
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	10	* Nokia Corporation - initial contribution.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	11	*
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	12	* Contributors:
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	13	*
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	14	* Description: EAP and WLAN authentication protocols.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	15	*
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	16	*/
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	17
2 1c7bc153c08e Revision: 201001 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 0 diff changeset	18	/*
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	19	* %version: 57 %
2 1c7bc153c08e Revision: 201001 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 0 diff changeset	20	*/
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	21
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	22	// This is enumeration of EAPOL source code.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	23	#if defined(USE_EAP_MINIMUM_RELEASE_TRACES)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	24	#undef EAP_FILE_NUMBER_ENUM
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	25	#define EAP_FILE_NUMBER_ENUM 209
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	26	#undef EAP_FILE_NUMBER_DATE
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	27	#define EAP_FILE_NUMBER_DATE 1127594498
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	28	#endif //#if defined(USE_EAP_MINIMUM_RELEASE_TRACES)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	29
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	30
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	31	// INCLUDES
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	32	#include "EapSimDbUtils.h"
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	33	#include "EapSimDbDefaults.h"
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	34	#include "EapSimDbParameterNames.h"
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	35
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	36	#include <EapTraceSymbian.h>
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	37	#include "EapPluginTools.h"
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	38
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	39	const TInt KMaxSqlQueryLength = 2048;
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	40	const TInt KMicroSecsInAMinute = 60000000; // 60000000 micro seconds is 1 minute.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	41
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	42	// ================= MEMBER FUNCTIONS =======================
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	43
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	44	void EapSimDbUtils::OpenDatabaseL(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	45	RDbNamedDatabase& aDatabase,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	46	RFs& aFileServerSession,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	47	const TIndexType aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	48	const TInt aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	49	const eap_type_value_e aTunnelingType)
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	50	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	51	EAP_TRACE_DEBUG_SYMBIAN(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	52	(_L("EapSimDbUtils::OpenDatabaseL(): Start - aIndexType=%d, aIndex=%d, aTunnelingType=0xfe%06x%08x\n"),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	53	aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	54	aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	55	aTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	56	aTunnelingType.get_vendor_type()));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	57
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	58	EAP_TRACE_RETURN_STRING_SYMBIAN(_L("returns: EapSimDbUtils::OpenDatabaseL()\n"));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	59
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	60	// 1. Open/create a database
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	61
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	62	TInt error(KErrNone);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	63	TFileName aPrivateDatabasePathName;
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	64
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	65	EapPluginTools::CreateDatabaseLC(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	66	aDatabase,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	67	aFileServerSession,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	68	error,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	69	KEapSimDatabaseName,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	70	aPrivateDatabasePathName);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	71
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	72	if(error == KErrNone)
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	73	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	74	aDatabase.Close();
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	75	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	76	else if (error != KErrAlreadyExists)
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	77	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	78	User::LeaveIfError(error);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	79	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	80
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	81	EAP_TRACE_DEBUG_SYMBIAN((_L("EapSimDbUtils::OpenDatabaseL(): calls aDatabase.Open()\n")));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	82
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	83	error = aDatabase.Open(aFileServerSession, aPrivateDatabasePathName);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	84
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	85	EAP_TRACE_DEBUG_SYMBIAN((_L("EapSimDbUtils::OpenDatabaseL(): Opened private DB for EAP-SIM. error=%d\n"), error));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	86
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	87	User::LeaveIfError(error);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	88
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	89	// 2. Create the eapsim table to database (ignore error if exists)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	90
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	91	// Table columns:
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	92	//// NAME ///////////////////////////////////////////////// TYPE ////////////// Constant /////////
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	93	//\| ServiceType \| UNSIGNED INTEGER \| KServiceType \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	94	//\| ServiceIndex \| UNSIGNED INTEGER \| KServiceIndex \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	95	//\| TunnelingTypeVendorId \| UNSIGNED INTEGER \| KTunnelingTypeVendorId \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	96	//\| TunnelingType \| UNSIGNED INTEGER \| KTunnelingType \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	97	//\| EAP_GSMSIM_use_manual_realm \| UNSIGNED INTEGER \| cf_str_EAP_GSMSIM_use_manual_realm_literal \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	98	//\| EAP_GSMSIM_manual_realm \| VARCHAR(255) \| cf_str_EAP_GSMSIM_manual_realm_literal \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	99	//\| EAP_GSMSIM_use_manual_username \| UNSIGNED INTEGER \| cf_str_EAP_GSMSIM_use_manual_username_literal\|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	100	//\| EAP_GSMSIM_manual_username \| VARCHAR(255) \| cf_str_EAP_GSMSIM_manual_username_literal \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	101	//\| PseudonymId \| LONG VARBINARY \| KPseudonymId \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	102	//\| XKEY \| BINARY(20) \| KXKey \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	103	//\| K_aut \| BINARY(16) \| KK_aut \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	104	//\| K_encr \| BINARY(16) \| KK_encr \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	105	//\| ReauthCounter \| UNSIGNED INTEGER \| KReauthCounter \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	106	//\| ReauthId \| LONG VARBINARY \| KReauthId \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	107	//\| PreviousIMSI \| VARBINARY(15) \| KPreviousIMSI \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	108	//\| EAP_GSMSIM_use_pseudonym_identity \| UNSIGNED INTEGER \| cf_str_EAP_GSMSIM_use_pseudonym_identity_literal \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	109	//\| EAP_GSMSIM_max_session_validity_time \| BIGINT \| cf_str_EAP_GSMSIM_max_session_validity_time_literal \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	110	//\| EAP_GSMSIM_last_full_authentication_time \| BIGINT \| KGSMSIMLastFullAuthTime \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	111	//////////////////////////////////////////////////////////////////////////////////////////////////
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	112
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	113	HBufC* buf = HBufC::NewLC(KMaxSqlQueryLength);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	114	TPtr sqlStatement = buf->Des();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	115
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	116	_LIT(KSQLCreateTable, "CREATE TABLE %S \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	117	(%S UNSIGNED INTEGER, \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	118	%S UNSIGNED INTEGER, \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	119	%S UNSIGNED INTEGER, \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	120	%S UNSIGNED INTEGER, \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	121	%S UNSIGNED INTEGER, \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	122	%S VARCHAR(%d), \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	123	%S UNSIGNED INTEGER, \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	124	%S VARCHAR(%d), \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	125	%S LONG VARBINARY, \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	126	%S BINARY(%d), \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	127	%S BINARY(%d), \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	128	%S BINARY(%d), \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	129	%S UNSIGNED INTEGER, \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	130	%S LONG VARBINARY, \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	131	%S VARBINARY(%d), \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	132	%S UNSIGNED INTEGER, \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	133	%S BIGINT, \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	134	%S BIGINT)");
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	135
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	136	sqlStatement.Format(KSQLCreateTable,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	137	&KSimTableName,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	138	&KServiceType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	139	&KServiceIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	140	&KTunnelingTypeVendorId,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	141	&KTunnelingType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	142	&cf_str_EAP_GSMSIM_use_manual_realm_literal,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	143	&cf_str_EAP_GSMSIM_manual_realm_literal, KMaxRealmLengthInDB,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	144	&cf_str_EAP_GSMSIM_use_manual_username_literal,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	145	&cf_str_EAP_GSMSIM_manual_username_literal, KMaxUsernameLengthInDB,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	146	&KPseudonymId,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	147	&KXKey, KMaxXKeyLengthInDB,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	148	&KK_aut, KMaxK_autLengthInDB,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	149	&KK_encr, KMaxK_encrLengthInDB,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	150	&KReauthCounter,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	151	&KReauthId,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	152	&KPreviousIMSI, KMaxIMSILengthInDB,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	153	&cf_str_EAP_GSMSIM_use_pseudonym_identity_literal,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	154	&cf_str_EAP_GSMSIM_max_session_validity_time_literal,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	155	&KGSMSIMLastFullAuthTime);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	156
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	157	error = aDatabase.Execute(sqlStatement);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	158	if (error != KErrNone && error != KErrAlreadyExists)
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	159	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	160	User::Leave(error);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	161	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	162
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	163	// 4. Check if database table contains a row for this service type and id
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	164
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	165	_LIT(KSQLQueryRow, "SELECT %S FROM %S WHERE %S=%d AND %S=%d AND %S=%d AND %S=%d");
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	166
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	167	sqlStatement.Format(KSQLQueryRow,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	168	&cf_str_EAP_GSMSIM_manual_realm_literal,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	169	&KSimTableName,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	170	&KServiceType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	171	aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	172	&KServiceIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	173	aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	174	&KTunnelingTypeVendorId,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	175	aTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	176	&KTunnelingType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	177	aTunnelingType.get_vendor_type());
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	178
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	179	RDbView view;
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	180	User::LeaveIfError(view.Prepare(aDatabase, TDbQuery(sqlStatement), TDbWindow::EUnlimited));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	181	// View must be closed when no longer needed
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	182	CleanupClosePushL(view);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	183
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	184	User::LeaveIfError(view.EvaluateAll());
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	185
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	186	// 5. If row is not found then add it
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	187
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	188	TInt rows = view.CountL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	189	CleanupStack::PopAndDestroy( &view ); // Close view.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	190	if (rows == 0)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	191	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	192	_LIT(KSQLInsert, "SELECT * FROM %S");
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	193	sqlStatement.Format(KSQLInsert, &KSimTableName);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	194
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	195	User::LeaveIfError(view.Prepare(aDatabase, TDbQuery(sqlStatement), TDbWindow::EUnlimited, RDbView::EInsertOnly));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	196	CleanupClosePushL(view);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	197
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	198	// Get column set so we get the correct column numbers
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	199	CDbColSet* colSet = view.ColSetL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	200	CleanupStack::PushL(colSet);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	201
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	202	view.InsertL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	203	view.SetColL(colSet->ColNo(KServiceType), static_cast<TInt>(aIndexType));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	204	view.SetColL(colSet->ColNo(KServiceIndex), aIndex);
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	205	view.SetColL(colSet->ColNo(KTunnelingTypeVendorId), aTunnelingType.get_vendor_id());
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	206	view.SetColL(colSet->ColNo(KTunnelingType), aTunnelingType.get_vendor_type());
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	207
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	208	view.SetColL(colSet->ColNo(cf_str_EAP_GSMSIM_use_manual_realm_literal), default_EAP_GSMSIM_use_manual_realm);
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	209	view.SetColL(colSet->ColNo(cf_str_EAP_GSMSIM_manual_realm_literal), default_EAP_realm);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	210
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	211	view.SetColL(colSet->ColNo(cf_str_EAP_GSMSIM_use_manual_username_literal), default_EAP_GSMSIM_use_manual_username);
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	212	view.SetColL(colSet->ColNo(cf_str_EAP_GSMSIM_manual_username_literal), default_EAP_username);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	213
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	214	view.SetColL(colSet->ColNo(cf_str_EAP_GSMSIM_use_pseudonym_identity_literal), default_EAP_GSMSIM_use_pseudonym_identity);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	215
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	216	view.SetColL(colSet->ColNo(cf_str_EAP_GSMSIM_max_session_validity_time_literal), default_MaxSessionTime);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	217
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	218	view.SetColL(colSet->ColNo(KGSMSIMLastFullAuthTime), default_FullAuthTime);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	219
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	220	view.PutL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	221
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	222	CleanupStack::PopAndDestroy( colSet );
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	223
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	224	CleanupStack::PopAndDestroy( &view );
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	225	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	226
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	227	aDatabase.Compact();
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	228
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	229	CleanupStack::PopAndDestroy( buf );
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	230	CleanupStack::Pop( &aDatabase );
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	231	CleanupStack::Pop( &aFileServerSession );
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	232	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	233
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	234	// ----------------------------------------------------------
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	235
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	236	void EapSimDbUtils::SetIndexL(
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	237	RDbNamedDatabase& aDatabase,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	238	const TIndexType aIndexType,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	239	const TInt aIndex,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	240	const eap_type_value_e aTunnelingType,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	241	const TIndexType aNewIndexType,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	242	const TInt aNewIndex,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	243	const eap_type_value_e aNewTunnelingType)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	244	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	245	EAP_TRACE_DEBUG_SYMBIAN(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	246	(_L("EapSimDbUtils::SetIndexL(): -Start- aIndexType=%d, aIndex=%d, aTunnelingType=0xfe%06x%08x\n"),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	247	aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	248	aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	249	aTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	250	aTunnelingType.get_vendor_type()));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	251
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	252	EAP_TRACE_DEBUG_SYMBIAN(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	253	(_L("EapSimDbUtils::SetIndexL(): -Start- aNewIndexType=%d, aNewIndex=%d, aNewTunnelingType=0xfe%06x%08x\n"),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	254	aNewIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	255	aNewIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	256	aNewTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	257	aNewTunnelingType.get_vendor_type()));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	258
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	259	EAP_TRACE_RETURN_STRING_SYMBIAN(_L("returns: EapSimDbUtils::SetIndexL()\n"));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	260
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	261	HBufC* buf = HBufC::NewLC(KMaxSqlQueryLength);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	262	TPtr sqlStatement = buf->Des();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	263
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	264	_LIT(KSQL, "SELECT * FROM %S WHERE %S=%d AND %S=%d AND %S=%d AND %S=%d");
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	265
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	266	sqlStatement.Format(KSQL,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	267	&KSimTableName,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	268	&KServiceType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	269	aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	270	&KServiceIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	271	aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	272	&KTunnelingTypeVendorId,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	273	aTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	274	&KTunnelingType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	275	aTunnelingType.get_vendor_type());
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	276
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	277	RDbView view;
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	278
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	279	User::LeaveIfError(view.Prepare(aDatabase, TDbQuery(sqlStatement), TDbWindow::EUnlimited));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	280
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	281	// View must be closed when no longer needed
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	282	CleanupClosePushL(view);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	283
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	284	User::LeaveIfError(view.EvaluateAll());
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	285
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	286	TInt rows = view.CountL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	287
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	288	if (rows == 0)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	289	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	290	User::Leave(KErrNotFound);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	291	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	292
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	293	// Get the first (and only) row
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	294	view.FirstL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	295	view.GetL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	296
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	297	// Get column set so we get the correct column numbers
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	298	CDbColSet* colSet = view.ColSetL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	299	CleanupStack::PushL(colSet);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	300
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	301	view.UpdateL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	302
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	303	view.SetColL(colSet->ColNo(KServiceType), static_cast<TUint>(aNewIndexType));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	304	view.SetColL(colSet->ColNo(KServiceIndex), aNewIndex);
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	305	view.SetColL(colSet->ColNo(KTunnelingTypeVendorId), aNewTunnelingType.get_vendor_id());
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	306	view.SetColL(colSet->ColNo(KTunnelingType), aNewTunnelingType.get_vendor_type());
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	307
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	308	view.PutL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	309
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	310	CleanupStack::PopAndDestroy(colSet);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	311	CleanupStack::PopAndDestroy(&view);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	312	CleanupStack::PopAndDestroy(buf);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	313	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	314
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	315	// ----------------------------------------------------------
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	316
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	317	void EapSimDbUtils::SetConfigurationL(
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	318	RDbNamedDatabase& aDatabase,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	319	const EAPSettings& aSettings,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	320	const TIndexType aIndexType,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	321	const TInt aIndex,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	322	const eap_type_value_e aTunnelingType)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	323	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	324	EAP_TRACE_DEBUG_SYMBIAN(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	325	(_L("EapSimDbUtils::SetConfigurationL(): -Start- aIndexType=%d, aIndex=%d, aTunnelingType=0xfe%06x%08x\n"),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	326	aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	327	aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	328	aTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	329	aTunnelingType.get_vendor_type()));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	330
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	331	EAP_TRACE_RETURN_STRING_SYMBIAN(_L("returns: EapSimDbUtils::SetConfigurationL()\n"));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	332
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	333	EAP_TRACE_DEBUG_SYMBIAN((_L("************************* SetConfigurationL(): Set the below values: *************************\n")) );
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	334
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	335	EAP_TRACE_SETTINGS(&aSettings);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	336
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	337	EAP_TRACE_DEBUG_SYMBIAN((_L("************************* SetConfigurationL(): Set the above values: *************************\n")) );
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	338
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	339	// Check if the settings are for the correct type
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	340	if (aSettings.iEAPExpandedType != (*EapExpandedTypeSim.GetType()))
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	341	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	342	User::Leave(KErrNotSupported);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	343	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	344
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	345	HBufC* buf = HBufC::NewLC(KMaxSqlQueryLength);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	346	TPtr sqlStatement = buf->Des();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	347
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	348	RDbView view;
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	349
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	350	_LIT(KSQLQuery, "SELECT * FROM %S WHERE %S=%d AND %S=%d AND %S=%d AND %S=%d");
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	351
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	352	sqlStatement.Format(KSQLQuery,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	353	&KSimTableName,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	354	&KServiceType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	355	aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	356	&KServiceIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	357	aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	358	&KTunnelingTypeVendorId,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	359	aTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	360	&KTunnelingType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	361	aTunnelingType.get_vendor_type());
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	362
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	363	// Evaluate view
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	364	User::LeaveIfError(view.Prepare(aDatabase, TDbQuery(sqlStatement)));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	365
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	366	CleanupClosePushL(view);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	367
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	368	User::LeaveIfError(view.EvaluateAll());
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	369
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	370	view.FirstL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	371
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	372	view.UpdateL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	373
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	374	// Get column set so we get the correct column numbers
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	375	CDbColSet* colSet = view.ColSetL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	376	CleanupStack::PushL(colSet);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	377
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	378
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	379	if (aSettings.iUseAutomaticUsernamePresent)
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	380	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	381	// This is to set the automatic or manual status.
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	382	TUint useManualUsernameStatus;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	383
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	384	if (aSettings.iUseAutomaticUsername)
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	385	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	386	useManualUsernameStatus = EEapDbFalse;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	387	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	388	else
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	389	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	390	useManualUsernameStatus = EEapDbTrue;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	391	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	392
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	393	// Set the value.
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	394	view.SetColL(colSet->ColNo(cf_str_EAP_GSMSIM_use_manual_username_literal), useManualUsernameStatus);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	395	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	396
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	397
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	398	if (aSettings.iUseAutomaticRealmPresent)
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	399	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	400	// This is to set the automatic or manual status.
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	401	TUint useManualRealmStatus;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	402
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	403	if (aSettings.iUseAutomaticRealm)
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	404	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	405	useManualRealmStatus = EEapDbFalse;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	406	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	407	else
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	408	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	409	useManualRealmStatus = EEapDbTrue;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	410	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	411
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	412	// Set the value.
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	413	view.SetColL(colSet->ColNo(cf_str_EAP_GSMSIM_use_manual_realm_literal), useManualRealmStatus);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	414	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	415
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	416
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	417	// Manual username
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	418	if (aSettings.iUsernamePresent) // no need to check as there may be empty usernames with the present status is EFlase.
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	419	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	420	// Check if length of username is less than the max length.
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	421	if(aSettings.iUsername.Length() > KMaxUsernameLengthInDB)
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	422	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	423	// Username too long. Can not be stored in DB.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	424
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	425	EAP_TRACE_DEBUG_SYMBIAN((_L("EapSimDbUtils::SetConfigurationL: Too long Username. Length=%d \n"),
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	426	aSettings.iUsername.Length()));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	427
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	428	User::Leave(KErrArgument);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	429	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	430
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	431	// Length is ok. Set the value in DB. Value could be empty. It doesn't matter.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	432	view.SetColL(colSet->ColNo(cf_str_EAP_GSMSIM_manual_username_literal), aSettings.iUsername);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	433	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	434
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	435	// Manual realm
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	436	if (aSettings.iRealmPresent) // no need to check as there may be empty realms with the present status is EFlase.
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	437	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	438	// Check if length of realm is less than the max length.
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	439	if(aSettings.iRealm.Length() > KMaxRealmLengthInDB)
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	440	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	441	// Realm too long. Can not be stored in DB.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	442
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	443	EAP_TRACE_DEBUG_SYMBIAN((_L("EapSimDbUtils::SetConfigurationL: Too long Realm. Length=%d \n"),
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	444	aSettings.iRealm.Length()));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	445
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	446	User::Leave(KErrArgument);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	447	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	448
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	449	// Length is ok. Set the value in DB. Value could be empty. It doesn't matter.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	450	view.SetColL(colSet->ColNo(cf_str_EAP_GSMSIM_manual_realm_literal), aSettings.iRealm);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	451	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	452
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	453	// UsePseudonym
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	454	if (aSettings.iUsePseudonymsPresent)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	455	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	456	if (aSettings.iUsePseudonyms)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	457	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	458	// Use pseudonym.
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	459	view.SetColL(colSet->ColNo(cf_str_EAP_GSMSIM_use_pseudonym_identity_literal), EEapDbTrue);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	460	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	461	else
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	462	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	463	// Don't use pseudonym.
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	464	view.SetColL(colSet->ColNo(cf_str_EAP_GSMSIM_use_pseudonym_identity_literal), EEapDbFalse);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	465	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	466	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	467	else
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	468	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	469	// Value is not configured. Value is read from config file if needed.
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	470	view.SetColL(colSet->ColNo(cf_str_EAP_GSMSIM_use_pseudonym_identity_literal), EEapDbNotValid);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	471	}
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	472
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	473	// Session validity time
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	474	if (aSettings.iSessionValidityTimePresent)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	475	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	476	// User or device management wants to store the session validity time.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	477	// Convert the time to micro seconds and save.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	478
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	479	TInt64 validityInMicro = (aSettings.iSessionValidityTime) * KMicroSecsInAMinute;
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	480
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	481	view.SetColL(colSet->ColNo(cf_str_EAP_GSMSIM_max_session_validity_time_literal), validityInMicro);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	482	}
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	483
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	484	if (aIndexType != EVpn) // This allows current VPN IF to use reauthentication. VPN does not zero last full authentication time.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	485	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	486	// Last full authentication time should be made zero when EAP configurations are modified.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	487	// This makes sure that the next authentication with this EAP would be full authentication
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	488	// instead of reauthentication even if the session is still valid.
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	489
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	490	view.SetColL(colSet->ColNo(KGSMSIMLastFullAuthTime), default_FullAuthTime);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	491
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	492	EAP_TRACE_DEBUG_SYMBIAN((_L("EapSimDbUtils::SetConfigurationL(): Session Validity: Resetting Full Auth Time since settings are modified\n")));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	493	}
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	494
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	495	view.PutL();
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	496
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	497	CleanupStack::PopAndDestroy(colSet);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	498	CleanupStack::PopAndDestroy(&view);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	499	CleanupStack::PopAndDestroy(buf);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	500	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	501
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	502	// ----------------------------------------------------------
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	503
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	504	void EapSimDbUtils::GetConfigurationL(
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	505	RDbNamedDatabase& aDatabase,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	506	EAPSettings& aSettings,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	507	const TIndexType aIndexType,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	508	const TInt aIndex,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	509	const eap_type_value_e aTunnelingType)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	510	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	511	EAP_TRACE_DEBUG_SYMBIAN(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	512	(_L("EapSimDbUtils::GetConfigurationL(): -Start- aIndexType=%d, aIndex=%d, aTunnelingType=0xfe%06x%08x\n"),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	513	aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	514	aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	515	aTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	516	aTunnelingType.get_vendor_type()));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	517
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	518	EAP_TRACE_RETURN_STRING_SYMBIAN(_L("returns: EapSimDbUtils::GetConfigurationL()\n"));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	519
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	520	HBufC* buf = HBufC::NewLC(KMaxSqlQueryLength);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	521	TPtr sqlStatement = buf->Des();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	522
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	523	RDbView view;
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	524
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	525	// Form the query
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	526	_LIT(KSQLQuery, "SELECT * FROM %S WHERE %S=%d AND %S=%d AND %S=%d AND %S=%d");
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	527
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	528	sqlStatement.Format(KSQLQuery,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	529	&KSimTableName,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	530	&KServiceType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	531	aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	532	&KServiceIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	533	aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	534	&KTunnelingTypeVendorId,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	535	aTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	536	&KTunnelingType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	537	aTunnelingType.get_vendor_type());
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	538
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	539	// Evaluate view
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	540	User::LeaveIfError(view.Prepare(aDatabase, TDbQuery(sqlStatement)));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	541
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	542	CleanupClosePushL(view);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	543
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	544	User::LeaveIfError(view.EvaluateAll());
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	545
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	546	// Get the first (and only) row
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	547	view.FirstL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	548	view.GetL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	549
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	550	// Get column set so we get the correct column numbers
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	551	CDbColSet* colSet = view.ColSetL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	552	CleanupStack::PushL(colSet);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	553
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	554	aSettings.iEAPExpandedType = *EapExpandedTypeSim.GetType();
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	555
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	556	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	557	// For manual or automatic username.
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	558	TUint useUsername = view.ColUint(colSet->ColNo(cf_str_EAP_GSMSIM_use_manual_username_literal));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	559
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	560	aSettings.iUseAutomaticUsernamePresent = ETrue;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	561
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	562	if(useUsername == EEapDbTrue)
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	563	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	564	aSettings.iUseAutomaticUsername = EFalse;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	565	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	566	else
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	567	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	568	aSettings.iUseAutomaticUsername = ETrue;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	569	}
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	570	}
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	571
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	572	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	573	// For manual or automatic realm.
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	574	TUint useRealm = view.ColUint(colSet->ColNo(cf_str_EAP_GSMSIM_use_manual_realm_literal));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	575
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	576	aSettings.iUseAutomaticRealmPresent = ETrue;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	577
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	578	if(useRealm == EEapDbTrue)
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	579	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	580	aSettings.iUseAutomaticRealm = EFalse;
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	581	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	582	else
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	583	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	584	aSettings.iUseAutomaticRealm = ETrue;
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	585	}
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	586	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	587
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	588	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	589	// Username
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	590	TPtrC username = view.ColDes(colSet->ColNo(cf_str_EAP_GSMSIM_manual_username_literal));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	591
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	592	aSettings.iUsernamePresent = ETrue;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	593
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	594	aSettings.iUsername.Copy(username);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	595	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	596
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	597	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	598	// Realm
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	599	TPtrC realm = view.ColDes(colSet->ColNo(cf_str_EAP_GSMSIM_manual_realm_literal));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	600
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	601	aSettings.iRealmPresent = ETrue;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	602
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	603	aSettings.iRealm.Copy(realm);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	604	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	605
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	606	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	607	TInt usePseudonym = view.ColUint(colSet->ColNo(cf_str_EAP_GSMSIM_use_pseudonym_identity_literal));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	608
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	609	if (usePseudonym == EEapDbNotValid)
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	610	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	611	aSettings.iUsePseudonymsPresent = EFalse;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	612	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	613	else
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	614	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	615	if (usePseudonym == EEapDbFalse)
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	616	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	617	aSettings.iUsePseudonyms = EFalse;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	618	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	619	else
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	620	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	621	aSettings.iUsePseudonyms = ETrue;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	622	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	623
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	624	aSettings.iUsePseudonymsPresent = ETrue;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	625	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	626	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	627
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	628	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	629	// Session validity time
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	630	TInt64 maxSessionTimeMicro = view.ColInt64(colSet->ColNo(cf_str_EAP_GSMSIM_max_session_validity_time_literal));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	631
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	632	// Convert the time to minutes.
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	633	TInt64 maxSessionTimeMin = maxSessionTimeMicro / KMicroSecsInAMinute;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	634
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	635	aSettings.iSessionValidityTime = static_cast<TUint>(maxSessionTimeMin);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	636	aSettings.iSessionValidityTimePresent = ETrue;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	637	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	638
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	639	CleanupStack::PopAndDestroy(colSet);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	640	CleanupStack::PopAndDestroy(&view);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	641	CleanupStack::PopAndDestroy(buf);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	642
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	643	EAP_TRACE_SETTINGS(&aSettings);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	644	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	645
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	646	// ----------------------------------------------------------
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	647
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	648	void EapSimDbUtils::CopySettingsL(
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	649	RDbNamedDatabase& aDatabase,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	650	const TIndexType aSrcIndexType,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	651	const TInt aSrcIndex,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	652	const eap_type_value_e aSrcTunnelingType,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	653	const TIndexType aDestIndexType,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	654	const TInt aDestIndex,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	655	const eap_type_value_e aDestTunnelingType)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	656	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	657	EAP_TRACE_DEBUG_SYMBIAN(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	658	(_L("EapSimDbUtils::CopySettingsL(): -Start- aSrcIndexType=%d, aSrcIndex=%d, aSrcTunnelingType=0xfe%06x%08x\n"),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	659	aSrcIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	660	aSrcIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	661	aSrcTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	662	aSrcTunnelingType.get_vendor_type()));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	663
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	664	EAP_TRACE_DEBUG_SYMBIAN(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	665	(_L("EapSimDbUtils::CopySettingsL(): -Start- aDestIndexType=%d, aDestTunnelingType=0xfe%06x%08x\n"),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	666	aDestIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	667	aDestIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	668	aDestTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	669	aDestTunnelingType.get_vendor_type()));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	670
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	671	EAP_TRACE_RETURN_STRING_SYMBIAN(_L("returns: EapSimDbUtils::CopySettingsL()\n"));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	672
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	673	HBufC* buf = HBufC::NewLC(KMaxSqlQueryLength);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	674	TPtr sqlStatement = buf->Des();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	675
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	676	_LIT(KSQL, "SELECT * FROM %S WHERE %S=%d AND %S=%d AND %S=%d AND %S=%d");
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	677
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	678	sqlStatement.Format(KSQL,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	679	&KSimTableName,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	680	&KServiceType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	681	aSrcIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	682	&KServiceIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	683	aSrcIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	684	&KTunnelingTypeVendorId,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	685	aSrcTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	686	&KTunnelingType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	687	aSrcTunnelingType.get_vendor_type());
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	688
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	689	RDbView view;
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	690
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	691	User::LeaveIfError(view.Prepare(aDatabase, TDbQuery(sqlStatement), TDbWindow::EUnlimited));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	692
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	693	// View must be closed when no longer needed
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	694	CleanupClosePushL(view);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	695
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	696	User::LeaveIfError(view.EvaluateAll());
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	697
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	698	TInt rows = view.CountL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	699
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	700	if (rows == 0)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	701	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	702	User::Leave(KErrNotFound);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	703	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	704
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	705	// Get the first (and only) row
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	706	view.FirstL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	707
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	708	view.GetL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	709
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	710	view.InsertCopyL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	711
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	712	// Get column set so we get the correct column numbers
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	713	CDbColSet* colSet = view.ColSetL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	714
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	715	CleanupStack::PushL(colSet);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	716
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	717	view.SetColL(colSet->ColNo(KServiceType), static_cast<TUint>(aDestIndexType));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	718	view.SetColL(colSet->ColNo(KServiceIndex), aDestIndex);
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	719	view.SetColL(colSet->ColNo(KTunnelingTypeVendorId), aDestTunnelingType.get_vendor_id());
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	720	view.SetColL(colSet->ColNo(KTunnelingType), aDestTunnelingType.get_vendor_type());
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	721
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	722	view.PutL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	723
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	724	CleanupStack::PopAndDestroy(colSet);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	725	CleanupStack::PopAndDestroy(&view);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	726	CleanupStack::PopAndDestroy(buf);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	727	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	728
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	729	// ----------------------------------------------------------
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	730
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	731	void EapSimDbUtils::DeleteConfigurationL(
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	732	const TIndexType aIndexType,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	733	const TInt aIndex,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	734	const eap_type_value_e aTunnelingType)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	735	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	736	EAP_TRACE_DEBUG_SYMBIAN(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	737	(_L("EapSimDbUtils::DeleteConfigurationL(): -Start- aIndexType=%d, aIndex=%d, aTunnelingType=0xfe%06x%08x\n"),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	738	aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	739	aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	740	aTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	741	aTunnelingType.get_vendor_type()));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	742
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	743	EAP_TRACE_RETURN_STRING_SYMBIAN(_L("returns: EapSimDbUtils::DeleteConfigurationL()\n"));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	744
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	745	RDbNamedDatabase aDatabase;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	746	RFs aFileServerSession;
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	747
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	748	TInt error(KErrNone);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	749	TFileName aPrivateDatabasePathName;
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	750
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	751	error = aFileServerSession.Connect();
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	752	EAP_TRACE_DEBUG_SYMBIAN((_L("EapSimDbUtils::DeleteConfigurationL(): - aFileServerSession.Connect(), error=%d\n"), error));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	753	User::LeaveIfError(error);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	754
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	755	EapPluginTools::CreateDatabaseLC(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	756	aDatabase,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	757	aFileServerSession,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	758	error,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	759	KEapSimDatabaseName,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	760	aPrivateDatabasePathName);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	761
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	762	if(error == KErrNone)
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	763	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	764	// Database was created so it was empty. No need for further actions.
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	765	aDatabase.Destroy();
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	766	CleanupStack::PopAndDestroy(&aDatabase);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	767	CleanupStack::PopAndDestroy(&aFileServerSession);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	768	return;
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	769	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	770	else if (error != KErrAlreadyExists)
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	771	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	772	User::LeaveIfError(error);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	773	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	774
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	775	error = aDatabase.Open(aFileServerSession, aPrivateDatabasePathName);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	776
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	777	User::LeaveIfError(error);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	778
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	779	HBufC* buf = HBufC::NewLC(KMaxSqlQueryLength);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	780	TPtr sqlStatement = buf->Des();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	781
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	782	// Main settings table
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	783	_LIT(KSQL, "SELECT * FROM %S WHERE %S=%d AND %S=%d AND %S=%d AND %S=%d");
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	784
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	785	sqlStatement.Format(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	786	KSQL,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	787	&KSimTableName,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	788	&KServiceType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	789	aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	790	&KServiceIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	791	aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	792	&KTunnelingTypeVendorId,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	793	aTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	794	&KTunnelingType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	795	aTunnelingType.get_vendor_type());
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	796
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	797	// Evaluate view
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	798	RDbView view;
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	799
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	800	error = view.Prepare(aDatabase, TDbQuery(sqlStatement), TDbWindow::EUnlimited);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	801
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	802	User::LeaveIfError(error);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	803
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	804	CleanupClosePushL(view);
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	805
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	806	error = view.EvaluateAll();
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	807
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	808	User::LeaveIfError(error);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	809
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	810	// Delete rows
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	811	if (view.FirstL())
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	812	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	813	do
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	814	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	815	EAP_TRACE_DEBUG_SYMBIAN((_L("EapSimDbUtils::DeleteConfigurationL(): calls view.DeleteL()\n")));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	816
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	817	view.DeleteL();
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	818	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	819	while (view.NextL() != EFalse);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	820
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	821	EAP_TRACE_DEBUG_SYMBIAN((_L("EapSimDbUtils::DeleteConfigurationL(): All rows deleted.\n")));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	822	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	823	else
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	824	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	825	EAP_TRACE_DEBUG_SYMBIAN((_L("EapSimDbUtils::DeleteConfigurationL(): No rows to delete.\n")));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	826	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	827
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	828	CleanupStack::PopAndDestroy(&view);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	829	CleanupStack::PopAndDestroy(buf);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	830	CleanupStack::PopAndDestroy(&aDatabase);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	831	CleanupStack::PopAndDestroy(&aFileServerSession);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	832	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	833
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	834	// ----------------------------------------------------------
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	835
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	836	// End of file

author	Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
	Tue, 31 Aug 2010 15:16:37 +0300
branch	RCL_3
changeset 18	bad0cc58d154
parent 2	1c7bc153c08e
child 19	c74b3d9f6b9e
permissions	-rw-r--r--