//
// 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();
}