--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/commsconfig/commsdatabaseshim/TE_commdb/src/Step_011_xx.cpp Mon Sep 06 13:49:23 2010 +0100
@@ -0,0 +1,350 @@
+//
+// 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 011.XX
+
+// EPOC includes
+#include <e32base.h>
+#include <commdb.h>
+
+
+// Test system includes
+#include "Teststepcommdb.h"
+#include "Step_011_xx.h"
+
+
+
+/////////////////////
+// Test step 011.001
+/////////////////////
+
+// constructor
+CCommDbTest011_01::CCommDbTest011_01()
+ {
+ // store the name of this test case
+ SetTestStepName(_L("step_011_01"));
+ }
+
+// destructor
+CCommDbTest011_01::~CCommDbTest011_01()
+ {
+ }
+
+
+TVerdict CCommDbTest011_01::doTestStepPreambleL()
+ {
+ openDbAndViewL(TPtrC(DIAL_OUT_ISP));
+ SetTestStepResult(EPass); return TestStepResult();
+ }
+
+
+#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( )
+ {
+ INFO_PRINTF1(_L("Step 011.01 called "));
+
+
+ if ( executeStepL() == KErrNotFound )
+ SetTestStepResult(EPass); else
+ SetTestStepResult(EFail);
+
+ return TestStepResult();
+ }
+
+ /////////////////////
+ // Test step 011.02
+ /////////////////////
+
+ // constructor
+CCommDbTest011_02::CCommDbTest011_02()
+ {
+ // store the name of this test case
+ SetTestStepName(_L("step_011_02"));
+ }
+
+ // destructor
+CCommDbTest011_02::~CCommDbTest011_02()
+ {
+ }
+
+TVerdict CCommDbTest011_02::doTestStepPreambleL()
+ {
+ openDbAndViewL(TPtrC(DIAL_OUT_ISP));
+ SetTestStepResult(EPass); return TestStepResult();
+ }
+
+
+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( )
+ {
+ INFO_PRINTF1(_L("Step 011.02 called "));
+
+ if ( executeStepL() == KErrNone )
+ SetTestStepResult(EPass); else
+ SetTestStepResult(EFail);
+
+ return TestStepResult();
+ }
+
+
+/////////////////////
+// Test step 011.03
+/////////////////////
+
+// constructor
+CCommDbTest011_03::CCommDbTest011_03()
+ {
+ // store the name of this test case
+ SetTestStepName(_L("step_011_03"));
+ }
+
+// destructor
+CCommDbTest011_03::~CCommDbTest011_03()
+ {
+ }
+
+TVerdict CCommDbTest011_03::doTestStepPreambleL()
+ {
+ openDbAndViewL(TPtrC(DIAL_OUT_ISP));
+ SetTestStepResult(EPass); return TestStepResult();
+ }
+
+
+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( )
+ {
+ INFO_PRINTF1(_L("Step 011.03 called "));
+
+ if ( executeStepL() == KErrNone )
+ SetTestStepResult(EPass); else
+ SetTestStepResult(EFail);
+
+ return TestStepResult();
+ }
+
+
+/////////////////////
+// Test step 011.04
+/////////////////////
+
+// constructor
+CCommDbTest011_04::CCommDbTest011_04()
+ {
+ // store the name of this test case
+ SetTestStepName(_L("step_011_04"));
+ }
+
+// destructor
+CCommDbTest011_04::~CCommDbTest011_04()
+ {
+ }
+
+TVerdict CCommDbTest011_04::doTestStepL( )
+ {
+ INFO_PRINTF1(_L("Step 011.04 called "));
+
+ SetTestStepResult(EPass);
+ // Heap test for 011.01
+
+ CCommDbTest011_01* step011_01 = new CCommDbTest011_01;
+ CleanupStack::PushL(step011_01);
+ if ( doTestStepWithHeapFailureL( *step011_01, KErrNotFound) == EFail )
+ SetTestStepResult(EFail); CleanupStack::PopAndDestroy(step011_01);
+
+
+ // Heap test for 011.02
+ CCommDbTest011_02* step011_02 = new CCommDbTest011_02;
+ CleanupStack::PushL(step011_02);
+ if ( doTestStepWithHeapFailureL( *step011_02, KErrNone) == EFail )
+ SetTestStepResult(EFail); CleanupStack::PopAndDestroy(step011_02);
+
+ // Heap test for 011.03
+ CCommDbTest011_03* step011_03 = new CCommDbTest011_03;
+ CleanupStack::PushL(step011_03);
+ if ( doTestStepWithHeapFailureL( *step011_03, KErrNone) == EFail )
+ SetTestStepResult(EFail); CleanupStack::PopAndDestroy(step011_03);
+
+ return TestStepResult();
+
+}