//
// Copyright (c) 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:
//
//
//

// Test code for encryption in Database

#include <e32test.h>
#include <f32file.h>
#include <d32comm.h>
#include <cdbcols.h>
#include <commdb.h>
#include <cdblen.h>

#include "TE_EncrptSteps.h"


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


CTE_CreateEntries::CTE_CreateEntries()
	{
	SetTestStepName(KCreateEntries);
	}

CTE_CreateEntries::~CTE_CreateEntries()
	{	
	}

enum TVerdict CTE_CreateEntries::doTestStepL()
	{
	
	TUint32 id1 = 0;  
	TUint32 id2 = 0; 
		
	INFO_PRINTF1(_L("Testing encryption"));

    CCommsDatabase* db=CCommsDatabase::NewL(EDatabaseTypeIAP);
	CleanupStack::PushL(db);
	User::LeaveIfError(db->BeginTransaction());
	
	CCommsDbTableView* table=db->OpenTableLC(TPtrC(DIAL_OUT_ISP));
	Test(table->InsertRecord(id1)==KErrNone);
	table->WriteTextL(TPtrC(COMMDB_NAME),_L("Test 1"));
	table->WriteBoolL(TPtrC(ISP_DIAL_RESOLUTION),ETrue);
	table->WriteBoolL(TPtrC(ISP_USE_LOGIN_SCRIPT),EFalse);
	table->WriteBoolL(TPtrC(ISP_PROMPT_FOR_LOGIN),EFalse);
	table->WriteTextL(TPtrC(ISP_LOGIN_NAME),_L("AnnW"));
	table->WriteTextL(TPtrC(ISP_LOGIN_PASS),pass1);
	table->WriteBoolL(TPtrC(ISP_IF_PROMPT_FOR_AUTH),ETrue);
	table->WriteTextL(TPtrC(ISP_IF_AUTH_NAME),_L("RasUser"));
	table->WriteTextL(TPtrC(ISP_IF_AUTH_PASS),pass2);
	table->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER),ETrue);
	table->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER),ETrue);
	table->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER),ETrue);
	Test(table->PutRecordChanges()==KErrNone);

	Test(table->InsertRecord(id2)==KErrNone);
	table->WriteTextL(TPtrC(COMMDB_NAME),_L("Test 2"));
	table->WriteBoolL(TPtrC(ISP_DIAL_RESOLUTION),ETrue);
	table->WriteBoolL(TPtrC(ISP_USE_LOGIN_SCRIPT),EFalse);
	table->WriteBoolL(TPtrC(ISP_PROMPT_FOR_LOGIN),EFalse);
	table->WriteTextL(TPtrC(ISP_LOGIN_NAME),_L("AnnW"));
	table->WriteTextL(TPtrC(ISP_LOGIN_PASS),pass3);
	table->WriteBoolL(TPtrC(ISP_IF_PROMPT_FOR_AUTH),ETrue);
	table->WriteTextL(TPtrC(ISP_IF_AUTH_NAME),_L("RasUser"));
	table->WriteTextL(TPtrC(ISP_IF_AUTH_PASS),pass4);
	table->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER),ETrue);
	table->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER),ETrue);
	table->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER),ETrue);
	Test(table->PutRecordChanges()==KErrNone);

	Test(db->CommitTransaction()==KErrNone);
	CleanupStack::PopAndDestroy(2);

	db = CCommsDatabase::NewL(EDatabaseTypeIAP);
		CleanupStack::PushL(db);
	
	table = db->OpenViewMatchingUintLC(TPtrC(DIAL_OUT_ISP), TPtrC(COMMDB_ID), id1);

	if (table->GotoFirstRecord() == KErrNone)
		table->DeleteRecord();

	CleanupStack::PopAndDestroy(table);
	table = NULL;
	table = db->OpenViewMatchingUintLC(TPtrC(DIAL_OUT_ISP), TPtrC(COMMDB_ID), id2);

	if (table->GotoFirstRecord() == KErrNone)
		table->DeleteRecord();

	CleanupStack::PopAndDestroy(2);

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

    SetTestStepResult(EPass);	
    
    return TestStepResult();
	}


CTE_CheckPasswords::CTE_CheckPasswords()
	{
	SetTestStepName(KCheckPasswords);
	}

CTE_CheckPasswords::~CTE_CheckPasswords()
	{	
	}

