//

// 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:

//

//

// TE_UseCasesSteps.CPP

//

//

// Use cases as in the commdb design overview

#include <e32test.h>

#include <f32file.h>

#include <commdb.h>

#include <cdbover.h>

#include <cdbtemp.h>

#include "TE_UseCasesSteps.h"

///

CTE_CreatingDatabaseAndView::CTE_CreatingDatabaseAndView()

	{

	SetTestStepName(KCreatingDatabaseAndView);

	}

CTE_CreatingDatabaseAndView::~CTE_CreatingDatabaseAndView()

	{	

	}

enum TVerdict CTE_CreatingDatabaseAndView::doTestStepL()

	{

	CCommsDbTableView* view;

	CCommsDatabase* db = CCommsDatabase::NewL();

	const TPtrC kTable1(DIAL_OUT_ISP);

	const TPtrC kColumn1(ISP_TYPE);

	view = db->OpenViewMatchingUintLC(kTable1, kColumn1, EIspTypeInternetOnly);

	CleanupStack::Pop(view);

	delete view; 

	delete db;		

        SetTestStepResult(EPass);	return TestStepResult();

	}

///

CTE_UsecaseReading::CTE_UsecaseReading()

	{

	SetTestStepName(KUsecaseReading);

	}

CTE_UsecaseReading::~CTE_UsecaseReading()

	{	

	}

enum TVerdict CTE_UsecaseReading::doTestStepL()

	{

	CCommsDbTableView* view;

	CCommsDatabase* db = CCommsDatabase::NewL();

	const TPtrC kTable1(DIAL_OUT_ISP);

	const TPtrC kColumn1(ISP_TYPE);

	view = db->OpenViewMatchingUintLC(kTable1, kColumn1, EIspTypeInternetOnly);

	CleanupStack::Pop(view);	

	const TPtrC kColumn(ISP_DESCRIPTION);

	TBuf<KCommsDbSvrMaxFieldLength> description;

	view->GotoFirstRecord();

	view->ReadTextL(kColumn, description);

	delete view; 

	delete db;

        SetTestStepResult(EPass);	return TestStepResult();

	}

///

CTE_UsecaseWriting::CTE_UsecaseWriting()

	{

	SetTestStepName(KUsecaseWriting);

	}

CTE_UsecaseWriting::~CTE_UsecaseWriting()

	{	

	}

enum TVerdict CTE_UsecaseWriting::doTestStepL()

	{

	CCommsDbTableView* view;

	CCommsDatabase* db = CCommsDatabase::NewL();

	const TPtrC kTable1(DIAL_OUT_ISP);

	const TPtrC kColumn1(ISP_TYPE);

	view = db->OpenViewMatchingUintLC(kTable1, kColumn1, EIspTypeInternetOnly);

	CleanupStack::Pop(view);    

	const TPtrC kColumn(ISP_DESCRIPTION);

	const TPtrC kDescription(_L("A new description put in by t_usecases"));

	TInt ret = view->GotoNextRecord();

	if(ret == KErrNone)

		{

		ret = view->UpdateRecord();

		if(ret == KErrNone)

			{

			view->WriteTextL(kColumn, kDescription);

			view->PutRecordChanges();

			}

		}

	delete view; 

	delete db;

        SetTestStepResult(EPass);	return TestStepResult();

	}

///

CTE_UsecaseOverridingATableEntry::CTE_UsecaseOverridingATableEntry()

	{

	SetTestStepName(KUsecaseOverridingATableEntry);

	}

CTE_UsecaseOverridingATableEntry::~CTE_UsecaseOverridingATableEntry()

	{	

	}

enum TVerdict CTE_UsecaseOverridingATableEntry::doTestStepL()

	{

	const TPtrC kTable(DIAL_OUT_ISP);

	const TPtrC kColumn(ISP_DESCRIPTION);

	const TPtrC kOverride(_L("An overriden description"));

	TBuf<KCommsDbSvrMaxFieldLength> overridenValue;

	CCommDbOverrideSettings *override;

	override = CCommDbOverrideSettings::NewL(CCommDbOverrideSettings::EParamListPartial);

	CleanupStack::PushL(override);

	override->SetDesOverride(kTable, kColumn, kOverride);

	if (override->GetDesOverride(kTable, kColumn, overridenValue) != KErrNone)

		{

		User::Leave(__LINE__);

		}

	if (overridenValue != kOverride)

		{

		User::Leave(__LINE__);

		}

	CleanupStack::PopAndDestroy(override);

        SetTestStepResult(EPass);	return TestStepResult();

	}

///

CTE_UsecaseOverridingThePreferenceTable::CTE_UsecaseOverridingThePreferenceTable()

	{

	SetTestStepName(KUsecaseOverridingThePreferenceTable);

	}

CTE_UsecaseOverridingThePreferenceTable::~CTE_UsecaseOverridingThePreferenceTable()

	{	

	}

enum TVerdict CTE_UsecaseOverridingThePreferenceTable::doTestStepL()

	{

	CCommsDbConnectionPrefTableView::TCommDbIapConnectionPref overrideSettings;

	CCommsDbConnectionPrefTableView::TCommDbIapConnectionPref overridenValue;

	CCommDbOverrideSettings* override;

	override = CCommDbOverrideSettings::NewL(CCommDbOverrideSettings::EParamListPartial);

	CleanupStack::PushL(override);

	overrideSettings.iDialogPref = ECommDbDialogPrefPrompt;

	overrideSettings.iRanking = 1;

	overrideSettings.iDirection = ECommDbConnectionDirectionOutgoing;

	override->SetConnectionPreferenceOverride(overrideSettings);

	overridenValue.iRanking = 1;

	override->GetConnectionPreferenceOverride(overridenValue);

	if (!(overrideSettings == overridenValue))

		{

		User::Leave(__LINE__);

		}

	CleanupStack::PopAndDestroy(override);

        SetTestStepResult(EPass);	return TestStepResult();

	}

///

CTE_UsecaseUsingATemplate::CTE_UsecaseUsingATemplate()

	{

	SetTestStepName(KUsecaseUsingATemplate);

	}

CTE_UsecaseUsingATemplate::~CTE_UsecaseUsingATemplate()

	{	

	}

enum TVerdict CTE_UsecaseUsingATemplate::doTestStepL()

	{

	CCommsDbTableView* view;

	CCommsDatabase* db = CCommsDatabase::NewL();

	const TPtrC kTable1(DIAL_OUT_ISP);

	const TPtrC kColumn1(ISP_TYPE);

	view = db->OpenViewMatchingUintLC(kTable1, kColumn1, EIspTypeInternetOnly);

	CleanupStack::Pop(view);   

	const TPtrC kTable(DIAL_OUT_ISP);

	const TPtrC kColumn(ISP_DESCRIPTION);

	const TPtrC kDescription(_L("A default description put in by t_usecases"));

	CCommsDbTemplateRecord* temp;

	temp = CCommsDbTemplateRecord::NewL(db, kTable);

	CleanupStack::PushL(temp);

	temp->Modify();

	temp->WriteTextL(kColumn, kDescription);

	temp->StoreModifications();

	CleanupStack::PopAndDestroy(temp);

	delete view; 

	delete db;

        SetTestStepResult(EPass);	return TestStepResult();

	}