--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/commsconfig/commsdatabaseshim/TE_commdb/src/Step_023_xx.cpp	Mon Sep 06 13:49:23 2010 +0100
@@ -0,0 +1,292 @@
+// step_023_XX.cpp
+//
+//
+// Copyright (c) 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 023.XX
+
+// EPOC includes
+#include <e32base.h>
+#include <commdb.h>
+#include <d32comm.h>
+
+// Test system includes
+#include "Teststepcommdb.h"
+#include "Step_023_xx.h"
+
+
+/////////////////////
+//	Test step 023.01
+/////////////////////
+
+// constructor
+CCommDbTest023_01::CCommDbTest023_01()
+	{
+	// store the name of this test case
+	SetTestStepName(_L("step_023_01"));
+	}
+
+// destructor
+CCommDbTest023_01::~CCommDbTest023_01()
+	{
+	}
+
+
+TVerdict CCommDbTest023_01::doTestStepPreambleL()
+	{	
+	// Have a temp copy of database
+	openDbL();
+        SetTestStepResult(EPass);	return TestStepResult();
+	}
+
+TInt CCommDbTest023_01::executeStepL()
+	{
+	TInt ret=KErrGeneral;
+
+	iTheView = iTheDb->OpenViewOnProxyRecordLC(1, TPtrC(DIAL_OUT_ISP) );
+	CleanupStack::Pop();
+	TUint32 value;
+
+	//Check the view contains the expected records
+	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone);
+	iTheView->ReadUintL(TPtrC(PROXY_ISP), value);
+
+	CDBLEAVE( iTheView->GotoNextRecord(), KErrNotFound );
+
+	ret = KErrNone;
+	
+	return ret;
+	}
+
+
+TVerdict CCommDbTest023_01::doTestStepL( )
+	{
+	INFO_PRINTF1(_L("Step 023.01 called "));
+
+
+	if ( executeStepL() == KErrNone )
+		SetTestStepResult(EPass);	else
+		SetTestStepResult(EFail);
+	return TestStepResult();
+	}
+
+
+
+/////////////////////
+//	Test step 023.02
+/////////////////////
+
+// constructor
+CCommDbTest023_02::CCommDbTest023_02()
+	{
+	// store the name of this test case
+	SetTestStepName(_L("step_023_02"));
+	}
+
+// destructor
+CCommDbTest023_02::~CCommDbTest023_02()
+	{
+	}
+
+
+TVerdict CCommDbTest023_02::doTestStepPreambleL()
+	{	
+	openDbL();
+        SetTestStepResult(EPass);	return TestStepResult();
+	}
+
+TInt CCommDbTest023_02::executeStepL()
+	{
+	TInt ret=KErrGeneral;
+
+	iTheView = iTheDb->OpenViewOnProxyRecordLC(99, TPtrC(DIAL_OUT_ISP) );
+	CleanupStack::Pop();
+
+	//The view should be empty
+	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNotFound);
+
+	ret = KErrNone;
+	
+	return ret;
+	}
+
+
+TVerdict CCommDbTest023_02::doTestStepL( )
+	{
+	INFO_PRINTF1(_L("Step 023.02 called "));
+
+
+	if ( executeStepL() == KErrNone )
+		SetTestStepResult(EPass);	else
+		SetTestStepResult(EFail);
+	return TestStepResult();
+	}
+
+
+/////////////////////
+//	Test step 023.03
+/////////////////////
+
+// constructor
+CCommDbTest023_03::CCommDbTest023_03()
+	{
+	// store the name of this test case
+	SetTestStepName(_L("step_023_03"));
+	}
+
+// destructor
+CCommDbTest023_03::~CCommDbTest023_03()
+	{
+	}
+
+
+TVerdict CCommDbTest023_03::doTestStepPreambleL()
+	{	
+	openDbL();
+        SetTestStepResult(EPass);	return TestStepResult();
+	}
+
+
+#define INVALID_TABLE	_L("Invalid")
+
+TInt CCommDbTest023_03::executeStepL()
+	{
+	TInt ret=KErrGeneral;
+
+
+	iTheView = iTheDb->OpenViewOnProxyRecordLC(1, TPtrC(INVALID_TABLE) );
+	CleanupStack::Pop();
+	
+	//It should be an empty view
+	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNotFound );
+
+	ret = KErrNone;
+
+	return ret;
+	}
+
+
+TVerdict CCommDbTest023_03::doTestStepL( )
+	{
+	INFO_PRINTF1(_L("Step 023.03 called "));
+
+
+	if ( executeStepL() == KErrNone )
+		SetTestStepResult(EPass);	else
+		SetTestStepResult(EFail);
+	return TestStepResult();
+	}
+
+
+
+/////////////////////
+//	Test step 023.04
+/////////////////////
+
+// constructor
+CCommDbTest023_04::CCommDbTest023_04()
+	{
+	// store the name of this test case
+	SetTestStepName(_L("step_023_04"));
+	}
+
+// destructor
+CCommDbTest023_04::~CCommDbTest023_04()
+	{
+	}
+
+TVerdict CCommDbTest023_04::doTestStepL( )
+	{
+	INFO_PRINTF1(_L("Step 023.04 called "));
+
+	SetTestStepResult(EPass);
+		// Heap test for 023.01
+
+	CCommDbTest023_01* step023_01 = new(ELeave) CCommDbTest023_01;
+	CleanupStack::PushL(step023_01);
+	if ( doTestStepWithHeapFailureL( *step023_01, KErrNone) == EFail )
+		SetTestStepResult(EFail);	CleanupStack::PopAndDestroy(step023_01);
+
+
+	return TestStepResult();	
+
+}
+
+
+/////////////////////
+//	Test step 023.05
+/////////////////////
+
+// constructor
+CCommDbTest023_05::CCommDbTest023_05()
+	{
+	// store the name of this test case
+	SetTestStepName(_L("step_023_05"));
+	}
+
+// destructor
+CCommDbTest023_05::~CCommDbTest023_05()
+	{
+	}
+
+TVerdict CCommDbTest023_05::doTestStepL( )
+	{
+	INFO_PRINTF1(_L("Step 023.05 called "));
+
+	SetTestStepResult(EPass);	
+			// Heap test for 023.02
+
+	CCommDbTest023_02* step023_02 = new CCommDbTest023_02;
+	CleanupStack::PushL(step023_02);
+	if ( doTestStepWithHeapFailureL( *step023_02, KErrNone) == EFail ) 
+		SetTestStepResult(EFail);	CleanupStack::PopAndDestroy(step023_02);
+	
+	return TestStepResult();
+	}
+	
+/////////////////////
+//	Test step 023.06
+/////////////////////
+
+// constructor
+CCommDbTest023_06::CCommDbTest023_06()
+	{
+	// store the name of this test case
+	SetTestStepName(_L("step_023_06"));
+	}
+
+// destructor
+CCommDbTest023_06::~CCommDbTest023_06()
+	{
+	}
+
+TVerdict CCommDbTest023_06::doTestStepL( )
+	{
+	INFO_PRINTF1(_L("Step 023.06 called "));
+
+	SetTestStepResult(EPass);	
+		// Heap test for 023.03
+
+	CCommDbTest023_03* step023_03 = new CCommDbTest023_03;
+	CleanupStack::PushL(step023_03);
+	if ( doTestStepWithHeapFailureL( *step023_03, KErrNone) == EFail )
+		SetTestStepResult(EFail);	CleanupStack::PopAndDestroy(step023_03);
+	
+	return TestStepResult();
+	}
+
+//EOF