// Copyright (c) 2001-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 036.XX

// 

//

// EPOC includes

#include <e32base.h>

#include <commdb.h>

#include <d32comm.h>

#include <cdbtemp.h>

#include <etelmm.h>

// Test system includes

#include <networking/log.h>

#include <networking/teststep.h>

#include "Teststepcommdb.h"

#include "TestSuiteCommdb.h"

#include "Step_036_xx.h"

CCommDbTest036_01::CCommDbTest036_01()

	{

	// store the name of this test case

	iTestStepName = _L("step_036_01");

	}

CCommDbTest036_01::~CCommDbTest036_01()

	{}

TVerdict CCommDbTest036_01::doTestStepL( void )

	{

	if(executeStepL()!=KErrNone)

		return EFail;

	return EPass;

	}

TVerdict CCommDbTest036_01::doTestStepPreambleL()

	{

	iTheDb=CCommsDatabase::NewL();

	return EPass;

	}

TInt CCommDbTest036_01::executeStepL()

	{

	CCommsDbTemplateRecord* templateRecord = CCommsDbTemplateRecord::NewL(iTheDb, TPtrC(MODEM_BEARER));

	CleanupStack::PushL(templateRecord);

	User::LeaveIfError(templateRecord->Modify());

	TBufC8<KCommsDbSvrMaxFieldLength> inputString = _L8("string");

	templateRecord->WriteTextL(TPtrC(COMMDB_NAME), _L("DummyName"));

	templateRecord->WriteTextL(TPtrC(MODEM_FAX_INIT_STRING), inputString);

	User::LeaveIfError(templateRecord->StoreModifications());

	CleanupStack::PopAndDestroy(templateRecord);

	//Create a new template record and check the value is the same as the one entered.

	CCommsDbTemplateRecord* checkRecord = CCommsDbTemplateRecord::NewL(iTheDb, TPtrC(MODEM_BEARER));

	CleanupStack::PushL(checkRecord);

	TBuf8<KCommsDbSvrMaxFieldLength> checkString;

	checkRecord->ReadTextL(TPtrC(MODEM_FAX_INIT_STRING), checkString);

	CleanupStack::PopAndDestroy(checkRecord);

	if(checkString!=inputString)

		return KErrGeneral;

	return KErrNone;

	}

TVerdict CCommDbTest036_01::doTestStepPostambleL()

	{

	delete iTheDb;

	iTheDb=NULL;

	return EPass;

	}

//

CCommDbTest036_02::CCommDbTest036_02()

	{

	// store the name of this test case

	iTestStepName = _L("step_036_02");

	}

CCommDbTest036_02::~CCommDbTest036_02()

	{}

TVerdict CCommDbTest036_02::doTestStepL( void )

	{

	if(executeStepL()!=KErrNone)

		return EFail;

	return EPass;

	}

TVerdict CCommDbTest036_02::doTestStepPreambleL()

	{

	iTheDb=CCommsDatabase::NewL();

	return EPass;

	}

TInt CCommDbTest036_02::executeStepL()

	{

	CCommsDbTemplateRecord* templateRecord = CCommsDbTemplateRecord::NewL(iTheDb, TPtrC(MODEM_BEARER));

	CleanupStack::PushL(templateRecord);

	User::LeaveIfError(templateRecord->Modify());

	TBufC8<KCommsDbSvrMaxFieldLength> firstInputString = _L8("string");

	templateRecord->WriteTextL(TPtrC(COMMDB_NAME), _L("DummyName"));

	templateRecord->WriteTextL(TPtrC(MODEM_FAX_INIT_STRING), firstInputString);

	User::LeaveIfError(templateRecord->StoreModifications());

	CleanupStack::PopAndDestroy(templateRecord);

	//Create a view on the modem table, over write the template value previosly set and check it sticks

	CCommsDbTableView* tableView = iTheDb->OpenTableLC(TPtrC(MODEM_BEARER));

	TUint32 dummyId;

	//Create a new record, so we can be sure it is the same as the templated one

	User::LeaveIfError(tableView->InsertRecord(dummyId));

	tableView->WriteTextL(TPtrC(COMMDB_NAME), _L("NewModem"));

	//Do overwrite of setting

	TBufC8<KCommsDbSvrMaxFieldLength> overwriteString = _L8("different string");

	tableView->WriteTextL(TPtrC(MODEM_FAX_INIT_STRING), overwriteString);

	User::LeaveIfError(tableView->PutRecordChanges());

	TBuf8<KCommsDbSvrMaxFieldLength> retrievedString;

	tableView->ReadTextL(TPtrC(MODEM_FAX_INIT_STRING), retrievedString);

	CleanupStack::PopAndDestroy(tableView);

	if(retrievedString!=overwriteString)

		return KErrGeneral;

	return KErrNone;

	}

