commsconfig/commsdatabaseshim/TE_commdb/src/step_056_xx.cpp
author hgs
Mon, 06 Sep 2010 13:49:23 +0100
changeset 72 ae47d0499bee
permissions -rw-r--r--
201033_02
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
72
ae47d0499bee 201033_02
hgs
parents:
diff changeset
     1
//
ae47d0499bee 201033_02
hgs
parents:
diff changeset
     2
// Copyright (c) 2009 Nokia Corporation and/or its subsidiary(-ies).
ae47d0499bee 201033_02
hgs
parents:
diff changeset
     3
// All rights reserved.
ae47d0499bee 201033_02
hgs
parents:
diff changeset
     4
// This component and the accompanying materials are made available
ae47d0499bee 201033_02
hgs
parents:
diff changeset
     5
// under the terms of "Eclipse Public License v1.0"
ae47d0499bee 201033_02
hgs
parents:
diff changeset
     6
// which accompanies this distribution, and is available
ae47d0499bee 201033_02
hgs
parents:
diff changeset
     7
// at the URL "http://www.eclipse.org/legal/epl-v10.html".
ae47d0499bee 201033_02
hgs
parents:
diff changeset
     8
//
ae47d0499bee 201033_02
hgs
parents:
diff changeset
     9
// Initial Contributors:
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    10
// Nokia Corporation - initial contribution.
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    11
//
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    12
// Contributors:
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    13
//
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    14
// Description:
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    15
//
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    16
//
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    17
// 
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    18
 
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    19
// EPOC includes
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    20
#include <e32base.h>
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    21
#include <commdb.h>
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    22
#include <d32comm.h>
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    23
#include <cdbstore.h>
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    24
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    25
// Test system includes
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    26
#include "Teststepcommdb.h"
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    27
#include "comms-infras/commdb/protection/protectdb.h"
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    28
#include "comms-infras/commdb/protection/protectcpdb.h"
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    29
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    30
#include <cdbpreftable.h>
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    31
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    32
#include "step_056_xx.h"
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    33
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    34
/////////////////////
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    35
//	Test step 056.01
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    36
/////////////////////
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    37
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    38
//TestProtectRecords
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    39
CCommDbTest056_01::CCommDbTest056_01()
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    40
{
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    41
	// store the name of this test case
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    42
	SetTestStepName(_L("step_056_01"));
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    43
}
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    44
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    45
CCommDbTest056_01::~CCommDbTest056_01()
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    46
{
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    47
	delete iTheDb;
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    48
}
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    49
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    50
TVerdict CCommDbTest056_01::doTestStepPreambleL()
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    51
	{	
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    52
	iTheDb = CCommsDatabase::NewL(EDatabaseTypeIAP);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    53
        SetTestStepResult(EPass);	return TestStepResult();
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    54
	}
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    55
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    56
enum TVerdict CCommDbTest056_01::doTestStepL( void )
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    57
	{
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    58
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    59
	INFO_PRINTF1(_L("Test Normal Records : Protection .."));
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    60
	SetTestStepResult(EPass);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    61
	CCommsDbProtectTableView* table = (CCommsDbProtectTableView *)iTheDb->OpenTableLC(TPtrC(DIAL_OUT_ISP));
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    62
	TESTL(iTheDb->BeginTransaction()==KErrNone);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    63
	
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    64
	TESTL(table->GotoFirstRecord()==KErrNone);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    65
	
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    66
	// Check record security level is writable
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    67
	TInt recordAccess = 1;
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    68
	TESTL(table->GetRecordAccess(recordAccess) == KErrNone);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    69
	TESTL(recordAccess == 0);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    70
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    71
	// Modify and test the first record
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    72
	TRAPD(ret,UpdateRecordL(table,KErrNone));
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    73
	TESTL(ret == KErrNone);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    74
	
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    75
	TRAP(ret,ProtectRecordL(table,KErrNone));		
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    76
	TESTL(ret == KErrNone);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    77
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    78
		// Test that protection is effective
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    79
	TRAP(ret,UpdateRecordL(table,KErrAccessDenied));
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    80
	TESTL(ret == KErrNone);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    81
	TRAP(ret,DeleteRecordL(table,KErrAccessDenied));
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    82
	TESTL(ret == KErrNone);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    83
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    84
		// Check record security level is read only
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    85
	TESTL(table->GetRecordAccess(recordAccess) == KErrNone);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    86
	TESTL(recordAccess == 1);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    87
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    88
	table->GotoFirstRecord();
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    89
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    90
	TESTL(iTheDb->CommitTransaction()==KErrNone);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    91
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    92
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    93
	SetTestStepResult(EPass);	INFO_PRINTF1(_L("\t\tSUCCESS"));
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    94
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    95
	CleanupStack::PopAndDestroy(); 
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    96
	return TestStepResult();
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    97
	}
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    98
ae47d0499bee 201033_02
hgs
parents:
diff changeset
    99
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   100
/////////////////////
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   101
//	Test step 056.02
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   102
/////////////////////
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   103
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   104
//TestUnprotectRecords
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   105
CCommDbTest056_02::CCommDbTest056_02()
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   106
{
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   107
	// store the name of this test case
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   108
	SetTestStepName(_L("step_056_02"));
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   109
}
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   110
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   111
CCommDbTest056_02::~CCommDbTest056_02()
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   112
{
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   113
	delete iTheDb;
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   114
}
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   115
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   116
TVerdict CCommDbTest056_02::doTestStepPreambleL()
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   117
	{	
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   118
	iTheDb = CCommsDatabase::NewL(EDatabaseTypeIAP);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   119
        SetTestStepResult(EPass);	return TestStepResult();
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   120
	}
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   121
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   122
enum TVerdict CCommDbTest056_02::doTestStepL( void )
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   123
	{
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   124
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   125
	INFO_PRINTF1(_L("Test Normal Records : unprotection .."));
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   126
	SetTestStepResult(EPass);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   127
	CCommsDbProtectTableView* table = (CCommsDbProtectTableView *)iTheDb->OpenTableLC(TPtrC(DIAL_OUT_ISP));
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   128
	TESTL(iTheDb->BeginTransaction()==KErrNone);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   129
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   130
	if(table->GotoFirstRecord()==KErrNone)
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   131
		{
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   132
		// Check record state is read only
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   133
		TInt recordAccess = 0;
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   134
		TESTL(table->GetRecordAccess(recordAccess) == KErrNone);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   135
		TESTL(recordAccess == 1);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   136
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   137
		// Check record cannot be updated
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   138
		TRAPD(ret, UpdateRecordL(table,KErrAccessDenied));
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   139
		TESTL(ret == KErrNone);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   140
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   141
		// Unprotect record
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   142
		table->GotoFirstRecord();
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   143
		TRAP(ret,UnprotectRecordL(table,KErrNone));
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   144
		TESTL(ret == KErrNone);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   145
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   146
		// Check record state is now writable
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   147
		TESTL(table->GetRecordAccess(recordAccess) == KErrNone);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   148
		TESTL(recordAccess == 0);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   149
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   150
		// Test record can now be updated
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   151
		TRAP(ret,UpdateRecordL(table,KErrNone));
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   152
		TESTL(ret == KErrNone);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   153
		}
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   154
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   155
	TESTL(iTheDb->CommitTransaction()==KErrNone);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   156
	
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   157
	// Do separate transaction to check deletion is 
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   158
	// allowed as want to be able to roll this back
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   159
	TESTL(iTheDb->BeginTransaction()==KErrNone);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   160
	
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   161
	if(table->GotoFirstRecord()==KErrNone)
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   162
		{
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   163
		// Check can delete record
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   164
		TRAPD(ret,DeleteRecordL(table,KErrNone));
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   165
		TESTL(ret == KErrNone);
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   166
		} 
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   167
	
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   168
	//don't commit as don't want to risk making db empty.
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   169
	iTheDb->RollbackTransaction();
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   170
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   171
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   172
	SetTestStepResult(EPass);	INFO_PRINTF1(_L("\t\tSUCCESS"));
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   173
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   174
	CleanupStack::PopAndDestroy(); 
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   175
	return TestStepResult();
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   176
	}
ae47d0499bee 201033_02
hgs
parents:
diff changeset
   177