// 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 007.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_007_xx.h"

//#ifndef SYMBIAN_COMMS_REPOSITORY

//	_LIT(KTempDb3, "c:\\system\\data\\default3.dat");

//#endif

//

//	Test step 007.001

//

// constructor

CCommDbTest007_01::CCommDbTest007_01()

	{

	// store the name of this test case

	iTestStepName = _L("step_007_01");

	}

// destructor

CCommDbTest007_01::~CCommDbTest007_01()

	{

	}

TVerdict CCommDbTest007_01::doTestStepPreambleL()

	{

	openDbAndViewL(TPtrC(DIAL_OUT_ISP));

	return EPass;

	}

#define EXPECTED_FIELD_VALUE _L8("Call me back")

TInt CCommDbTest007_01::executeStepL()

	{

	TInt ret = EFail;

	CDBLEAVE( ret = iTheView->GotoFirstRecord(), KErrNone );

	//Read the value from the field and compare it to the expected value

	TBuf8<KCommsDbSvrMaxFieldLength> value;

	iTheView->ReadTextL( TPtrC(ISP_IF_CALLBACK_INFO), value );

	if( !value.Compare( TPtrC8(EXPECTED_FIELD_VALUE) ) )

		{

		ret = EPass;

		}

	return ret;

	}

TVerdict CCommDbTest007_01::doTestStepL( )

	{

	Log(_L("Step 007.01 called "));

	iTestStepResult = EFail;

	if ( executeStepL() == EPass )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 007.002

//

// constructor

CCommDbTest007_02::CCommDbTest007_02()

	{

	// store the name of this test case

	iTestStepName = _L("step_007_02");

	}

// destructor

CCommDbTest007_02::~CCommDbTest007_02()

	{

	}

TVerdict CCommDbTest007_02::doTestStepPreambleL()

	{

	openDbAndViewL(TPtrC(DIAL_OUT_ISP));

	return EPass;

	}

#define EXPECTED_ISP_DESCRIPTION _S("Description")

TInt CCommDbTest007_02::executeStepL()

	{

	TInt32 ret = EFail;

	CDBLEAVE( ret = iTheView->GotoFirstRecord(), KErrNone );

	//Read the value from the field and compare it to the expected value

	TBuf<KCommsDbSvrMaxFieldLength> value;

	iTheView->ReadTextL( TPtrC(ISP_DESCRIPTION), value );

	if( !value.Compare( TPtrC(EXPECTED_ISP_DESCRIPTION) ) )

		{

		ret = EPass;

		}

	return ret;

	}

TVerdict CCommDbTest007_02::doTestStepL( )

	{

	Log(_L("Step 007.02 called "));

	iTestStepResult = EFail;

	if ( executeStepL() == EPass  )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 007.003

//

// constructor

CCommDbTest007_03::CCommDbTest007_03()

	{

	// store the name of this test case

	iTestStepName = _L("step_007_03");

	}

// destructor

CCommDbTest007_03::~CCommDbTest007_03()

	{

	}

TVerdict CCommDbTest007_03::doTestStepPreambleL()

	{

	openDbAndViewL(TPtrC(DIAL_OUT_ISP));

	return EPass;

	}

#define EXPECTED_ISP_LOGIN_SCRIPT _S("wobble")

TInt CCommDbTest007_03::executeStepL()

	{

	TInt32 ret = EFail;

	CDBLEAVE( ret = iTheView->GotoFirstRecord(), KErrNone );

	//Read the value from the LongText field and compare it to the expected value

	HBufC* value = iTheView->ReadLongTextLC( TPtrC(ISP_LOGIN_SCRIPT) );

	if ( value )

		{

		if( !value->Compare( TPtrC(EXPECTED_ISP_LOGIN_SCRIPT) ) )

			{

			ret = EPass;

			}

		CleanupStack::PopAndDestroy();

		}

	return ret;

	}

TVerdict CCommDbTest007_03::doTestStepL( )

	{

	Log(_L("Step 007.03 called "));

	if ( executeStepL() == EPass  )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 007.004

//

// constructor

CCommDbTest007_04::CCommDbTest007_04()

	{

	// store the name of this test case

	iTestStepName = _L("step_007_04");

	}

// destructor

CCommDbTest007_04::~CCommDbTest007_04()

	{

	}

TVerdict CCommDbTest007_04::doTestStepPreambleL()

	{

	openDbAndViewL(TPtrC(DIAL_OUT_ISP));

	return EPass;

	}

#define EXPECTED_ISP_TYPE  2

TInt CCommDbTest007_04::executeStepL()

	{

	TBool ret = EFail;

	CDBLEAVE( ret = iTheView->GotoFirstRecord(), KErrNone);

	//Read the value from the Uint field and compare it to the expected value

	TUint32 value;

	iTheView->ReadUintL( TPtrC(ISP_TYPE), value );

	if( value == EXPECTED_ISP_TYPE )

		{

		ret = EPass;

		}

	return ret;

}

TVerdict CCommDbTest007_04::doTestStepL( )

	{

	Log(_L("Step 007.04 called "));

	if ( executeStepL() == EPass  )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 007.005

//

// constructor

CCommDbTest007_05::CCommDbTest007_05()

	{

	// store the name of this test case

	iTestStepName = _L("step_007_05");

	// default to no local objects allocated

	iLocalObjects = EFalse;

	}

// destructor

CCommDbTest007_05::~CCommDbTest007_05()

	{

	}

TVerdict CCommDbTest007_05::doTestStepPreambleL()

	{

	openDbAndViewL(TPtrC(DIAL_OUT_ISP));

	return EPass;

	}

TInt CCommDbTest007_05::executeStepL()

	{

	TBool ret = EFail;

	CDBLEAVE( ret = iTheView->GotoFirstRecord(), KErrNone);

	//Read the value from the Uint field and compare it to the expected value

	TBool expectedValue;

	iTheView->ReadBoolL( TPtrC(ISP_DISPLAY_PCT), expectedValue );

	if( expectedValue )

		{

		iTestStepResult = EPass;

		}

	return ret;

	}

TVerdict CCommDbTest007_05::doTestStepL( )

	{

	Log(_L("Step 007.05 called "));

	if ( executeStepL() == EPass  )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 007.006

//

// constructor

CCommDbTest007_06::CCommDbTest007_06()

	{

	// store the name of this test case

	iTestStepName = _L("step_007_06");

	}

// destructor

CCommDbTest007_06::~CCommDbTest007_06()

	{

	}

TVerdict CCommDbTest007_06::doTestStepPreambleL()

	{

	openDbAndViewL(TPtrC(DIAL_OUT_ISP));

	return EPass;

	}

#define EXPECTED_COLUMN_LENGTH	10		//Expected length of ISP_IP_ADDR column

TInt CCommDbTest007_06::executeStepL()

	{

	TBool ret = EFail;

	CDBLEAVE( ret = iTheView->GotoFirstRecord(), KErrNone );

	//Read the length of a column

	TInt value;

	iTheView->ReadColumnLengthL( TPtrC(ISP_IP_ADDR), value );

	if( value == EXPECTED_COLUMN_LENGTH )

		iTestStepResult = EPass;

	return ret;

	}

TVerdict CCommDbTest007_06::doTestStepL( )

	{

	Log(_L("Step 007.06 called "));

	if ( executeStepL() == EPass  )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 007.007

//

// constructor

CCommDbTest007_07::CCommDbTest007_07()

	{

	// store the name of this test case

	iTestStepName = _L("step_007_07");

	}

// destructor

CCommDbTest007_07::~CCommDbTest007_07()

	{

	}

TVerdict CCommDbTest007_07::doTestStepPreambleL()

	{

	openDbAndViewL(TPtrC(DIAL_OUT_ISP));

	return EPass;

	}

TInt CCommDbTest007_07::executeStepL()

	{

	TInt ret = KErrGeneral;

	ret = iTheView->GotoFirstRecord();

	if ( ret == KErrNotFound )

		return ret;

	//Try to read a column value from the empty view

	TBuf<KCommsDbSvrMaxFieldLength> value;

	iTheView->ReadTextL( TPtrC(ISP_DESCRIPTION), value );

	return ret;

	}

TVerdict CCommDbTest007_07::doTestStepL( )

	{

	Log(_L("Step 007.07 called "));

	//NB. create a view on an empty table

	if ( executeStepL() == KErrNotFound )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 007.08

//

// constructor

CCommDbTest007_08::CCommDbTest007_08()

	{

	// store the name of this test case

	iTestStepName = _L("step_007_08");

	// default to no local objects allocated

	iLocalObjects = EFalse;

	}

// destructor

CCommDbTest007_08::~CCommDbTest007_08()

	{

	}

TVerdict CCommDbTest007_08::doTestStepPreambleL()

	{

	openDbAndViewL(TPtrC(DIAL_OUT_ISP));

	return EPass;

	}

TInt CCommDbTest007_08::executeStepL()

	{

	TBool ret = EFail;

	ret = iTheView->GotoFirstRecord();

	if ( ret == KErrNotFound )

		return EPass;

	//Read the length of a column

	TInt value;

	iTheView->ReadColumnLengthL( TPtrC(ISP_IF_PARAMS), value );

	if ( value == 0 )

		ret = EPass;

	return ret;

	}

TVerdict CCommDbTest007_08::doTestStepL( )

	{

	Log(_L("Step 007.08 called "));

	//NB. create a view on an empty table

	if ( executeStepL() == EPass )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 007.09

//

// constructor

CCommDbTest007_09::CCommDbTest007_09()

	{

	// store the name of this test case

	iTestStepName = _L("step_007_09");

	}

// destructor

CCommDbTest007_09::~CCommDbTest007_09()

	{

	}

TVerdict CCommDbTest007_09::doTestStepPreambleL()

	{

	openDbAndViewL(TPtrC(DIAL_OUT_ISP));

	return EPass;

	}

TInt CCommDbTest007_09::executeStepL()

	{

	TInt ret = KErrGeneral;

	CDBLEAVE( ret = iTheView->GotoFirstRecord(), KErrNone )

	//Try to read from an invalid column

	TBuf<KCommsDbSvrMaxFieldLength> value;

	TRAPD(r, iTheView->ReadTextL( KInvalidColumnName, value ) );

	ret = r;

	return ret;

	}

TVerdict CCommDbTest007_09::doTestStepL( )

	{

	Log(_L("Step 007.09 called "));

	//NB. create a view on an empty table