TVerdict CCommDbTest036_02::doTestStepPostambleL()

	{

	delete iTheDb;

	iTheDb=NULL;

	return EPass;

	}

//

CCommDbTest036_03::CCommDbTest036_03()

	{

	// store the name of this test case

	iTestStepName = _L("step_036_03");

	}

CCommDbTest036_03::~CCommDbTest036_03()

	{}

TVerdict CCommDbTest036_03::doTestStepL( void )

	{

	if(executeStepL()!=KErrNone)

		return EFail;

	return EPass;

	}

TVerdict CCommDbTest036_03::doTestStepPreambleL()

	{

	iTheDb=CCommsDatabase::NewL();

	return EPass;

	}

TInt CCommDbTest036_03::executeStepL()

	{

	CCommsDbTemplateRecord* templateRecord = CCommsDbTemplateRecord::NewL(iTheDb, TPtrC(MODEM_BEARER));

	CleanupStack::PushL(templateRecord);

	User::LeaveIfError(templateRecord->Modify());

	TBufC<KCommsDbSvrMaxFieldLength> inputString = _L("string");

	templateRecord->WriteTextL(TPtrC(COMMDB_NAME), _L("DummyName"));

	templateRecord->WriteTextL(TPtrC(MODEM_PORT_NAME), inputString);

	User::LeaveIfError(templateRecord->StoreModifications());

	CleanupStack::PopAndDestroy(templateRecord);

	//Create a view on the modem table, make a new record and check the value is the one set for the template

	CCommsDbTableView* tableView = iTheDb->OpenTableLC(TPtrC(MODEM_BEARER));

	TUint32 dummyId;

	//Create a new record, so we can be sure it is the same as the templated one

	User::LeaveIfError(tableView->InsertRecord(dummyId));

	tableView->WriteTextL(TPtrC(COMMDB_NAME), _L("NewModem"));

	User::LeaveIfError(tableView->PutRecordChanges());

	//Retrieve the string we set for the template

	TBuf<KCommsDbSvrMaxFieldLength> retrievedString;

	tableView->ReadTextL(TPtrC(MODEM_PORT_NAME), retrievedString);

	CleanupStack::PopAndDestroy(tableView);

	if(retrievedString!=inputString)

		return KErrGeneral;

	return KErrNone;

	}

TVerdict CCommDbTest036_03::doTestStepPostambleL()

	{

	delete iTheDb;

	iTheDb=NULL;

	return EPass;

	}

//

CCommDbTest036_04::CCommDbTest036_04()

	{

	// store the name of this test case

	iTestStepName = _L("step_036_04");

	}

CCommDbTest036_04::~CCommDbTest036_04()

	{}

TVerdict CCommDbTest036_04::doTestStepL( void )

	{

	if(executeStepL()!=KErrNone)

		return EFail;

	return EPass;

	}

TVerdict CCommDbTest036_04::doTestStepPreambleL()

	{

	iTheDb=CCommsDatabase::NewL();

	return EPass;

	}

TInt CCommDbTest036_04::executeStepL()

	{

	CCommsDbTemplateRecord* templateRecord = CCommsDbTemplateRecord::NewL(iTheDb, TPtrC(MODEM_BEARER));

	CleanupStack::PushL(templateRecord);

	User::LeaveIfError(templateRecord->Modify());

	TBufC<KCommsDbSvrMaxFieldLength> inputString = _L("string");

	templateRecord->WriteTextL(TPtrC(COMMDB_NAME), _L("DummyName"));

	templateRecord->WriteTextL(TPtrC(MODEM_PORT_NAME), inputString);

	User::LeaveIfError(templateRecord->StoreModifications());

	CleanupStack::PopAndDestroy(templateRecord);

	//Create a view on the modem table, make a new record and overwrite the value set in the template

	CCommsDbTableView* tableView = iTheDb->OpenTableLC(TPtrC(MODEM_BEARER));

	TUint32 dummyId;

	//Create a new record, so we can be sure it is the same as the templated one

	User::LeaveIfError(tableView->InsertRecord(dummyId));

	tableView->WriteTextL(TPtrC(COMMDB_NAME), _L("NewModem"));

	//Do overwrite of setting

	TBufC<KCommsDbSvrMaxFieldLength> overwriteString = _L("different string");

	tableView->WriteTextL(TPtrC(MODEM_PORT_NAME), overwriteString);

	User::LeaveIfError(tableView->PutRecordChanges());

	//Retrieve the string we just set

	TBuf<KCommsDbSvrMaxFieldLength> retrievedString;

	tableView->ReadTextL(TPtrC(MODEM_PORT_NAME), retrievedString);

	CleanupStack::PopAndDestroy(tableView);

	if(retrievedString!=overwriteString)

		return KErrGeneral;

	return KErrNone;

	}

