--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/commsconfig/commsdatabaseshim/ts_commdb/Step_062_xx.cpp	Thu Dec 17 09:22:25 2009 +0200
@@ -0,0 +1,335 @@
+// Copyright (c) 2001-2009 Nokia Corporation and/or its subsidiary(-ies).
+// All rights reserved.
+// This component and the accompanying materials are made available
+// under the terms of "Eclipse Public License v1.0"
+// which accompanies this distribution, and is available
+// at the URL "http://www.eclipse.org/legal/epl-v10.html".
+//
+// Initial Contributors:
+// Nokia Corporation - initial contribution.
+//
+// Contributors:
+//
+// Description:
+// This contains CommDb Unit Test Cases 062.XX
+// 
+//
+
+// EPOC includes
+#include <e32base.h>
+#include <commdb.h>
+#include <d32comm.h>
+#include <cdbtemp.h>
+#include <cdbover.h>
+
+
+// Test system includes
+#include <networking/log.h>
+#include <networking/teststep.h>
+#include "Teststepcommdb.h"
+#include "TestSuiteCommdb.h"
+#include "Step_062_xx.h"
+
+//
+//	Test step 062.01
+//
+
+// constructor
+CCommDbTest062_01::CCommDbTest062_01()
+	{
+	// store the name of this test case
+	iTestStepName = _L("step_062_01");
+	}
+
+// destructor
+CCommDbTest062_01::~CCommDbTest062_01()
+	{
+	}
+
+TVerdict CCommDbTest062_01::doTestStepPreambleL()
+	{	
+	openDbAndViewL(_L("Modem"));
+	return EPass;
+	}
+
+TInt CCommDbTest062_01::executeStepL()
+	{
+	TInt ret=KErrGeneral;
+	TUint32 id;
+
+	
+	//Insert a new record, 
+
+	CDBLEAVE( iTheView->InsertRecord( id ), KErrNone );
+	
+	_LIT(KModem,"US Robotics Sportster");
+	_LIT(KTsy,"HAYES");
+	_LIT8(KModemInitString,"AT&F1");
+	_LIT8(KModemFaxInitString,"AT&d2");
+	//Write some sample data into the table
+	iTheView->WriteTextL(TPtrC(COMMDB_NAME),KModem);
+	iTheView->WriteTextL(TPtrC(MODEM_NIF_NAME),_L("PPP"));
+	iTheView->WriteTextL(TPtrC(MODEM_TSY_NAME),KTsy);
+	iTheView->WriteUintL(TPtrC(MODEM_RATE),(TUint32)EBps57600);
+	iTheView->WriteUintL(TPtrC(MODEM_DATA_BITS),(TUint32)EData8);
+	iTheView->WriteUintL(TPtrC(MODEM_STOP_BITS),(TUint32)EStop1);
+	iTheView->WriteUintL(TPtrC(MODEM_PARITY),(TUint32)EParityNone);
+	iTheView->WriteUintL(TPtrC(MODEM_HANDSHAKING),(TUint32)(KConfigObeyCTS|KConfigObeyDSR|KConfigFailDSR|KConfigObeyDCD|KConfigFailDCD));	//KConfigObeyCTS;
+	iTheView->WriteUintL(TPtrC(MODEM_SPECIAL_RATE),(TUint32)0);
+	iTheView->WriteUintL(TPtrC(MODEM_XON_CHAR),(TUint32)0);
+	iTheView->WriteUintL(TPtrC(MODEM_XOFF_CHAR),(TUint32)0);
+	iTheView->WriteTextL(TPtrC(MODEM_MODEM_INIT_STRING),KModemInitString);
+	iTheView->WriteTextL(TPtrC(MODEM_DATA_INIT_STRING),KNullDesC8);
+	iTheView->WriteTextL(TPtrC(MODEM_FAX_INIT_STRING),KModemFaxInitString);
+	iTheView->WriteUintL(TPtrC(MODEM_SPEAKER_PREF),(TUint32)EModemSpeakerSettingAfterDialUntilAnswer);
+	iTheView->WriteUintL(TPtrC(MODEM_SPEAKER_VOL_PREF),(TUint32)EModemSpeakerVolumeQuiet);
+
+	//Insert the record and destroy the view
+	CDBLEAVE( iTheView->PutRecordChanges(), KErrNone );
+	
+	delete iTheView;
+	iTheView = 0;
+
+	//Open a view and make a change to the record just written
+	iTheView = iTheDb->OpenViewMatchingTextLC( _L("Modem"), TPtrC(COMMDB_NAME), KModem);
+	CleanupStack::Pop();
+
+	CDBLEAVE( ret = iTheView->GotoFirstRecord(), KErrNone );
+	CDBLEAVE( iTheView->UpdateRecord(), KErrNone );
+	_LIT(KModem2,"Another US Robotics Sportster");
+	iTheView->WriteTextL(TPtrC(COMMDB_NAME), KModem2 );
+	
+	//Cancel the changes made and destroy the view
+	iTheView->CancelRecordChanges();
+
+	delete iTheView;
+	iTheView = 0;
+
+	//Open a view to check that the record was not modified
+	iTheView = iTheDb->OpenViewMatchingTextLC( _L("Modem"), TPtrC(COMMDB_NAME), KModem);
+	CleanupStack::Pop();
+
+	CDBLEAVE( ret = iTheView->GotoFirstRecord(), KErrNone );
+
+	return ret;
+	}
+
+
+
+TVerdict CCommDbTest062_01::doTestStepL( )
+	{
+	Log(_L("Step 062.01 called "));
+
+	if ( executeStepL() == KErrNone )
+		iTestStepResult = EPass;
+	else
+		iTestStepResult = EFail;
+
+	return iTestStepResult;
+	}
+
+
+
+//
+//	Test step 062.02
+//
+
+// constructor
+CCommDbTest062_02::CCommDbTest062_02()
+	{
+	// store the name of this test case
+	iTestStepName = _L("step_062_02");
+	}
+
+// destructor
+CCommDbTest062_02::~CCommDbTest062_02()
+	{
+	}
+
+TVerdict CCommDbTest062_02::doTestStepPreambleL()
+	{	
+	openDbL();
+//	TInt ret = copyTestDatabase( EDatabase_1 );
+//	if(ret != KErrNone) // can't check this at the moment because copyTestDatabase returns 
+//	   User::Leave(ret);// KErrGeneral when it passes!!
+	return EPass;
+	}
+
+
+
+TInt CCommDbTest062_02::executeStepL()
+	{
+	TInt ret=KErrGeneral;
+	CCommsDbTableView* table = NULL;
+
+	// Not much to this - in fact it's the specific case raised in the defect report
+	// INC027976 which describes the BC break due to chenging the name of the Modem table 
+	// to ModemBearer
+	
+	__UHEAP_MARK;
+	table = iTheDb->OpenViewLC(_L("Modem"),_L("select * from Modem where Hidden=0")); 
+	CleanupStack::Pop();
+
+	if(table != NULL)
+	{
+		ret = KErrNone;
+		delete table;
+		table = 0;
+	}
+
+	__UHEAP_MARKEND;
+	return ret;
+	}
+
+
+
+TVerdict CCommDbTest062_02::doTestStepL( )
+	{
+	Log(_L("Step 062.02 called "));
+
+	TRAPD(ret, executeStepL());
+	if( ret == KErrNotSupported )
+		iTestStepResult = EPass;
+	else
+		iTestStepResult = EFail;
+
+	return iTestStepResult;
+	}
+
+// Test step 03 is the same as 37_01, except that the literal string 'Modem'
+// is used to verify that template handling is BC.
+
+
+
+CCommDbTest062_03::CCommDbTest062_03()
+	{
+	// store the name of this test case
+	iTestStepName = _L("step_062_03");
+	}
+
+CCommDbTest062_03::~CCommDbTest062_03()
+	{}
+
+TVerdict CCommDbTest062_03::doTestStepL( void )
+	{
+	if(executeStepL()!=KErrNone)
+		return EFail;
+	return EPass;
+	}
+
+TVerdict CCommDbTest062_03::doTestStepPreambleL()
+	{
+	iTheDb=CCommsDatabase::NewL();
+
+	return EPass;
+	}
+
+TInt CCommDbTest062_03::executeStepL()
+	{
+	//alter something in the template
+	CCommsDbTemplateRecord* templateRecord = CCommsDbTemplateRecord::NewL(iTheDb, _L("Modem"));
+	CleanupStack::PushL(templateRecord);
+	
+	User::LeaveIfError(templateRecord->Modify());
+	templateRecord->WriteTextL(TPtrC(COMMDB_NAME), _L("DummyName"));
+	TBufC8<KCommsDbSvrMaxFieldLength> firstInputString = _L8("first string");
+
+	templateRecord->WriteTextL(TPtrC(MODEM_FAX_INIT_STRING), firstInputString);
+	User::LeaveIfError(templateRecord->StoreModifications());
+	//Now start to overwrite initial change, but don't commit, cancel instead.
+	User::LeaveIfError(templateRecord->Modify());
+
+	TBufC8<KCommsDbSvrMaxFieldLength> secondInputString = _L8("second string");
+	templateRecord->WriteTextL(TPtrC(MODEM_FAX_INIT_STRING), secondInputString);
+	templateRecord->CancelModifications();
+
+	TBuf8<KCommsDbSvrMaxFieldLength> retrievedString;
+	templateRecord->ReadTextL(TPtrC(MODEM_FAX_INIT_STRING), retrievedString);
+	CleanupStack::PopAndDestroy(templateRecord);
+
+	if(retrievedString!=firstInputString)
+		return KErrGeneral;
+	
+	return KErrNone;
+	}
+	
+TVerdict CCommDbTest062_03::doTestStepPostambleL()
+	{
+	delete iTheDb;
+	iTheDb=NULL;
+	return EPass;
+	}
+
+// Test steps 04 & 05 are the same as 41_13 & 41_14, except that the literal string
+// 'Modem' is used to access the table to verify that the override handling is BC.
+//
+
+CCommDbTest062_04::CCommDbTest062_04()
+	{
+	// store the name of this test case
+	iTestStepName = _L("step_062_04");
+	}
+
+CCommDbTest062_04::~CCommDbTest062_04()
+	{}
+
+TVerdict CCommDbTest062_04::doTestStepL( void )
+	{
+	if(executeStepL()!=KErrNone)
+		return EFail;
+	return EPass;
+	}
+
+TVerdict CCommDbTest062_04::doTestStepPreambleL()
+	{
+	return EPass;
+	}
+
+TInt CCommDbTest062_04::executeStepL()
+	{
+	iOverSet=CCommDbOverrideSettings::NewL(CCommDbOverrideSettings::EParamListPartial);
+	TBuf<KCommsDbSvrMaxFieldLength> temp(_L("There's no place like home"));
+	return iOverSet->SetDesOverride(_L("Modem"), TPtrC(MODEM_TSY_NAME), temp);
+	}
+
+TVerdict CCommDbTest062_04::doTestStepPostambleL()
+	{
+	delete iOverSet;
+	return EPass;
+	}
+
+//
+
+CCommDbTest062_05::CCommDbTest062_05()
+	{
+	// store the name of this test case
+	iTestStepName = _L("step_062_05");
+	}
+
+CCommDbTest062_05::~CCommDbTest062_05()
+	{}
+
+TVerdict CCommDbTest062_05::doTestStepL( void )
+	{
+	if(executeStepL()!=KErrNotSupported)
+		return EFail;
+	return EPass;
+	}
+
+TVerdict CCommDbTest062_05::doTestStepPreambleL()
+	{
+	return EPass;
+	}
+
+TInt CCommDbTest062_05::executeStepL()
+	{
+	iOverSet=CCommDbOverrideSettings::NewL(CCommDbOverrideSettings::EParamListPartial);
+	
+	return iOverSet->SetIntOverride(_L("Modem"), TPtrC(MODEM_STOP_BITS), 10);
+	}
+
+TVerdict CCommDbTest062_05::doTestStepPostambleL()
+	{
+	delete iOverSet;
+	return EPass;
+	}