1 // Copyright (c) 2001-2009 Nokia Corporation and/or its subsidiary(-ies).

     2 // All rights reserved.

     3 // This component and the accompanying materials are made available

     4 // under the terms of "Eclipse Public License v1.0"

     5 // which accompanies this distribution, and is available

     6 // at the URL "http://www.eclipse.org/legal/epl-v10.html".

     7 //

     8 // Initial Contributors:

     9 // Nokia Corporation - initial contribution.

    10 //

    11 // Contributors:

    12 //

    13 // Description:

    14 // Use cases as in the commdb design overview

    15 // 

    16 //

    17 

    18 #include <e32test.h>

    19 #include <f32file.h>

    20 #include <commdb.h>

    21 #include <cdbover.h>

    22 #include <cdbtemp.h>

    23 

    24 #include "TS_UseCasesSteps.h"

    25 

    26 //

    27 CTS_CreatingDatabaseAndView::CTS_CreatingDatabaseAndView()

    28 	{

    29 	iTestStepName = KCreatingDatabaseAndView;

    30 	}

    31 

    32 CTS_CreatingDatabaseAndView::~CTS_CreatingDatabaseAndView()

    33 	{	

    34 	}

    35 

    36 enum TVerdict CTS_CreatingDatabaseAndView::doTestStepL()

    37 	{

    38 		

    39 	CCommsDbTableView* view;

    40 	CCommsDatabase* db = CCommsDatabase::NewL();

    41 	const TPtrC kTable1(DIAL_OUT_ISP);

    42 	const TPtrC kColumn1(ISP_TYPE);

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

    44 	CleanupStack::Pop(view);

    45 

    46 	// Allocate global storage to be held in tls.

    47 	TGlobalData*  globals=new(ELeave) TGlobalData ;

    48 	globals->iDb = db;

    49 	globals->iView = view;

    50 	CTS_UseCasesStep::Set(globals);

    51 

    52 	return EPass;

    53 	}

    54 

    55 //

    56 CTS_UsecaseReading::CTS_UsecaseReading()

    57 	{

    58 	iTestStepName = KUsecaseReading;

    59 	}

    60 

    61 CTS_UsecaseReading::~CTS_UsecaseReading()

    62 	{	

    63 	}

    64 

    65 enum TVerdict CTS_UsecaseReading::doTestStepL()

    66 	{

    67 

    68 	TGlobalData* globals = CTS_UseCasesStep::Get();

    69 	CCommsDbTableView* view= globals->iView;  

    70 		

    71 	const TPtrC kColumn(ISP_DESCRIPTION);

    72 

    73 	TBuf<KCommsDbSvrMaxFieldLength> description;

    74 

    75 	view->GotoFirstRecord();

    76 	view->ReadTextL(kColumn, description);

    77 	

    78 	return EPass;

    79 	}

    80 

    81 //

    82 CTS_UsecaseWriting::CTS_UsecaseWriting()

    83 	{

    84 	iTestStepName = KUsecaseWriting;

    85 	}

    86 

    87 CTS_UsecaseWriting::~CTS_UsecaseWriting()

    88 	{	

    89 	}

    90 

    91 enum TVerdict CTS_UsecaseWriting::doTestStepL()

    92 	{

    93 	

    94 	TGlobalData* globals = CTS_UseCasesStep::Get();

    95 	CCommsDbTableView* view= globals->iView;  

    96 	

    97 	const TPtrC kColumn(ISP_DESCRIPTION);

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

    99 

   100 	TInt ret = view->GotoNextRecord();

   101 	if(ret == KErrNone)

   102 		{

   103 		ret = view->UpdateRecord();

   104 		if(ret == KErrNone)

   105 			{

   106 			view->WriteTextL(kColumn, kDescription);

   107 			view->PutRecordChanges();

   108 			}

   109 		}

   110 

   111 	return EPass;

   112 	}

   113 

   114 //

   115 CTS_UsecaseOverridingATableEntry::CTS_UsecaseOverridingATableEntry()

   116 	{

   117 	iTestStepName = KUsecaseOverridingATableEntry;

   118 	}

   119 

   120 CTS_UsecaseOverridingATableEntry::~CTS_UsecaseOverridingATableEntry()

   121 	{	

   122 	}

   123 

   124 enum TVerdict CTS_UsecaseOverridingATableEntry::doTestStepL()

   125 	{

   126 	const TPtrC kTable(DIAL_OUT_ISP);

   127 	const TPtrC kColumn(ISP_DESCRIPTION);

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

   129 	TBuf<KCommsDbSvrMaxFieldLength> overridenValue;

   130 

   131 	CCommDbOverrideSettings *override;

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

   133 	CleanupStack::PushL(override);

   134 

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

   136 

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

   138 		{

   139 		User::Leave(__LINE__);

   140 		}

   141 	if (overridenValue != kOverride)

   142 		{

   143 		User::Leave(__LINE__);

   144 		}

   145 

   146 	CleanupStack::PopAndDestroy(override);

   147 

   148 	return EPass;

   149 	}

   150 

   151 //

   152 CTS_UsecaseOverridingThePreferenceTable::CTS_UsecaseOverridingThePreferenceTable()

   153 	{

   154 	iTestStepName = KUsecaseOverridingThePreferenceTable;

   155 	}

   156 

   157 CTS_UsecaseOverridingThePreferenceTable::~CTS_UsecaseOverridingThePreferenceTable()

   158 	{	

   159 	}

   160 

   161 enum TVerdict CTS_UsecaseOverridingThePreferenceTable::doTestStepL()

   162 	{

   163 	CCommsDbConnectionPrefTableView::TCommDbIapConnectionPref overrideSettings;

   164 	CCommsDbConnectionPrefTableView::TCommDbIapConnectionPref overridenValue;

   165 

   166 	CCommDbOverrideSettings* override;

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

   168 	CleanupStack::PushL(override);

   169 

   170 	overrideSettings.iDialogPref = ECommDbDialogPrefPrompt;

   171 	overrideSettings.iRanking = 1;

   172 	overrideSettings.iDirection = ECommDbConnectionDirectionOutgoing;

   173 	override->SetConnectionPreferenceOverride(overrideSettings);

   174 

   175 	overridenValue.iRanking = 1;

   176 	override->GetConnectionPreferenceOverride(overridenValue);

   177 

   178 	if (!(overrideSettings == overridenValue))

   179 		{

   180 		User::Leave(__LINE__);

   181 		}

   182 

   183 	CleanupStack::PopAndDestroy(override);

   184 

   185 	return EPass;

   186 	}

   187 

   188 //

   189 CTS_UsecaseUsingATemplate::CTS_UsecaseUsingATemplate()

   190 	{

   191 	iTestStepName = KUsecaseUsingATemplate;

   192 	}

   193 

   194 CTS_UsecaseUsingATemplate::~CTS_UsecaseUsingATemplate()

   195 	{	

   196 	}

   197 

   198 enum TVerdict CTS_UsecaseUsingATemplate::doTestStepL()

   199 	{

   200 

   201 	TGlobalData* globals = CTS_UseCasesStep::Get();

   202 	CCommsDatabase* db = globals->iDb;

   203 	CCommsDbTableView* view= globals->iView; 

   204 	

   205 	const TPtrC kTable(DIAL_OUT_ISP);

   206 	const TPtrC kColumn(ISP_DESCRIPTION);

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

   208 

   209 	CCommsDbTemplateRecord* temp;

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

   211 	CleanupStack::PushL(temp);

   212 

   213 	temp->Modify();

   214 	temp->WriteTextL(kColumn, kDescription);

   215 	temp->StoreModifications();

   216 	

   217 	CleanupStack::PopAndDestroy(temp);

   218 	 

   219 	delete view; 

   220 	delete db;		

   221 	delete globals;

   222 	CTS_UseCasesStep::Set(NULL);

   223 	

   224 	return EPass;

   225 	}