harvester/harvesterserver/src/cblacklistdb.cpp
changeset 1 6f2c1c46032b
parent 0 671dee74050a
child 7 a5fbfefd615f
equal deleted inserted replaced
0:671dee74050a 1:6f2c1c46032b
    16 */
    16 */
    17 
    17 
    18 
    18 
    19 #include "CBlacklistDb.h"
    19 #include "CBlacklistDb.h"
    20 #include <HarvesterServerLogger.h>
    20 #include <HarvesterServerLogger.h>
       
    21 #include "OstTraceDefinitions.h"
       
    22 #ifdef OST_TRACE_COMPILER_IN_USE
       
    23 #include "cblacklistdbTraces.h"
       
    24 #endif
       
    25 
    21 
    26 
    22 _LIT(KBlacklistFileName,"Blacklist.dat");
    27 _LIT(KBlacklistFileName,"Blacklist.dat");
    23 
    28 
    24 //Table name in blacklist database
    29 //Table name in blacklist database
    25 _LIT( KBlacklistTableName , "table" );
    30 _LIT( KBlacklistTableName , "table" );
    40 // CBlacklistDb::NewL()
    45 // CBlacklistDb::NewL()
    41 // -----------------------------------------------------------------------------
    46 // -----------------------------------------------------------------------------
    42 //
    47 //
    43 CBlacklistDb* CBlacklistDb::NewL()
    48 CBlacklistDb* CBlacklistDb::NewL()
    44     {
    49     {
       
    50     OstTraceFunctionEntry0( CBLACKLISTDB_NEWL_ENTRY );
    45     CPIXLOGSTRING("CBlacklistDb::NewL(): Entered");
    51     CPIXLOGSTRING("CBlacklistDb::NewL(): Entered");
    46     CBlacklistDb* instance = CBlacklistDb::NewLC();
    52     CBlacklistDb* instance = CBlacklistDb::NewLC();
    47     CleanupStack::Pop( instance );
    53     CleanupStack::Pop( instance );
    48     CPIXLOGSTRING("CBlacklistDb::NewL(): Exit");
    54     CPIXLOGSTRING("CBlacklistDb::NewL(): Exit");
       
    55     OstTraceFunctionExit0( CBLACKLISTDB_NEWL_EXIT );
    49     return instance;
    56     return instance;
    50     }
    57     }
    51 
    58 
    52 // -----------------------------------------------------------------------------
    59 // -----------------------------------------------------------------------------
    53 // CBlacklistDb::NewLC()
    60 // CBlacklistDb::NewLC()
    85 // CBlacklistDb::ConstructL()
    92 // CBlacklistDb::ConstructL()
    86 // -----------------------------------------------------------------------------
    93 // -----------------------------------------------------------------------------
    87 //
    94 //
    88 void CBlacklistDb::ConstructL()
    95 void CBlacklistDb::ConstructL()
    89     {
    96     {
       
    97     OstTraceFunctionEntry0( CBLACKLISTDB_CONSTRUCTL_ENTRY );
    90     CPIXLOGSTRING("CBlacklistDb::ConstructL(): Entered");
    98     CPIXLOGSTRING("CBlacklistDb::ConstructL(): Entered");
    91     //Open the sql database.If doesn't exist,create the sql database and open it     
    99     //Open the sql database.If doesn't exist,create the sql database and open it     
    92     User::LeaveIfError( iFs.Connect() );
   100     User::LeaveIfError( iFs.Connect() );
    93        
   101        
    94     TFileName privatePath;
   102     TFileName privatePath;
   114             TRAPD( error , CreateDBL() );
   122             TRAPD( error , CreateDBL() );
   115             
   123             
   116             if ( error == KErrNone )
   124             if ( error == KErrNone )
   117                 {                
   125                 {                
   118                 iOpened = ETrue;                
   126                 iOpened = ETrue;                
       
   127                 OstTrace0( TRACE_NORMAL, CBLACKLISTDB_CONSTRUCTL, "CBlacklistDb::ConstructL(): Database Opened" );
   119                 CPIXLOGSTRING("CBlacklistDb::ConstructL(): Database Opened");
   128                 CPIXLOGSTRING("CBlacklistDb::ConstructL(): Database Opened");
   120                 }
   129                 }
   121             }
   130             }
   122             break;
   131             break;
   123             
   132             
   124         default:
   133         default:
   125             break;
   134             break;
   126         }
   135         }
   127     
   136     
   128     CPIXLOGSTRING("CBlacklistDb::ConstructL(): Exit");
   137     CPIXLOGSTRING("CBlacklistDb::ConstructL(): Exit");
       
   138     OstTraceFunctionExit0( CBLACKLISTDB_CONSTRUCTL_EXIT );
   129     return;
   139     return;
   130     }
   140     }
   131 
   141 
   132 // -----------------------------------------------------------------------------
   142 // -----------------------------------------------------------------------------
   133 // CBlacklistDb::AddL()
   143 // CBlacklistDb::AddL()
   134 // -----------------------------------------------------------------------------
   144 // -----------------------------------------------------------------------------
   135 //
   145 //
   136 TInt CBlacklistDb::AddL( TInt32 aPluginUid , TInt aVersion )
   146 TInt CBlacklistDb::AddL( TInt32 aPluginUid , TInt aVersion )
   137     {
   147     {
       
   148     OstTraceFunctionEntry0( CBLACKLISTDB_ADDL_ENTRY );
   138     //Add the item record to database
   149     //Add the item record to database
       
   150     OstTraceExt2( TRACE_NORMAL, CBLACKLISTDB_ADDL, "CBlacklistDb::AddL;Uid=%x;Version=%d", aPluginUid, aVersion );
   139     CPIXLOGSTRING3("CBlacklistDb::AddL(): Uid = %x and Version = %d" , aPluginUid , aVersion);
   151     CPIXLOGSTRING3("CBlacklistDb::AddL(): Uid = %x and Version = %d" , aPluginUid , aVersion);
   140     
   152     
   141     if ( !iOpened )
   153     if ( !iOpened )
   142         return KErrNotReady;
   154         return KErrNotReady;
   143     
   155     
   164             }            
   176             }            
   165        }
   177        }
   166     CleanupStack::PopAndDestroy( &dbView ); // dbView/    
   178     CleanupStack::PopAndDestroy( &dbView ); // dbView/    
   167     User::LeaveIfError( iDatabase.Compact() );    
   179     User::LeaveIfError( iDatabase.Compact() );    
   168     CPIXLOGSTRING("CBlacklistDb::AddL(): Exit");
   180     CPIXLOGSTRING("CBlacklistDb::AddL(): Exit");
       
   181     OstTraceFunctionExit0( CBLACKLISTDB_ADDL_EXIT );
   169     return err;
   182     return err;
   170     }
   183     }
   171 
   184 
   172 // -----------------------------------------------------------------------------
   185 // -----------------------------------------------------------------------------
   173 // CBlacklistDb::RemoveL()
   186 // CBlacklistDb::RemoveL()
   174 // -----------------------------------------------------------------------------
   187 // -----------------------------------------------------------------------------
   175 //
   188 //
   176 void CBlacklistDb::Remove( TInt32 aPluginUid )
   189 void CBlacklistDb::Remove( TInt32 aPluginUid )
   177     {
   190     {
       
   191     OstTraceFunctionEntry0( CBLACKLISTDB_REMOVE_ENTRY );
       
   192     OstTrace1( TRACE_NORMAL, CBLACKLISTDB_REMOVE, "CBlacklistDb::Remove;Uid=%x", aPluginUid );
   178     CPIXLOGSTRING2("CBlacklistDb::RemoveL(): Uid = %x " , aPluginUid);
   193     CPIXLOGSTRING2("CBlacklistDb::RemoveL(): Uid = %x " , aPluginUid);
   179     
   194     
   180     if ( !iOpened )
   195     if ( !iOpened )
   181        return;
   196        return;
   182     
   197     
   187     
   202     
   188     //delete the row.
   203     //delete the row.
   189     TInt rowCount( iDatabase.Execute(sql) );
   204     TInt rowCount( iDatabase.Execute(sql) );
   190     if(rowCount > 0)
   205     if(rowCount > 0)
   191         {        
   206         {        
       
   207         OstTrace0( TRACE_NORMAL, DUP1_CBLACKLISTDB_REMOVE, "CBlacklistDb::RemoveL(): Removed UID succesfully" );
   192         CPIXLOGSTRING("CBlacklistDb::RemoveL(): Removed UID succesfully");
   208         CPIXLOGSTRING("CBlacklistDb::RemoveL(): Removed UID succesfully");
   193         }
   209         }
   194     else
   210     else
   195         {
   211         {
       
   212         OstTrace0( TRACE_NORMAL, DUP2_CBLACKLISTDB_REMOVE, "CBlacklistDb::RemoveL(): UID not found" );
   196         CPIXLOGSTRING("CBlacklistDb::RemoveL(): UID not found");
   213         CPIXLOGSTRING("CBlacklistDb::RemoveL(): UID not found");
   197         }
   214         }
   198     CPIXLOGSTRING("CBlacklistDb::RemoveL(): Exit");
   215     CPIXLOGSTRING("CBlacklistDb::RemoveL(): Exit");
       
   216     OstTraceFunctionExit0( CBLACKLISTDB_REMOVE_EXIT );
   199     return ;
   217     return ;
   200     }
   218     }
   201 
   219 
   202 // -----------------------------------------------------------------------------
   220 // -----------------------------------------------------------------------------
   203 // CBlacklistDb::iSAvailableL()
   221 // CBlacklistDb::iSAvailableL()
   204 // -----------------------------------------------------------------------------
   222 // -----------------------------------------------------------------------------
   205 //
   223 //
   206 TBool CBlacklistDb::FindWithVersionL( TInt32 aPluginUid , TInt aVersion )
   224 TBool CBlacklistDb::FindWithVersionL( TInt32 aPluginUid , TInt aVersion )
   207     {
   225     {
       
   226     OstTraceExt2( TRACE_NORMAL, CBLACKLISTDB_FINDWITHVERSIONL, "CBlacklistDb::FindWithVersionL;Uid=%x;Version=%d", aPluginUid, aVersion );
   208     CPIXLOGSTRING3("CBlacklistDb::FindWithVersionL(): Uid = %x and Version = %d" , aPluginUid , aVersion);
   227     CPIXLOGSTRING3("CBlacklistDb::FindWithVersionL(): Uid = %x and Version = %d" , aPluginUid , aVersion);
   209     
   228     
   210     if ( !iOpened )
   229     if ( !iOpened )
   211             return EFalse;
   230             return EFalse;
   212     
   231     
   231         CDbColSet* colSet = dbView.ColSetL(); 
   250         CDbColSet* colSet = dbView.ColSetL(); 
   232         TDbColNo versioncolno = colSet->ColNo(Kversion);        
   251         TDbColNo versioncolno = colSet->ColNo(Kversion);        
   233         TInt version = dbView.ColInt32( versioncolno );
   252         TInt version = dbView.ColInt32( versioncolno );
   234         if ( version == aVersion)
   253         if ( version == aVersion)
   235             {
   254             {
       
   255             OstTrace0( TRACE_NORMAL, DUP1_CBLACKLISTDB_FINDWITHVERSIONL, "CBlacklistDb::FindWithVersionL(): UID found" );
   236             CPIXLOGSTRING("CBlacklistDb::FindWithVersionL(): UID found");
   256             CPIXLOGSTRING("CBlacklistDb::FindWithVersionL(): UID found");
   237             found = ETrue;
   257             found = ETrue;
   238             }        
   258             }        
   239        }    
   259        }    
   240     CleanupStack::PopAndDestroy( &dbView ); // dbView/
   260     CleanupStack::PopAndDestroy( &dbView ); // dbView/
   245 // CBlacklistDb::UpdateL
   265 // CBlacklistDb::UpdateL
   246 // -----------------------------------------------------------------------------
   266 // -----------------------------------------------------------------------------
   247 //
   267 //
   248 TInt CBlacklistDb::UpdateL( TInt32 aPluginUid , TInt aVersion )
   268 TInt CBlacklistDb::UpdateL( TInt32 aPluginUid , TInt aVersion )
   249 	{
   269 	{
       
   270 	OstTraceFunctionEntry0( CBLACKLISTDB_UPDATEL_ENTRY );
   250 	//Add the item record to database
   271 	//Add the item record to database
       
   272     OstTraceExt2( TRACE_NORMAL, CBLACKLISTDB_UPDATEL, "CBlacklistDb::UpdateL;Uid=%x;Version=%d", aPluginUid, aVersion );
   251     CPIXLOGSTRING3("CBlacklistDb::UpdateL(): Uid = %x and Version = %d" , aPluginUid , aVersion);
   273     CPIXLOGSTRING3("CBlacklistDb::UpdateL(): Uid = %x and Version = %d" , aPluginUid , aVersion);
   252     
   274     
   253     if ( !iOpened )
   275     if ( !iOpened )
   254        return KErrNotReady;
   276        return KErrNotReady;
   255     
   277     
   286         }        
   308         }        
   287        
   309        
   288     CleanupStack::PopAndDestroy( &dbView ); // dbView/    
   310     CleanupStack::PopAndDestroy( &dbView ); // dbView/    
   289     User::LeaveIfError( iDatabase.Compact() );    
   311     User::LeaveIfError( iDatabase.Compact() );    
   290     CPIXLOGSTRING("CBlacklistDb::UpdateL(): Exit");
   312     CPIXLOGSTRING("CBlacklistDb::UpdateL(): Exit");
       
   313     OstTraceFunctionExit0( CBLACKLISTDB_UPDATEL_EXIT );
   291     return KErrNone;
   314     return KErrNone;
   292 	}
   315 	}
   293 
   316 
   294 // -----------------------------------------------------------------------------
   317 // -----------------------------------------------------------------------------
   295 // CBlacklistDb::FindL
   318 // CBlacklistDb::FindL
   296 // -----------------------------------------------------------------------------
   319 // -----------------------------------------------------------------------------
   297 //
   320 //
   298 TBool CBlacklistDb::FindL(TInt32 aPluginUid)
   321 TBool CBlacklistDb::FindL(TInt32 aPluginUid)
   299 	{
   322 	{
       
   323 	OstTrace1( TRACE_NORMAL, CBLACKLISTDB_FINDL, "CBlacklistDb::FindL;Uid=%x", aPluginUid );
   300 	CPIXLOGSTRING2("CBlacklistDb::FindL(): Uid = %x " , aPluginUid );
   324 	CPIXLOGSTRING2("CBlacklistDb::FindL(): Uid = %x " , aPluginUid );
   301 	
   325 	
   302 	if ( !iOpened )
   326 	if ( !iOpened )
   303 	        return EFalse;
   327 	        return EFalse;
   304 	
   328 	
   316 
   340 
   317     TInt isAtRow( dbView.FirstL() );
   341     TInt isAtRow( dbView.FirstL() );
   318     
   342     
   319     if ( isAtRow )
   343     if ( isAtRow )
   320        {        
   344        {        
       
   345 		OstTrace0( TRACE_NORMAL, DUP1_CBLACKLISTDB_FINDL, "CBlacklistDb::FindL(): UID found" );
   321 		CPIXLOGSTRING("CBlacklistDb::FindL(): UID found");
   346 		CPIXLOGSTRING("CBlacklistDb::FindL(): UID found");
   322 		found = ETrue;                 
   347 		found = ETrue;                 
   323        }    
   348        }    
   324     CleanupStack::PopAndDestroy( &dbView ); // dbView/
   349     CleanupStack::PopAndDestroy( &dbView ); // dbView/
   325     return found;
   350     return found;
   328 // CBlacklistDb::CreateDBL
   353 // CBlacklistDb::CreateDBL
   329 // -----------------------------------------------------------------------------
   354 // -----------------------------------------------------------------------------
   330 //
   355 //
   331 void CBlacklistDb::CreateDBL()
   356 void CBlacklistDb::CreateDBL()
   332     {
   357     {
       
   358     OstTraceFunctionEntry0( CBLACKLISTDB_CREATEDBL_ENTRY );
   333     CPIXLOGSTRING("CBlacklistDb::CreateDBL(): Enter");
   359     CPIXLOGSTRING("CBlacklistDb::CreateDBL(): Enter");
   334     
   360     
   335     iDatabase.Close();
   361     iDatabase.Close();
   336     
   362     
   337     TFileName privatePath;
   363     TFileName privatePath;
   348     User::LeaveIfError( iDatabase.CreateTable( KBlacklistTableName , *columns ) );
   374     User::LeaveIfError( iDatabase.CreateTable( KBlacklistTableName , *columns ) );
   349     //clean up of variables (columns and dataFile)
   375     //clean up of variables (columns and dataFile)
   350     CleanupStack::PopAndDestroy( columns );
   376     CleanupStack::PopAndDestroy( columns );
   351     
   377     
   352     CPIXLOGSTRING("CBlacklistDb::CreateDBL(): Exit");
   378     CPIXLOGSTRING("CBlacklistDb::CreateDBL(): Exit");
       
   379     OstTraceFunctionExit0( CBLACKLISTDB_CREATEDBL_EXIT );
   353     }
   380     }
   354 
   381 
   355 // -----------------------------------------------------------------------------
   382 // -----------------------------------------------------------------------------
   356 // CBlacklistDb::CreateColumnSetLC
   383 // CBlacklistDb::CreateColumnSetLC
   357 // -----------------------------------------------------------------------------
   384 // -----------------------------------------------------------------------------
   358 //
   385 //
   359 CDbColSet* CBlacklistDb::CreateColumnSetLC()
   386 CDbColSet* CBlacklistDb::CreateColumnSetLC()
   360     {
   387     {
       
   388     OstTraceFunctionEntry0( CBLACKLISTDB_CREATECOLUMNSETLC_ENTRY );
   361     CPIXLOGSTRING("CBlacklistDb::CreateColumnSetLC(): Enter");
   389     CPIXLOGSTRING("CBlacklistDb::CreateColumnSetLC(): Enter");
   362     
   390     
   363     CDbColSet* columns = CDbColSet::NewLC();
   391     CDbColSet* columns = CDbColSet::NewLC();
   364     
   392     
   365     //Add uid column
   393     //Add uid column
   373     col.iAttributes = TDbCol::ENotNull;
   401     col.iAttributes = TDbCol::ENotNull;
   374     columns->AddL( col );
   402     columns->AddL( col );
   375     
   403     
   376     CPIXLOGSTRING("CBlacklistDb::CreateColumnSetLC(): Exit");
   404     CPIXLOGSTRING("CBlacklistDb::CreateColumnSetLC(): Exit");
   377     
   405     
       
   406     OstTraceFunctionExit0( CBLACKLISTDB_CREATECOLUMNSETLC_EXIT );
   378     return columns; // columns stays on CleanupStack
   407     return columns; // columns stays on CleanupStack
   379     }
   408     }