commsconfig/commsdatabaseshim/TE_commdb/src/Step_011_xx.cpp
changeset 72 ae47d0499bee
equal deleted inserted replaced
68:5da8188e392b 72:ae47d0499bee
       
     1 //
       
     2 // Copyright (c) 2009 Nokia Corporation and/or its subsidiary(-ies).
       
     3 // All rights reserved.
       
     4 // This component and the accompanying materials are made available
       
     5 // under the terms of "Eclipse Public License v1.0"
       
     6 // which accompanies this distribution, and is available
       
     7 // at the URL "http://www.eclipse.org/legal/epl-v10.html".
       
     8 //
       
     9 // Initial Contributors:
       
    10 // Nokia Corporation - initial contribution.
       
    11 //
       
    12 // Contributors:
       
    13 //
       
    14 // Description:
       
    15 //
       
    16 //
       
    17 //
       
    18 // This contains CommDb Unit Test Cases 011.XX
       
    19 
       
    20 // EPOC includes
       
    21 #include <e32base.h>
       
    22 #include <commdb.h>
       
    23 
       
    24 
       
    25 // Test system includes
       
    26 #include "Teststepcommdb.h"
       
    27 #include "Step_011_xx.h"
       
    28 
       
    29 
       
    30 
       
    31 /////////////////////
       
    32 //	Test step 011.001
       
    33 /////////////////////
       
    34 
       
    35 // constructor
       
    36 CCommDbTest011_01::CCommDbTest011_01()
       
    37 	{
       
    38 	// store the name of this test case
       
    39 	SetTestStepName(_L("step_011_01"));
       
    40 	}
       
    41 
       
    42 // destructor
       
    43 CCommDbTest011_01::~CCommDbTest011_01()
       
    44 	{
       
    45 	}
       
    46 
       
    47 
       
    48 TVerdict CCommDbTest011_01::doTestStepPreambleL()
       
    49 	{	
       
    50 	openDbAndViewL(TPtrC(DIAL_OUT_ISP));
       
    51         SetTestStepResult(EPass);	return TestStepResult();
       
    52 	}
       
    53 
       
    54 
       
    55 #define HIDDEN_RECORD_TEST_VALUE	_L("This is a hidden record")
       
    56 
       
    57 TInt CCommDbTest011_01::executeStepL()
       
    58 	{
       
    59 	TInt ret=KErrGeneral;
       
    60 	TUint32 id;
       
    61 
       
    62 	//Create a hidden record in the database
       
    63 	//NB. This step will panic if the bale used is empty, so use a
       
    64 	//populated table to simplify things.
       
    65 	
       
    66 	//Try to insert a record
       
    67 	CDBLEAVE( iTheView->InsertRecord( id ), KErrNone );
       
    68 
       
    69 	//Insert some text
       
    70 	iTheView->WriteTextL( TPtrC(COMMDB_NAME), HIDDEN_RECORD_TEST_VALUE ) ;
       
    71 
       
    72 	//Must write to these columns as they cannot hold null values
       
    73 	iTheView->WriteBoolL(TPtrC(ISP_DIAL_RESOLUTION),ETrue);
       
    74 	iTheView->WriteBoolL(TPtrC(ISP_USE_LOGIN_SCRIPT),ETrue);
       
    75 	iTheView->WriteBoolL(TPtrC(ISP_PROMPT_FOR_LOGIN),EFalse);
       
    76 //	iTheView->WriteTextL(TPtrC(ISP_IF_NAME), _L("PPP") );
       
    77 	iTheView->WriteBoolL(TPtrC(ISP_IF_PROMPT_FOR_AUTH),EFalse);
       
    78 	iTheView->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER),ETrue);
       
    79 	iTheView->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER),ETrue);
       
    80 	iTheView->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER),ETrue);
       
    81 
       
    82 	//Store the record as hidden
       
    83 	CDBLEAVE( iTheView->PutRecordChanges(ETrue), KErrNone );
       
    84 
       
    85 	//Now search through the table looking for this record
       
    86 	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );
       
    87 
       
    88 	TBuf<KCommsDbSvrMaxFieldLength> value;
       
    89 	do {
       
    90 
       
    91 		iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
       
    92 		if ( !value.Compare(HIDDEN_RECORD_TEST_VALUE) )
       
    93 			{
       
    94 				//Found the record, even though it is hidden
       
    95 				ret = KErrGeneral;
       
    96 				break;
       
    97 			}
       
    98 		//Move on to the next record
       
    99 		TRAPD(r, ret = iTheView->GotoNextRecord() );
       
   100 		if( r!= KErrNone )
       
   101 			User::Leave( r );
       
   102 		} while (ret == KErrNone ) ;
       
   103 
       
   104 	return ret;
       
   105 	}
       
   106 
       
   107 
       
   108 
       
   109 TVerdict CCommDbTest011_01::doTestStepL( )
       
   110 	{
       
   111 	INFO_PRINTF1(_L("Step 011.01 called "));
       
   112 
       
   113 		
       
   114 	if ( executeStepL() == KErrNotFound )
       
   115 		SetTestStepResult(EPass);	else
       
   116 		SetTestStepResult(EFail);
       
   117 
       
   118 	return TestStepResult();
       
   119 	}
       
   120 
       
   121  /////////////////////
       
   122  //	Test step 011.02
       
   123  /////////////////////
       
   124  
       
   125  // constructor
       
   126 CCommDbTest011_02::CCommDbTest011_02()
       
   127  	{
       
   128  	// store the name of this test case
       
   129 	SetTestStepName(_L("step_011_02"));
       
   130  	}
       
   131  
       
   132  // destructor
       
   133 CCommDbTest011_02::~CCommDbTest011_02()
       
   134  	{
       
   135  	}
       
   136  
       
   137 TVerdict CCommDbTest011_02::doTestStepPreambleL()
       
   138  	{	
       
   139  	openDbAndViewL(TPtrC(DIAL_OUT_ISP));
       
   140          SetTestStepResult(EPass); 	return TestStepResult();
       
   141  	}
       
   142  
       
   143  
       
   144 TInt CCommDbTest011_02::executeStepL()
       
   145  	{
       
   146  	TInt ret=KErrGeneral;
       
   147  	TUint32 id;
       
   148 
       
   149 	//Create a hidden record in the database, try to find it,
       
   150 	//make a call to ShowHiddenRecords the try to find the record again
       
   151 	
       
   152 	//Try to insert a test record
       
   153 	CDBLEAVE( iTheView->InsertRecord( id ), KErrNone );
       
   154 
       
   155 	//Insert some text
       
   156 	iTheView->WriteTextL( TPtrC(COMMDB_NAME), HIDDEN_RECORD_TEST_VALUE );
       
   157 
       
   158 	//Must write to these columns as they cannot hold null values
       
   159 	iTheView->WriteBoolL(TPtrC(ISP_DIAL_RESOLUTION),ETrue);
       
   160 	iTheView->WriteBoolL(TPtrC(ISP_USE_LOGIN_SCRIPT),ETrue);
       
   161 	iTheView->WriteBoolL(TPtrC(ISP_PROMPT_FOR_LOGIN),EFalse);
       
   162 //	iTheView->WriteTextL(TPtrC(ISP_IF_NAME), _L("PPP") );
       
   163 	iTheView->WriteBoolL(TPtrC(ISP_IF_PROMPT_FOR_AUTH),EFalse);
       
   164 	iTheView->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER),ETrue);
       
   165 	iTheView->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER),ETrue);
       
   166 	iTheView->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER),ETrue);
       
   167 
       
   168 	//Store the record as hidden
       
   169 	CDBLEAVE( iTheView->PutRecordChanges(ETrue), KErrNone );
       
   170 
       
   171 	//Now search through the table looking for this record
       
   172 	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );
       
   173 
       
   174 	//This first search through the table should not find the hidden record
       
   175 	TBuf<KCommsDbSvrMaxFieldLength> value;
       
   176 	do {
       
   177 
       
   178 		iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
       
   179 		if ( !value.Compare(HIDDEN_RECORD_TEST_VALUE) )
       
   180 			{
       
   181 				//Found the record
       
   182 				ret = KErrGeneral;
       
   183 				break;
       
   184 			}
       
   185 		//Move on to the next record
       
   186 		TRAPD(r, ret= iTheView->GotoNextRecord() );
       
   187 		if ( r!=KErrNone )
       
   188 			User::Leave( r );
       
   189 
       
   190 		}while(ret == KErrNone );
       
   191 	
       
   192 	if ( ret == KErrNotFound )
       
   193 		{
       
   194 
       
   195 		//Search again, but this this time we'll show the hidden records
       
   196 		delete iTheView;
       
   197 		iTheView = 0;
       
   198 
       
   199 		iTheDb->ShowHiddenRecords();
       
   200 		iTheView=iTheDb->OpenTableLC( TPtrC(DIAL_OUT_ISP) );
       
   201 		CleanupStack::Pop();
       
   202 
       
   203 		CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );
       
   204 		TBuf<KCommsDbSvrMaxFieldLength> value;
       
   205 
       
   206 		do {
       
   207 			iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
       
   208 			if ( !value.Compare(HIDDEN_RECORD_TEST_VALUE) )
       
   209 				{
       
   210 					//Found the record
       
   211 					ret = KErrNone;
       
   212 
       
   213 					//Change the record not to be hidden for the test 11_03
       
   214 					CDBLEAVE( iTheView->UpdateRecord(), KErrNone );
       
   215 					CDBLEAVE( iTheView->PutRecordChanges(), KErrNone );
       
   216 					break;
       
   217 				}
       
   218 			//Move on to the next record
       
   219 			TRAPD(r, ret = iTheView->GotoNextRecord() )
       
   220 			if ( r!=KErrNone )
       
   221 				User::Leave( r );
       
   222 
       
   223 			}while( ret == KErrNone );
       
   224 		}
       
   225 
       
   226 	return ret;
       
   227 	}
       
   228 
       
   229 TVerdict CCommDbTest011_02::doTestStepL( )
       
   230 	{
       
   231 	INFO_PRINTF1(_L("Step 011.02 called "));
       
   232 
       
   233 	if ( executeStepL() == KErrNone )
       
   234 		SetTestStepResult(EPass);	else
       
   235 		SetTestStepResult(EFail);
       
   236 
       
   237 	return TestStepResult();
       
   238 	}
       
   239 
       
   240 
       
   241 /////////////////////
       
   242 //	Test step 011.03
       
   243 /////////////////////
       
   244 
       
   245 // constructor
       
   246 CCommDbTest011_03::CCommDbTest011_03()
       
   247 	{
       
   248 	// store the name of this test case
       
   249 	SetTestStepName(_L("step_011_03"));
       
   250 	}
       
   251 
       
   252 // destructor
       
   253 CCommDbTest011_03::~CCommDbTest011_03()
       
   254 	{
       
   255 	}
       
   256 
       
   257 TVerdict CCommDbTest011_03::doTestStepPreambleL()
       
   258 	{	
       
   259 	openDbAndViewL(TPtrC(DIAL_OUT_ISP));
       
   260         SetTestStepResult(EPass);	return TestStepResult();
       
   261 	}
       
   262 
       
   263 
       
   264 TInt CCommDbTest011_03::executeStepL()
       
   265 	{
       
   266 	TInt ret=KErrGeneral;
       
   267 
       
   268 	//Check if a record from test 11_02 is readable again
       
   269 	
       
   270 	//Now search through the table looking for this record
       
   271 	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );
       
   272 
       
   273 	//This first search through the table should not find the hidden record
       
   274 	TBuf<KCommsDbSvrMaxFieldLength> value;
       
   275 	do {
       
   276 
       
   277 		iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );
       
   278 		if ( !value.Compare(HIDDEN_RECORD_TEST_VALUE) )
       
   279 			{
       
   280 				//Found the record
       
   281 				ret = KErrNone;
       
   282 				break;
       
   283 			}
       
   284 		//Move on to the next record
       
   285 		TRAPD(r, ret= iTheView->GotoNextRecord() );
       
   286 		if ( r!=KErrNone )
       
   287 			User::Leave( r );
       
   288 
       
   289 		}while(ret == KErrNone );
       
   290 
       
   291 	return ret;
       
   292 	}
       
   293 
       
   294 
       
   295 TVerdict CCommDbTest011_03::doTestStepL( )
       
   296 	{
       
   297 	INFO_PRINTF1(_L("Step 011.03 called "));
       
   298 
       
   299 	if ( executeStepL() == KErrNone )
       
   300 		SetTestStepResult(EPass);	else
       
   301 		SetTestStepResult(EFail);
       
   302 
       
   303 	return TestStepResult();
       
   304 	}
       
   305 
       
   306 
       
   307 /////////////////////
       
   308 //	Test step 011.04
       
   309 /////////////////////
       
   310 
       
   311 // constructor
       
   312 CCommDbTest011_04::CCommDbTest011_04()
       
   313 	{
       
   314 	// store the name of this test case
       
   315 	SetTestStepName(_L("step_011_04"));
       
   316 	}
       
   317 
       
   318 // destructor
       
   319 CCommDbTest011_04::~CCommDbTest011_04()
       
   320 	{
       
   321 	}
       
   322 
       
   323 TVerdict CCommDbTest011_04::doTestStepL( )
       
   324 	{
       
   325 	INFO_PRINTF1(_L("Step 011.04 called "));
       
   326 
       
   327 	SetTestStepResult(EPass);
       
   328 	// Heap test for 011.01
       
   329 
       
   330 	CCommDbTest011_01* step011_01 = new CCommDbTest011_01;
       
   331 	CleanupStack::PushL(step011_01);
       
   332 	if ( doTestStepWithHeapFailureL( *step011_01, KErrNotFound) == EFail )
       
   333 		SetTestStepResult(EFail);	CleanupStack::PopAndDestroy(step011_01);
       
   334 
       
   335 
       
   336 	// Heap test for 011.02
       
   337 	CCommDbTest011_02* step011_02 = new CCommDbTest011_02;
       
   338 	CleanupStack::PushL(step011_02);
       
   339 	if ( doTestStepWithHeapFailureL( *step011_02, KErrNone) == EFail )
       
   340 		SetTestStepResult(EFail);	CleanupStack::PopAndDestroy(step011_02);
       
   341 
       
   342 	// Heap test for 011.03
       
   343 	CCommDbTest011_03* step011_03 = new CCommDbTest011_03;
       
   344 	CleanupStack::PushL(step011_03);
       
   345 	if ( doTestStepWithHeapFailureL( *step011_03, KErrNone) == EFail )
       
   346 		SetTestStepResult(EFail);	CleanupStack::PopAndDestroy(step011_03);
       
   347 
       
   348 	return TestStepResult();	
       
   349 
       
   350 }