TVerdict CCommDbTest036_04::doTestStepPostambleL()

	{

	delete iTheDb;

	iTheDb=NULL;

	return EPass;

	}

//

CCommDbTest036_05::CCommDbTest036_05()

	{

	// store the name of this test case

	iTestStepName = _L("step_036_05");

	}

CCommDbTest036_05::~CCommDbTest036_05()

	{}

TVerdict CCommDbTest036_05::doTestStepL( void )

	{

	if(executeStepL()!=KErrNone)

		return EFail;

	return EPass;

	}

TVerdict CCommDbTest036_05::doTestStepPreambleL()

	{

	iTheDb=CCommsDatabase::NewL();

	return EPass;

	}

TInt CCommDbTest036_05::executeStepL()

	{

	CCommsDbTemplateRecord* templateRecord = CCommsDbTemplateRecord::NewL(iTheDb, TPtrC(DIAL_IN_ISP));

	CleanupStack::PushL(templateRecord);

	User::LeaveIfError(templateRecord->Modify());

	TBufC<KCommsDbSvrMaxFieldLength> inputString = _L("test string");

	templateRecord->WriteTextL(TPtrC(COMMDB_NAME), _L("Name"));

//	templateRecord->WriteTextL(TPtrC(ISP_IF_NAME), _L("SLIP"));

	templateRecord->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER), ETrue);

	templateRecord->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER), ETrue);

	templateRecord->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER), ETrue);

	templateRecord->WriteLongTextL(TPtrC(ISP_LOGIN_SCRIPT), inputString);

	User::LeaveIfError(templateRecord->StoreModifications());

	CleanupStack::PopAndDestroy(templateRecord);

	//Create a view on the DialInISP table, make a new record and check the value is the one set for the template

	CCommsDbTableView* tableView = iTheDb->OpenTableLC(TPtrC(DIAL_IN_ISP));

	TUint32 dummyId;

	//Create a new record, so we can be sure it is the same as the templated one

	User::LeaveIfError(tableView->InsertRecord(dummyId));

	tableView->WriteTextL(TPtrC(COMMDB_NAME), _L("Test ISP"));

//	tableView->WriteTextL(TPtrC(ISP_IF_NAME), _L("Test If"));

	tableView->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER), EFalse);

	tableView->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER), EFalse);

	tableView->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER), EFalse);

	User::LeaveIfError(tableView->PutRecordChanges());

	//Retrieve the string we set for the template

	HBufC* retrievedString = tableView->ReadLongTextLC(TPtrC(ISP_LOGIN_SCRIPT));

	TInt ret(KErrNone);

	if(*retrievedString!=inputString)

		ret= KErrGeneral;

	CleanupStack::PopAndDestroy();	//retrievedString

	CleanupStack::PopAndDestroy(tableView);

	return ret;

	}

TVerdict CCommDbTest036_05::doTestStepPostambleL()

	{

	delete iTheDb;

	iTheDb=NULL;

	return EPass;

	}

//

CCommDbTest036_06::CCommDbTest036_06()

	{

	// store the name of this test case

	iTestStepName = _L("step_036_06");

	}

CCommDbTest036_06::~CCommDbTest036_06()

	{}

TVerdict CCommDbTest036_06::doTestStepL( void )

	{

	if(executeStepL()!=KErrNone)

		return EFail;

	return EPass;

	}

TVerdict CCommDbTest036_06::doTestStepPreambleL()

	{

	iTheDb=CCommsDatabase::NewL();

	return EPass;

	}

TInt CCommDbTest036_06::executeStepL()

	{

	CCommsDbTemplateRecord* templateRecord = CCommsDbTemplateRecord::NewL(iTheDb, TPtrC(DIAL_IN_ISP));

	CleanupStack::PushL(templateRecord);

	User::LeaveIfError(templateRecord->Modify());

	TBufC<KCommsDbSvrMaxFieldLength> inputString = _L("test string");

	templateRecord->WriteTextL(TPtrC(COMMDB_NAME), _L("Name"));

//	templateRecord->WriteTextL(TPtrC(ISP_IF_NAME), _L("SLIP"));

	templateRecord->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER), ETrue);

	templateRecord->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER), ETrue);

	templateRecord->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER), ETrue);

	templateRecord->WriteLongTextL(TPtrC(ISP_LOGIN_SCRIPT), inputString);

	User::LeaveIfError(templateRecord->StoreModifications());

	CleanupStack::PopAndDestroy(templateRecord);

	//Create a view on the DialInISP table, make a new record and change the value we set int he template

	CCommsDbTableView* tableView = iTheDb->OpenTableLC(TPtrC(DIAL_IN_ISP));

	TUint32 dummyId;

	//Create a new record, so we can be sure it is the same as the templated one

	User::LeaveIfError(tableView->InsertRecord(dummyId));

	tableView->WriteTextL(TPtrC(COMMDB_NAME), _L("Test ISP"));

