commsconfig/commsdatabaseshim/ts_commdb/Step_011_xx.cpp
changeset 0 dfb7c4ff071f
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/commsconfig/commsdatabaseshim/ts_commdb/Step_011_xx.cpp	Thu Dec 17 09:22:25 2009 +0200
@@ -0,0 +1,364 @@
+// 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 011.XX
+// 
+//
+
+// EPOC includes
+#include <e32base.h>
+#include <commdb.h>
+
+
+// Test system includes
+#include <networking/log.h>
+#include <networking/teststep.h>
+#include "Teststepcommdb.h"
+#include "TestSuiteCommdb.h"
+#include "Step_011_xx.h"
+
+
+
+//
+//	Test step 011.001
+//
+
+// constructor
+CCommDbTest011_01::CCommDbTest011_01()
+	{
+	// store the name of this test case
+	iTestStepName = _L("step_011_01");
+	}
+
+// destructor
+CCommDbTest011_01::~CCommDbTest011_01()
+	{
+	}
+
+
+TVerdict CCommDbTest011_01::doTestStepPreambleL()
+	{	
+	openDbAndViewL(TPtrC(DIAL_OUT_ISP));
+	return EPass;
+	}
+
+
+#define HIDDEN_RECORD_TEST_VALUE	_L("This is a hidden record")
+
+TInt CCommDbTest011_01::executeStepL()
+	{
+	TInt ret=KErrGeneral;
+	TUint32 id;
+
+	//Create a hidden record in the database
+	//NB. This step will panic if the bale used is empty, so use a
+	//populated table to simplify things.
+	
+	//Try to insert a record
+	CDBLEAVE( iTheView->InsertRecord( id ), KErrNone );
+
+	//Insert some text
+	iTheView->WriteTextL( TPtrC(COMMDB_NAME), HIDDEN_RECORD_TEST_VALUE ) ;
+
+	//Must write to these columns as they cannot hold null values
+	iTheView->WriteBoolL(TPtrC(ISP_DIAL_RESOLUTION),ETrue);
+	iTheView->WriteBoolL(TPtrC(ISP_USE_LOGIN_SCRIPT),ETrue);
+	iTheView->WriteBoolL(TPtrC(ISP_PROMPT_FOR_LOGIN),EFalse);
+//	iTheView->WriteTextL(TPtrC(ISP_IF_NAME), _L("PPP") );
+	iTheView->WriteBoolL(TPtrC(ISP_IF_PROMPT_FOR_AUTH),EFalse);
+	iTheView->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER),ETrue);
+	iTheView->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER),ETrue);
+	iTheView->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER),ETrue);
+
+	//Store the record as hidden
+	CDBLEAVE( iTheView->PutRecordChanges(ETrue), KErrNone );
+
+	//Now search through the table looking for this record
+	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );
+
+	TBuf<KCommsDbSvrMaxFieldLength> value;
+	do {
+
+		iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
+		if ( !value.Compare(HIDDEN_RECORD_TEST_VALUE) )
+			{
+				//Found the record, even though it is hidden
+				ret = KErrGeneral;
+				break;
+			}
+		//Move on to the next record
+		TRAPD(r, ret = iTheView->GotoNextRecord() );
+		if( r!= KErrNone )
+			User::Leave( r );
+		} while (ret == KErrNone ) ;
+
+	return ret;
+	}
+
+
+
+TVerdict CCommDbTest011_01::doTestStepL( )
+	{
+	Log(_L("Step 011.01 called "));
+
+		
+	if ( executeStepL() == KErrNotFound )
+		iTestStepResult = EPass;
+	else
+		iTestStepResult = EFail;
+
+
+	return iTestStepResult;
+	}
+
+ //
+ //	Test step 011.02
+ //
+ 
+ // constructor
+CCommDbTest011_02::CCommDbTest011_02()
+ 	{
+ 	// store the name of this test case
+	iTestStepName = _L("step_011_02");
+ 	}
+ 
+ // destructor
+CCommDbTest011_02::~CCommDbTest011_02()
+ 	{
+ 	}
+ 
+TVerdict CCommDbTest011_02::doTestStepPreambleL()
+ 	{	
+ 	openDbAndViewL(TPtrC(DIAL_OUT_ISP));
+ 	return EPass;
+ 	}
+ 
+ 
+TInt CCommDbTest011_02::executeStepL()
+ 	{
+ 	TInt ret=KErrGeneral;
+ 	TUint32 id;
+
+	//Create a hidden record in the database, try to find it,
+	//make a call to ShowHiddenRecords the try to find the record again
+	
+	//Try to insert a test record
+	CDBLEAVE( iTheView->InsertRecord( id ), KErrNone );
+
+	//Insert some text
+	iTheView->WriteTextL( TPtrC(COMMDB_NAME), HIDDEN_RECORD_TEST_VALUE );
+
+	//Must write to these columns as they cannot hold null values
+	iTheView->WriteBoolL(TPtrC(ISP_DIAL_RESOLUTION),ETrue);
+	iTheView->WriteBoolL(TPtrC(ISP_USE_LOGIN_SCRIPT),ETrue);
+	iTheView->WriteBoolL(TPtrC(ISP_PROMPT_FOR_LOGIN),EFalse);
+//	iTheView->WriteTextL(TPtrC(ISP_IF_NAME), _L("PPP") );
+	iTheView->WriteBoolL(TPtrC(ISP_IF_PROMPT_FOR_AUTH),EFalse);
+	iTheView->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER),ETrue);
+	iTheView->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER),ETrue);
+	iTheView->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER),ETrue);
+
+	//Store the record as hidden
+	CDBLEAVE( iTheView->PutRecordChanges(ETrue), KErrNone );
+
+	//Now search through the table looking for this record
+	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );
+
+	//This first search through the table should not find the hidden record
+	TBuf<KCommsDbSvrMaxFieldLength> value;
+	do {
+
+		iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
+		if ( !value.Compare(HIDDEN_RECORD_TEST_VALUE) )
+			{
+				//Found the record
+				ret = KErrGeneral;
+				break;
+			}
+		//Move on to the next record
+		TRAPD(r, ret= iTheView->GotoNextRecord() );
+		if ( r!=KErrNone )
+			User::Leave( r );
+
+		}while(ret == KErrNone );
+	
+	if ( ret == KErrNotFound )
+		{
+
+		//Search again, but this this time we'll show the hidden records
+		delete iTheView;
+		iTheView = 0;
+
+		iTheDb->ShowHiddenRecords();
+		iTheView=iTheDb->OpenTableLC( TPtrC(DIAL_OUT_ISP) );
+		CleanupStack::Pop();
+
+		CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );
+		TBuf<KCommsDbSvrMaxFieldLength> value;
+
+		do {
+			iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
+			if ( !value.Compare(HIDDEN_RECORD_TEST_VALUE) )
+				{
+					//Found the record
+					ret = KErrNone;
+
+					//Change the record not to be hidden for the test 11_03
+					CDBLEAVE( iTheView->UpdateRecord(), KErrNone );
+					CDBLEAVE( iTheView->PutRecordChanges(), KErrNone );
+					break;
+				}
+			//Move on to the next record
+			TRAPD(r, ret = iTheView->GotoNextRecord() )
+			if ( r!=KErrNone )
+				User::Leave( r );
+
+			}while( ret == KErrNone );
+		}
+
+	return ret;
+	}
+
+TVerdict CCommDbTest011_02::doTestStepL( )
+	{
+	Log(_L("Step 011.02 called "));
+
+	if ( executeStepL() == KErrNone )
+		iTestStepResult = EPass;
+	else
+		iTestStepResult = EFail;
+
+
+	return iTestStepResult;
+	}
+
+
+//
+//	Test step 011.03
+//
+
+// constructor
+CCommDbTest011_03::CCommDbTest011_03()
+	{
+	// store the name of this test case
+	iTestStepName = _L("step_011_03");
+	}
+
+// destructor
+CCommDbTest011_03::~CCommDbTest011_03()
+	{
+	}
+
+TVerdict CCommDbTest011_03::doTestStepPreambleL()
+	{	
+	openDbAndViewL(TPtrC(DIAL_OUT_ISP));
+	return EPass;
+	}
+
+
+TInt CCommDbTest011_03::executeStepL()
+	{
+	TInt ret=KErrGeneral;
+
+	//Check if a record from test 11_02 is readable again
+	
+	//Now search through the table looking for this record
+	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );
+
+	//This first search through the table should not find the hidden record
+	TBuf<KCommsDbSvrMaxFieldLength> value;
+	do {
+
+		iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
+		if ( !value.Compare(HIDDEN_RECORD_TEST_VALUE) )
+			{
+				//Found the record
+				ret = KErrNone;
+				break;
+			}
+		//Move on to the next record
+		TRAPD(r, ret= iTheView->GotoNextRecord() );
+		if ( r!=KErrNone )
+			User::Leave( r );
+
+		}while(ret == KErrNone );
+
+	return ret;
+	}
+
+
+TVerdict CCommDbTest011_03::doTestStepL( )
+	{
+	Log(_L("Step 011.03 called "));
+
+	if ( executeStepL() == KErrNone )
+		iTestStepResult = EPass;
+	else
+		iTestStepResult = EFail;
+
+
+	return iTestStepResult;
+	}
+
+
+//
+//	Test step 011.04
+//
+
+// constructor
+CCommDbTest011_04::CCommDbTest011_04()
+	{
+	// store the name of this test case
+	iTestStepName = _L("step_011_04");
+	}
+
+// destructor
+CCommDbTest011_04::~CCommDbTest011_04()
+	{
+	}
+
+TVerdict CCommDbTest011_04::doTestStepL( )
+	{
+	Log(_L("Step 011.04 called "));
+
+	iTestStepResult = EPass;
+
+	// Heap test for 011.01
+
+	CCommDbTest011_01* step011_01 = new CCommDbTest011_01;
+	CleanupStack::PushL(step011_01);
+	step011_01->iSuite = iSuite;				
+	if ( doTestStepWithHeapFailureL( *step011_01, KErrNotFound) == EFail )
+		iTestStepResult = EFail;
+	CleanupStack::PopAndDestroy(step011_01);
+
+
+	// Heap test for 011.02
+	CCommDbTest011_02* step011_02 = new CCommDbTest011_02;
+	CleanupStack::PushL(step011_02);
+	step011_02->iSuite = iSuite;				
+	if ( doTestStepWithHeapFailureL( *step011_02, KErrNone) == EFail )
+		iTestStepResult = EFail;
+	CleanupStack::PopAndDestroy(step011_02);
+
+	// Heap test for 011.03
+	CCommDbTest011_03* step011_03 = new CCommDbTest011_03;
+	CleanupStack::PushL(step011_03);
+	step011_03->iSuite = iSuite;				
+	if ( doTestStepWithHeapFailureL( *step011_03, KErrNone) == EFail )
+		iTestStepResult = EFail;
+	CleanupStack::PopAndDestroy(step011_03);
+
+	return iTestStepResult;	
+
+}