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 |
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 |