|
1 /** |
|
2 * Copyright (c) 2010 Sasken Communication Technologies Ltd. |
|
3 * All rights reserved. |
|
4 * This component and the accompanying materials are made available |
|
5 * under the terms of the "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 * Pritam Roy Biswas, Sasken Communication Technologies Ltd - Initial contribution |
|
11 * |
|
12 * Description: |
|
13 * This file contains routines to handle the data-base operations like insertion, query etc. |
|
14 * on Credential Manager Server Database |
|
15 */ |
|
16 |
|
17 #include <BAUTILS.H> |
|
18 #include "smfcredmgrdbuser.h" |
|
19 #include "smfcredmgrdb.h" |
|
20 |
|
21 CSmfCredMgrDbUser* CSmfCredMgrDbUser::NewL(CSmfCredMgrServerSession* aSession) |
|
22 { |
|
23 CSmfCredMgrDbUser* self = CSmfCredMgrDbUser::NewLC(aSession); |
|
24 CleanupStack::Pop(self); |
|
25 return (self); |
|
26 } |
|
27 |
|
28 CSmfCredMgrDbUser* CSmfCredMgrDbUser::NewLC(CSmfCredMgrServerSession* aSession) |
|
29 { |
|
30 CSmfCredMgrDbUser* self = new (ELeave) CSmfCredMgrDbUser(aSession); |
|
31 CleanupStack::PushL(self); |
|
32 self->ConstructL(); |
|
33 return (self); |
|
34 } |
|
35 |
|
36 void CSmfCredMgrDbUser::ConstructL() |
|
37 { |
|
38 TInt err = iFileSession.Connect(); |
|
39 User::LeaveIfError(err); |
|
40 |
|
41 iFileSession.SetSessionToPrivate(EDriveC); |
|
42 |
|
43 TFileName dbFileName; |
|
44 iFileSession.PrivatePath(dbFileName); |
|
45 TFindFile PrivFolder(iFileSession); |
|
46 |
|
47 // find drive-private path |
|
48 if (KErrNone == PrivFolder.FindByDir(dbFileName, KNullDesC)) |
|
49 { |
|
50 dbFileName.Copy(PrivFolder.File()); |
|
51 dbFileName.Append(KSmfCredMgrDbFileName); |
|
52 iDbFilePathName = dbFileName; |
|
53 if (BaflUtils::FileExists(iFileSession, dbFileName)) |
|
54 { |
|
55 //err = iDataBase.Open(dbFileName); |
|
56 User::LeaveIfError(iDataBase.Open(dbFileName)); |
|
57 RSqlDatabase::TIsolationLevel isolationLevel = |
|
58 RSqlDatabase::EReadUncommitted; |
|
59 iDataBase.SetIsolationLevel(isolationLevel); |
|
60 } |
|
61 else |
|
62 { |
|
63 //file not present |
|
64 User::Leave(KErrNotFound); |
|
65 } |
|
66 } |
|
67 else |
|
68 { |
|
69 //path not present |
|
70 User::Leave(KErrPathNotFound); |
|
71 } |
|
72 } |
|
73 |
|
74 CSmfCredMgrDbUser::CSmfCredMgrDbUser(CSmfCredMgrServerSession* aSession) : |
|
75 iSession(aSession) |
|
76 { |
|
77 } |
|
78 |
|
79 CSmfCredMgrDbUser::~CSmfCredMgrDbUser() |
|
80 { |
|
81 iFileSession.Close(); |
|
82 iDataBase.Close(); |
|
83 } |
|
84 |
|
85 TInt CSmfCredMgrDbUser::PluginIDTableInsert(const TDesC& aPluginId, |
|
86 const TDesC& aAuthAppId, TBool aEnableFlag) |
|
87 { |
|
88 TInt err(KErrNone); |
|
89 RSqlStatement sqlStatement; |
|
90 RSqlDatabase db; |
|
91 |
|
92 err = db.Open(iDbFilePathName); |
|
93 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
94 |
|
95 err = sqlStatement.Prepare(db, KSmfPluginIDTableInsert); |
|
96 TInt paramIndex(KErrNone); |
|
97 |
|
98 TBuf<KMaxBufSize> pluginbuf(aPluginId); |
|
99 |
|
100 paramIndex = sqlStatement.ParameterIndex(_L(":Val1")); |
|
101 err = sqlStatement.BindText(paramIndex, pluginbuf); |
|
102 |
|
103 paramIndex = sqlStatement.ParameterIndex(_L(":Val2")); |
|
104 err = sqlStatement.BindText(paramIndex, aAuthAppId); |
|
105 |
|
106 paramIndex = sqlStatement.ParameterIndex(_L(":Val3")); |
|
107 err = sqlStatement.BindInt(paramIndex, aEnableFlag); |
|
108 |
|
109 err = db.Exec(KBegin); |
|
110 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
111 err = sqlStatement.Exec(); |
|
112 if (KSqlErrConstraint == err) |
|
113 { |
|
114 //Table already present. |
|
115 } |
|
116 else if (err < KErrNone) |
|
117 { |
|
118 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
119 } |
|
120 |
|
121 err = db.Exec(KCommit); |
|
122 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
123 |
|
124 //if commit fails we have to roll back |
|
125 if (err < KErrNone) |
|
126 { |
|
127 err = db.Exec(KRollback); |
|
128 } |
|
129 sqlStatement.Close(); |
|
130 db.Close(); |
|
131 if (err >= 0) |
|
132 { |
|
133 return KErrNone; |
|
134 } |
|
135 return err; |
|
136 } |
|
137 |
|
138 TInt CSmfCredMgrDbUser::URLTableInsert(const TDesC& aAuthAppId, |
|
139 const TDesC& aURL) |
|
140 { |
|
141 TInt err(KErrNone); |
|
142 RSqlStatement sqlStatement; |
|
143 RSqlDatabase db; |
|
144 |
|
145 err = db.Open(iDbFilePathName); |
|
146 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
147 |
|
148 err = sqlStatement.Prepare(db, KSmfURLTableInsert); |
|
149 TInt paramIndex(KErrNone); |
|
150 |
|
151 paramIndex = sqlStatement.ParameterIndex(_L(":Val1")); |
|
152 err = sqlStatement.BindText(paramIndex, aAuthAppId); |
|
153 |
|
154 TBuf<KMaxBufSize> urlbuf(aURL); |
|
155 |
|
156 paramIndex = sqlStatement.ParameterIndex(_L(":Val2")); |
|
157 err = sqlStatement.BindText(paramIndex, urlbuf); |
|
158 |
|
159 err = db.Exec(KBegin); |
|
160 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
161 err = sqlStatement.Exec(); |
|
162 if (KSqlErrConstraint == err) |
|
163 { |
|
164 //Table already present. |
|
165 } |
|
166 else if (err < KErrNone) |
|
167 { |
|
168 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
169 } |
|
170 |
|
171 err = db.Exec(KCommit); |
|
172 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
173 |
|
174 //if commit fails we have to roll back |
|
175 if (err < KErrNone) |
|
176 { |
|
177 err = db.Exec(KRollback); |
|
178 } |
|
179 sqlStatement.Close(); |
|
180 db.Close(); |
|
181 if (err >= 0) |
|
182 { |
|
183 return KErrNone; |
|
184 } |
|
185 return err; |
|
186 } |
|
187 |
|
188 TInt CSmfCredMgrDbUser::RegTokenValidityTableInsert(const TDesC& aRegToken, |
|
189 const TDesC& aAuthAppId, const TUint aValidity) |
|
190 { |
|
191 TInt err(KErrNone); |
|
192 RSqlStatement sqlStatement; |
|
193 RSqlDatabase db; |
|
194 |
|
195 TBuf<KMaxBufSize> regTokenBuf(aRegToken); |
|
196 |
|
197 err = db.Open(iDbFilePathName); |
|
198 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
199 |
|
200 err = sqlStatement.Prepare(db, KSmfRegTokenValidityTableInsert); |
|
201 TInt paramIndex(KErrNone); |
|
202 |
|
203 paramIndex = sqlStatement.ParameterIndex(_L(":Val1")); |
|
204 err = sqlStatement.BindText(paramIndex, aRegToken); |
|
205 |
|
206 paramIndex = sqlStatement.ParameterIndex(_L(":Val2")); |
|
207 err = sqlStatement.BindText(paramIndex, aAuthAppId); |
|
208 |
|
209 paramIndex = sqlStatement.ParameterIndex(_L(":Val3")); |
|
210 err = sqlStatement.BindInt(paramIndex, aValidity); |
|
211 |
|
212 err = db.Exec(KBegin); |
|
213 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
214 err = sqlStatement.Exec(); |
|
215 if (KSqlErrConstraint == err) |
|
216 { |
|
217 //Table already present. |
|
218 } |
|
219 else if (err < KErrNone) |
|
220 { |
|
221 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
222 } |
|
223 |
|
224 err = db.Exec(KCommit); |
|
225 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
226 |
|
227 //if commit fails we have to roll back |
|
228 if (err < KErrNone) |
|
229 { |
|
230 err = db.Exec(KRollback); |
|
231 } |
|
232 sqlStatement.Close(); |
|
233 db.Close(); |
|
234 if (err >= 0) |
|
235 { |
|
236 return KErrNone; |
|
237 } |
|
238 return err; |
|
239 |
|
240 } |
|
241 |
|
242 TInt CSmfCredMgrDbUser::AuthParamsTableInsert(const TDesC& aAuthAppId, |
|
243 const TDesC& aKey, const TDesC& aSecret) |
|
244 { |
|
245 TInt err(KErrNone); |
|
246 RSqlStatement sqlStatement; |
|
247 RSqlDatabase db; |
|
248 |
|
249 TBuf<KMaxBufSize> keyBuf(aKey); |
|
250 TBuf<KMaxBufSize> secretBuf(aSecret); |
|
251 |
|
252 err = db.Open(iDbFilePathName); |
|
253 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
254 |
|
255 err = sqlStatement.Prepare(db, KSmfAuthParamsTableInsert); |
|
256 TInt paramIndex(KErrNone); |
|
257 |
|
258 paramIndex = sqlStatement.ParameterIndex(_L(":Val1")); |
|
259 err = sqlStatement.BindText(paramIndex, aAuthAppId); |
|
260 |
|
261 paramIndex = sqlStatement.ParameterIndex(_L(":Val2")); |
|
262 err = sqlStatement.BindText(paramIndex, keyBuf); |
|
263 |
|
264 paramIndex = sqlStatement.ParameterIndex(_L(":Val3")); |
|
265 err = sqlStatement.BindText(paramIndex, secretBuf); |
|
266 |
|
267 err = db.Exec(KBegin); |
|
268 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
269 err = sqlStatement.Exec(); |
|
270 if (KSqlErrConstraint == err) |
|
271 { |
|
272 //Table already present. |
|
273 } |
|
274 else if (err < KErrNone) |
|
275 { |
|
276 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
277 } |
|
278 |
|
279 err = db.Exec(KCommit); |
|
280 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
281 |
|
282 //if commit fails we have to roll back |
|
283 if (err < KErrNone) |
|
284 { |
|
285 err = db.Exec(KRollback); |
|
286 } |
|
287 sqlStatement.Close(); |
|
288 db.Close(); |
|
289 if (err >= 0) |
|
290 { |
|
291 return KErrNone; |
|
292 } |
|
293 return err; |
|
294 } |
|
295 |
|
296 void CSmfCredMgrDbUser::readFlagInPluginIdTable(const TDesC& aPluginID, |
|
297 TInt& aFlag) |
|
298 { |
|
299 TInt err(KErrNone); |
|
300 |
|
301 RSqlStatement sqlReadStatement; |
|
302 TInt paramIndex(KErrNone); |
|
303 |
|
304 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadFlagInPluginTable); |
|
305 |
|
306 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
|
307 err = sqlReadStatement.BindText(paramIndex, aPluginID); |
|
308 |
|
309 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
|
310 { |
|
311 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
|
312 if (!sqlReadStatement.IsNull(0)) |
|
313 { |
|
314 aFlag = sqlReadStatement.ColumnInt(0); |
|
315 } |
|
316 } |
|
317 sqlReadStatement.Close(); |
|
318 } |
|
319 |
|
320 void CSmfCredMgrDbUser::readAuthAppIdInPluginIdTable(const TDesC& aPluginID, |
|
321 TDes& aAuthAppId) |
|
322 { |
|
323 TInt err(KErrNone); |
|
324 |
|
325 RSqlStatement sqlReadStatement; |
|
326 TInt paramIndex(KErrNone); |
|
327 |
|
328 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadAuthAppIdInPluginTable); |
|
329 |
|
330 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
|
331 err = sqlReadStatement.BindText(paramIndex, aPluginID); |
|
332 |
|
333 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
|
334 { |
|
335 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
|
336 if (!sqlReadStatement.IsNull(0)) |
|
337 { |
|
338 sqlReadStatement.ColumnText(0, aAuthAppId); |
|
339 } |
|
340 } |
|
341 sqlReadStatement.Close(); |
|
342 } |
|
343 |
|
344 void CSmfCredMgrDbUser::readAuthTokens(const TDesC& aAuthAppId, RArray< |
|
345 TSmfAuthToken>& aArray) |
|
346 { |
|
347 TInt err(KErrNone); |
|
348 |
|
349 RSqlStatement sqlReadStatement; |
|
350 TInt paramIndex(KErrNone); |
|
351 |
|
352 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadAuthTokens); |
|
353 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
|
354 err = sqlReadStatement.BindText(paramIndex, aAuthAppId); |
|
355 |
|
356 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
|
357 { |
|
358 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
|
359 if (!sqlReadStatement.IsNull(0)) |
|
360 { |
|
361 TSmfAuthToken Set; |
|
362 |
|
363 Set.iKey = HBufC::NewL(KMaxAuthTokenLength); |
|
364 Set.iSecret = HBufC::NewL(KMaxAuthTokenLength); |
|
365 |
|
366 TBuf<KMaxBufSize> keyBuf; |
|
367 TBuf<KMaxBufSize> secretBuf; |
|
368 |
|
369 sqlReadStatement.ColumnText(0, keyBuf); |
|
370 sqlReadStatement.ColumnText(1, secretBuf); |
|
371 |
|
372 Set.iKey->Des().Copy(keyBuf); |
|
373 Set.iSecret->Des().Copy(secretBuf); |
|
374 //add it to the array |
|
375 aArray.Append(Set); |
|
376 |
|
377 } |
|
378 else |
|
379 { |
|
380 __ASSERT_DEBUG( 0, User::Invariant()); |
|
381 } |
|
382 } |
|
383 sqlReadStatement.Close(); |
|
384 } |
|
385 |
|
386 void CSmfCredMgrDbUser::fetchPluginList(const TDesC& aRegToken, RPointerArray< |
|
387 HBufC>& aArray) |
|
388 { |
|
389 TBuf<KMaxBufSize> authAppID; |
|
390 readAuthAppIdInRegTokenTable(aRegToken, authAppID); |
|
391 readPluginId(authAppID, aArray); |
|
392 } |
|
393 |
|
394 void CSmfCredMgrDbUser::readAuthAppIdInRegTokenTable(const TDesC& aRegToken, |
|
395 TDes& aAuthAppId) |
|
396 { |
|
397 TInt err(KErrNone); |
|
398 |
|
399 RSqlStatement sqlReadStatement; |
|
400 TInt paramIndex(KErrNone); |
|
401 TInt64 duration; |
|
402 TBuf<KMaxBufSize> tokenBuf(aRegToken); |
|
403 err = sqlReadStatement.Prepare(iDataBase, |
|
404 KSmfDbReadAuthAppIdInRegTokenTable); |
|
405 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
|
406 err = sqlReadStatement.BindText(paramIndex, tokenBuf); |
|
407 |
|
408 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
|
409 { |
|
410 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
|
411 if (!sqlReadStatement.IsNull(0)) |
|
412 { |
|
413 duration = sqlReadStatement.ColumnInt(1); |
|
414 if (duration) //to be checked with epoch date-time |
|
415 { |
|
416 sqlReadStatement.ColumnText(0, aAuthAppId); |
|
417 } |
|
418 } |
|
419 else |
|
420 { |
|
421 __ASSERT_DEBUG( 0, User::Invariant()); |
|
422 } |
|
423 } |
|
424 sqlReadStatement.Close(); |
|
425 } |
|
426 void CSmfCredMgrDbUser::readPluginId(const TDesC& aAuthAppId, RPointerArray< |
|
427 HBufC>& aArray) |
|
428 { |
|
429 TInt err(KErrNone); |
|
430 RSqlStatement sqlReadStatement; |
|
431 TInt paramIndex(KErrNone); |
|
432 TInt flag; |
|
433 |
|
434 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadPluginID); |
|
435 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
|
436 err = sqlReadStatement.BindText(paramIndex, aAuthAppId); |
|
437 |
|
438 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
|
439 { |
|
440 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
|
441 if (!sqlReadStatement.IsNull(0)) |
|
442 { |
|
443 flag = sqlReadStatement.ColumnInt(1); |
|
444 if (flag > 0) |
|
445 { |
|
446 TBuf<KMaxBufSize> pluginbuf; |
|
447 HBufC* buf = HBufC::NewL(KMaxBufSize); |
|
448 sqlReadStatement.ColumnText(0, pluginbuf); |
|
449 buf->Des().Copy(pluginbuf); |
|
450 aArray.Append(buf); |
|
451 } |
|
452 } |
|
453 else |
|
454 { |
|
455 __ASSERT_DEBUG( 0, User::Invariant()); |
|
456 } |
|
457 } |
|
458 sqlReadStatement.Close(); |
|
459 } |
|
460 |
|
461 void CSmfCredMgrDbUser::readURL(const TDesC& aAuthAppId, |
|
462 RPointerArray<HBufC>& aArray) |
|
463 { |
|
464 TInt err(KErrNone); |
|
465 |
|
466 RSqlStatement sqlReadStatement; |
|
467 TInt paramIndex(KErrNone); |
|
468 |
|
469 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadURL); |
|
470 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
|
471 err = sqlReadStatement.BindText(paramIndex, aAuthAppId); |
|
472 |
|
473 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
|
474 { |
|
475 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
|
476 if (!sqlReadStatement.IsNull(0)) |
|
477 { |
|
478 TBuf<KMaxBufSize> urlBuf; |
|
479 HBufC* buf = HBufC::NewL(KMaxBufSize); |
|
480 sqlReadStatement.ColumnText(0, urlBuf); |
|
481 buf->Des().Copy(urlBuf); |
|
482 aArray.Append(buf); |
|
483 } |
|
484 else |
|
485 { |
|
486 __ASSERT_DEBUG( 0, User::Invariant()); |
|
487 } |
|
488 } |
|
489 sqlReadStatement.Close(); |
|
490 } |
|
491 |
|
492 void CSmfCredMgrDbUser::readValidity(const TDesC& aAuthAppId, TInt64& aValidity) |
|
493 { |
|
494 TInt err(KErrNone); |
|
495 |
|
496 RSqlStatement sqlReadStatement; |
|
497 TInt paramIndex(KErrNone); |
|
498 |
|
499 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadValidity); |
|
500 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
|
501 err = sqlReadStatement.BindText(paramIndex, aAuthAppId); |
|
502 |
|
503 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
|
504 { |
|
505 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
|
506 if (!sqlReadStatement.IsNull(0)) |
|
507 { |
|
508 aValidity = sqlReadStatement.ColumnInt64(1); |
|
509 } |
|
510 else |
|
511 { |
|
512 __ASSERT_DEBUG( 0, User::Invariant()); |
|
513 } |
|
514 } |
|
515 sqlReadStatement.Close(); |
|
516 |
|
517 } |
|
518 |
|
519 void CSmfCredMgrDbUser::readRegistrationToken(const TDesC& aAuthAppId, |
|
520 TDesC& aRegToken) |
|
521 { |
|
522 TInt err(KErrNone); |
|
523 |
|
524 RSqlStatement sqlReadStatement; |
|
525 TInt paramIndex(KErrNone); |
|
526 |
|
527 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadRegistrationToken); |
|
528 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
|
529 err = sqlReadStatement.BindText(paramIndex, aAuthAppId); |
|
530 |
|
531 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
|
532 { |
|
533 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
|
534 if (!sqlReadStatement.IsNull(0)) |
|
535 { |
|
536 aRegToken = sqlReadStatement.ColumnTextL(0);//aKey.AllocL(); |
|
537 } |
|
538 else |
|
539 { |
|
540 __ASSERT_DEBUG( 0, User::Invariant()); |
|
541 } |
|
542 } |
|
543 sqlReadStatement.Close(); |
|
544 } |
|
545 |
|
546 TInt CSmfCredMgrDbUser::updatePlugin(const TDesC& aPluginID, |
|
547 const TBool& aFlag, const TDesC& aOldPluginID) |
|
548 { |
|
549 TInt err(KErrNone); |
|
550 RSqlStatement sqlStatement; |
|
551 TInt paramIndex(KErrNone); |
|
552 TBuf<KMaxBufSize> newPluginBuf(aPluginID); |
|
553 TBuf<KMaxBufSize> OldPluginBuf(aOldPluginID); |
|
554 RSqlDatabase db; |
|
555 |
|
556 err = db.Open(iDbFilePathName); |
|
557 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
558 |
|
559 err = sqlStatement.Prepare(db, KUpdatePluginID); |
|
560 |
|
561 paramIndex = sqlStatement.ParameterIndex(_L(":iText")); |
|
562 err = sqlStatement.BindText(paramIndex, newPluginBuf); |
|
563 |
|
564 paramIndex = sqlStatement.ParameterIndex(_L(":iFlag")); |
|
565 err = sqlStatement.BindInt(paramIndex, aFlag); |
|
566 |
|
567 paramIndex = sqlStatement.ParameterIndex(_L(":iID")); |
|
568 err = sqlStatement.BindText(paramIndex, OldPluginBuf); |
|
569 |
|
570 err = db.Exec(KBegin); |
|
571 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
572 err = sqlStatement.Exec(); |
|
573 if (KSqlErrConstraint == err) |
|
574 { |
|
575 // |
|
576 } |
|
577 else if (err < KErrNone) |
|
578 { |
|
579 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
580 } |
|
581 |
|
582 err = db.Exec(KCommit); |
|
583 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
584 |
|
585 //if commit fails we have to roll back |
|
586 if (err < KErrNone) |
|
587 { |
|
588 err = db.Exec(KRollback); |
|
589 } |
|
590 sqlStatement.Close(); |
|
591 db.Close(); |
|
592 if (err >= 0) |
|
593 { |
|
594 return KErrNone; |
|
595 } |
|
596 return err; |
|
597 } |