locationdataharvester/mylocationsengine/src/lookupmaptiledb.cpp
changeset 38 793f76d9ab0c
parent 35 59575560d1e6
equal deleted inserted replaced
35:59575560d1e6 38:793f76d9ab0c
   187 
   187 
   188     TInt ret = Open();
   188     TInt ret = Open();
   189     if (ret != KErrNone)
   189     if (ret != KErrNone)
   190     {
   190     {
   191 		Close();
   191 		Close();
   192         Open();
   192         ret = Open();
       
   193         if( ret != KErrNone )
       
   194             return;
   193        
   195        
   194     }
   196     }
   195 	 iItemsDatabase.Begin();
   197 	 iItemsDatabase.Begin();
   196     
   198     
   197     RDbView myView;
   199     RDbView myView;
   224     queryBuffer.Format(KQueryToDB, aLookupItem.iUid, aLookupItem.iSource);
   226     queryBuffer.Format(KQueryToDB, aLookupItem.iUid, aLookupItem.iSource);
   225     TInt ret = Open();
   227     TInt ret = Open();
   226     if (ret != KErrNone)
   228     if (ret != KErrNone)
   227     {
   229     {
   228         Close();
   230         Close();
   229         Open();
   231         ret = Open();
   230 
   232         if( ret != KErrNone )
       
   233             return;
   231     }
   234     }
   232     iItemsDatabase.Begin();
   235     iItemsDatabase.Begin();
   233 
   236 
   234     // Create a view of the table based on the query created.
   237     // Create a view of the table based on the query created.
   235     RDbView myView;
   238     RDbView myView;
   268     queryBuffer.Format(KQueryToDB, aLookupItem.iUid, aLookupItem.iSource);
   271     queryBuffer.Format(KQueryToDB, aLookupItem.iUid, aLookupItem.iSource);
   269     TInt ret = Open();
   272     TInt ret = Open();
   270     if (ret != KErrNone)
   273     if (ret != KErrNone)
   271     {
   274     {
   272 		Close();
   275 		Close();
   273         Open();
   276         ret = Open();
   274        
   277         if( ret != KErrNone )
       
   278             return;       
   275     }
   279     }
   276 	 iItemsDatabase.Begin();
   280 	 iItemsDatabase.Begin();
   277 
   281 
   278     // Create a view of the table based on the query created.
   282     // Create a view of the table based on the query created.
   279     RDbView myView;
   283     RDbView myView;
   313 
   317 
   314     TInt ret = Open();
   318     TInt ret = Open();
   315     if (ret != KErrNone)
   319     if (ret != KErrNone)
   316     {
   320     {
   317 		Close();
   321 		Close();
   318         Open();
   322         ret = Open();
   319        
   323         if( ret != KErrNone )
       
   324             return;
   320     }
   325     }
   321 	 iItemsDatabase.Begin();
   326 	 iItemsDatabase.Begin();
   322 
   327 
   323     RDbView myView;
   328     RDbView myView;
   324     // query buffer finds only the selected item row.
   329     // query buffer finds only the selected item row.
   364     
   369     
   365     TInt ret = Open();
   370     TInt ret = Open();
   366     if (ret != KErrNone)
   371     if (ret != KErrNone)
   367     {
   372     {
   368        Close();
   373        Close();
   369        Open();      
   374        ret = Open();
       
   375        if( ret != KErrNone )
       
   376            return;
   370     }
   377     }
   371     
   378     
   372     iItemsDatabase.Begin();
   379     iItemsDatabase.Begin();
   373 
   380 
   374     RDbView myView;
   381     RDbView myView;
   428     
   435     
   429     TInt ret = Open();
   436     TInt ret = Open();
   430         if (ret != KErrNone)
   437         if (ret != KErrNone)
   431         {
   438         {
   432            Close();
   439            Close();
   433            ret= Open();
   440            ret = Open();
   434            
   441            if( ret != KErrNone )
       
   442                return;
   435         }
   443         }
   436       iItemsDatabase.Begin();
   444       iItemsDatabase.Begin();
   437 
   445 
   438     
   446     
   439     // Create a view of the table with the above query.
   447     // Create a view of the table with the above query.
   470     
   478     
   471     TInt ret = Open();
   479     TInt ret = Open();
   472         if (ret != KErrNone)
   480         if (ret != KErrNone)
   473         {
   481         {
   474            Close();
   482            Close();
   475            ret= Open();
   483            ret = Open();
   476            
   484            if( ret != KErrNone )
       
   485                return;
   477         }
   486         }
   478     iItemsDatabase.Begin();
   487     iItemsDatabase.Begin();
   479 
   488 
   480     
   489     
   481     // Create a view of the table with the above query.
   490     // Create a view of the table with the above query.
   494         aIdArray.Append( id );
   503         aIdArray.Append( id );
   495         myView.NextL();
   504         myView.NextL();
   496     }
   505     }
   497 
   506 
   498     CleanupStack::PopAndDestroy( &myView ); // myView
   507     CleanupStack::PopAndDestroy( &myView ); // myView
       
   508     Close();
   499 }
   509 }
   500 
   510 
   501 // -----------------------------------------------------------------------------
   511 // -----------------------------------------------------------------------------
   502 // CLookupMapTileDatabase::FindEntryL()
   512 // CLookupMapTileDatabase::FindEntryL()
   503 // Finds an entry in the lookup table.
   513 // Finds an entry in the lookup table.
   513 
   523 
   514    TInt ret = Open();
   524    TInt ret = Open();
   515     if (ret != KErrNone)
   525     if (ret != KErrNone)
   516     {
   526     {
   517 		Close();
   527 		Close();
   518         Open();
   528         ret = Open();
       
   529         if( ret != KErrNone )
       
   530             return EFalse;
   519        
   531        
   520     }
   532     }
   521 	 iItemsDatabase.Begin();
   533 	 iItemsDatabase.Begin();
   522 
   534 
   523     // Create a view of the table with the above query.
   535     // Create a view of the table with the above query.
   551    
   563    
   552     TInt ret = Open();
   564     TInt ret = Open();
   553     if (ret != KErrNone)
   565     if (ret != KErrNone)
   554     {
   566     {
   555         Close();
   567         Close();
   556         Open();
   568         ret = Open();
   557        
   569         if( ret != KErrNone )
       
   570             return EFalse;       
   558     }
   571     }
   559     
   572     
   560     iItemsDatabase.Begin();
   573     iItemsDatabase.Begin();
   561     
   574     
   562     // Create a query to find the item.
   575     // Create a query to find the item.