// Copyright (c) 2006-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 009.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_009_xx.h"

//

//	Test step 009.001

//

// constructor

CCommDbTest009_01::CCommDbTest009_01()

	{

	// store the name of this test case

	iTestStepName = _L("step_009_01");

	}

// destructor

CCommDbTest009_01::~CCommDbTest009_01()

	{

	}

TVerdict CCommDbTest009_01::doTestStepPreambleL()

	{	

	openDbAndViewL(TPtrC(DIAL_OUT_ISP));

	return EPass;

	}

#define ISP_INIT_STRING_TEST_VALUE	_L8("Test Value")

#define COMMDB_NAME_TEST_VALUE	_L("Test record")

//#define ISP_IF_NAME_TEST_VALUE	_L("Test record")

TInt CCommDbTest009_01::executeStepL()

	{

	TInt ret=KErrGeneral;

	TUint32 id;

	//NB. The table MUST be empty for this test to work!

	//Try to insert a record

	CDBLEAVE( iTheView->InsertRecord( id ), KErrNone );

	//Insert some text

	iTheView->WriteTextL( TPtrC(ISP_INIT_STRING), ISP_INIT_STRING_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), ISP_IF_NAME_TEST_VALUE );

	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);

	iTheView->WriteTextL(TPtrC(COMMDB_NAME),COMMDB_NAME_TEST_VALUE);

	CDBLEAVE( iTheView->PutRecordChanges(), KErrNone );

	//Read the value from the field and compare it to the value we've just written

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

	TBuf8<KCommsDbSvrMaxFieldLength> value;

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

 	if( !value.Compare( ISP_INIT_STRING_TEST_VALUE ) )

		{

		ret = KErrNone;

		}

	return ret;

	}

TVerdict CCommDbTest009_01::doTestStepL( )

	{

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

	if ( executeStepL() == KErrNone )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 009.002

//

// constructor

CCommDbTest009_02::CCommDbTest009_02()

	{

	// store the name of this test case

	iTestStepName = _L("step_009_02");

	}

// destructor

CCommDbTest009_02::~CCommDbTest009_02()

	{

	}

TVerdict CCommDbTest009_02::doTestStepPreambleL()

	{	

	openDbAndViewL(TPtrC(DIAL_OUT_ISP));

	return EPass;

	}

#define ISP_DESCRIPTION_TEST_VALUE	_L16("ISP description test value")

TInt CCommDbTest009_02::executeStepL()

	{

	TInt ret=KErrGeneral;

	TUint32 id;

	//NB. The table MUST be empty for this test to work!

	//Try to insert a record

	CDBLEAVE( iTheView->InsertRecord( id ), KErrNone );

	//Insert some text

	iTheView->WriteTextL( TPtrC(ISP_DESCRIPTION), ISP_DESCRIPTION_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), ISP_IF_NAME_TEST_VALUE );

	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);

	iTheView->WriteTextL(TPtrC(COMMDB_NAME),COMMDB_NAME_TEST_VALUE);

	CDBLEAVE( iTheView->PutRecordChanges(), KErrNone);

	//Read the value from the field and compare it to the value we've just written

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

	TBuf<KCommsDbSvrMaxFieldLength> value;

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

	if( !value.Compare( ISP_DESCRIPTION_TEST_VALUE ) )

		{

		ret = KErrNone;

		}

	return ret;

	}

TVerdict CCommDbTest009_02::doTestStepL( )

	{

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

	if ( executeStepL() == KErrNone )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 009.003

//

// constructor

CCommDbTest009_03::CCommDbTest009_03()

	{

	// store the name of this test case

	iTestStepName = _L("step_009_03");

	}

// destructor

CCommDbTest009_03::~CCommDbTest009_03()

	{

	}

TVerdict CCommDbTest009_03::doTestStepPreambleL()

	{	

	openDbAndViewL(TPtrC(DIAL_OUT_ISP));

	return EPass;

	}

#define ISP_BEARER_TYPE_TEST_VALUE		0x1

TInt CCommDbTest009_03::executeStepL()

	{

	TInt ret=KErrGeneral;

	TUint32 id;

	//NB. The table MUST be empty for this test to work!

	//Try to insert a record

	CDBLEAVE( iTheView->InsertRecord( id ),  KErrNone );

	//Insert a value

	iTheView->WriteUintL( TPtrC(ISP_BEARER_TYPE), ISP_BEARER_TYPE_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), ISP_IF_NAME_TEST_VALUE );

	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);

	iTheView->WriteTextL(TPtrC(COMMDB_NAME),COMMDB_NAME_TEST_VALUE);

	CDBLEAVE( iTheView->PutRecordChanges(),  KErrNone );

	//Read the value from the field and compare it to the value we've just written

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

	TUint32 value;

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

	if( value == ISP_BEARER_TYPE_TEST_VALUE )

		{

		ret = KErrNone;

		}

	return ret;

	}

