//
// 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 012.XX

// EPOC includes
#include <e32base.h>
#include <commdb.h>


// Test system includes
#include "Teststepcommdb.h"
#include "Step_012_xx.h"



/////////////////////
//	Test step 012.001
/////////////////////

// constructor
CCommDbTest012_01::CCommDbTest012_01()
	{
	// store the name of this test case
	SetTestStepName(_L("step_012_01"));
	}

// destructor
CCommDbTest012_01::~CCommDbTest012_01()
	{
	}


TVerdict CCommDbTest012_01::doTestStepPreambleL()
	{	
	openDbL();
        SetTestStepResult(EPass);	return TestStepResult();
	}


TInt CCommDbTest012_01::executeStepL()
	{
	TInt ret=KErrNone;

	//This query should select 3 records
	iTheView = iTheDb->OpenViewLC( TPtrC(DIAL_IN_ISP),_L("select * from DialInISP where Ifname='PPP'") );
	CleanupStack::Pop();

	//Now check that the records are what we expect
	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );

	//Read the value from the field and compare it to the expected value
	TBuf<KCommsDbSvrMaxFieldLength> value;
	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
	if( value.Compare(_L("Record #1")) )
		{
		ret = KErrGeneral;
		}

	CDBLEAVE( iTheView->GotoNextRecord(), KErrNone );
	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
	if( value.Compare(_L("Record #2")) )
		{
		ret = KErrGeneral;
		}

	CDBLEAVE( iTheView->GotoNextRecord(), KErrNone );
	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
	if( value.Compare(_L("Record #5 (Read Only)")) )
		{
		ret = KErrGeneral;
		}

	CDBLEAVE( ret = iTheView->GotoNextRecord(), KErrNotFound);

	return ret;
	}



TVerdict CCommDbTest012_01::doTestStepL( )
	{
	INFO_PRINTF1(_L("Step 012.01 called "));

	
	if ( executeStepL() == KErrNotFound )
		SetTestStepResult(EPass);	else
		SetTestStepResult(EFail);

	return TestStepResult();
	}


/////////////////////
//	Test step 012.02
/////////////////////

// constructor
CCommDbTest012_02::CCommDbTest012_02()
	{
	// store the name of this test case
	SetTestStepName(_L("step_012_02"));

	}

// destructor
CCommDbTest012_02::~CCommDbTest012_02()
	{
	}

TVerdict CCommDbTest012_02::doTestStepPreambleL()
	{	
	openDbL();
        SetTestStepResult(EPass);	return TestStepResult();
	}


TInt CCommDbTest012_02::executeStepL()
	{
	TInt ret=KErrNone;

	//This query should select 0 records
	iTheView = iTheDb->OpenViewLC( TPtrC(DIAL_IN_ISP),_L("select * from DialInISP where Ifname='XXX'") );
	CleanupStack::Pop();

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

	return ret;
	}



TVerdict CCommDbTest012_02::doTestStepL( )
	{
	INFO_PRINTF1(_L("Step 012.02 called "));

	if ( executeStepL() == KErrNotFound )
		SetTestStepResult(EPass);	else
		SetTestStepResult(EFail);
	return TestStepResult();
	}


/////////////////////
//	Test step 012.03
/////////////////////

// constructor
CCommDbTest012_03::CCommDbTest012_03()
	{
	// store the name of this test case
	SetTestStepName(_L("step_012_03"));

	}

// destructor
CCommDbTest012_03::~CCommDbTest012_03()
	{
	}


TVerdict CCommDbTest012_03::doTestStepPreambleL()
	{	
	openDbL();
        SetTestStepResult(EPass);	return TestStepResult();
	}

TInt CCommDbTest012_03::executeStepL()
	{
	TInt ret=KErrNone;

	//This query should select 1 record
	iTheView = iTheDb->OpenViewLC( TPtrC(DIAL_IN_ISP),_L("select * from DialInISP where Name='Record #3'") );
	CleanupStack::Pop();

	//Read the value from the field and compare it to the expected value
	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );
	TBuf<KCommsDbSvrMaxFieldLength> value;
	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
	if( value.Compare(_L("Record #3")) )
		{
		ret = KErrGeneral;
		}

	//Check that there was only one record
	CDBLEAVE( ret = iTheView->GotoNextRecord(), KErrNotFound );

	return ret;
	}



