// 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 015.XX

// 

//

// EPOC includes

#include <e32base.h>

#include <commdb.h>

#include <d32comm.h>

// Test system includes

#include <networking/log.h>

#include <networking/teststep.h>

#include "Teststepcommdb.h"

#include "TestSuiteCommdb.h"

#include "Step_015_xx.h"

//

//	Test step 015.01

//

// constructor

CCommDbTest015_01::CCommDbTest015_01()

	{

	// store the name of this test case

	iTestStepName = _L("step_015_01");

	}

// destructor

CCommDbTest015_01::~CCommDbTest015_01()

	{

	}

TVerdict CCommDbTest015_01::doTestStepPreambleL()

	{	

	openDbL();

	return EPass;

	}

TInt CCommDbTest015_01::executeStepL()

	{

	TInt ret=KErrGeneral;

	//Check the inTransaction flag

	TRAPD(r, iTheDb->BeginTransaction() );

	ret  = !(iTheDb->InTransaction() );

	if ( r != KErrNone )

		{

		ret = r;

		}

	return ret;

	}

TVerdict CCommDbTest015_01::doTestStepL( )

	{

	Log(_L("Step 015.01 called "));

	if ( executeStepL() == KErrNone )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 015.02

//

// constructor

CCommDbTest015_02::CCommDbTest015_02()

	{

	// store the name of this test case

	iTestStepName = _L("step_015_02");

	}

// destructor

CCommDbTest015_02::~CCommDbTest015_02()

	{

	}

TVerdict CCommDbTest015_02::doTestStepPreambleL()

	{	

	openDbAndViewL(TPtrC(MODEM_BEARER));

	return EPass;

	}

TInt CCommDbTest015_02::executeStepL()

	{

	TInt ret=KErrGeneral;

	TUint32 id;

	TBool beforeValue=EFalse, afterValue=EFalse;

	//Check that the write lock flag is set when the

	//database is written to.

	//Take a copy of the flag before we insert a record

	TRAPD(r, beforeValue = iTheDb->IsDatabaseWriteLockedL() );

	CDBLEAVE( iTheDb->BeginTransaction(), KErrNone );

	CDBLEAVE( iTheView->InsertRecord( id ), KErrNone );

	//Take a copy after the insert

	afterValue = iTheDb->IsDatabaseWriteLockedL();

	iTheView->CancelRecordChanges();

	//Now get the flag value after the record has been written

	if ( r == KErrNone )

		{

		if ( !beforeValue  && afterValue  )

			ret = KErrNone;

		}

		else

		{	

			//return the trap value

			ret = r;

		}

	return ret;

	}

TVerdict CCommDbTest015_02::doTestStepL( )

	{

	Log(_L("Step 015.02 called "));

	if ( executeStepL() == KErrNone )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 015.03

//

// constructor

CCommDbTest015_03::CCommDbTest015_03()

	{

	// store the name of this test case

	iTestStepName = _L("step_015_03");

	// default to no local objects allocated

	}

// destructor

CCommDbTest015_03::~CCommDbTest015_03()

	{

	}

TVerdict CCommDbTest015_03::doTestStepPreambleL()

	{	

	openDbAndViewL(TPtrC(MODEM_BEARER));

	return EPass;

	}

TInt CCommDbTest015_03::executeStepL()

	{

	TUint32 id;

	//Commit a record and check for correct state of flags

	CDBLEAVE( iTheDb->BeginTransaction(), KErrNone );

	CDBLEAVE( iTheView->InsertRecord( id ), KErrNone );

	_LIT(KName,"CCommDbTest015_03");

	_LIT(KTsy,"HAYES");

	_LIT8(KModemInitString,"AT&F1");

	_LIT8(KModemFaxInitString,"AT&d2");

	//Write some sample data into the table

	iTheView->WriteTextL(TPtrC(COMMDB_NAME),KName);

	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);

	CDBLEAVE ( iTheView->PutRecordChanges(), KErrNone );

	User::LeaveIfError(iTheDb->CommitTransaction());

	delete iTheView;

	iTheView=NULL;

	//Create a new view that should have the record in it

	iTheView = iTheDb->OpenViewMatchingTextLC( TPtrC(MODEM_BEARER), TPtrC(COMMDB_NAME), KName);

	CleanupStack::Pop();

	User::LeaveIfError(iTheView->GotoFirstRecord());	//Will leave if first record isn't there

	if (! iTheDb->IsDatabaseWriteLockedL() && ! iTheDb->InTransaction() )

			return KErrNone;

	return KErrGeneral;

	}

TVerdict CCommDbTest015_03::doTestStepL( )

	{

	Log(_L("Step 015.03 called "));

	if ( executeStepL() == KErrNone )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 015.04

//

// constructor

CCommDbTest015_04::CCommDbTest015_04()

	{

	// store the name of this test case

	iTestStepName = _L("step_015_04");

	// default to no local objects allocated

	}

// destructor

CCommDbTest015_04::~CCommDbTest015_04()

	{

	}

TVerdict CCommDbTest015_04::doTestStepPreambleL()

	{	

	openDbAndViewL(TPtrC(MODEM_BEARER));

	return EPass;

	}

TInt CCommDbTest015_04::executeStepL()

	{

	TInt ret=KErrGeneral;

	TUint32 id;

	//Check that we can rollback a transaction

	//NB Test assumes that the table is empty

	CDBLEAVE( iTheDb->BeginTransaction(), KErrNone );

	CDBLEAVE( iTheView->InsertRecord( id ), KErrNone );

	_LIT(KName,"CCommDbTest015_04");

	_LIT(KTsy,"HAYES");

	_LIT8(KModemInitString,"AT&F1");

	_LIT8(KModemFaxInitString,"AT&d2");

	//Write some sample data into the table

	iTheView->WriteTextL(TPtrC(COMMDB_NAME),KName);

	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);

	CDBLEAVE( iTheView->PutRecordChanges(), KErrNone );

	//Rollback the record we've just written

	TRAPD(r, iTheDb->RollbackTransaction() );

	//Get rid of our view

	delete iTheView;

	iTheView=0;

	//Create a new view that should have the record in it

	iTheView = iTheDb->OpenViewMatchingTextLC( TPtrC(MODEM_BEARER), TPtrC(COMMDB_NAME), KName);

	CleanupStack::Pop();

	ret = iTheView->GotoFirstRecord();

	if ( r == KErrNone )

		{

		if ( ret == KErrNotFound )

			ret = KErrNone;

		else

			ret = KErrGeneral;

		}

	else

		{	

		//Trap occoured, so return that value instead

		ret = r;

		}

	return ret;

	}

TVerdict CCommDbTest015_04::doTestStepPostambleL()

	{

	//Get rid of our view

	if(iTheView)

		{

		delete iTheView;

		}

	iTheView=0;

	_LIT(KName,"CCommDbTest015_04");

	//Create a new view that should have the record that was added in executeStepL and

	// may have been left in by a leave condition

	iTheView = iTheDb->OpenViewMatchingTextLC( TPtrC(MODEM_BEARER), TPtrC(COMMDB_NAME), KName);

	CleanupStack::Pop();

	if(iTheView->GotoFirstRecord() == KErrNone)

		{

		iTheView->DeleteRecord();

		}

	// Cleanup after test run

	CTestStepCommDb::doTestStepPostambleL();	

	return EPass;

	}

TVerdict CCommDbTest015_04::doTestStepL( )

	{

	Log(_L("Step 015.04 called "));

	if ( executeStepL() == KErrNone )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 015.05

//

// constructor

CCommDbTest015_05::CCommDbTest015_05()

	{

	// store the name of this test case

	iTestStepName = _L("step_015_05");

	}

// destructor

CCommDbTest015_05::~CCommDbTest015_05()

	{

	}

TVerdict CCommDbTest015_05::doTestStepPreambleL()

	{	

	openDbAndViewL(TPtrC(MODEM_BEARER));

	return EPass;

	}

TInt CCommDbTest015_05::executeStepL()

	{

	TInt ret=KErrGeneral;

	TUint32 id;

	//Try to rollback without a prior call to BeginTransaction()

	//

	// NB. This test will cause the DBMS server to Panic!

	//

	CDBLEAVE( iTheView->InsertRecord( id ), KErrNone );

	_LIT(KName,"CCommDbTest015_05");

	_LIT(KTsy,"HAYES");

	_LIT8(KModemInitString,"AT&F1");

	_LIT8(KModemFaxInitString,"AT&d2");

	//Write some sample data into the table

	iTheView->WriteTextL(TPtrC(COMMDB_NAME),KName);

	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);

	CDBLEAVE( iTheView->PutRecordChanges(), KErrNone );

	TRAPD(r, iTheDb->RollbackTransaction() );

	delete iTheView ;

	iTheView=0;

	//Create a new view that would have the record in it

	iTheView = iTheDb->OpenViewLC(TPtrC(MODEM_BEARER), _L("Select * from Modem where Name='CCommDbTest015_05'") );

	CleanupStack::Pop();

	ret = iTheView->GotoFirstRecord();

	if ( r == KErrNone )

		{

		if ( ret == KErrNotFound  )

			ret = KErrNone;

		else

			ret = KErrGeneral;

		}

	else

		{	

		//Trap occoured, so return that value instead

		ret = r;

		}

	return ret;

	}

TVerdict CCommDbTest015_05::doTestStepPostambleL()

	{

	//Get rid of our view

	if(iTheView)

		{

		delete iTheView;

		}

	iTheView=0;

	_LIT(KName,"CCommDbTest015_05");

	//Create a new view that should have the record that was added in executeStepL and

	// may have been left in by a leave condition

	iTheView = iTheDb->OpenViewMatchingTextLC( TPtrC(MODEM_BEARER), TPtrC(COMMDB_NAME), KName);

	CleanupStack::Pop();

	if(iTheView->GotoFirstRecord() == KErrNone)

		{

		iTheView->DeleteRecord();

		}

	// Cleanup after test run

	CTestStepCommDb::doTestStepPostambleL();	

	return EPass;

	}

TVerdict CCommDbTest015_05::doTestStepL( )

	{

	//Log(_L("Step 015.05 called "));

	TRAPD(leaveCode, executeStepL());

	if (leaveCode != KErrNotSupported) // SQL views no longer supported

		{

		iTestStepResult = EFail;

		}

	return iTestStepResult;

	}

//

//	Test step 015.06

//

// constructor

CCommDbTest015_06::CCommDbTest015_06()

	{

	// store the name of this test case