--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/commsconfig/commsdatabaseshim/TE_commdb/src/Step_012_xx.cpp	Mon Sep 06 13:49:23 2010 +0100
@@ -0,0 +1,505 @@
+//
+// 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 012.XX
+
+// EPOC includes
+#include <e32base.h>
+#include <commdb.h>
+
+
+// Test system includes
+#include "Teststepcommdb.h"
+#include "Step_012_xx.h"
+
+
+
+/////////////////////
+//	Test step 012.001
+/////////////////////
+
+// constructor
+CCommDbTest012_01::CCommDbTest012_01()
+	{
+	// store the name of this test case
+	SetTestStepName(_L("step_012_01"));
+	}
+
+// destructor
+CCommDbTest012_01::~CCommDbTest012_01()
+	{
+	}
+
+
+TVerdict CCommDbTest012_01::doTestStepPreambleL()
+	{	
+	openDbL();
+        SetTestStepResult(EPass);	return TestStepResult();
+	}
+
+
+TInt CCommDbTest012_01::executeStepL()
+	{
+	TInt ret=KErrNone;
+
+	//This query should select 3 records
+	iTheView = iTheDb->OpenViewLC( TPtrC(DIAL_IN_ISP),_L("select * from DialInISP where Ifname='PPP'") );
+	CleanupStack::Pop();
+
+	//Now check that the records are what we expect
+	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );
+
+	//Read the value from the field and compare it to the expected value
+	TBuf<KCommsDbSvrMaxFieldLength> value;
+	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
+	if( value.Compare(_L("Record #1")) )
+		{
+		ret = KErrGeneral;
+		}
+
+	CDBLEAVE( iTheView->GotoNextRecord(), KErrNone );
+	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
+	if( value.Compare(_L("Record #2")) )
+		{
+		ret = KErrGeneral;
+		}
+
+	CDBLEAVE( iTheView->GotoNextRecord(), KErrNone );
+	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
+	if( value.Compare(_L("Record #5 (Read Only)")) )
+		{
+		ret = KErrGeneral;
+		}
+
+	CDBLEAVE( ret = iTheView->GotoNextRecord(), KErrNotFound);
+
+	return ret;
+	}
+
+
+
+TVerdict CCommDbTest012_01::doTestStepL( )
+	{
+	INFO_PRINTF1(_L("Step 012.01 called "));
+
+	
+	if ( executeStepL() == KErrNotFound )
+		SetTestStepResult(EPass);	else
+		SetTestStepResult(EFail);
+
+	return TestStepResult();
+	}
+
+
+/////////////////////
+//	Test step 012.02
+/////////////////////
+
+// constructor
+CCommDbTest012_02::CCommDbTest012_02()
+	{
+	// store the name of this test case
+	SetTestStepName(_L("step_012_02"));
+
+	}
+
+// destructor
+CCommDbTest012_02::~CCommDbTest012_02()
+	{
+	}
+
+TVerdict CCommDbTest012_02::doTestStepPreambleL()
+	{	
+	openDbL();
+        SetTestStepResult(EPass);	return TestStepResult();
+	}
+
+
+TInt CCommDbTest012_02::executeStepL()
+	{
+	TInt ret=KErrNone;
+
+	//This query should select 0 records
+	iTheView = iTheDb->OpenViewLC( TPtrC(DIAL_IN_ISP),_L("select * from DialInISP where Ifname='XXX'") );
+	CleanupStack::Pop();
+
+	CDBLEAVE(ret = iTheView->GotoFirstRecord(), KErrNotFound );
+
+	return ret;
+	}
+
+
+
+TVerdict CCommDbTest012_02::doTestStepL( )
+	{
+	INFO_PRINTF1(_L("Step 012.02 called "));
+
+	if ( executeStepL() == KErrNotFound )
+		SetTestStepResult(EPass);	else
+		SetTestStepResult(EFail);
+	return TestStepResult();
+	}
+
+
+/////////////////////
+//	Test step 012.03
+/////////////////////
+
+// constructor
+CCommDbTest012_03::CCommDbTest012_03()
+	{
+	// store the name of this test case
+	SetTestStepName(_L("step_012_03"));
+
+	}
+
+// destructor
+CCommDbTest012_03::~CCommDbTest012_03()
+	{
+	}
+
+
+TVerdict CCommDbTest012_03::doTestStepPreambleL()
+	{	
+	openDbL();
+        SetTestStepResult(EPass);	return TestStepResult();
+	}
+
+TInt CCommDbTest012_03::executeStepL()
+	{
+	TInt ret=KErrNone;
+
+	//This query should select 1 record
+	iTheView = iTheDb->OpenViewLC( TPtrC(DIAL_IN_ISP),_L("select * from DialInISP where Name='Record #3'") );
+	CleanupStack::Pop();
+
+	//Read the value from the field and compare it to the expected value
+	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );
+	TBuf<KCommsDbSvrMaxFieldLength> value;
+	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
+	if( value.Compare(_L("Record #3")) )
+		{
+		ret = KErrGeneral;
+		}
+
+	//Check that there was only one record
+	CDBLEAVE( ret = iTheView->GotoNextRecord(), KErrNotFound );
+
+	return ret;
+	}
+
+
+
+TVerdict CCommDbTest012_03::doTestStepL( )
+	{
+	INFO_PRINTF1(_L("Step 012.03 called "));
+
+	if ( executeStepL() == KErrNotFound )
+		SetTestStepResult(EPass);	else
+		SetTestStepResult(EFail);	
+	return TestStepResult();
+	}
+
+
+/////////////////////
+//	Test step 012.04
+/////////////////////
+
+// constructor
+CCommDbTest012_04::CCommDbTest012_04()
+	{
+	// store the name of this test case
+	SetTestStepName(_L("step_012_04"));
+	// default to no local objects allocated
+	iLocalObjects = EFalse;
+	}
+
+// destructor
+CCommDbTest012_04::~CCommDbTest012_04()
+	{
+	}
+
+TVerdict CCommDbTest012_04::doTestStepPreambleL()
+	{	
+	openDbL();
+        SetTestStepResult(EPass);	return TestStepResult();
+	}
+
+
+TInt CCommDbTest012_04::executeStepL()
+	{
+	TInt ret=KErrNone;
+
+	//This query should select al1 records
+	iTheView = iTheDb->OpenViewLC( TPtrC(DIAL_IN_ISP),_L("select * from DialInISP") );
+	CleanupStack::Pop();
+
+	//For each expected record read the value from the field and compare it to the expected value
+	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );
+	TBuf<KCommsDbSvrMaxFieldLength> value;
+	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
+	if( value.Compare(_L("Record #1")) )
+		{
+		ret = KErrGeneral;
+		}
+
+	CDBLEAVE( iTheView->GotoNextRecord(), KErrNone );
+	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
+	if( value.Compare(_L("Record #2")) )
+		{
+		ret = KErrGeneral;
+		}
+
+	CDBLEAVE( iTheView->GotoNextRecord(), KErrNone );
+	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
+	if( value.Compare(_L("Record #3")) )
+		{
+		ret = KErrGeneral;
+		}
+
+	CDBLEAVE( iTheView->GotoNextRecord(), KErrNone );
+	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
+	if( value.Compare(_L("Record #4")) )
+		{
+		ret = KErrGeneral;
+		}
+
+	CDBLEAVE( iTheView->GotoNextRecord(), KErrNone );
+	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
+	if( value.Compare(_L("Record #5")) )
+		{
+		ret = KErrGeneral;
+		}
+	//Check there no more records
+
+	CDBLEAVE( ret = iTheView->GotoNextRecord(), KErrNotFound );
+		
+	return ret;
+	}
+
+
+
+TVerdict CCommDbTest012_04::doTestStepL( )
+	{
+	INFO_PRINTF1(_L("Step 012.04 called "));
+
+	if ( executeStepL() == KErrNotFound )
+		SetTestStepResult(EPass);	else
+		SetTestStepResult(EFail);
+
+	return TestStepResult();
+	}
+
+
+/////////////////////
+//	Test step 012.05
+/////////////////////
+
+// constructor
+CCommDbTest012_05::CCommDbTest012_05()
+	{
+	// store the name of this test case
+	SetTestStepName(_L("step_012_05"));
+	// default to no local objects allocated
+	iLocalObjects = EFalse;
+	}
+
+// destructor
+CCommDbTest012_05::~CCommDbTest012_05()
+	{
+	}
+
+TVerdict CCommDbTest012_05::doTestStepPreambleL()
+	{	
+	openDbL();
+        SetTestStepResult(EPass);	return TestStepResult();
+	}
+
+TInt CCommDbTest012_05::myOpenViewL()
+{
+	//This query contains an erroneous query
+//	TRAPD( r, iTheView = iTheDb->OpenViewLC( TPtrC(DIAL_IN_ISP),_L("select * from DialInISP where") ) );
+	 iTheView = iTheDb->OpenViewLC( TPtrC(DIAL_IN_ISP),_L("select * from DialInISP where") ) ;
+
+	
+	return 0;
+}
+
+
+TInt CCommDbTest012_05::executeStepL()
+	{
+	TInt ret=KErrGeneral;
+
+	TRAPD(r, myOpenViewL() );
+
+	if ( r!=KErrNone )
+		ret = r;
+
+	
+
+	return ret;
+	}
+
+
+
+TVerdict CCommDbTest012_05::doTestStepL( )
+	{
+	INFO_PRINTF1(_L("Step 012.05 called "));
+
+	
+	if ( executeStepL() == KErrArgument )
+		SetTestStepResult(EPass);	else
+		SetTestStepResult(EFail);
+
+
+	return TestStepResult();
+	}
+
+
+/////////////////////
+//	Test step 012.06
+/////////////////////
+
+// constructor
+CCommDbTest012_06::CCommDbTest012_06()
+	{
+	// store the name of this test case
+	SetTestStepName(_L("step_012_06"));
+	}
+
+// destructor
+CCommDbTest012_06::~CCommDbTest012_06()
+	{
+	}
+
+TVerdict CCommDbTest012_06::doTestStepPreambleL()
+	{	
+	openDbL();
+        SetTestStepResult(EPass);	return TestStepResult();
+	}
+
+TInt CCommDbTest012_06::myOpenViewL()
+{
+	//This query contains an erroneous query
+	iTheView = iTheDb->OpenViewLC( TPtrC(DIAL_IN_ISP),_L("") );
+
+	
+	return 0;
+}
+
+
+TInt CCommDbTest012_06::executeStepL()
+	{
+	TInt ret=KErrGeneral;
+
+	TRAPD(r, myOpenViewL() );
+
+	if (r!=KErrNone )
+		ret = r;
+
+	return ret;
+	}
+
+
+
+TVerdict CCommDbTest012_06::doTestStepL( )
+	{
+	INFO_PRINTF1(_L("Step 012.06 called "));
+	
+	if ( executeStepL() == KErrArgument )
+		SetTestStepResult(EPass);	else
+		SetTestStepResult(EFail);
+	return TestStepResult();
+	}
+
+
+
+/////////////////////
+//	Test step 012.07
+/////////////////////
+
+// constructor
+CCommDbTest012_07::CCommDbTest012_07()
+	{
+	// store the name of this test case
+	SetTestStepName(_L("step_012_07"));
+	}
+
+// destructor
+CCommDbTest012_07::~CCommDbTest012_07()
+	{
+	}
+
+TVerdict CCommDbTest012_07::doTestStepL( )
+	{
+	INFO_PRINTF1(_L("Step 012.07 called "));
+
+	SetTestStepResult(EPass);
+/*	// Heap test for 012.01
+
+#if 1
+	CCommDbTest012_01* step012_01 = new CCommDbTest012_01;
+	CleanupStack::PushL(step012_01);
+	doTestStepWithHeapFailureL( *step012_01, KErrNotFound);
+	if ( step012_01->TestStepResult() == EFail )
+		SetTestStepResult(EFail);	CleanupStack::PopAndDestroy(step012_01);
+#endif
+
+	// Heap test for 012.02
+
+	CCommDbTest012_02* step012_02 = new CCommDbTest012_02;
+	CleanupStack::PushL(step012_02);
+	doTestStepWithHeapFailureL( *step012_02, KErrNotFound);
+	if ( step012_02->TestStepResult() == EFail )
+		SetTestStepResult(EFail);	CleanupStack::PopAndDestroy(step012_02);
+
+*/	// Heap test for 012.03
+
+	CCommDbTest012_03* step012_03 = new CCommDbTest012_03;
+	CleanupStack::PushL(step012_03);
+	doTestStepWithHeapFailureL( *step012_03, KErrNotFound);
+	if ( step012_03->TestStepResult() == EFail )
+		SetTestStepResult(EFail);	CleanupStack::PopAndDestroy(step012_03);
+
+	// Heap test for 012.04
+
+	CCommDbTest012_04* step012_04 = new CCommDbTest012_04;
+	CleanupStack::PushL(step012_04);
+	doTestStepWithHeapFailureL( *step012_04, KErrNotFound);
+	if( step012_04->TestStepResult() == EFail )
+		SetTestStepResult(EFail);	CleanupStack::PopAndDestroy(step012_04);
+
+	// Heap test for 012.05
+
+	CCommDbTest012_05* step012_05 = new CCommDbTest012_05;
+	CleanupStack::PushL(step012_05);
+	doTestStepWithHeapFailureL( *step012_05, KErrArgument);
+	if( step012_05->TestStepResult() == EFail )
+		SetTestStepResult(EFail);	CleanupStack::PopAndDestroy(step012_05);
+
+
+	// Heap test for 012.06
+
+	CCommDbTest012_06* step012_06 = new CCommDbTest012_06;
+	CleanupStack::PushL(step012_06);
+	doTestStepWithHeapFailureL( *step012_06, KErrArgument);
+	if( step012_06->TestStepResult() == EFail )
+		SetTestStepResult(EFail);	CleanupStack::PopAndDestroy(step012_06);
+
+	return TestStepResult();	
+
+}