//	tableView->WriteTextL(TPtrC(ISP_IF_NAME), _L("Test If"));

	tableView->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER), EFalse);

	tableView->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER), EFalse);

	tableView->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER), EFalse);

	//Overwrite value set above in template

	TBufC<KCommsDbSvrMaxFieldLength> overwriteString = _L("new string");

	tableView->WriteLongTextL(TPtrC(ISP_LOGIN_SCRIPT), overwriteString);

	User::LeaveIfError(tableView->PutRecordChanges());

	//Retrieve the string we just set

	HBufC* retrievedString = tableView->ReadLongTextLC(TPtrC(ISP_LOGIN_SCRIPT));

	TInt ret(KErrNone);

	if(*retrievedString!=overwriteString)

		ret= KErrGeneral;

	CleanupStack::PopAndDestroy();	//retrievedString

	CleanupStack::PopAndDestroy(tableView);

	return ret;

	}

TVerdict CCommDbTest036_06::doTestStepPostambleL()

	{

	delete iTheDb;

	iTheDb=NULL;

	return EPass;

	}

//

CCommDbTest036_07::CCommDbTest036_07()

	{

	// store the name of this test case

	iTestStepName = _L("step_036_07");

	}

CCommDbTest036_07::~CCommDbTest036_07()

	{}

TVerdict CCommDbTest036_07::doTestStepL( void )

	{

	if(executeStepL()!=KErrNone)

		return EFail;

	return EPass;

	}

TVerdict CCommDbTest036_07::doTestStepPreambleL()

	{

	iTheDb=CCommsDatabase::NewL();

	return EPass;

	}

TInt CCommDbTest036_07::executeStepL()

	{

	CCommsDbTemplateRecord* templateRecord = CCommsDbTemplateRecord::NewL(iTheDb, TPtrC(DIAL_IN_ISP));

	CleanupStack::PushL(templateRecord);

	User::LeaveIfError(templateRecord->Modify());

	TBool inputBool = ETrue;

	templateRecord->WriteTextL(TPtrC(COMMDB_NAME), _L("Name"));

//	templateRecord->WriteTextL(TPtrC(ISP_IF_NAME), _L("SLIP"));

	templateRecord->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER), ETrue);

	templateRecord->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER), ETrue);

	templateRecord->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER), ETrue);

	templateRecord->WriteBoolL(TPtrC(ISP_USE_LOGIN_SCRIPT), inputBool);	//Set to ETrue, since EFalse is default

	User::LeaveIfError(templateRecord->StoreModifications());

	CleanupStack::PopAndDestroy(templateRecord);

	//Create a view on the DialInISP table, make a new record and check the value is the one set for the template

	CCommsDbTableView* tableView = iTheDb->OpenTableLC(TPtrC(DIAL_IN_ISP));

	TUint32 dummyId;

	//Create a new record, so we can be sure it is the same as the templated one

	User::LeaveIfError(tableView->InsertRecord(dummyId));

	tableView->WriteTextL(TPtrC(COMMDB_NAME), _L("Test ISP"));

//	tableView->WriteTextL(TPtrC(ISP_IF_NAME), _L("Test If"));

	tableView->WriteBoolL(TPtrC(ISP_IP_ADDR_FROM_SERVER), EFalse);

	tableView->WriteBoolL(TPtrC(ISP_IP_DNS_ADDR_FROM_SERVER), EFalse);

	tableView->WriteBoolL(TPtrC(ISP_IP6_DNS_ADDR_FROM_SERVER), EFalse);

	User::LeaveIfError(tableView->PutRecordChanges());

	//Retrieve the bool we set for the template

	TBool retrievedBool;

	tableView->ReadBoolL(TPtrC(ISP_USE_LOGIN_SCRIPT), retrievedBool);

	CleanupStack::PopAndDestroy(tableView);

	if(retrievedBool!=inputBool)

		return KErrGeneral;

	return KErrNone;

	}

TVerdict CCommDbTest036_07::doTestStepPostambleL()

	{

	delete iTheDb;

	iTheDb=NULL;

	return EPass;

	}

//

CCommDbTest036_08::CCommDbTest036_08()

	{