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

// EPOC includes
#include <commdb.h>
#include <d32dbms.h>
#include <badesca.h>
#include <cdbstore.h>

#ifdef SYMBIAN_OLD_EXPORT_LOCATION
#include <comms-infras/commdb/protection/protectdb.h>
#include <comms-infras/commdb/protection/protectcpdb.h>
#else
//these headers are user includes in the new env.
#include "protectdb.h"
#include "protectcpdb.h"
#endif

// Test system includes
#include <networking/log.h>
#include <networking/teststep.h>
#include "Teststepcommdb.h"
#include "TestSuiteCommdb.h"
#include "step_063_xx.h"

//
//	Test step 063.01
//

// constructor
CCommDbTest063_01::CCommDbTest063_01()
	{
	// store the name of this test case
	iTestStepName = _L("step_063_01");
	}

// destructor
CCommDbTest063_01::~CCommDbTest063_01()
	{}
	
enum TVerdict CCommDbTest063_01::doTestStepL( void )
	{
	iTestStepResult = EPass;

	iTheProtectedDb = CCommsDatabaseProtect::NewL();

	if(iTheProtectedDb->ProtectTable(TPtrC(DIAL_OUT_ISP))!=KErrNone)
		{iTestStepResult = EFail;}

	RDbRowSet::TAccess rowSet = RDbRowSet::EUpdatable;
	TRAPD(ret, rowSet = iTheProtectedDb->GetTableAccessL(TPtrC(DIAL_OUT_ISP)));

	if (ret != KErrNone || rowSet != RDbRowSet::EReadOnly)
		{
		iTestStepResult = EFail;
		}

	delete iTheProtectedDb;
	iTheProtectedDb=NULL;

	return iTestStepResult;
	}

//
//	Test step 063.02
//

// constructor
CCommDbTest063_02::CCommDbTest063_02()
	{
	// store the name of this test case
	iTestStepName = _L("step_063_02");
	}

// destructor
CCommDbTest063_02::~CCommDbTest063_02()
	{}
	
enum TVerdict CCommDbTest063_02::doTestStepL( void )
	{
	iTestStepResult = EPass;

	iTheProtectedDb = CCommsDatabaseProtect::NewL();

	if(iTheProtectedDb->UnProtectTable(TPtrC(DIAL_OUT_ISP))!=KErrNone)
		{
		iTestStepResult = EFail;
		}

	RDbRowSet::TAccess rowSet = RDbRowSet::EReadOnly;
	TRAPD(ret, rowSet = iTheProtectedDb->GetTableAccessL(TPtrC(DIAL_OUT_ISP)));

	if (ret != KErrNone || rowSet != RDbRowSet::EUpdatable)
		{
		iTestStepResult = EFail;
		}

	delete iTheProtectedDb;
	iTheProtectedDb=NULL;

	return iTestStepResult;
	}

//
//	Test step 063.03
//

// constructor
CCommDbTest063_03::CCommDbTest063_03()
	{
	// store the name of this test case
	iTestStepName = _L("step_063_03");
	}

// destructor
CCommDbTest063_03::~CCommDbTest063_03()
	{}
	
enum TVerdict CCommDbTest063_03::doTestStepL( void )
	{
	iTestStepResult = EPass;

	iTheProtectedDb = CCommsDatabaseProtect::NewL();

	//Construct table list
	CPtrCArray* tableArray;
	tableArray = new (ELeave) CPtrCArray(2);
	CleanupStack::PushL(tableArray);

	TRAPD(ret, tableArray->InsertL(0,DIAL_OUT_ISP));
	if (ret != KErrNone)
		{
		iTestStepResult = EFail;
		CleanupStack::PopAndDestroy(tableArray);
		delete iTheProtectedDb;
		iTheProtectedDb=NULL;
		return iTestStepResult;
		}

	TRAP(ret, tableArray->InsertL(1,DIAL_IN_ISP));
	if (ret != KErrNone)
		{
		iTestStepResult = EFail;
		CleanupStack::PopAndDestroy(tableArray);
		delete iTheProtectedDb;
		iTheProtectedDb=NULL;
		return iTestStepResult;
		}
	
	if(iTheProtectedDb->ProtectTables(*tableArray) != KErrNone)
		{
		iTestStepResult = EFail;
		CleanupStack::PopAndDestroy(tableArray);
		delete iTheProtectedDb;
		iTheProtectedDb=NULL;
		return iTestStepResult;
		}

	RDbRowSet::TAccess rowSet = RDbRowSet::EUpdatable;
	TRAP(ret, rowSet = iTheProtectedDb->GetTableAccessL(TPtrC(DIAL_IN_ISP)));

	if (ret != KErrNone || rowSet != RDbRowSet::EReadOnly)
		{
		iTestStepResult = EFail;
		}

	CleanupStack::PopAndDestroy(tableArray);

	delete iTheProtectedDb;
	iTheProtectedDb=NULL;

	return iTestStepResult;
	}

