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

    15 

    16 

    17 

    18 #include "cmtpdpidstore.h"

    19 #include "dbutility.h"

    20 

    21 

    22 _LIT(KSQLDPIDTableName, "DPIDStore");

    23 _LIT(KSQLInsertDPIDObjectText, "INSERT INTO DPIDStore (DataProviderId, Uid) VALUES (%u, %u)");

    24 _LIT(KSQLCreateDPIDTableText, "CREATE TABLE DPIDStore (DataProviderId UNSIGNED INTEGER, Uid UNSIGNED INTEGER )");

    25 _LIT(KSQLGetDPIDUID, "SELECT * FROM DPIDStore");

    26 

    27 /**

    28 Two-phase construction

    29 @param aDatabase	The reference to the database object

    30 @return	pointer to the created suid map instance

    31 */

    32 CMTPDPIDStore* CMTPDPIDStore::NewL(RDbDatabase& aDatabase)

    33 	{

    34 	CMTPDPIDStore* self = new (ELeave) CMTPDPIDStore(aDatabase);

    35 	CleanupStack::PushL(self);

    36 	self->ConstructL();

    37 	CleanupStack::Pop(self);

    38 	return self;

    39 	}

    40 

    41 

    42 /**

    43 Standard c++ constructor

    44 */	

    45 CMTPDPIDStore::CMTPDPIDStore(RDbDatabase& aDatabase)

    46 	:iDatabase(aDatabase)

    47 	{

    48 	}

    49 

    50 /**

    51 Second phase constructor.

    52 */    

    53 void CMTPDPIDStore::ConstructL()

    54     {    

    55     CreateDPIDStoteTableL();

    56     }

    57 

    58 /**

    59 Create the table for storing the mapping from object handle to other properties 

    60 (data provider id, storage id, formatcode, etc.)

    61 */    

    62 void CMTPDPIDStore::CreateDPIDStoteTableL()

    63 	{	

    64 	if (!DBUtility::IsTableExistsL(iDatabase, KSQLDPIDTableName))

    65 		{

    66 		User::LeaveIfError(iDatabase.Execute(KSQLCreateDPIDTableText));			

    67 		}

    68 	iSqlStatement.Format(KSQLGetDPIDUID);    

    69     RDbView view;

    70     CleanupClosePushL(view);

    71     User::LeaveIfError(view.Prepare(iDatabase, TDbQuery(iSqlStatement)));

    72     User::LeaveIfError(view.Evaluate());

    73 	while (view.NextL())

    74         {

    75         view.GetL();

    76        	iDPIDs.AppendL(view.ColInt64(EDPIDStoreDataProviderId));

    77 		iDPUIDs.AppendL(view.ColInt64(EDPIDStoreUid));

    78         }

    79 	CleanupStack::PopAndDestroy(&view);	

    80 	}

    81 	

    82 /**

    83 Destructor.

    84 */    

    85 CMTPDPIDStore::~CMTPDPIDStore()

    86     {  

    87 	iDPIDs.Close();

    88 	iDPUIDs.Close();

    89     }

    90 

    91 

    92 void CMTPDPIDStore::InsertDPIDObjectL(TUint aDPId, TUint aUid)

    93 	{		

    94 	iSqlStatement.Format(KSQLInsertDPIDObjectText, aDPId, aUid);

    95 	TInt err(iDatabase.Execute(iSqlStatement));

    96 	iDatabase.Compact();

    97 	iDPIDs.AppendL(aDPId);

    98 	iDPUIDs.AppendL(aUid);

    99 	}	

   100   

   101 TUint CMTPDPIDStore::DPIDL(TUint32 aUid, TBool& aFlag) const

   102     {

   103 	TUint tempDPId = 3;

   104 	aFlag = ETrue;

   105 	TRAPD(err, tempDPId = iDPUIDs.FindL(aUid));

   106 	if(err == KErrNone)

   107 		{

   108 		tempDPId = iDPIDs[tempDPId];

   109 		}

   110 	else

   111 		{

   112 		if(iDPIDs.Count()>0)

   113 			{

   114 			tempDPId = iDPIDs[iDPIDs.Count() - 1];

   115 			tempDPId++;			

   116 			}

   117 		aFlag = EFalse;

   118 		}

   119 	return tempDPId;

   120     }