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

}