//
//	Test step 063.04
//

// constructor
CCommDbTest063_04::CCommDbTest063_04()
	{
	// store the name of this test case
	iTestStepName = _L("step_063_04");
	}

// destructor
CCommDbTest063_04::~CCommDbTest063_04()
	{}
	
enum TVerdict CCommDbTest063_04::doTestStepL( void )
	{
	iTestStepResult = EPass;

	iTheProtectedDb = CCommsDatabaseProtect::NewL();

	//Construct table list
	CPtrCArray* tableArray;
	tableArray = new (ELeave) CPtrCArray(2);
	CleanupStack::PushL(tableArray);

	TRAPD(ret, tableArray->InsertL(0,DIAL_OUT_ISP));
	if (ret != KErrNone)
		{
		iTestStepResult = EFail;
		CleanupStack::PopAndDestroy(tableArray);
		delete iTheProtectedDb;
		iTheProtectedDb=NULL;
		return iTestStepResult;
		}

	TRAP(ret, tableArray->InsertL(1,DIAL_IN_ISP));
	if (ret != KErrNone)
		{
		iTestStepResult = EFail;
		CleanupStack::PopAndDestroy(tableArray);
		delete iTheProtectedDb;
		iTheProtectedDb=NULL;
		return iTestStepResult;
		}

	if(iTheProtectedDb->UnprotectTables(*tableArray) != KErrNone)
		{
		iTestStepResult = EFail;
		CleanupStack::PopAndDestroy(tableArray);
		delete iTheProtectedDb;
		iTheProtectedDb=NULL;
		return iTestStepResult;
		}

	RDbRowSet::TAccess rowSet = RDbRowSet::EReadOnly;
	TRAP(ret, rowSet = iTheProtectedDb->GetTableAccessL(TPtrC(DIAL_IN_ISP)));

	if (ret != KErrNone || rowSet != RDbRowSet::EUpdatable)
		{
		iTestStepResult = EFail;
		}

	CleanupStack::PopAndDestroy(tableArray);

	delete iTheProtectedDb;
	iTheProtectedDb=NULL;

	return iTestStepResult;
	}

//
//	Test step 063.05
//

// constructor
CCommDbTest063_05::CCommDbTest063_05()
	{
	// store the name of this test case
	iTestStepName = _L("step_063_05");
	}

// destructor
CCommDbTest063_05::~CCommDbTest063_05()
	{
	}
	
enum TVerdict CCommDbTest063_05::doTestStepL( void )
	{	
	iTestStepResult = EPass;
	TBool val=0;
	iTheProtectedDb = CCommsDatabaseProtect::NewL(val);
	if(iTheProtectedDb->ProtectTable(TPtrC(DIAL_OUT_ISP)) != KErrNone)
		{
		iTestStepResult = EFail;
		}
	RDbRowSet::TAccess rowSet = RDbRowSet::EUpdatable;
	TRAPD(ret, rowSet = iTheProtectedDb->GetTableAccessL(TPtrC(DIAL_OUT_ISP)));
	if (ret != KErrNone || rowSet != RDbRowSet::EReadOnly)
		{
		iTestStepResult = EFail;
		}
	delete iTheProtectedDb;
	iTheProtectedDb=NULL;
    return iTestStepResult;
	}
		
	//
//	Test step 063.06
//

// constructor
CCommDbTest063_06::CCommDbTest063_06()
	{
	// store the name of this test case
	iTestStepName = _L("step_063_06");
	}

// destructor
CCommDbTest063_06::~CCommDbTest063_06()
	{
	}
	
enum TVerdict CCommDbTest063_06::doTestStepL( void )
	{
	iTestStepResult = EPass;
    TBool val=0;
	iTheProtectedDb = CCommsDatabaseProtect::NewL(val);
	if(iTheProtectedDb->UnProtectTable(TPtrC(DIAL_OUT_ISP)) != KErrNone)
		{
		iTestStepResult = EFail;
		}
	RDbRowSet::TAccess rowSet = RDbRowSet::EReadOnly;
	TRAPD(ret, rowSet = iTheProtectedDb->GetTableAccessL(TPtrC(DIAL_OUT_ISP)));
	if (ret != KErrNone || rowSet != RDbRowSet::EUpdatable)
		{
		iTestStepResult = EFail;
		}
	delete iTheProtectedDb;
	iTheProtectedDb=NULL;
	return iTestStepResult;
	}