enum TVerdict CTE_CheckPasswords::doTestStepL()
	{

	INFO_PRINTF1(_L("Checking passwords"));

	TUint32 id1 = 0;  
	TUint32 id2 = 0;

	CCommsDatabase* db=CCommsDatabase::NewL(EDatabaseTypeIAP);
	CleanupStack::PushL(db);
	User::LeaveIfError(db->BeginTransaction());
	
	CCommsDbTableView* table=db->OpenTableLC(TPtrC(DIAL_OUT_ISP));
	Test(table->InsertRecord(id1)==KErrNone);
	table->WriteTextL(TPtrC(COMMDB_NAME),_L("Test 1"));
	table->WriteBoolL(TPtrC(ISP_DIAL_RESOLUTION),ETrue);
	table->WriteBoolL(TPtrC(ISP_USE_LOGIN_SCRIPT),EFalse);
	table->WriteBoolL(TPtrC(ISP_PROMPT_FOR_LOGIN),EFalse);
	table->WriteTextL(TPtrC(ISP_LOGIN_NAME),_L("AnnW"));
	table->WriteTextL(TPtrC(ISP_LOGIN_PASS),pass1);
	table->WriteBoolL(TPtrC(ISP_IF_PROMPT_FOR_AUTH),ETrue);
	table->WriteTextL(TPtrC(ISP_IF_AUTH_NAME),_L("RasUser"));
	table->WriteTextL(TPtrC(ISP_IF_AUTH_PASS),pass2);
	table->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER),ETrue);
	table->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER),ETrue);
	table->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER),ETrue);
	Test(table->PutRecordChanges()==KErrNone);

	Test(table->InsertRecord(id2)==KErrNone);
	table->WriteTextL(TPtrC(COMMDB_NAME),_L("Test 2"));
	table->WriteBoolL(TPtrC(ISP_DIAL_RESOLUTION),ETrue);
	table->WriteBoolL(TPtrC(ISP_USE_LOGIN_SCRIPT),EFalse);
	table->WriteBoolL(TPtrC(ISP_PROMPT_FOR_LOGIN),EFalse);
	table->WriteTextL(TPtrC(ISP_LOGIN_NAME),_L("AnnW"));
	table->WriteTextL(TPtrC(ISP_LOGIN_PASS),pass3);
	table->WriteBoolL(TPtrC(ISP_IF_PROMPT_FOR_AUTH),ETrue);
	table->WriteTextL(TPtrC(ISP_IF_AUTH_NAME),_L("RasUser"));
	table->WriteTextL(TPtrC(ISP_IF_AUTH_PASS),pass4);
	table->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER),ETrue);
	table->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER),ETrue);
	table->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER),ETrue);
	Test(table->PutRecordChanges()==KErrNone);

	Test(db->CommitTransaction()==KErrNone);
	CleanupStack::PopAndDestroy(2);

	db=CCommsDatabase::NewL(EDatabaseTypeIAP);
	CleanupStack::PushL(db);
	
	table=db->OpenViewMatchingUintLC(TPtrC(DIAL_OUT_ISP), TPtrC(COMMDB_ID), id1);

	TBuf<KCommsDbSvrMaxFieldLength> password;
	Test(table->GotoFirstRecord()==KErrNone);
	table->ReadTextL(TPtrC(ISP_LOGIN_PASS),password);
	Test(password==pass1);
	table->ReadTextL(TPtrC(ISP_IF_AUTH_PASS),password);
	Test(password==pass2);

	CleanupStack::PopAndDestroy(table);
	table = NULL;
	table = db->OpenViewMatchingUintLC(TPtrC(DIAL_OUT_ISP), TPtrC(COMMDB_ID), id2);

	Test(table->GotoFirstRecord()== KErrNone);
	table->ReadTextL(TPtrC(ISP_LOGIN_PASS),password);
	Test(password==pass3);
	table->ReadTextL(TPtrC(ISP_IF_AUTH_PASS),password);
	Test(password==pass4);
	
	CleanupStack::PopAndDestroy(2);

	db = CCommsDatabase::NewL(EDatabaseTypeIAP);
	CleanupStack::PushL(db);
	
	table = db->OpenViewMatchingUintLC(TPtrC(DIAL_OUT_ISP), TPtrC(COMMDB_ID), id1);

	if (table->GotoFirstRecord() == KErrNone)
		table->DeleteRecord();

	CleanupStack::PopAndDestroy(table);
	table = NULL;
	table = db->OpenViewMatchingUintLC(TPtrC(DIAL_OUT_ISP), TPtrC(COMMDB_ID), id2);

	if (table->GotoFirstRecord() == KErrNone)
		table->DeleteRecord();

	CleanupStack::PopAndDestroy(2);

    SetTestStepResult(EPass);	
     
    return TestStepResult();
	}


