--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/commsconfig/commsdatabaseshim/ts_commdb/step_063_xx.cpp	Thu Dec 17 09:22:25 2009 +0200
@@ -0,0 +1,466 @@
+// 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;
+	}
+	
+
+
+
+	
+	
+	
+	
+	
+	
+
+