//
//	Test step 063.07
//

// constructor
CCommDbTest063_07::CCommDbTest063_07()
	{
	// store the name of this test case
	iTestStepName = _L("step_063_07");
	}

// destructor
CCommDbTest063_07::~CCommDbTest063_07()
	{
	}
	
enum TVerdict CCommDbTest063_07::doTestStepL( void )
	{
	iTestStepResult = EPass;
	TBool val=0;
	iTheProtectedDb = CCommsDatabaseProtect::NewL(val);
	//Construct table list
	CPtrCArray* tableArray = new (ELeave) CPtrCArray(2);
	CleanupStack::PushL(tableArray);
	TRAPD(ret, tableArray->InsertL(0,DIAL_OUT_ISP));
	if (ret != KErrNone)
		{
		iTestStepResult = EFail;
		CleanupStack::PopAndDestroy(tableArray);
		delete iTheProtectedDb;
		iTheProtectedDb=NULL;
		return iTestStepResult;
		}
	TRAP(ret, tableArray->InsertL(1,DIAL_IN_ISP));
	if (ret != KErrNone)
		{
		iTestStepResult = EFail;
		CleanupStack::PopAndDestroy(tableArray);
		delete iTheProtectedDb;
		iTheProtectedDb=NULL;
		return iTestStepResult;
		}	
	if(iTheProtectedDb->ProtectTables(*tableArray) != KErrNone)
		{
		iTestStepResult = EFail;
		CleanupStack::PopAndDestroy(tableArray);
		delete iTheProtectedDb;
		iTheProtectedDb=NULL;
		return iTestStepResult;
		}
	RDbRowSet::TAccess rowSet = RDbRowSet::EUpdatable;
	TRAP(ret, rowSet = iTheProtectedDb->GetTableAccessL(TPtrC(DIAL_IN_ISP)));
	if (ret != KErrNone || rowSet != RDbRowSet::EReadOnly)
		{
		iTestStepResult = EFail;
		}
	CleanupStack::PopAndDestroy(tableArray);
	delete iTheProtectedDb;
	iTheProtectedDb=NULL;
	return iTestStepResult;
	}

//
//	Test step 063.08
//

// constructor
CCommDbTest063_08::CCommDbTest063_08()
	{
	// store the name of this test case
	iTestStepName = _L("step_063_08");
	}

// destructor
CCommDbTest063_08::~CCommDbTest063_08()
	{
	}
	
enum TVerdict CCommDbTest063_08::doTestStepL( void )
	{
	iTestStepResult = EPass;
	TBool val=0;
	iTheProtectedDb = CCommsDatabaseProtect::NewL(val);
	//Construct table list
	CPtrCArray* tableArray = new (ELeave) CPtrCArray(2);
	CleanupStack::PushL(tableArray);
	TRAPD(ret, tableArray->InsertL(0,DIAL_OUT_ISP));
	if (ret != KErrNone)
		{
		iTestStepResult = EFail;
		CleanupStack::PopAndDestroy(tableArray);
		delete iTheProtectedDb;
		iTheProtectedDb=NULL;
		return iTestStepResult;
		}
	TRAP(ret, tableArray->InsertL(1,DIAL_IN_ISP));
	if (ret != KErrNone)
		{
		iTestStepResult = EFail;
		CleanupStack::PopAndDestroy(tableArray);
		delete iTheProtectedDb;
		iTheProtectedDb=NULL;
		return iTestStepResult;
		}
	if(iTheProtectedDb->UnprotectTables(*tableArray) != KErrNone)
		{
		iTestStepResult = EFail;
		CleanupStack::PopAndDestroy(tableArray);
		delete iTheProtectedDb;
		iTheProtectedDb=NULL;
		return iTestStepResult;
		}
	RDbRowSet::TAccess rowSet = RDbRowSet::EReadOnly;
	TRAP(ret, rowSet = iTheProtectedDb->GetTableAccessL(TPtrC(DIAL_IN_ISP)));
	if (ret != KErrNone || rowSet != RDbRowSet::EUpdatable)
		{
		iTestStepResult = EFail;
		}
	CleanupStack::PopAndDestroy(tableArray);
	delete iTheProtectedDb;
	iTheProtectedDb=NULL;
	return iTestStepResult;
	}