|
99
|
1 |
/*
|
|
|
2 |
* Copyright (c) 2009 Nokia Corporation and/or its subsidiary(-ies).
|
|
|
3 |
* All rights reserved.
|
|
|
4 |
* This component and the accompanying materials are made available
|
|
|
5 |
* under the terms of "Eclipse Public License v1.0"
|
|
|
6 |
* which accompanies this distribution, and is available
|
|
|
7 |
* at the URL "http://www.eclipse.org/legal/epl-v10.html".
|
|
|
8 |
*
|
|
|
9 |
* Initial Contributors:
|
|
|
10 |
* Nokia Corporation - initial contribution.
|
|
|
11 |
*
|
|
|
12 |
* Contributors:
|
|
|
13 |
*
|
|
|
14 |
* Description:
|
|
|
15 |
*
|
|
|
16 |
*/
|
|
|
17 |
#include "afstorage.h"
|
|
|
18 |
#include <bautils.h>
|
|
|
19 |
#include <hash.h>
|
|
|
20 |
#include <s32mem.h>
|
|
|
21 |
|
|
112
|
22 |
#include "afdatabasecleaner.h"
|
|
99
|
23 |
#include "afqueries.h"
|
|
|
24 |
#include "afentry.h"
|
|
|
25 |
|
|
|
26 |
_LIT(KDbName, "activity.db");
|
|
|
27 |
_LIT(KDbDrive, "c:");
|
|
|
28 |
const TInt KMaxPathLength = 256;
|
|
|
29 |
|
|
|
30 |
_LIT(KNonPersistent, "non_persistent\\");
|
|
|
31 |
_LIT(KPersistent, "persistent\\");
|
|
|
32 |
_LIT(KUidFormat, "%+08x\\");
|
|
|
33 |
_LIT(KExtFormat, ".mbm");
|
|
|
34 |
|
|
|
35 |
// -----------------------------------------------------------------------------
|
|
|
36 |
/**
|
|
|
37 |
* Constructor for performing 1st stage construction
|
|
|
38 |
* @param session - initialized session to file system
|
|
|
39 |
*/
|
|
|
40 |
CAfStorage::CAfStorage(RFs& session)
|
|
|
41 |
:
|
|
116
|
42 |
iFsSession(session)
|
|
|
43 |
{
|
|
99
|
44 |
// No implementation required
|
|
116
|
45 |
}
|
|
99
|
46 |
|
|
|
47 |
// -----------------------------------------------------------------------------
|
|
|
48 |
/**
|
|
|
49 |
* Destructor.
|
|
|
50 |
*/
|
|
|
51 |
CAfStorage::~CAfStorage()
|
|
116
|
52 |
{
|
|
|
53 |
delete iDatabaseCleaner;
|
|
|
54 |
iActDb.Close();
|
|
|
55 |
delete iFileStore;
|
|
|
56 |
}
|
|
99
|
57 |
|
|
|
58 |
// -----------------------------------------------------------------------------
|
|
|
59 |
/**
|
|
|
60 |
* Two-phased constructor.
|
|
|
61 |
* @param session - initialized session to file system
|
|
|
62 |
*/
|
|
|
63 |
CAfStorage* CAfStorage::NewL(RFs& session)
|
|
116
|
64 |
{
|
|
99
|
65 |
CAfStorage* self = new (ELeave) CAfStorage(session);
|
|
|
66 |
CleanupStack::PushL(self);
|
|
|
67 |
self->ConstructL();
|
|
|
68 |
CleanupStack::Pop(); // self;
|
|
|
69 |
return self;
|
|
116
|
70 |
}
|
|
99
|
71 |
|
|
|
72 |
// -----------------------------------------------------------------------------
|
|
|
73 |
/**
|
|
|
74 |
* EPOC default constructor for performing 2nd stage construction
|
|
|
75 |
*/
|
|
|
76 |
void CAfStorage::ConstructL()
|
|
116
|
77 |
{
|
|
99
|
78 |
RBuf path;
|
|
|
79 |
CleanupClosePushL( path );
|
|
|
80 |
path.CreateL(KMaxPathLength);
|
|
116
|
81 |
User::LeaveIfError(iFsSession.PrivatePath(path ));
|
|
99
|
82 |
path.Append(KDbName);
|
|
|
83 |
path.Insert(0, KDbDrive);
|
|
116
|
84 |
BaflUtils::EnsurePathExistsL(iFsSession, path);
|
|
|
85 |
BaflUtils::FileExists(iFsSession, path) ? OpenDbL(path) : CreateDbL(path);
|
|
99
|
86 |
CleanupStack::PopAndDestroy(&path);
|
|
116
|
87 |
|
|
|
88 |
iDatabaseCleaner = new (ELeave) CAfDatabaseCleaner(iActDb);
|
|
|
89 |
|
|
99
|
90 |
DeleteNonPersistentActivitiesL();
|
|
112
|
91 |
RequestCleanup();
|
|
116
|
92 |
}
|
|
99
|
93 |
|
|
|
94 |
// -----------------------------------------------------------------------------
|
|
|
95 |
/**
|
|
|
96 |
* Create database and its structure
|
|
|
97 |
* @param databaseFile - database file path
|
|
|
98 |
*/
|
|
|
99 |
void CAfStorage::CreateDbL(const TDesC& databaseFile)
|
|
116
|
100 |
{
|
|
|
101 |
iFileStore = CPermanentFileStore::ReplaceL(iFsSession,
|
|
99
|
102 |
databaseFile,
|
|
|
103 |
EFileRead|EFileWrite);
|
|
116
|
104 |
iFileStore->SetTypeL(iFileStore->Layout());// Set file store type
|
|
|
105 |
TStreamId id = iActDb.CreateL(iFileStore);// Create stream object
|
|
|
106 |
iFileStore->SetRootL(id);// Keep database id as root of store
|
|
|
107 |
iFileStore->CommitL();// Complete creation by commiting
|
|
99
|
108 |
CreateTableL();
|
|
116
|
109 |
}
|
|
99
|
110 |
|
|
|
111 |
// -----------------------------------------------------------------------------
|
|
|
112 |
/**
|
|
|
113 |
* Open database
|
|
|
114 |
* @param databaseFile - database file path
|
|
|
115 |
*/
|
|
|
116 |
void CAfStorage::OpenDbL(const TDesC& databaseFile)
|
|
116
|
117 |
{
|
|
|
118 |
TRAPD( errNo,
|
|
|
119 |
iFileStore = CPermanentFileStore::OpenL( iFsSession,
|
|
|
120 |
databaseFile,
|
|
|
121 |
EFileRead|EFileWrite );
|
|
|
122 |
iFileStore->SetTypeL( iFileStore->Layout() ); /* Set file store type*/
|
|
|
123 |
iActDb.OpenL( iFileStore, iFileStore->Root() );
|
|
|
124 |
VerifyTableL(); )
|
|
|
125 |
if( KErrNone != errNo )
|
|
|
126 |
{
|
|
|
127 |
//database is corrupted. recreate
|
|
|
128 |
iActDb.Close();
|
|
|
129 |
delete iFileStore;
|
|
|
130 |
iFileStore = 0;
|
|
|
131 |
CreateDbL( databaseFile );
|
|
|
132 |
}
|
|
|
133 |
}
|
|
|
134 |
|
|
|
135 |
// -----------------------------------------------------------------------------
|
|
|
136 |
/**
|
|
|
137 |
* Verify database structure
|
|
|
138 |
*/
|
|
|
139 |
void CAfStorage::VerifyDbL()
|
|
99
|
140 |
{
|
|
116
|
141 |
TInt errNo(KErrCorrupt);
|
|
|
142 |
CDbTableNames* tables = iActDb.TableNamesL();
|
|
|
143 |
CleanupStack::PushL( tables );
|
|
|
144 |
for( TInt iter(0); iter < tables->Count() && KErrNone != errNo; ++iter )
|
|
|
145 |
{
|
|
|
146 |
if( 0 == (*tables)[iter].Compare( KActivityTableName() ) )
|
|
|
147 |
{
|
|
|
148 |
VerifyTableL();
|
|
|
149 |
errNo = KErrNone;
|
|
|
150 |
}
|
|
|
151 |
}
|
|
|
152 |
CleanupStack::PopAndDestroy( tables );
|
|
|
153 |
User::LeaveIfError( errNo );
|
|
99
|
154 |
}
|
|
|
155 |
|
|
|
156 |
// -----------------------------------------------------------------------------
|
|
116
|
157 |
CDbColSet* CAfStorage::ExpectedTableLC()
|
|
|
158 |
{
|
|
|
159 |
CDbColSet* actColSet = CDbColSet::NewLC();
|
|
|
160 |
|
|
|
161 |
TDbCol appName(KApplicationColumnName, EDbColInt64);
|
|
|
162 |
appName.iAttributes = TDbCol::ENotNull;
|
|
|
163 |
actColSet->AddL( appName );
|
|
|
164 |
|
|
|
165 |
TDbCol actName( KActivityColumnName, EDbColText16 );// Using default length
|
|
|
166 |
actName.iAttributes = TDbCol::ENotNull;
|
|
|
167 |
actColSet->AddL( actName );
|
|
|
168 |
|
|
|
169 |
// custom name
|
|
|
170 |
actColSet->AddL( TDbCol( KCustomNameColumnName, EDbColText16 ) );
|
|
|
171 |
|
|
|
172 |
TDbCol actFlags( KFlagsColumnName, EDbColInt32 );
|
|
|
173 |
actFlags.iAttributes = TDbCol::ENotNull;
|
|
|
174 |
actColSet->AddL(actFlags);
|
|
|
175 |
|
|
|
176 |
TDbCol actTimestamp( KTimestampColumnName, EDbColDateTime );
|
|
|
177 |
actTimestamp.iAttributes = TDbCol::ENotNull;
|
|
|
178 |
actColSet->AddL(actTimestamp);
|
|
|
179 |
|
|
|
180 |
actColSet->AddL( TDbCol( KDataColumnName, EDbColLongBinary ) );// Stream Data
|
|
|
181 |
|
|
|
182 |
return actColSet;
|
|
|
183 |
}
|
|
|
184 |
|
|
|
185 |
// -----------------------------------------------------------------------------
|
|
99
|
186 |
/**
|
|
|
187 |
* Create database structure
|
|
|
188 |
*/
|
|
|
189 |
void CAfStorage::CreateTableL()
|
|
116
|
190 |
{
|
|
|
191 |
CDbColSet* actColSet(ExpectedTableLC());
|
|
|
192 |
// Create the table
|
|
|
193 |
User::LeaveIfError(iActDb.CreateTable(KActivityTableName,
|
|
|
194 |
*actColSet));
|
|
|
195 |
CleanupStack::PopAndDestroy(actColSet);
|
|
|
196 |
}
|
|
99
|
197 |
|
|
116
|
198 |
// -----------------------------------------------------------------------------
|
|
|
199 |
/**
|
|
|
200 |
* Verify table structure
|
|
|
201 |
*/
|
|
|
202 |
void CAfStorage::VerifyTableL()
|
|
|
203 |
{
|
|
|
204 |
CDbColSet *currentTable(iActDb.ColSetL(KActivityTableName));
|
|
|
205 |
CleanupStack::PushL(currentTable);
|
|
|
206 |
CDbColSet *expectedTable(ExpectedTableLC());
|
|
|
207 |
for( TInt iter(1); iter <= expectedTable->Count(); ++iter )
|
|
|
208 |
{
|
|
|
209 |
const TDbCol& expectedColumn((*expectedTable)[iter]);
|
|
|
210 |
const TDbCol* currentColumn(currentTable->Col(expectedColumn.iName));
|
|
|
211 |
if( 0 == currentColumn ||
|
|
|
212 |
expectedColumn.iAttributes != currentColumn->iAttributes ||
|
|
|
213 |
expectedColumn.iMaxLength != currentColumn->iMaxLength ||
|
|
|
214 |
expectedColumn.iType != currentColumn->iType )
|
|
|
215 |
{
|
|
|
216 |
User::Leave(KErrCorrupt);
|
|
|
217 |
}
|
|
|
218 |
}
|
|
|
219 |
CleanupStack::PopAndDestroy( expectedTable );
|
|
|
220 |
CleanupStack::PopAndDestroy( currentTable );
|
|
|
221 |
}
|
|
99
|
222 |
// -----------------------------------------------------------------------------
|
|
|
223 |
/**
|
|
|
224 |
* Delete non-persistent activities
|
|
|
225 |
*/
|
|
|
226 |
void CAfStorage::DeleteNonPersistentActivitiesL()
|
|
116
|
227 |
{
|
|
|
228 |
HBufC *query(BuildQueryLC(KDeleteNonPersistentActivities(),
|
|
|
229 |
CAfEntry::Persistent,
|
|
|
230 |
KNullDesC));
|
|
|
231 |
User::LeaveIfError(iActDb.Execute(*query));
|
|
99
|
232 |
RBuf privatePath;
|
|
|
233 |
CleanupClosePushL(privatePath);
|
|
|
234 |
privatePath.CreateL(KMaxPathLength);
|
|
|
235 |
StoragePathL(privatePath, Fs(), FALSE);
|
|
|
236 |
CFileMan *fileMan = CFileMan::NewL(Fs());
|
|
|
237 |
TInt i = fileMan->RmDir(privatePath);
|
|
|
238 |
delete fileMan;
|
|
|
239 |
CleanupStack::PopAndDestroy(&privatePath);
|
|
|
240 |
CleanupStack::PopAndDestroy(query);
|
|
116
|
241 |
}
|
|
99
|
242 |
|
|
|
243 |
// -----------------------------------------------------------------------------
|
|
|
244 |
/**
|
|
|
245 |
* Register new activity
|
|
|
246 |
* @param appId - application id
|
|
|
247 |
* @param actId - activity id
|
|
|
248 |
* @param flags - activity flags
|
|
|
249 |
* @param imgSrc - activity thumbnail source
|
|
|
250 |
* @param privateData - activity private data
|
|
|
251 |
* @param publicData - activity public data
|
|
|
252 |
*/
|
|
|
253 |
void CAfStorage::AddActivityL(CAfEntry& entry)
|
|
116
|
254 |
{
|
|
99
|
255 |
//verify if row already exists
|
|
|
256 |
TInt errNo(KErrNone);
|
|
|
257 |
RDbView view;
|
|
|
258 |
CleanupClosePushL(view);
|
|
|
259 |
TRAP( errNo, GetActivityForUpdateL(view, entry.ApplicationId(), entry.ActivityId()));
|
|
116
|
260 |
if( KErrNone == errNo )
|
|
|
261 |
{
|
|
99
|
262 |
User::Leave(KErrAlreadyExists);
|
|
116
|
263 |
}
|
|
99
|
264 |
CleanupStack::PopAndDestroy(&view);
|
|
|
265 |
|
|
|
266 |
//write table
|
|
|
267 |
RDbTable table;
|
|
|
268 |
CleanupClosePushL(table);
|
|
116
|
269 |
User::LeaveIfError(table.Open(iActDb, KActivityTableName, table.EUpdatable));
|
|
99
|
270 |
CDbColSet *row = table.ColSetL();
|
|
|
271 |
CleanupStack::PushL(row);
|
|
116
|
272 |
|
|
|
273 |
TTime time;
|
|
|
274 |
time.UniversalTime();
|
|
|
275 |
|
|
99
|
276 |
table.InsertL();
|
|
|
277 |
TRAP(errNo,
|
|
|
278 |
table.SetColL(row->ColNo(KApplicationColumnName), TInt64(entry.ApplicationId()));
|
|
|
279 |
table.SetColL(row->ColNo(KActivityColumnName), entry.ActivityId());
|
|
116
|
280 |
table.SetColL(row->ColNo(KCustomNameColumnName), entry.CustomActivityName());
|
|
99
|
281 |
table.SetColL(row->ColNo(KFlagsColumnName), entry.Flags());
|
|
116
|
282 |
table.SetColL(row->ColNo(KTimestampColumnName), time.DateTime());
|
|
|
283 |
ExternalizeDataL(table, entry, row->ColNo(KDataColumnName) );
|
|
|
284 |
|
|
99
|
285 |
table.PutL();)
|
|
116
|
286 |
if( KErrNone != errNo )
|
|
|
287 |
{
|
|
99
|
288 |
table.Cancel();
|
|
|
289 |
User::Leave(errNo);
|
|
116
|
290 |
}
|
|
99
|
291 |
CleanupStack::PopAndDestroy(row);
|
|
|
292 |
CleanupStack::PopAndDestroy(&table);
|
|
116
|
293 |
}
|
|
99
|
294 |
|
|
|
295 |
// -----------------------------------------------------------------------------
|
|
|
296 |
/**
|
|
|
297 |
* Update activity
|
|
|
298 |
* @param entry - activity data
|
|
|
299 |
*/
|
|
|
300 |
void CAfStorage::UpdateActivityL(CAfEntry& entry)
|
|
116
|
301 |
{
|
|
|
302 |
TTime time;
|
|
|
303 |
time.UniversalTime();
|
|
99
|
304 |
RDbView view;
|
|
|
305 |
CleanupClosePushL(view);
|
|
|
306 |
GetActivityForUpdateL(view, entry.ApplicationId(), entry.ActivityId());
|
|
|
307 |
view.UpdateL();
|
|
|
308 |
TRAPD(errNo,
|
|
|
309 |
CDbColSet* colSet = view.ColSetL();
|
|
|
310 |
CleanupStack::PushL(colSet);
|
|
|
311 |
|
|
|
312 |
view.SetColL(colSet->ColNo(KFlagsColumnName), entry.Flags());
|
|
116
|
313 |
view.SetColL(colSet->ColNo(KTimestampColumnName), time.DateTime());
|
|
|
314 |
view.SetColL(colSet->ColNo(KCustomNameColumnName), entry.CustomActivityName());
|
|
99
|
315 |
ExternalizeDataL(view, entry, colSet->ColNo(KDataColumnName));
|
|
|
316 |
|
|
|
317 |
view.PutL();
|
|
|
318 |
CleanupStack::PopAndDestroy(colSet);)
|
|
|
319 |
|
|
116
|
320 |
if(KErrNone != errNo)
|
|
|
321 |
{
|
|
99
|
322 |
view.Cancel();
|
|
|
323 |
User::Leave(errNo);
|
|
116
|
324 |
}
|
|
99
|
325 |
CleanupStack::PopAndDestroy(&view);
|
|
116
|
326 |
}
|
|
99
|
327 |
|
|
|
328 |
// -----------------------------------------------------------------------------
|
|
|
329 |
/**
|
|
107
|
330 |
* Save activity
|
|
|
331 |
* @param entry - activity data
|
|
|
332 |
*/
|
|
|
333 |
void CAfStorage::SaveActivityL(CAfEntry &entry)
|
|
|
334 |
{
|
|
116
|
335 |
TTime time;
|
|
|
336 |
time.UniversalTime();
|
|
107
|
337 |
// @todo check if this can be tidied up
|
|
|
338 |
//verify if row already exists
|
|
|
339 |
TInt errNo(KErrNone);
|
|
|
340 |
RDbView view;
|
|
|
341 |
CleanupClosePushL(view);
|
|
|
342 |
TRAP(errNo, GetActivityForUpdateL(view, entry.ApplicationId(), entry.ActivityId()));
|
|
116
|
343 |
if( KErrNone == errNo )
|
|
|
344 |
{
|
|
107
|
345 |
// update
|
|
|
346 |
view.UpdateL();
|
|
|
347 |
TRAPD(errNo,
|
|
|
348 |
CDbColSet* colSet = view.ColSetL();
|
|
|
349 |
CleanupStack::PushL(colSet);
|
|
|
350 |
|
|
|
351 |
view.SetColL(colSet->ColNo(KFlagsColumnName), entry.Flags());
|
|
116
|
352 |
view.SetColL(colSet->ColNo(KTimestampColumnName), time.DateTime());
|
|
|
353 |
view.SetColL(colSet->ColNo(KCustomNameColumnName), entry.CustomActivityName());
|
|
107
|
354 |
ExternalizeDataL(view, entry, colSet->ColNo(KDataColumnName));
|
|
|
355 |
|
|
|
356 |
view.PutL();
|
|
|
357 |
CleanupStack::PopAndDestroy(colSet);)
|
|
|
358 |
|
|
116
|
359 |
if (KErrNone != errNo)
|
|
|
360 |
{
|
|
107
|
361 |
view.Cancel();
|
|
|
362 |
User::Leave(errNo);
|
|
116
|
363 |
}
|
|
107
|
364 |
}
|
|
116
|
365 |
else
|
|
|
366 |
{
|
|
107
|
367 |
// insert
|
|
|
368 |
|
|
|
369 |
//write table
|
|
|
370 |
RDbTable table;
|
|
|
371 |
CleanupClosePushL(table);
|
|
116
|
372 |
User::LeaveIfError(table.Open(iActDb, KActivityTableName, table.EUpdatable));
|
|
107
|
373 |
CDbColSet *row = table.ColSetL();
|
|
|
374 |
CleanupStack::PushL(row);
|
|
|
375 |
|
|
|
376 |
table.InsertL();
|
|
|
377 |
TRAP(errNo,
|
|
|
378 |
table.SetColL(row->ColNo(KApplicationColumnName), TInt64(entry.ApplicationId()));
|
|
|
379 |
table.SetColL(row->ColNo(KActivityColumnName), entry.ActivityId());
|
|
116
|
380 |
table.SetColL(row->ColNo(KCustomNameColumnName), entry.CustomActivityName());
|
|
107
|
381 |
table.SetColL(row->ColNo(KFlagsColumnName), entry.Flags());
|
|
116
|
382 |
table.SetColL(row->ColNo(KTimestampColumnName), time.DateTime());
|
|
107
|
383 |
ExternalizeDataL(table, entry, row->ColNo(KDataColumnName));
|
|
|
384 |
table.PutL();)
|
|
|
385 |
if (KErrNone != errNo) {
|
|
|
386 |
table.Cancel();
|
|
|
387 |
User::Leave(errNo);
|
|
|
388 |
}
|
|
|
389 |
CleanupStack::PopAndDestroy(row);
|
|
|
390 |
CleanupStack::PopAndDestroy(&table);
|
|
|
391 |
}
|
|
|
392 |
CleanupStack::PopAndDestroy(&view);
|
|
|
393 |
}
|
|
|
394 |
|
|
|
395 |
// -----------------------------------------------------------------------------
|
|
|
396 |
/**
|
|
99
|
397 |
* Delete activity
|
|
|
398 |
* @param appId - application id
|
|
|
399 |
* @param actId - activity id
|
|
|
400 |
*/
|
|
|
401 |
void CAfStorage::DeleteActivityL(CAfEntry& entry)
|
|
116
|
402 |
{
|
|
99
|
403 |
HBufC *query(DeleteRowLC(entry.ApplicationId(), entry.ActivityId()));
|
|
116
|
404 |
User::LeaveIfError(iActDb.Execute(*query));
|
|
99
|
405 |
CleanupStack::PopAndDestroy(query);
|
|
116
|
406 |
}
|
|
99
|
407 |
|
|
|
408 |
// -----------------------------------------------------------------------------
|
|
|
409 |
//
|
|
|
410 |
void CAfStorage::DeleteActivitiesL(CAfEntry& entry)
|
|
116
|
411 |
{
|
|
99
|
412 |
HBufC *query(DeleteRowsLC(entry.ApplicationId()));
|
|
116
|
413 |
User::LeaveIfError(iActDb.Execute(*query));
|
|
99
|
414 |
RBuf privatePath;
|
|
|
415 |
CleanupClosePushL(privatePath);
|
|
|
416 |
privatePath.CreateL(KMaxPathLength);
|
|
|
417 |
AppStoragePathL(privatePath, Fs(), entry.ApplicationId(), FALSE);
|
|
|
418 |
CFileMan *fileMan = CFileMan::NewL(Fs());
|
|
|
419 |
CleanupStack::PushL(fileMan);
|
|
|
420 |
fileMan->RmDir(privatePath);
|
|
|
421 |
privatePath.Zero();
|
|
|
422 |
|
|
|
423 |
AppStoragePathL(privatePath, Fs(), entry.ApplicationId(), TRUE);
|
|
|
424 |
fileMan->RmDir(privatePath);
|
|
|
425 |
|
|
|
426 |
CleanupStack::PopAndDestroy(fileMan);
|
|
|
427 |
CleanupStack::PopAndDestroy(&privatePath);
|
|
|
428 |
CleanupStack::PopAndDestroy(query);
|
|
116
|
429 |
}
|
|
99
|
430 |
|
|
|
431 |
// -----------------------------------------------------------------------------
|
|
|
432 |
//
|
|
|
433 |
// -----------------------------------------------------------------------------
|
|
|
434 |
//
|
|
116
|
435 |
void CAfStorage::AllActivitiesL(RPointerArray<CAfEntry>& dst, TInt aLimit)
|
|
|
436 |
{
|
|
|
437 |
ActivitiesL(dst, KSelectRows(), CAfEntry::Public, aLimit);
|
|
|
438 |
}
|
|
99
|
439 |
|
|
|
440 |
// -----------------------------------------------------------------------------
|
|
|
441 |
/**
|
|
|
442 |
* Serialize application activity into the buffer
|
|
|
443 |
* @param dst - destination buffer
|
|
|
444 |
* @param appId - application id
|
|
|
445 |
*/
|
|
|
446 |
void CAfStorage::ActivitiesL(RPointerArray<CAfEntry>& dst,TInt appId)
|
|
116
|
447 |
{
|
|
99
|
448 |
HBufC *query(SelectRowsLC(appId));
|
|
|
449 |
ActivitiesL(dst, *query, CAfEntry::Private);
|
|
|
450 |
CleanupStack::PopAndDestroy(query);
|
|
116
|
451 |
}
|
|
99
|
452 |
|
|
|
453 |
// -----------------------------------------------------------------------------
|
|
|
454 |
/**
|
|
|
455 |
* Serialize application activity into the buffer
|
|
|
456 |
* @param dst - destination entry
|
|
|
457 |
* @param src - condition pattern
|
|
|
458 |
*/
|
|
|
459 |
void CAfStorage::ActivityL(RPointerArray<CAfEntry> &dst, CAfEntry& src)
|
|
116
|
460 |
{
|
|
99
|
461 |
HBufC *query = SelectRowLC(src.ApplicationId(), src.ActivityId());
|
|
116
|
462 |
ActivitiesL(dst, *query, CAfEntry::Private, 1, ETrue);
|
|
|
463 |
if( 0 >= dst.Count() )
|
|
|
464 |
{
|
|
99
|
465 |
User::Leave(KErrNotFound);
|
|
116
|
466 |
}
|
|
99
|
467 |
CleanupStack::PopAndDestroy(query);
|
|
116
|
468 |
}
|
|
99
|
469 |
|
|
|
470 |
// -----------------------------------------------------------------------------
|
|
|
471 |
/**
|
|
|
472 |
* Provide initialized file system session
|
|
|
473 |
* @return file system session
|
|
|
474 |
*/
|
|
|
475 |
RFs& CAfStorage::Fs()
|
|
116
|
476 |
{
|
|
|
477 |
return iFsSession;
|
|
|
478 |
}
|
|
99
|
479 |
|
|
|
480 |
// -----------------------------------------------------------------------------
|
|
|
481 |
/**
|
|
|
482 |
* Format query to select activity row
|
|
|
483 |
* @param appId - application id
|
|
|
484 |
* @param actId - activity id
|
|
|
485 |
* @return formated sql query
|
|
|
486 |
*/
|
|
|
487 |
HBufC* CAfStorage::SelectRowLC(TInt appId, const TDesC& actId) const
|
|
116
|
488 |
{
|
|
99
|
489 |
return BuildQueryLC(KSelectRow(),appId, actId);
|
|
116
|
490 |
}
|
|
99
|
491 |
|
|
|
492 |
// -----------------------------------------------------------------------------
|
|
|
493 |
/**
|
|
|
494 |
* Format query to select activities for application
|
|
|
495 |
* @param appId - application id
|
|
|
496 |
* @return formated sql query
|
|
|
497 |
*/
|
|
|
498 |
HBufC* CAfStorage::SelectRowsLC(TInt appId) const
|
|
116
|
499 |
{
|
|
99
|
500 |
return BuildQueryLC(KSelectAppRows(), appId, KNullDesC);
|
|
116
|
501 |
}
|
|
99
|
502 |
|
|
|
503 |
// -----------------------------------------------------------------------------
|
|
|
504 |
/**
|
|
|
505 |
* Format query to delete activity
|
|
|
506 |
* @param appId - application id
|
|
|
507 |
* @param actId - activity id
|
|
|
508 |
* @return formated sql query
|
|
|
509 |
*/
|
|
|
510 |
HBufC* CAfStorage::DeleteRowLC(TInt appId, const TDesC& actId) const
|
|
116
|
511 |
{
|
|
99
|
512 |
return BuildQueryLC(KDeleteRow(),appId, actId);
|
|
116
|
513 |
}
|
|
99
|
514 |
|
|
|
515 |
// -----------------------------------------------------------------------------
|
|
|
516 |
/**
|
|
|
517 |
* Format query to delete activities for application
|
|
|
518 |
* @param appId - application id
|
|
|
519 |
* @return formated sql query
|
|
|
520 |
*/
|
|
|
521 |
HBufC* CAfStorage::DeleteRowsLC(TInt appId) const
|
|
116
|
522 |
{
|
|
99
|
523 |
return BuildQueryLC(KDeleteRows(),appId, KNullDesC);
|
|
116
|
524 |
}
|
|
99
|
525 |
|
|
|
526 |
// -----------------------------------------------------------------------------
|
|
|
527 |
/**
|
|
|
528 |
* Format sql query
|
|
|
529 |
* @format - sql format string
|
|
|
530 |
* @param appId - application id
|
|
|
531 |
* @param actId - activity id
|
|
|
532 |
* @return formated sql query
|
|
|
533 |
*/
|
|
|
534 |
HBufC* CAfStorage::BuildQueryLC(const TDesC& format,
|
|
|
535 |
TInt appId,
|
|
|
536 |
const TDesC& actId) const
|
|
116
|
537 |
{
|
|
99
|
538 |
TBuf<16> appName;
|
|
|
539 |
appName.AppendNum(appId);
|
|
|
540 |
RBuf actName;
|
|
|
541 |
CleanupClosePushL(actName);
|
|
|
542 |
actName.CreateL(actId.Length());
|
|
|
543 |
actName.Copy(actId);
|
|
|
544 |
HBufC* query = HBufC::NewL(format.Length() +
|
|
|
545 |
appName.Length() +
|
|
|
546 |
actName.Length() );
|
|
|
547 |
query->Des().AppendFormat(format, &appName, &actName);
|
|
|
548 |
CleanupStack::PopAndDestroy(&actName);
|
|
|
549 |
CleanupStack::PushL(query);
|
|
|
550 |
return query;
|
|
116
|
551 |
}
|
|
99
|
552 |
|
|
|
553 |
// -----------------------------------------------------------------------------
|
|
|
554 |
/**
|
|
|
555 |
* Execute sql query and result serialize into buffer
|
|
|
556 |
* @param dst - destination result buffer
|
|
|
557 |
* @param query - sql activity query
|
|
|
558 |
*/
|
|
116
|
559 |
void CAfStorage::ActivitiesL(RPointerArray<CAfEntry>& dst, const TDesC& query, CAfEntry::AccessRights rights, TInt limit, TBool deserializeAllData)
|
|
|
560 |
{
|
|
99
|
561 |
RDbView view;// Create a view on the database
|
|
|
562 |
CleanupClosePushL(view);
|
|
116
|
563 |
User::LeaveIfError(view.Prepare(iActDb, TDbQuery(query), view.EReadOnly));
|
|
99
|
564 |
User::LeaveIfError(view.EvaluateAll());
|
|
116
|
565 |
ActivitiesL(dst, view, rights, limit, deserializeAllData);
|
|
99
|
566 |
CleanupStack::PopAndDestroy(&view);
|
|
116
|
567 |
}
|
|
99
|
568 |
|
|
|
569 |
// -----------------------------------------------------------------------------
|
|
|
570 |
/**
|
|
|
571 |
* Return view deserialisd into entries array
|
|
|
572 |
* @param dst - destination result
|
|
|
573 |
* @param query - view
|
|
|
574 |
* @param rights - acess rights
|
|
|
575 |
*/
|
|
116
|
576 |
void CAfStorage::ActivitiesL(RPointerArray<CAfEntry>& dst,
|
|
|
577 |
RDbView& src,
|
|
|
578 |
CAfEntry::AccessRights rights,
|
|
|
579 |
TInt limit,
|
|
|
580 |
TBool deserializeAllData)
|
|
|
581 |
{
|
|
99
|
582 |
CDbColSet* row = src.ColSetL();
|
|
|
583 |
CleanupStack::PushL(row);
|
|
|
584 |
|
|
|
585 |
const TInt flagsOffset(row->ColNo(KFlagsColumnName)),
|
|
|
586 |
applicationOffset(row->ColNo(KApplicationColumnName)),
|
|
|
587 |
activityOffset(row->ColNo(KActivityColumnName)),
|
|
116
|
588 |
customNameOffset(row->ColNo(KCustomNameColumnName)),
|
|
99
|
589 |
dataOffset(row->ColNo(KDataColumnName));
|
|
|
590 |
|
|
|
591 |
RBuf activityName;
|
|
|
592 |
CleanupClosePushL(activityName);
|
|
|
593 |
|
|
116
|
594 |
RBuf customName;
|
|
|
595 |
CleanupClosePushL(customName);
|
|
|
596 |
|
|
|
597 |
|
|
|
598 |
for (src.FirstL(); src.AtRow(); src.NextL())
|
|
|
599 |
{
|
|
|
600 |
if ( 0 < limit && dst.Count() >= limit )
|
|
|
601 |
{
|
|
99
|
602 |
break;
|
|
116
|
603 |
}
|
|
99
|
604 |
src.GetL();
|
|
|
605 |
ReadDataL(activityName, src, activityOffset);
|
|
116
|
606 |
ReadDataL(customName, src, customNameOffset);
|
|
99
|
607 |
|
|
|
608 |
CAfEntry *entry = CAfEntry::NewLC(src.ColInt32(flagsOffset),
|
|
|
609 |
src.ColInt64(applicationOffset),
|
|
|
610 |
activityName,
|
|
116
|
611 |
customName,
|
|
99
|
612 |
KNullDesC,
|
|
|
613 |
KNullDesC8,
|
|
|
614 |
KNullDesC8);
|
|
116
|
615 |
if( CAfEntry::Public == rights &&
|
|
|
616 |
(entry->Flags() & CAfEntry::Invisible) )
|
|
|
617 |
{
|
|
99
|
618 |
CleanupStack::PopAndDestroy(entry);
|
|
|
619 |
continue;
|
|
116
|
620 |
}
|
|
99
|
621 |
InternalizeDataL(*entry, src, dataOffset);
|
|
|
622 |
|
|
116
|
623 |
if (!deserializeAllData) {
|
|
|
624 |
entry->SetDataL(KNullDesC8(), CAfEntry::Public);
|
|
99
|
625 |
entry->SetDataL(KNullDesC8(), CAfEntry::Private);
|
|
116
|
626 |
} else {
|
|
|
627 |
if (CAfEntry::Public == rights) {
|
|
|
628 |
entry->SetDataL(KNullDesC8(), CAfEntry::Private);
|
|
|
629 |
}
|
|
99
|
630 |
}
|
|
116
|
631 |
|
|
99
|
632 |
dst.AppendL(entry);
|
|
|
633 |
CleanupStack::Pop(entry);
|
|
116
|
634 |
}
|
|
|
635 |
CleanupStack::PopAndDestroy(&customName);
|
|
99
|
636 |
CleanupStack::PopAndDestroy(&activityName);
|
|
|
637 |
CleanupStack::PopAndDestroy(row);
|
|
116
|
638 |
}
|
|
99
|
639 |
|
|
|
640 |
// -----------------------------------------------------------------------------
|
|
|
641 |
/**
|
|
|
642 |
* Get activity for update
|
|
|
643 |
* @param query - destination query result
|
|
|
644 |
* @param appId - application id
|
|
|
645 |
* @param actId - activity id
|
|
|
646 |
*/
|
|
|
647 |
void CAfStorage::GetActivityForUpdateL(RDbView& view, TInt appId, const TDesC& actId)
|
|
116
|
648 |
{
|
|
99
|
649 |
HBufC* query(SelectRowLC(appId, actId));
|
|
116
|
650 |
User::LeaveIfError(view.Prepare(iActDb, TDbQuery(*query), view.EUpdatable));
|
|
99
|
651 |
CleanupStack::PopAndDestroy(query);
|
|
|
652 |
User::LeaveIfError(view.EvaluateAll());
|
|
116
|
653 |
if( !view.FirstL() )
|
|
|
654 |
{
|
|
99
|
655 |
User::Leave(KErrNotFound);
|
|
116
|
656 |
}
|
|
99
|
657 |
}
|
|
|
658 |
|
|
|
659 |
// -----------------------------------------------------------------------------
|
|
|
660 |
void CAfStorage::ReadDataL(RBuf& dst, RDbRowSet& src, TInt offset) const
|
|
116
|
661 |
{
|
|
99
|
662 |
const TInt length(src.ColLength(offset));
|
|
|
663 |
CAfEntry::ReallocL(dst, length);
|
|
|
664 |
RDbColReadStream srcStream;
|
|
|
665 |
srcStream.OpenLC(src,offset);
|
|
|
666 |
srcStream.ReadL(dst, src.ColLength(offset));
|
|
|
667 |
CleanupStack::PopAndDestroy(&srcStream);
|
|
116
|
668 |
}
|
|
99
|
669 |
|
|
|
670 |
// -----------------------------------------------------------------------------
|
|
|
671 |
void CAfStorage::ExternalizeDataL(RDbRowSet& dst,const CAfEntry &src, TInt offset) const
|
|
116
|
672 |
{
|
|
99
|
673 |
RDbColWriteStream dbStream;
|
|
|
674 |
CleanupClosePushL(dbStream);
|
|
|
675 |
dbStream.OpenL(dst, offset);
|
|
|
676 |
src.ExternalizeDataOnlyL(dbStream);
|
|
|
677 |
CleanupStack::PopAndDestroy(&dbStream);
|
|
116
|
678 |
}
|
|
99
|
679 |
|
|
|
680 |
// -----------------------------------------------------------------------------
|
|
|
681 |
void CAfStorage::InternalizeDataL(CAfEntry & dst, RDbRowSet& src, TInt offset) const
|
|
116
|
682 |
{
|
|
99
|
683 |
RDbColReadStream dbStream;
|
|
|
684 |
CleanupClosePushL(dbStream);
|
|
|
685 |
dbStream.OpenL(src, offset);
|
|
|
686 |
dst.InternalizeDataOnlyL(dbStream);
|
|
|
687 |
CleanupStack::PopAndDestroy(&dbStream);
|
|
116
|
688 |
}
|
|
99
|
689 |
|
|
|
690 |
// -----------------------------------------------------------------------------
|
|
|
691 |
//
|
|
|
692 |
// -----------------------------------------------------------------------------
|
|
|
693 |
//
|
|
|
694 |
void CAfStorage::StoragePathL(RBuf &dst,
|
|
|
695 |
RFs& fileSystem,
|
|
|
696 |
TBool persistent)
|
|
116
|
697 |
{
|
|
|
698 |
if (dst.MaxLength() < KMaxPathLength)
|
|
|
699 |
{
|
|
99
|
700 |
dst.ReAllocL(KMaxPathLength);
|
|
116
|
701 |
}
|
|
99
|
702 |
dst.Zero();
|
|
|
703 |
User::LeaveIfError(fileSystem.PrivatePath(dst));
|
|
116
|
704 |
if(persistent)
|
|
|
705 |
{
|
|
99
|
706 |
dst.Append(KPersistent);
|
|
116
|
707 |
}
|
|
|
708 |
else
|
|
|
709 |
{
|
|
|
710 |
dst.Append(KNonPersistent);
|
|
|
711 |
}
|
|
99
|
712 |
}
|
|
|
713 |
|
|
|
714 |
// -----------------------------------------------------------------------------
|
|
|
715 |
//
|
|
|
716 |
// -----------------------------------------------------------------------------
|
|
|
717 |
//
|
|
|
718 |
void CAfStorage::AppStoragePathL(RBuf &dst,
|
|
|
719 |
RFs& fileSystem,
|
|
|
720 |
TInt uid,
|
|
|
721 |
TBool persistent)
|
|
116
|
722 |
{
|
|
99
|
723 |
StoragePathL(dst, fileSystem, persistent);
|
|
|
724 |
|
|
|
725 |
//Format activity path
|
|
|
726 |
dst.AppendFormat( KUidFormat, uid);
|
|
|
727 |
}
|
|
|
728 |
|
|
|
729 |
// -----------------------------------------------------------------------------
|
|
|
730 |
//
|
|
|
731 |
// -----------------------------------------------------------------------------
|
|
|
732 |
//
|
|
|
733 |
void CAfStorage::ThumbnailPathL(RBuf &dst,
|
|
|
734 |
RFs& fileSystem,
|
|
|
735 |
TInt uid,
|
|
|
736 |
const TDesC &activityName,
|
|
|
737 |
TBool persistent)
|
|
|
738 |
{
|
|
|
739 |
RBuf8 buff8;
|
|
|
740 |
CleanupClosePushL(buff8);
|
|
|
741 |
buff8.CreateL(activityName.Length());
|
|
|
742 |
buff8.Copy(activityName);
|
|
|
743 |
HBufC8 *activityHash = Md5HexDigestL(buff8);
|
|
|
744 |
CleanupStack::PopAndDestroy(&buff8);
|
|
|
745 |
CleanupStack::PushL(activityHash);
|
|
|
746 |
|
|
|
747 |
AppStoragePathL(dst, fileSystem, uid, persistent);
|
|
|
748 |
|
|
|
749 |
RBuf hash16;
|
|
|
750 |
CleanupClosePushL(hash16);
|
|
|
751 |
hash16.CreateL(KMaxPathLength);
|
|
|
752 |
hash16.Copy(*activityHash);
|
|
|
753 |
dst.Append(hash16);//reuse already allocated buffer to convert 8 -> 16
|
|
|
754 |
CleanupStack::PopAndDestroy(&hash16);
|
|
|
755 |
dst.Append(KExtFormat());
|
|
|
756 |
CleanupStack::PopAndDestroy(activityHash);
|
|
|
757 |
|
|
|
758 |
BaflUtils::EnsurePathExistsL(fileSystem, dst);
|
|
|
759 |
}
|
|
|
760 |
|
|
|
761 |
// -----------------------------------------------------------------------------
|
|
|
762 |
//
|
|
|
763 |
// -----------------------------------------------------------------------------
|
|
|
764 |
//
|
|
|
765 |
HBufC8* CAfStorage::Md5HexDigestL(const TDesC8 &string)
|
|
116
|
766 |
{
|
|
99
|
767 |
_LIT8(KMd5HexFormat, "%+02x");
|
|
|
768 |
CMD5* md5 = CMD5::NewL();
|
|
|
769 |
CleanupStack::PushL(md5);
|
|
|
770 |
|
|
|
771 |
TPtrC8 hashedSig(md5->Hash(string));
|
|
|
772 |
|
|
|
773 |
HBufC8* buf = HBufC8::NewL(hashedSig.Length() * 2);
|
|
|
774 |
TPtr8 bufPtr = buf->Des();
|
|
|
775 |
|
|
|
776 |
for(TInt i(0); i< hashedSig.Length(); ++i) {
|
|
|
777 |
bufPtr.AppendFormat(KMd5HexFormat,hashedSig[i]);
|
|
|
778 |
}
|
|
|
779 |
CleanupStack::PopAndDestroy(md5);
|
|
|
780 |
return buf;
|
|
116
|
781 |
}
|
|
112
|
782 |
|
|
|
783 |
// -----------------------------------------------------------------------------
|
|
|
784 |
/**
|
|
|
785 |
* Cancel ongoing cleanup if one is in progress.
|
|
|
786 |
* @return ETrue if the database cleanup was in progress, EFalse otherwise
|
|
|
787 |
*/
|
|
|
788 |
TBool CAfStorage::InterruptCleanup()
|
|
116
|
789 |
{
|
|
|
790 |
if( iDatabaseCleaner->IsActive() )
|
|
|
791 |
{
|
|
|
792 |
iDatabaseCleaner->Cancel();
|
|
112
|
793 |
return ETrue;
|
|
116
|
794 |
}
|
|
|
795 |
else
|
|
|
796 |
{
|
|
112
|
797 |
return EFalse;
|
|
116
|
798 |
}
|
|
112
|
799 |
}
|
|
|
800 |
|
|
|
801 |
// -----------------------------------------------------------------------------
|
|
|
802 |
/**
|
|
|
803 |
* Start database cleanup
|
|
|
804 |
*/
|
|
|
805 |
void CAfStorage::RequestCleanup()
|
|
116
|
806 |
{
|
|
|
807 |
iDatabaseCleaner->StartCleanup();
|
|
|
808 |
}
|