TVerdict CCommDbTest012_03::doTestStepL( )
	{
	INFO_PRINTF1(_L("Step 012.03 called "));

	if ( executeStepL() == KErrNotFound )
		SetTestStepResult(EPass);	else
		SetTestStepResult(EFail);	
	return TestStepResult();
	}


/////////////////////
//	Test step 012.04
/////////////////////

// constructor
CCommDbTest012_04::CCommDbTest012_04()
	{
	// store the name of this test case
	SetTestStepName(_L("step_012_04"));
	// default to no local objects allocated
	iLocalObjects = EFalse;
	}

// destructor
CCommDbTest012_04::~CCommDbTest012_04()
	{
	}

TVerdict CCommDbTest012_04::doTestStepPreambleL()
	{	
	openDbL();
        SetTestStepResult(EPass);	return TestStepResult();
	}


TInt CCommDbTest012_04::executeStepL()
	{
	TInt ret=KErrNone;

	//This query should select al1 records
	iTheView = iTheDb->OpenViewLC( TPtrC(DIAL_IN_ISP),_L("select * from DialInISP") );
	CleanupStack::Pop();

	//For each expected record read the value from the field and compare it to the expected value
	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );
	TBuf<KCommsDbSvrMaxFieldLength> value;
	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
	if( value.Compare(_L("Record #1")) )
		{
		ret = KErrGeneral;
		}

	CDBLEAVE( iTheView->GotoNextRecord(), KErrNone );
	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
	if( value.Compare(_L("Record #2")) )
		{
		ret = KErrGeneral;
		}

	CDBLEAVE( iTheView->GotoNextRecord(), KErrNone );
	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
	if( value.Compare(_L("Record #3")) )
		{
		ret = KErrGeneral;
		}

	CDBLEAVE( iTheView->GotoNextRecord(), KErrNone );
	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
	if( value.Compare(_L("Record #4")) )
		{
		ret = KErrGeneral;
		}

	CDBLEAVE( iTheView->GotoNextRecord(), KErrNone );
	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
	if( value.Compare(_L("Record #5")) )
		{
		ret = KErrGeneral;
		}
	//Check there no more records

	CDBLEAVE( ret = iTheView->GotoNextRecord(), KErrNotFound );
		
	return ret;
	}



TVerdict CCommDbTest012_04::doTestStepL( )
	{
	INFO_PRINTF1(_L("Step 012.04 called "));

	if ( executeStepL() == KErrNotFound )
		SetTestStepResult(EPass);	else
		SetTestStepResult(EFail);

	return TestStepResult();
	}


/////////////////////
//	Test step 012.05
/////////////////////

// constructor
CCommDbTest012_05::CCommDbTest012_05()
	{
	// store the name of this test case
	SetTestStepName(_L("step_012_05"));
	// default to no local objects allocated
	iLocalObjects = EFalse;
	}

// destructor
CCommDbTest012_05::~CCommDbTest012_05()
	{
	}

TVerdict CCommDbTest012_05::doTestStepPreambleL()
	{	
	openDbL();
        SetTestStepResult(EPass);	return TestStepResult();
	}

TInt CCommDbTest012_05::myOpenViewL()
{
	//This query contains an erroneous query
//	TRAPD( r, iTheView = iTheDb->OpenViewLC( TPtrC(DIAL_IN_ISP),_L("select * from DialInISP where") ) );
	 iTheView = iTheDb->OpenViewLC( TPtrC(DIAL_IN_ISP),_L("select * from DialInISP where") ) ;

	
	return 0;
}


TInt CCommDbTest012_05::executeStepL()
	{
	TInt ret=KErrGeneral;

	TRAPD(r, myOpenViewL() );

	if ( r!=KErrNone )
		ret = r;

	

	return ret;
	}



TVerdict CCommDbTest012_05::doTestStepL( )
	{
	INFO_PRINTF1(_L("Step 012.05 called "));

	
	if ( executeStepL() == KErrArgument )
		SetTestStepResult(EPass);	else
		SetTestStepResult(EFail);


	return TestStepResult();
	}


