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 

    19 // Test code for encryption in Database

    20 

    21 #include <e32test.h>

    22 #include <f32file.h>

    23 #include <d32comm.h>

    24 #include <cdbcols.h>

    25 #include <commdb.h>

    26 #include <cdblen.h>

    27 

    28 #include "TE_EncrptSteps.h"

    29 

    30 

    31 #define pass1	_L("PASS")

    32 #define pass2	_L("1234567890")

    33 #define pass3	_L("abcdefghijklmnopqrstuvwxyz")

    34 #define pass4	_L("!\xa3$%^&*()_+-=?><,.@~:;'#|")

    35 

    36 

    37 CTE_CreateEntries::CTE_CreateEntries()

    38 	{

    39 	SetTestStepName(KCreateEntries);

    40 	}

    41 

    42 CTE_CreateEntries::~CTE_CreateEntries()

    43 	{	

    44 	}

    45 

    46 enum TVerdict CTE_CreateEntries::doTestStepL()

    47 	{

    48 	

    49 	TUint32 id1 = 0;  

    50 	TUint32 id2 = 0; 

    51 		

    52 	INFO_PRINTF1(_L("Testing encryption"));

    53 

    54     CCommsDatabase* db=CCommsDatabase::NewL(EDatabaseTypeIAP);

    55 	CleanupStack::PushL(db);

    56 	User::LeaveIfError(db->BeginTransaction());

    57 	

    58 	CCommsDbTableView* table=db->OpenTableLC(TPtrC(DIAL_OUT_ISP));

    59 	Test(table->InsertRecord(id1)==KErrNone);

    60 	table->WriteTextL(TPtrC(COMMDB_NAME),_L("Test 1"));

    61 	table->WriteBoolL(TPtrC(ISP_DIAL_RESOLUTION),ETrue);

    62 	table->WriteBoolL(TPtrC(ISP_USE_LOGIN_SCRIPT),EFalse);

    63 	table->WriteBoolL(TPtrC(ISP_PROMPT_FOR_LOGIN),EFalse);

    64 	table->WriteTextL(TPtrC(ISP_LOGIN_NAME),_L("AnnW"));

    65 	table->WriteTextL(TPtrC(ISP_LOGIN_PASS),pass1);

    66 	table->WriteBoolL(TPtrC(ISP_IF_PROMPT_FOR_AUTH),ETrue);

    67 	table->WriteTextL(TPtrC(ISP_IF_AUTH_NAME),_L("RasUser"));

    68 	table->WriteTextL(TPtrC(ISP_IF_AUTH_PASS),pass2);

    69 	table->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER),ETrue);

    70 	table->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER),ETrue);

    71 	table->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER),ETrue);

    72 	Test(table->PutRecordChanges()==KErrNone);

    73 

    74 	Test(table->InsertRecord(id2)==KErrNone);

    75 	table->WriteTextL(TPtrC(COMMDB_NAME),_L("Test 2"));

    76 	table->WriteBoolL(TPtrC(ISP_DIAL_RESOLUTION),ETrue);

    77 	table->WriteBoolL(TPtrC(ISP_USE_LOGIN_SCRIPT),EFalse);

    78 	table->WriteBoolL(TPtrC(ISP_PROMPT_FOR_LOGIN),EFalse);

    79 	table->WriteTextL(TPtrC(ISP_LOGIN_NAME),_L("AnnW"));

    80 	table->WriteTextL(TPtrC(ISP_LOGIN_PASS),pass3);

    81 	table->WriteBoolL(TPtrC(ISP_IF_PROMPT_FOR_AUTH),ETrue);

    82 	table->WriteTextL(TPtrC(ISP_IF_AUTH_NAME),_L("RasUser"));

    83 	table->WriteTextL(TPtrC(ISP_IF_AUTH_PASS),pass4);

    84 	table->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER),ETrue);

    85 	table->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER),ETrue);

    86 	table->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER),ETrue);

    87 	Test(table->PutRecordChanges()==KErrNone);

    88 

    89 	Test(db->CommitTransaction()==KErrNone);

    90 	CleanupStack::PopAndDestroy(2);

    91 

    92 	db = CCommsDatabase::NewL(EDatabaseTypeIAP);

    93 		CleanupStack::PushL(db);

    94 	

    95 	table = db->OpenViewMatchingUintLC(TPtrC(DIAL_OUT_ISP), TPtrC(COMMDB_ID), id1);

    96 

    97 	if (table->GotoFirstRecord() == KErrNone)

    98 		table->DeleteRecord();

    99 

   100 	CleanupStack::PopAndDestroy(table);

   101 	table = NULL;

   102 	table = db->OpenViewMatchingUintLC(TPtrC(DIAL_OUT_ISP), TPtrC(COMMDB_ID), id2);

   103 

   104 	if (table->GotoFirstRecord() == KErrNone)

   105 		table->DeleteRecord();

   106 

   107 	CleanupStack::PopAndDestroy(2);

   108 

   109 	INFO_PRINTF1(_L("IAP Entries Added Successfully"));

   110 

   111     SetTestStepResult(EPass);	

   112     

   113     return TestStepResult();

   114 	}

   115 

   116 

   117 CTE_CheckPasswords::CTE_CheckPasswords()

   118 	{

   119 	SetTestStepName(KCheckPasswords);

   120 	}

   121 

   122 CTE_CheckPasswords::~CTE_CheckPasswords()

   123 	{	

   124 	}

   125 

   126 enum TVerdict CTE_CheckPasswords::doTestStepL()

   127 	{

   128 

   129 	INFO_PRINTF1(_L("Checking passwords"));

   130 

   131 	TUint32 id1 = 0;  

   132 	TUint32 id2 = 0;

   133 

   134 	CCommsDatabase* db=CCommsDatabase::NewL(EDatabaseTypeIAP);

   135 	CleanupStack::PushL(db);

   136 	User::LeaveIfError(db->BeginTransaction());

   137 	

   138 	CCommsDbTableView* table=db->OpenTableLC(TPtrC(DIAL_OUT_ISP));

   139 	Test(table->InsertRecord(id1)==KErrNone);

   140 	table->WriteTextL(TPtrC(COMMDB_NAME),_L("Test 1"));

   141 	table->WriteBoolL(TPtrC(ISP_DIAL_RESOLUTION),ETrue);

   142 	table->WriteBoolL(TPtrC(ISP_USE_LOGIN_SCRIPT),EFalse);

   143 	table->WriteBoolL(TPtrC(ISP_PROMPT_FOR_LOGIN),EFalse);

   144 	table->WriteTextL(TPtrC(ISP_LOGIN_NAME),_L("AnnW"));

   145 	table->WriteTextL(TPtrC(ISP_LOGIN_PASS),pass1);

   146 	table->WriteBoolL(TPtrC(ISP_IF_PROMPT_FOR_AUTH),ETrue);

   147 	table->WriteTextL(TPtrC(ISP_IF_AUTH_NAME),_L("RasUser"));

   148 	table->WriteTextL(TPtrC(ISP_IF_AUTH_PASS),pass2);

   149 	table->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER),ETrue);

   150 	table->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER),ETrue);

   151 	table->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER),ETrue);

   152 	Test(table->PutRecordChanges()==KErrNone);

   153 

   154 	Test(table->InsertRecord(id2)==KErrNone);

   155 	table->WriteTextL(TPtrC(COMMDB_NAME),_L("Test 2"));

   156 	table->WriteBoolL(TPtrC(ISP_DIAL_RESOLUTION),ETrue);

   157 	table->WriteBoolL(TPtrC(ISP_USE_LOGIN_SCRIPT),EFalse);

   158 	table->WriteBoolL(TPtrC(ISP_PROMPT_FOR_LOGIN),EFalse);

   159 	table->WriteTextL(TPtrC(ISP_LOGIN_NAME),_L("AnnW"));

   160 	table->WriteTextL(TPtrC(ISP_LOGIN_PASS),pass3);

   161 	table->WriteBoolL(TPtrC(ISP_IF_PROMPT_FOR_AUTH),ETrue);

   162 	table->WriteTextL(TPtrC(ISP_IF_AUTH_NAME),_L("RasUser"));

   163 	table->WriteTextL(TPtrC(ISP_IF_AUTH_PASS),pass4);

   164 	table->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER),ETrue);

   165 	table->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER),ETrue);

   166 	table->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER),ETrue);

   167 	Test(table->PutRecordChanges()==KErrNone);

   168 

   169 	Test(db->CommitTransaction()==KErrNone);

   170 	CleanupStack::PopAndDestroy(2);

   171 

   172 	db=CCommsDatabase::NewL(EDatabaseTypeIAP);

   173 	CleanupStack::PushL(db);

   174 	

   175 	table=db->OpenViewMatchingUintLC(TPtrC(DIAL_OUT_ISP), TPtrC(COMMDB_ID), id1);

   176 

   177 	TBuf<KCommsDbSvrMaxFieldLength> password;

   178 	Test(table->GotoFirstRecord()==KErrNone);

   179 	table->ReadTextL(TPtrC(ISP_LOGIN_PASS),password);

   180 	Test(password==pass1);

   181 	table->ReadTextL(TPtrC(ISP_IF_AUTH_PASS),password);

   182 	Test(password==pass2);

   183 

   184 	CleanupStack::PopAndDestroy(table);

   185 	table = NULL;

   186 	table = db->OpenViewMatchingUintLC(TPtrC(DIAL_OUT_ISP), TPtrC(COMMDB_ID), id2);

   187 

   188 	Test(table->GotoFirstRecord()== KErrNone);

   189 	table->ReadTextL(TPtrC(ISP_LOGIN_PASS),password);

   190 	Test(password==pass3);

   191 	table->ReadTextL(TPtrC(ISP_IF_AUTH_PASS),password);

   192 	Test(password==pass4);

   193 	

   194 	CleanupStack::PopAndDestroy(2);

   195 

   196 	db = CCommsDatabase::NewL(EDatabaseTypeIAP);

   197 	CleanupStack::PushL(db);

   198 	

   199 	table = db->OpenViewMatchingUintLC(TPtrC(DIAL_OUT_ISP), TPtrC(COMMDB_ID), id1);

   200 

   201 	if (table->GotoFirstRecord() == KErrNone)

   202 		table->DeleteRecord();

   203 

   204 	CleanupStack::PopAndDestroy(table);

   205 	table = NULL;

   206 	table = db->OpenViewMatchingUintLC(TPtrC(DIAL_OUT_ISP), TPtrC(COMMDB_ID), id2);

   207 

   208 	if (table->GotoFirstRecord() == KErrNone)

   209 		table->DeleteRecord();

   210 

   211 	CleanupStack::PopAndDestroy(2);

   212 

   213     SetTestStepResult(EPass);	

   214      

   215     return TestStepResult();

   216 	}

   217 

   218 

   219 CTE_DeleteEntries::CTE_DeleteEntries()

   220 	{

   221 	SetTestStepName(KDeleteEntries);

   222 	}

   223 

   224 CTE_DeleteEntries::~CTE_DeleteEntries()

   225 	{	

   226 	}

   227 

   228 enum TVerdict CTE_DeleteEntries::doTestStepL()

   229 	{

   230 

   231 	INFO_PRINTF1(_L("Delete the IAP entries."));

   232 

   233 	TUint32 id1 = 0;  

   234 	TUint32 id2 = 0;

   235 

   236 	CCommsDatabase* db=CCommsDatabase::NewL(EDatabaseTypeIAP);

   237 	CleanupStack::PushL(db);

   238 	User::LeaveIfError(db->BeginTransaction());

   239 	

   240 	CCommsDbTableView* table=db->OpenTableLC(TPtrC(DIAL_OUT_ISP));

   241 	Test(table->InsertRecord(id1)==KErrNone);

   242 	table->WriteTextL(TPtrC(COMMDB_NAME),_L("Test 1"));

   243 	table->WriteBoolL(TPtrC(ISP_DIAL_RESOLUTION),ETrue);

   244 	table->WriteBoolL(TPtrC(ISP_USE_LOGIN_SCRIPT),EFalse);

   245 	table->WriteBoolL(TPtrC(ISP_PROMPT_FOR_LOGIN),EFalse);

   246 	table->WriteTextL(TPtrC(ISP_LOGIN_NAME),_L("AnnW"));

   247 	table->WriteTextL(TPtrC(ISP_LOGIN_PASS),pass1);

   248 	table->WriteBoolL(TPtrC(ISP_IF_PROMPT_FOR_AUTH),ETrue);

   249 	table->WriteTextL(TPtrC(ISP_IF_AUTH_NAME),_L("RasUser"));

   250 	table->WriteTextL(TPtrC(ISP_IF_AUTH_PASS),pass2);

   251 	table->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER),ETrue);

   252 	table->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER),ETrue);

   253 	table->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER),ETrue);

   254 	Test(table->PutRecordChanges()==KErrNone);

   255 

   256 	Test(table->InsertRecord(id2)==KErrNone);

   257 	table->WriteTextL(TPtrC(COMMDB_NAME),_L("Test 2"));

   258 	table->WriteBoolL(TPtrC(ISP_DIAL_RESOLUTION),ETrue);

   259 	table->WriteBoolL(TPtrC(ISP_USE_LOGIN_SCRIPT),EFalse);

   260 	table->WriteBoolL(TPtrC(ISP_PROMPT_FOR_LOGIN),EFalse);

   261 	table->WriteTextL(TPtrC(ISP_LOGIN_NAME),_L("AnnW"));

   262 	table->WriteTextL(TPtrC(ISP_LOGIN_PASS),pass3);

   263 	table->WriteBoolL(TPtrC(ISP_IF_PROMPT_FOR_AUTH),ETrue);

   264 	table->WriteTextL(TPtrC(ISP_IF_AUTH_NAME),_L("RasUser"));

   265 	table->WriteTextL(TPtrC(ISP_IF_AUTH_PASS),pass4);

   266 	table->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER),ETrue);

   267 	table->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER),ETrue);

   268 	table->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER),ETrue);

   269 	Test(table->PutRecordChanges()==KErrNone);

   270 

   271 	Test(db->CommitTransaction()==KErrNone);

   272 	CleanupStack::PopAndDestroy(2);

   273 

   274     db = CCommsDatabase::NewL(EDatabaseTypeIAP);

   275 	CleanupStack::PushL(db);

   276 	

   277 	table = db->OpenViewMatchingUintLC(TPtrC(DIAL_OUT_ISP), TPtrC(COMMDB_ID), id1);

   278 

   279 	if (table->GotoFirstRecord() == KErrNone)

   280 		table->DeleteRecord();

   281 

   282 	CleanupStack::PopAndDestroy(table);

   283 	table = NULL;

   284 	table = db->OpenViewMatchingUintLC(TPtrC(DIAL_OUT_ISP), TPtrC(COMMDB_ID), id2);

   285 

   286 	if (table->GotoFirstRecord() == KErrNone)

   287 		table->DeleteRecord();

   288 

   289 	CleanupStack::PopAndDestroy(2);

   290 

   291 	INFO_PRINTF1(_L("IAP Entries Deleted Successfully"));

   292 

   293     SetTestStepResult(EPass);	

   294     

   295     return TestStepResult();

   296 	}

   297 

   298 

   299 

   300 

   301 

   302 

   303 

   304