CTE_DeleteEntries::CTE_DeleteEntries()
	{
	SetTestStepName(KDeleteEntries);
	}

CTE_DeleteEntries::~CTE_DeleteEntries()
	{	
	}

enum TVerdict CTE_DeleteEntries::doTestStepL()
	{

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

	TUint32 id1 = 0;  
	TUint32 id2 = 0;

	CCommsDatabase* db=CCommsDatabase::NewL(EDatabaseTypeIAP);
	CleanupStack::PushL(db);
	User::LeaveIfError(db->BeginTransaction());
	
	CCommsDbTableView* table=db->OpenTableLC(TPtrC(DIAL_OUT_ISP));
	Test(table->InsertRecord(id1)==KErrNone);
	table->WriteTextL(TPtrC(COMMDB_NAME),_L("Test 1"));
	table->WriteBoolL(TPtrC(ISP_DIAL_RESOLUTION),ETrue);
	table->WriteBoolL(TPtrC(ISP_USE_LOGIN_SCRIPT),EFalse);
	table->WriteBoolL(TPtrC(ISP_PROMPT_FOR_LOGIN),EFalse);
	table->WriteTextL(TPtrC(ISP_LOGIN_NAME),_L("AnnW"));
	table->WriteTextL(TPtrC(ISP_LOGIN_PASS),pass1);
	table->WriteBoolL(TPtrC(ISP_IF_PROMPT_FOR_AUTH),ETrue);
	table->WriteTextL(TPtrC(ISP_IF_AUTH_NAME),_L("RasUser"));
	table->WriteTextL(TPtrC(ISP_IF_AUTH_PASS),pass2);
	table->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER),ETrue);
	table->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER),ETrue);
	table->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER),ETrue);
	Test(table->PutRecordChanges()==KErrNone);

	Test(table->InsertRecord(id2)==KErrNone);
	table->WriteTextL(TPtrC(COMMDB_NAME),_L("Test 2"));
	table->WriteBoolL(TPtrC(ISP_DIAL_RESOLUTION),ETrue);
	table->WriteBoolL(TPtrC(ISP_USE_LOGIN_SCRIPT),EFalse);
	table->WriteBoolL(TPtrC(ISP_PROMPT_FOR_LOGIN),EFalse);
	table->WriteTextL(TPtrC(ISP_LOGIN_NAME),_L("AnnW"));
	table->WriteTextL(TPtrC(ISP_LOGIN_PASS),pass3);
	table->WriteBoolL(TPtrC(ISP_IF_PROMPT_FOR_AUTH),ETrue);
	table->WriteTextL(TPtrC(ISP_IF_AUTH_NAME),_L("RasUser"));
	table->WriteTextL(TPtrC(ISP_IF_AUTH_PASS),pass4);
	table->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER),ETrue);
	table->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER),ETrue);
	table->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER),ETrue);
	Test(table->PutRecordChanges()==KErrNone);

	Test(db->CommitTransaction()==KErrNone);
	CleanupStack::PopAndDestroy(2);

    db = CCommsDatabase::NewL(EDatabaseTypeIAP);
	CleanupStack::PushL(db);
	
	table = db->OpenViewMatchingUintLC(TPtrC(DIAL_OUT_ISP), TPtrC(COMMDB_ID), id1);

	if (table->GotoFirstRecord() == KErrNone)
		table->DeleteRecord();

	CleanupStack::PopAndDestroy(table);
	table = NULL;
	table = db->OpenViewMatchingUintLC(TPtrC(DIAL_OUT_ISP), TPtrC(COMMDB_ID), id2);

	if (table->GotoFirstRecord() == KErrNone)
		table->DeleteRecord();

	CleanupStack::PopAndDestroy(2);

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

    SetTestStepResult(EPass);	
    
    return TestStepResult();
	}