upnpharvester/common/dbmanager/src/cmdmsqliteconnection.cpp
changeset 32 3785f754ee62
parent 0 7f85d04be362
equal deleted inserted replaced
27:03808033c9a2 32:3785f754ee62
  1359         for ( err = iStatement.Next(); 
  1359         for ( err = iStatement.Next(); 
  1360               err == KSqlAtRow; 
  1360               err == KSqlAtRow; 
  1361               err = iStatement.Next() )
  1361               err = iStatement.Next() )
  1362             {
  1362             {
  1363             // Get cell contents    
  1363             // Get cell contents    
  1364             mediaServerIds.Append( 
  1364             mediaServerIds.AppendL( 
  1365                 iStatement.ColumnInt64(0) );             
  1365                 iStatement.ColumnInt64(0) );             
  1366             }    
  1366             }    
  1367         iStatement.Reset();            
  1367         iStatement.Reset();            
  1368         iStatement.Close();  // Destruct statement
  1368         iStatement.Close();  // Destruct statement
  1369         }
  1369         }
  1408         for ( err = iStatement.Next(); 
  1408         for ( err = iStatement.Next(); 
  1409               err == KSqlAtRow; 
  1409               err == KSqlAtRow; 
  1410               err = iStatement.Next() )
  1410               err = iStatement.Next() )
  1411             {
  1411             {
  1412             // Get cell content
  1412             // Get cell content
  1413             ruleIds.Append( iStatement.ColumnInt64( 0 ) );
  1413             ruleIds.AppendL( iStatement.ColumnInt64( 0 ) );
  1414             aFillRule->AddRuleL( 
  1414             aFillRule->AddRuleL( 
  1415                 (TCmMetadataField)iStatement.ColumnInt( 1 ), 
  1415                 (TCmMetadataField)iStatement.ColumnInt( 1 ), 
  1416                 (TCmOperatorType)iStatement.ColumnInt( 2 ) );
  1416                 (TCmOperatorType)iStatement.ColumnInt( 2 ) );
  1417             }            
  1417             }            
  1418         
  1418         
  1593             for ( err = iStatement.Next(); 
  1593             for ( err = iStatement.Next(); 
  1594                   err == KSqlAtRow; 
  1594                   err == KSqlAtRow; 
  1595                   err = iStatement.Next() )
  1595                   err = iStatement.Next() )
  1596                 {
  1596                 {
  1597                 // Get cell contents    
  1597                 // Get cell contents    
  1598                 mediaServerIds.Append( 
  1598                 mediaServerIds.AppendL( 
  1599                     iStatement.ColumnInt64( 0 ));
  1599                     iStatement.ColumnInt64( 0 ));
  1600                 }
  1600                 }
  1601             iStatement.Reset();            
  1601             iStatement.Reset();            
  1602             iStatement.Close();// Destruct statement
  1602             iStatement.Close();// Destruct statement
  1603             TInt mediaServerCount( mediaServerIds.Count() );             
  1603             TInt mediaServerCount( mediaServerIds.Count() );             
  1908             CCmFillListItem* filled = CCmFillListItem::NewLC();
  1908             CCmFillListItem* filled = CCmFillListItem::NewLC();
  1909             filled->SetPathL( temp );
  1909             filled->SetPathL( temp );
  1910             filled->SetSize( size );
  1910             filled->SetSize( size );
  1911             filled->SetListId( listId );
  1911             filled->SetListId( listId );
  1912             filled->SetDbId( fileId );
  1912             filled->SetDbId( fileId );
  1913             aFilled.Append( filled );
  1913             aFilled.AppendL( filled );
  1914             CleanupStack::Pop( filled );                
  1914             CleanupStack::Pop( filled );                
  1915             }                                
  1915             }                                
  1916         }
  1916         }
  1917     iStatement.Reset();                
  1917     iStatement.Reset();                
  1918     iStatement.Close();  // Destruct statement    
  1918     iStatement.Close();  // Destruct statement    
  2096         item->SetSize( iStatement.ColumnInt64( 3 ));
  2096         item->SetSize( iStatement.ColumnInt64( 3 ));
  2097         status = iStatement.ColumnInt( 4 );
  2097         status = iStatement.ColumnInt( 4 );
  2098         item->SetListId( iStatement.ColumnInt( 5 ) );
  2098         item->SetListId( iStatement.ColumnInt( 5 ) );
  2099         devId = iStatement.ColumnInt( 6 );
  2099         devId = iStatement.ColumnInt( 6 );
  2100         item->SetDevId( devId, (TCmListItemStatus)status );            
  2100         item->SetDevId( devId, (TCmListItemStatus)status );            
  2101         aItems.Append( item ); // transfer ownership
  2101         aItems.AppendL( item ); // transfer ownership
  2102         CleanupStack::Pop( item );
  2102         CleanupStack::Pop( item );
  2103         }       
  2103         }       
  2104     iStatement.Reset();                
  2104     iStatement.Reset();                
  2105     iStatement.Close();  // Destruct statement    
  2105     iStatement.Close();  // Destruct statement    
  2106     return ret;    
  2106     return ret;    
  2150         item->SetRefId( iStatement.ColumnInt64( 14 ) );
  2150         item->SetRefId( iStatement.ColumnInt64( 14 ) );
  2151         item->SetSelected( ( TCmFillRuleStatus )
  2151         item->SetSelected( ( TCmFillRuleStatus )
  2152             iStatement.ColumnInt( 15 ));
  2152             iStatement.ColumnInt( 15 ));
  2153         item->SetDriveId( iStatement.ColumnInt64( 16 ) );
  2153         item->SetDriveId( iStatement.ColumnInt64( 16 ) );
  2154         item->SetDriveNumber( iStatement.ColumnInt( 17 ) );    
  2154         item->SetDriveNumber( iStatement.ColumnInt( 17 ) );    
  2155         aItems.Append( item ); // transfer ownership
  2155         aItems.AppendL( item ); // transfer ownership
  2156         CleanupStack::Pop( item );
  2156         CleanupStack::Pop( item );
  2157         }
  2157         }
  2158     iStatement.Reset();                
  2158     iStatement.Reset();                
  2159     iStatement.Close();  // Destruct statement    
  2159     iStatement.Close();  // Destruct statement    
  2160     return ret;    
  2160     return ret;    
  2202                 foundIndex = i;
  2202                 foundIndex = i;
  2203                 }
  2203                 }
  2204             }
  2204             }
  2205         if( !found )
  2205         if( !found )
  2206             {
  2206             {
  2207             aItems.Append( item ); // transfer ownership
  2207             aItems.AppendL( item ); // transfer ownership
  2208             CleanupStack::Pop( item );
  2208             CleanupStack::Pop( item );
  2209             }
  2209             }
  2210         else
  2210         else
  2211             {
  2211             {
  2212             aItems[foundIndex]->SetDevId( devId, status );
  2212             aItems[foundIndex]->SetDevId( devId, status );
  2341         drive->SetDriveSize( iStatement.ColumnInt64( 3 ) );
  2341         drive->SetDriveSize( iStatement.ColumnInt64( 3 ) );
  2342         drive->SetDriveQuota( iStatement.ColumnInt64( 4 ) );
  2342         drive->SetDriveQuota( iStatement.ColumnInt64( 4 ) );
  2343         drive->SetUsedDriveQuota( iStatement.ColumnInt64( 5 ) );
  2343         drive->SetUsedDriveQuota( iStatement.ColumnInt64( 5 ) );
  2344         drive->SetDriveId( iStatement.ColumnInt64( 6 ) );
  2344         drive->SetDriveId( iStatement.ColumnInt64( 6 ) );
  2345         drive->SetStatus( (TBool)iStatement.ColumnInt( 7 ) );
  2345         drive->SetStatus( (TBool)iStatement.ColumnInt( 7 ) );
  2346         aDrives.Append( drive );
  2346         aDrives.AppendL( drive );
  2347         CleanupStack::Pop( drive ); 
  2347         CleanupStack::Pop( drive ); 
  2348         }   
  2348         }   
  2349     iStatement.Reset();                
  2349     iStatement.Reset();                
  2350     iStatement.Close();  // Destruct statement     
  2350     iStatement.Close();  // Destruct statement     
  2351     }
  2351     }