/////////////////////
//	Test step 012.06
/////////////////////

// constructor
CCommDbTest012_06::CCommDbTest012_06()
	{
	// store the name of this test case
	SetTestStepName(_L("step_012_06"));
	}

// destructor
CCommDbTest012_06::~CCommDbTest012_06()
	{
	}

TVerdict CCommDbTest012_06::doTestStepPreambleL()
	{	
	openDbL();
        SetTestStepResult(EPass);	return TestStepResult();
	}

TInt CCommDbTest012_06::myOpenViewL()
{
	//This query contains an erroneous query
	iTheView = iTheDb->OpenViewLC( TPtrC(DIAL_IN_ISP),_L("") );

	
	return 0;
}


TInt CCommDbTest012_06::executeStepL()
	{
	TInt ret=KErrGeneral;

	TRAPD(r, myOpenViewL() );

	if (r!=KErrNone )
		ret = r;

	return ret;
	}



TVerdict CCommDbTest012_06::doTestStepL( )
	{
	INFO_PRINTF1(_L("Step 012.06 called "));
	
	if ( executeStepL() == KErrArgument )
		SetTestStepResult(EPass);	else
		SetTestStepResult(EFail);
	return TestStepResult();
	}



/////////////////////
//	Test step 012.07
/////////////////////

// constructor
CCommDbTest012_07::CCommDbTest012_07()
	{
	// store the name of this test case
	SetTestStepName(_L("step_012_07"));
	}

// destructor
CCommDbTest012_07::~CCommDbTest012_07()
	{
	}

TVerdict CCommDbTest012_07::doTestStepL( )
	{
	INFO_PRINTF1(_L("Step 012.07 called "));

	SetTestStepResult(EPass);
/*	// Heap test for 012.01

#if 1
	CCommDbTest012_01* step012_01 = new CCommDbTest012_01;
	CleanupStack::PushL(step012_01);
	doTestStepWithHeapFailureL( *step012_01, KErrNotFound);
	if ( step012_01->TestStepResult() == EFail )
		SetTestStepResult(EFail);	CleanupStack::PopAndDestroy(step012_01);
#endif

	// Heap test for 012.02

	CCommDbTest012_02* step012_02 = new CCommDbTest012_02;
	CleanupStack::PushL(step012_02);
	doTestStepWithHeapFailureL( *step012_02, KErrNotFound);
	if ( step012_02->TestStepResult() == EFail )
		SetTestStepResult(EFail);	CleanupStack::PopAndDestroy(step012_02);

*/	// Heap test for 012.03

	CCommDbTest012_03* step012_03 = new CCommDbTest012_03;
	CleanupStack::PushL(step012_03);
	doTestStepWithHeapFailureL( *step012_03, KErrNotFound);
	if ( step012_03->TestStepResult() == EFail )
		SetTestStepResult(EFail);	CleanupStack::PopAndDestroy(step012_03);

	// Heap test for 012.04

	CCommDbTest012_04* step012_04 = new CCommDbTest012_04;
	CleanupStack::PushL(step012_04);
	doTestStepWithHeapFailureL( *step012_04, KErrNotFound);
	if( step012_04->TestStepResult() == EFail )
		SetTestStepResult(EFail);	CleanupStack::PopAndDestroy(step012_04);

	// Heap test for 012.05

	CCommDbTest012_05* step012_05 = new CCommDbTest012_05;
	CleanupStack::PushL(step012_05);
	doTestStepWithHeapFailureL( *step012_05, KErrArgument);
	if( step012_05->TestStepResult() == EFail )
		SetTestStepResult(EFail);	CleanupStack::PopAndDestroy(step012_05);


	// Heap test for 012.06

	CCommDbTest012_06* step012_06 = new CCommDbTest012_06;
	CleanupStack::PushL(step012_06);
	doTestStepWithHeapFailureL( *step012_06, KErrArgument);
	if( step012_06->TestStepResult() == EFail )
		SetTestStepResult(EFail);	CleanupStack::PopAndDestroy(step012_06);

	return TestStepResult();	

}