TVerdict CCommDbTest009_03::doTestStepL( )

	{

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

	if ( executeStepL() == KErrNone )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 009.004

//

// constructor

CCommDbTest009_04::CCommDbTest009_04()

	{

	// store the name of this test case

	iTestStepName = _L("step_009_04");

	}

// destructor

CCommDbTest009_04::~CCommDbTest009_04()

	{

	}

TVerdict CCommDbTest009_04::doTestStepPreambleL()

	{	

	openDbAndViewL(TPtrC(DIAL_OUT_ISP));

	return EPass;

	}

#define ISP_ENABLE_SW_COMP_TEST_VALUE	ETrue

TInt CCommDbTest009_04::executeStepL()

	{

	TInt ret=KErrGeneral;

	TUint32 id;

	//NB. The table MUST be empty for this test to work!

	//Try to insert a record

	CDBLEAVE( iTheView->InsertRecord( id ),  KErrNone );

	//Insert a value

	iTheView->WriteBoolL( TPtrC(ISP_ENABLE_SW_COMP), ISP_ENABLE_SW_COMP_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), ISP_IF_NAME_TEST_VALUE );

	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);

	iTheView->WriteTextL(TPtrC(COMMDB_NAME),COMMDB_NAME_TEST_VALUE);

	CDBLEAVE( iTheView->PutRecordChanges(), KErrNone );

	//Read the value from the field and compare it to the value we've just written

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

	TBool value;

	iTheView->ReadBoolL( TPtrC(ISP_ENABLE_SW_COMP), value );

	if( value )

		{

		ret = KErrNone;

		}

	return ret;

	}

TVerdict CCommDbTest009_04::doTestStepL( )

	{

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

	if ( executeStepL() == KErrNone )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 009.005

//

// constructor

CCommDbTest009_05::CCommDbTest009_05()

	{

	// store the name of this test case

	iTestStepName = _L("step_009_05");

	}

// destructor

CCommDbTest009_05::~CCommDbTest009_05()

	{

	}

TVerdict CCommDbTest009_05::doTestStepPreambleL()

	{	

	openDbAndViewL(TPtrC(DIAL_OUT_ISP));

	return EPass;

	}

#define ISP_LOGIN_SCRIPT_TEST_VALUE	 _L("This is a test string that will be used in the test. It must be longer than 50 characters")

TInt CCommDbTest009_05::executeStepL()

	{

	TInt ret=KErrGeneral;

	TUint32 id;

	//NB. The table MUST be empty for this test to work!

	//Try to insert a record

	CDBLEAVE( iTheView->InsertRecord( id ), KErrNone );

	//Insert a value

	iTheView->WriteLongTextL( TPtrC(ISP_LOGIN_SCRIPT), TPtrC(ISP_LOGIN_SCRIPT_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), ISP_IF_NAME_TEST_VALUE );

	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);

	iTheView->WriteTextL(TPtrC(COMMDB_NAME),COMMDB_NAME_TEST_VALUE);

	CDBLEAVE( iTheView->PutRecordChanges(), KErrNone );

	//Read the value from the field and compare it to the value we've just written

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

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

	if ( value )

		{

		if( !value->Compare( ISP_LOGIN_SCRIPT_TEST_VALUE) )

			{

			ret = KErrNone;

			}

		CleanupStack::PopAndDestroy();

		}

	return ret;

	}

TVerdict CCommDbTest009_05::doTestStepL( )

	{

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

	if ( executeStepL() == KErrNone )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 009.06

//

// constructor

CCommDbTest009_06::CCommDbTest009_06()

	{

	// store the name of this test case

	iTestStepName = _L("step_009_06");

	}

// destructor

CCommDbTest009_06::~CCommDbTest009_06()

	{

	}

TVerdict CCommDbTest009_06::doTestStepPreambleL()

	{	

	openDbAndViewL(TPtrC(DIAL_OUT_ISP));

	return EPass;

	}

#define TEST_DATA		_L("Test data")

TInt CCommDbTest009_06::executeStepL()

	{

	TInt ret=KErrNone;

	TUint32 id;

	//NB. The table MUST be empty for this test to work!

	//NB. This test will cause a PANIC

	//Try to insert a record

	CDBLEAVE( iTheView->InsertRecord( id ), KErrNone );

	//Insert a value in an invalid column

	iTheView->WriteTextL( KInvalidColumnName, TPtrC(TEST_DATA) );

	// We should never get here because we should have hit a panic

	// If the Panic doesnt happen, we'll cause a leave

	User::Leave( KErrGeneral );

	return ret;

	}

TVerdict CCommDbTest009_06::doTestStepL( )

	{

	//This test step needs to trap a Panic

	TRAPD( r, executeStepL() );

	if ( r == KErrNotFound )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 009.07

//

// constructor

CCommDbTest009_07::CCommDbTest009_07()