24 _LIT( KSelectfilepathFrom, "SELECT filepath FROM " );

    25 _LIT(KQueryMaptile, "SELECT filepath FROM cntmaptilelookuptable WHERE filepath = '%S'");

    26 // string 'where'

    27 _LIT( KStringWhere, " WHERE " );

    28 // string ' = '

    29 _LIT( KStringEqual, " = " );

    30 

    31 _LIT(KQueryByMaptileFetchingState,"SELECT * FROM cntmaptilelookuptable WHERE fetchingstatus = %d");

   159     

   160     //MK 

   161     // add map tile fetching status to the db

   162     columns->AddL(TDbCol(MapTileFetchingStatus, EDbColUint32));

   163     

   203     myView.SetColL(KColumnMapTileFetchingStatus, aLookupItem.iFetchingStatus); //MK

   244         myView.SetColL(KColumnMapTileFetchingStatus, aLookupItem.iFetchingStatus); //MK

   293             

   295         myView.DeleteL();

   296     }

   297 

   298     CleanupStack::PopAndDestroy(&myView); // myView

   299     iItemsDatabase.Commit();

   300     // compacts the databse, by physicaly removing deleted data.

   301     iItemsDatabase.Compact();

   302 

   303     Close();

   304 }

   305 

   306 // -----------------------------------------------------------------------------

   307 // CLookupMapTileDatabase::DeleteMapTileL()

   308 // Deletes an maptile if there's no reference to maptile in lookupdb

   309 // -----------------------------------------------------------------------------

   310 //

   311 void CLookupMapTileDatabase::DeleteMapTileL( const TLookupItem& aLookupItem)

   312 {

   313     __TRACE_CALLSTACK;// Create the query to find the row to be deleted.

   314 

   315     TFileName queryBuffer;    

   316     queryBuffer.Format(KQueryMaptile, &aLookupItem.iFilePath);

   317     

   318     TInt ret = Open();

   319     if (ret != KErrNone)

   320     {

   321        Close();

   322        Open();      

   323     }

   324     

   325     iItemsDatabase.Begin();

   326 

   327     RDbView myView;

   328     // query buffer finds only the selected item row.

   329     myView.Prepare(iItemsDatabase, TDbQuery(queryBuffer));

   330     CleanupClosePushL(myView);

   331 

   332     myView.EvaluateAll();

   333 

   334     // positions the cursor on the first row of the rowset

   335     myView.FirstL();

   336 

   337     // Delete if no reference to maptile

   338     if (!myView.AtRow())

   339     {

   340         ret = iFsSession.Delete(aLookupItem.iFilePath);     

   341     }

   342         

   343     CleanupStack::PopAndDestroy(&myView); // myView

   344 

   345     Close();

   346 }

   347 

   348 

   349 // -----------------------------------------------------------------------------

   350 // CLookupMapTileDatabase::FindEntriesByMapTileFetchingStatusL()

   351 // Finds a list of lookup items given a landmark uid.

   352 // -----------------------------------------------------------------------------

   353 //

   354 void CLookupMapTileDatabase::FindEntriesByMapTileFetchingStateL(const TUint32 aFetchingState,

   355         RArray<TLookupItem>& aLookupItemArray)

   356 {

   357     __TRACE_CALLSTACK;// Create a query to find the item.

   358     TFileName queryBuffer;

   359     queryBuffer.Format(KQueryByMaptileFetchingState,aFetchingState);

   360     

   361     TInt ret = Open();

   362         if (ret != KErrNone)

   363         {

   364            Close();

   365            ret= Open();

   366            

   367         }

   368       iItemsDatabase.Begin();

   369 

   370     

   371     // Create a view of the table with the above query.

   372     RDbView myView;

   373     myView.Prepare(iItemsDatabase, TDbQuery(queryBuffer));

   374     CleanupClosePushL(myView);

   375     myView.EvaluateAll();

   376     myView.FirstL();

   377 

   378     while (myView.AtRow())

   379     {

   380         // Item found. get the details.

   381         myView.GetL();

   382         TLookupItem newItem;

   383         newItem.iUid = myView.ColUint(KColumnUid);

   384         newItem.iSource = myView.ColUint(KColumnSource);

   385         aLookupItemArray.Append(newItem);

   386         myView.NextL();

   387     }

   388 

   389     CleanupStack::PopAndDestroy(&myView); // myView

   390 }

   391 

   392 // -----------------------------------------------------------------------------

   393 // CLookupMapTileDatabase::FindEntryL()

   394 // Finds an entry in the lookup table.

   395 // -----------------------------------------------------------------------------

   396 //

   397 TBool CLookupMapTileDatabase::FindEntryL(TLookupItem& aLookupItem)

   398 {

   399     __TRACE_CALLSTACK;// used to store return value

   400     TBool retVal = EFalse;

   401     // Create a query to find the item.

   402     TFileName queryBuffer;

   403     queryBuffer.Format(KQueryToDB, aLookupItem.iUid, aLookupItem.iSource);

   404 

   405    TInt ret = Open();

   406     if (ret != KErrNone)

   407     {

   408 		Close();

   409         Open();

   410        

   411     }

   412 	 iItemsDatabase.Begin();

   413 

   414     // Create a view of the table with the above query.

   415     RDbView myView;

   416     myView.Prepare(iItemsDatabase, TDbQuery(queryBuffer));

   417     CleanupClosePushL(myView);

   418     myView.EvaluateAll();

   419     myView.FirstL();

   420 

   421     if (myView.AtRow())

   422     {

   423         // Item found. get the details.

   424         myView.GetL();

   432 

   433 // -----------------------------------------------------------------------------

   434 // CLookupMapTileDatabase::FindEntryByFIlePathLL()

   435 // Finds an entry in the lookup table for maptile image file

   436 // -----------------------------------------------------------------------------

   437 //

   438 TBool CLookupMapTileDatabase::FindEntryByFilePathL(const TDesC& aFilePath)

   439 {

   440     __TRACE_CALLSTACK;// used to store return value

   441     TBool retVal = EFalse;

   442    

   443     TInt ret = Open();

   444     if (ret != KErrNone)

   445     {

   446         Close();

   447         Open();

   448        

   449     }

   450     

   451     iItemsDatabase.Begin();

   452     

   453     // Create a query to find the item.

   454     TFileName queryBuffer;

   455     _LIT(KFormatSpec, "%S%S%S%S%S'%S'");

   456     

   457     queryBuffer.Format(KFormatSpec, 

   458         &KSelectfilepathFrom(), 

   459         &KMapTileLookupTable(),

   460         &KStringWhere(),

   461         &NCntColFilePath(),

   462         &KStringEqual(),

   463         &aFilePath);

   464     

   465     // Create a view of the table with the above query.

   466     RDbView myView;

   467     TInt retPrep = myView.Prepare(iItemsDatabase, TDbQuery(queryBuffer));

   468     CleanupClosePushL(myView);

   469     myView.EvaluateAll();

   470     myView.FirstL();

   471 

   472     if (myView.AtRow())

   473     {

   474         // Item found, return true

   475         retVal = ETrue;

   476     }

   477 

   478     CleanupStack::PopAndDestroy(&myView); // myView

   479     Close();

   480 

   481     return retVal;

   482 }

   483