// 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 018.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_018_xx.h"

//

//	Test step 018.01

//

// constructor

CCommDbTest018_01::CCommDbTest018_01()

	{

	// store the name of this test case

	iTestStepName = _L("step_018_01");

	}

// destructor

CCommDbTest018_01::~CCommDbTest018_01()

	{

	}

TVerdict CCommDbTest018_01::doTestStepPreambleL()

	{	

	openDbAndViewL(TPtrC(DIAL_OUT_ISP));

	return EPass;

	}

TInt CCommDbTest018_01::executeStepL()

	{

	TInt ret=KErrNone;

	//Verify DeleteRecord() by deleting the records in the Dial out ISP

	//table and then checking for their lack of existance

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

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

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

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

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

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

	//The table will now be empty

	delete iTheView;

	iTheView = 0;

	iTheView = iTheDb->OpenTableLC(TPtrC(DIAL_OUT_ISP ) );

	CleanupStack::Pop();

	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNotFound );

	return ret;

	}

TVerdict CCommDbTest018_01::doTestStepL( )

	{

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

	if ( executeStepL() == KErrNone )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 018.02

//

// constructor

CCommDbTest018_02::CCommDbTest018_02()

	{

	// store the name of this test case

	iTestStepName = _L("step_018_02");

	}

// destructor

CCommDbTest018_02::~CCommDbTest018_02()

	{

	}

TVerdict CCommDbTest018_02::doTestStepPreambleL()

	{	

	copyTestDatabase( EDatabase_1 );

	openDbAndViewL(TPtrC(DIAL_OUT_ISP));

	return EPass;

	}

TInt CCommDbTest018_02::executeStepL()

	{

	TInt ret=KErrNone;

	//Try to delete the last record in a view and then 

	//verify its deletion

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

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

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

	//The DAIL_OUT_ISP table only has 3 records, so we know

	//we are at the end.

	//Delete the last record

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

	//The table should now only have 2 records

	delete iTheView;

	iTheView = 0;

	iTheView = iTheDb->OpenTableLC(TPtrC(DIAL_OUT_ISP ) );

	CleanupStack::Pop();

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

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

	CDBLEAVE( iTheView->GotoNextRecord(), KErrNotFound ); //no more records

	return ret;

	}

TVerdict CCommDbTest018_02::doTestStepL( )

	{

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

	if ( executeStepL() == KErrNone )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 018.03

//

// constructor

CCommDbTest018_03::CCommDbTest018_03()

	{

	// store the name of this test case

	iTestStepName = _L("step_018_03");

	}

// destructor

CCommDbTest018_03::~CCommDbTest018_03()

	{

	}

TVerdict CCommDbTest018_03::doTestStepPreambleL()

	{	

	openDbAndViewL(TPtrC(IAP));

	return EPass;

	}

TInt CCommDbTest018_03::executeStepL()

	{

	TInt ret=KErrNone;

	//Delete record in empty view

	CDBLEAVE( iTheView->DeleteRecord(), KErrNotFound );	

	return ret;

	}

TVerdict CCommDbTest018_03::doTestStepL( )

	{

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

	if ( executeStepL() == KErrNone )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 018.04

//

// constructor

CCommDbTest018_04::CCommDbTest018_04()

	{

	// store the name of this test case

	iTestStepName = _L("step_018_04");

	}

// destructor

CCommDbTest018_04::~CCommDbTest018_04()

	{

	}

TVerdict CCommDbTest018_04::doTestStepPreambleL()

	{	

	openDbAndViewL(TPtrC(DIAL_IN_ISP));

	return EPass;

	}

TInt CCommDbTest018_04::executeStepL()

	{

	TInt ret=KErrNone;

	//Delete a read only record 

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

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

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

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

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

	//Delete the read only record #5

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

	//Open a new view and check that we've only 4 records left

	delete iTheView;

	iTheView = 0;

	iTheView = iTheDb->OpenTableLC(TPtrC(DIAL_IN_ISP ) );

	CleanupStack::Pop();

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

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

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

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

	CDBLEAVE( iTheView->GotoNextRecord(), KErrNotFound ); //no more records

	return ret;

	}

TVerdict CCommDbTest018_04::doTestStepL( )

	{

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

	if ( executeStepL() == KErrNone )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 018.05

//

// constructor

CCommDbTest018_05::CCommDbTest018_05()

	{

	// store the name of this test case

	iTestStepName = _L("step_018_05");

	}

// destructor

CCommDbTest018_05::~CCommDbTest018_05()

	{

	}

TVerdict CCommDbTest018_05::doTestStepL( )

	{

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

	iTestStepResult = EPass;

		// Heap test for 018.01

	CCommDbTest018_01* step018_01 = new(ELeave) CCommDbTest018_01;

	CleanupStack::PushL(step018_01);

	step018_01->iSuite = iSuite;

	if ( doTestStepWithHeapFailureL( *step018_01, KErrNone) == EFail )

		iTestStepResult = EFail;

	CleanupStack::PopAndDestroy(step018_01);

	return iTestStepResult;	

}

//

//	Test step 018.06

//

// constructor

CCommDbTest018_06::CCommDbTest018_06()

	{

	// store the name of this test case

	iTestStepName = _L("step_018_06");

	}

// destructor

CCommDbTest018_06::~CCommDbTest018_06()

	{

	}

TVerdict CCommDbTest018_06::doTestStepL( )

	{

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

	iTestStepResult = EPass;

			// Heap test for 018.02

	CCommDbTest018_02* step018_02 = new CCommDbTest018_02;

	CleanupStack::PushL(step018_02);

	step018_02->iSuite = iSuite;

	if ( doTestStepWithHeapFailureL( *step018_02, KErrNone) == EFail )

		iTestStepResult = EFail;

	CleanupStack::PopAndDestroy(step018_02);

	return iTestStepResult;		

	}

//

//	Test step 018.07

//

// constructor

CCommDbTest018_07::CCommDbTest018_07()

	{

	// store the name of this test case

	iTestStepName = _L("step_018_07");

	}

// destructor

CCommDbTest018_07::~CCommDbTest018_07()

	{

	}

TVerdict CCommDbTest018_07::doTestStepL( )

	{

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

	iTestStepResult = EPass;

		// Heap test for 018.03

	CCommDbTest018_03* step018_03 = new CCommDbTest018_03;

	CleanupStack::PushL(step018_03);

	step018_03->iSuite = iSuite;

	if ( doTestStepWithHeapFailureL( *step018_03, KErrNone) == EFail )

		iTestStepResult = EFail;

	CleanupStack::PopAndDestroy(step018_03);

	return iTestStepResult;		

	}

//

//	Test step 018.08

//

// constructor

CCommDbTest018_08::CCommDbTest018_08()

	{

	// store the name of this test case

	iTestStepName = _L("step_018_08");

	}

// destructor

CCommDbTest018_08::~CCommDbTest018_08()

	{

	}

TVerdict CCommDbTest018_08::doTestStepL( )

	{

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

	iTestStepResult = EPass;

		// Heap test for 018.04

	CCommDbTest018_04* step018_04 = new CCommDbTest018_04;

	CleanupStack::PushL(step018_04);

	step018_04->iSuite = iSuite;

	if ( doTestStepWithHeapFailureL( *step018_04, KErrNone) == EFail )

		iTestStepResult = EFail;

	CleanupStack::PopAndDestroy(step018_04);

	return iTestStepResult;		

	}

//EOF