// 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;
	}