author | hgs |
Fri, 17 Sep 2010 16:54:49 +0300 | |
changeset 54 | a3cc46f37772 |
parent 0 | c53acadfccc6 |
permissions | -rw-r--r-- |
0
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
1 |
/* |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
2 |
* Copyright (c) 2005-2009 Nokia Corporation and/or its subsidiary(-ies). |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
3 |
* All rights reserved. |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
4 |
* This component and the accompanying materials are made available |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
5 |
* under the terms of "Eclipse Public License v1.0" |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
6 |
* which accompanies this distribution, and is available |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
7 |
* at the URL "http://www.eclipse.org/legal/epl-v10.html". |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
8 |
* |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
9 |
* Initial Contributors: |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
10 |
* Nokia Corporation - initial contribution. |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
11 |
* |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
12 |
* Contributors: |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
13 |
* |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
14 |
* Description: SQL database startup routines* |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
15 |
*/ |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
16 |
|
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
17 |
// INCLUDE FILES |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
18 |
#include "mdssqldbmaintenance.h" |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
19 |
#include "mdccommon.h" |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
20 |
#include "mdspreferences.h" |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
21 |
|
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
22 |
// ========================= MEMBER FUNCTIONS ================================== |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
23 |
|
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
24 |
CMdSSqlDbMaintenance* CMdSSqlDbMaintenance::NewL() |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
25 |
{ |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
26 |
CMdSSqlDbMaintenance* self = CMdSSqlDbMaintenance::NewLC(); |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
27 |
CleanupStack::Pop( self ); |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
28 |
return self; |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
29 |
} |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
30 |
|
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
31 |
CMdSSqlDbMaintenance* CMdSSqlDbMaintenance::NewLC() |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
32 |
{ |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
33 |
CMdSSqlDbMaintenance* self = new ( ELeave ) CMdSSqlDbMaintenance(); |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
34 |
CleanupStack::PushL( self ); |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
35 |
self->ConstructL(); |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
36 |
return self; |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
37 |
} |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
38 |
|
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
39 |
void CMdSSqlDbMaintenance::ConstructL( ) |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
40 |
{ |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
41 |
} |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
42 |
|
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
43 |
CMdSSqlDbMaintenance::CMdSSqlDbMaintenance() |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
44 |
{ |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
45 |
} |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
46 |
|
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
47 |
CMdSSqlDbMaintenance::~CMdSSqlDbMaintenance() |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
48 |
{ |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
49 |
} |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
50 |
|
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
51 |
TBool CMdSSqlDbMaintenance::ValidateL( ) |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
52 |
{ |
54 | 53 |
//validate content of critical tables |
0
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
54 |
_LIT( KValidateTableExistence, "SELECT COUNT(*) FROM MdE_Preferences;" ); |
54 | 55 |
_LIT( KValidateObjectDef, "SELECT COUNT(*) FROM ObjectDef;" ); |
56 |
_LIT( KValidatePropertyDef, "SELECT COUNT(*) FROM PropertyDef;" ); |
|
57 |
_LIT( KValidateRelationDef, "SELECT COUNT(*) FROM RelationDef;" ); |
|
58 |
_LIT( KValidateCol2Prop, "SELECT COUNT(*) FROM Col2Prop;" ); |
|
0
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
59 |
|
54 | 60 |
TInt test(KErrNone); |
61 |
TUint32 count(0); |
|
62 |
||
63 |
RRowData emptyRowData; |
|
64 |
CleanupClosePushL( emptyRowData ); |
|
65 |
||
0
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
66 |
RMdsStatement validationQuery; |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
67 |
CleanupClosePushL( validationQuery ); |
54 | 68 |
|
0
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
69 |
CMdSSqLiteConnection& connection = MMdSDbConnectionPool::GetDefaultDBL(); |
54 | 70 |
|
71 |
TRAP( test, connection.ExecuteQueryL( KValidateTableExistence, validationQuery, emptyRowData ) ); |
|
72 |
if(test == KErrNone) |
|
73 |
{ |
|
74 |
emptyRowData.AppendL( TColumn( count ) ); |
|
75 |
TRAP( test, connection.NextRowL(validationQuery, emptyRowData)); |
|
76 |
if(test == KErrNone) |
|
77 |
{ |
|
78 |
emptyRowData.Column(0).Get( count ); |
|
79 |
||
80 |
if(count <= 0) |
|
81 |
{ |
|
82 |
test = KErrCorrupt; |
|
83 |
} |
|
84 |
} |
|
85 |
} |
|
86 |
||
87 |
CleanupStack::PopAndDestroy( &validationQuery ); |
|
88 |
emptyRowData.Reset(); |
|
89 |
||
90 |
RMdsStatement objectDefQuery; |
|
91 |
CleanupClosePushL( objectDefQuery ); |
|
92 |
||
93 |
if( test == KErrNone ) |
|
94 |
{ |
|
95 |
TRAP( test, connection.ExecuteQueryL( KValidateObjectDef, objectDefQuery, emptyRowData ) ); |
|
96 |
||
97 |
if(test == KErrNone) |
|
98 |
{ |
|
99 |
emptyRowData.AppendL( TColumn( count ) ); |
|
100 |
TRAP( test, connection.NextRowL(objectDefQuery, emptyRowData)); |
|
101 |
if(test == KErrNone) |
|
102 |
{ |
|
103 |
emptyRowData.Column(0).Get( count ); |
|
104 |
||
105 |
if(count <= 0) |
|
106 |
{ |
|
107 |
test = KErrCorrupt; |
|
108 |
} |
|
109 |
} |
|
110 |
} |
|
111 |
} |
|
112 |
||
113 |
CleanupStack::PopAndDestroy( &objectDefQuery ); |
|
114 |
emptyRowData.Reset(); |
|
115 |
||
116 |
RMdsStatement propertyDefQuery; |
|
117 |
CleanupClosePushL( propertyDefQuery ); |
|
118 |
||
119 |
if( test == KErrNone ) |
|
120 |
{ |
|
121 |
TRAP( test, connection.ExecuteQueryL( KValidatePropertyDef, propertyDefQuery, emptyRowData ) ); |
|
122 |
if(test == KErrNone) |
|
123 |
{ |
|
124 |
emptyRowData.AppendL( TColumn( count ) ); |
|
125 |
TRAP( test, connection.NextRowL(propertyDefQuery, emptyRowData)); |
|
126 |
if(test == KErrNone) |
|
127 |
{ |
|
128 |
emptyRowData.Column(0).Get( count ); |
|
129 |
||
130 |
if(count <= 0) |
|
131 |
{ |
|
132 |
test = KErrCorrupt; |
|
133 |
} |
|
134 |
} |
|
135 |
} |
|
136 |
} |
|
137 |
||
138 |
CleanupStack::PopAndDestroy( &propertyDefQuery ); |
|
139 |
emptyRowData.Reset(); |
|
140 |
||
141 |
RMdsStatement relationDefQuery; |
|
142 |
CleanupClosePushL( relationDefQuery ); |
|
143 |
||
144 |
if( test == KErrNone ) |
|
145 |
{ |
|
146 |
TRAP( test, connection.ExecuteQueryL( KValidateRelationDef, relationDefQuery, emptyRowData ) ); |
|
147 |
if(test == KErrNone) |
|
148 |
{ |
|
149 |
emptyRowData.AppendL( TColumn( count ) ); |
|
150 |
TRAP( test, connection.NextRowL(relationDefQuery, emptyRowData)); |
|
151 |
||
152 |
if(test == KErrNone) |
|
153 |
{ |
|
154 |
emptyRowData.Column(0).Get( count ); |
|
155 |
||
156 |
if(count <= 0) |
|
157 |
{ |
|
158 |
test = KErrCorrupt; |
|
159 |
} |
|
160 |
} |
|
161 |
} |
|
162 |
} |
|
163 |
||
164 |
CleanupStack::PopAndDestroy( &relationDefQuery ); |
|
165 |
emptyRowData.Reset(); |
|
166 |
||
167 |
RMdsStatement col2propQuery; |
|
168 |
CleanupClosePushL( col2propQuery ); |
|
169 |
||
170 |
if( test == KErrNone ) |
|
171 |
{ |
|
172 |
TRAP( test, connection.ExecuteQueryL( KValidateCol2Prop, col2propQuery, emptyRowData ) ); |
|
173 |
if(test == KErrNone) |
|
174 |
{ |
|
175 |
emptyRowData.AppendL( TColumn( count ) ); |
|
176 |
TRAP( test, connection.NextRowL(col2propQuery, emptyRowData)); |
|
177 |
||
178 |
if(test == KErrNone) |
|
179 |
{ |
|
180 |
emptyRowData.Column(0).Get( count ); |
|
181 |
||
182 |
if(count <= 0) |
|
183 |
||
184 |
{ |
|
185 |
test = KErrCorrupt; |
|
186 |
} |
|
187 |
} |
|
188 |
} |
|
189 |
} |
|
190 |
CleanupStack::PopAndDestroy( &col2propQuery ); |
|
191 |
||
192 |
CleanupStack::PopAndDestroy( &emptyRowData ); |
|
193 |
||
194 |
if(test == KErrCorrupt ) |
|
195 |
{ |
|
196 |
User::Leave( test ); |
|
197 |
} |
|
198 |
||
0
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
199 |
return ( test == KErrNone ); |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
200 |
} |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
201 |
|
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
202 |
|
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
203 |
void CMdSSqlDbMaintenance::CreateDatabaseL() |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
204 |
{ |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
205 |
_LIT( KCreateTblMdE_Preferences, // Table for metadata engine use |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
206 |
"CREATE TABLE MdE_Preferences(Key TEXT,Value NONE,ExtraValue LARGEINT,UNIQUE(Key,Value));"); |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
207 |
|
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
208 |
_LIT( KCreateTblMdS_Medias, // Table for metadata engine use |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
209 |
"CREATE TABLE MdS_Medias(MediaId INTEGER PRIMARY KEY,Drive INTEGER,PresentState INTEGER,Time LARGEINT);"); |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
210 |
|
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
211 |
RRowData emptyRowData; |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
212 |
CleanupClosePushL( emptyRowData ); |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
213 |
|
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
214 |
// Create ontology tables |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
215 |
CMdSSqLiteConnection& connection = MMdSDbConnectionPool::GetDefaultDBL(); |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
216 |
|
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
217 |
connection.ExecuteL( KCreateTblMdE_Preferences, emptyRowData ); |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
218 |
|
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
219 |
connection.ExecuteL( KCreateTblMdS_Medias, emptyRowData ); |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
220 |
|
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
221 |
TInt majorVersion = KMdSServMajorVersionNumber; |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
222 |
TInt64 minorVersion = KMdSServMinorVersionNumber; |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
223 |
MMdsPreferences::InsertL( KMdsDBVersionName, MMdsPreferences::EPreferenceBothSet, |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
224 |
majorVersion, minorVersion ); |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
225 |
|
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
226 |
CleanupStack::PopAndDestroy( &emptyRowData ); |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
227 |
} |
c53acadfccc6
Revision: 201001
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
228 |
|
54 | 229 |
TBool CMdSSqlDbMaintenance::CheckForCorruptionL() |
230 |
{ |
|
231 |
// Check the MDS default namespace main table for validity |
|
232 |
// This table should always contain at least 1 default system folder object |
|
233 |
_LIT( KValidateData, "SELECT COUNT(*) FROM Object%u;" ); |
|
234 |
||
235 |
RBuf commonClauseOne; |
|
236 |
User::LeaveIfError( commonClauseOne.Create( KValidateData.iTypeLength + KMaxUintValueLength ) ); |
|
237 |
CleanupClosePushL( commonClauseOne ); |
|
238 |
commonClauseOne.Format( KValidateData, KDefaultNamespaceDefId ); |
|
239 |
||
240 |
RRowData emptyRowData; |
|
241 |
CleanupClosePushL( emptyRowData ); |
|
242 |
||
243 |
RMdsStatement validationQuery; |
|
244 |
CleanupClosePushL( validationQuery ); |
|
245 |
||
246 |
CMdSSqLiteConnection& connection = MMdSDbConnectionPool::GetDefaultDBL(); |
|
247 |
||
248 |
TInt test( KErrNone ); |
|
249 |
TUint32 count( 0 ); |
|
250 |
TRAP( test, connection.ExecuteQueryL( commonClauseOne, validationQuery, emptyRowData ) ); |
|
251 |
if( test == KErrNone ) |
|
252 |
{ |
|
253 |
emptyRowData.AppendL( TColumn( count ) ); |
|
254 |
TRAP( test, connection.NextRowL(validationQuery, emptyRowData)); |
|
255 |
if(test == KErrNone) |
|
256 |
{ |
|
257 |
emptyRowData.Column(0).Get( count ); |
|
258 |
||
259 |
if(count <= 0) |
|
260 |
{ |
|
261 |
test = KErrCorrupt; |
|
262 |
} |
|
263 |
} |
|
264 |
} |
|
265 |
||
266 |
CleanupStack::PopAndDestroy( &validationQuery ); |
|
267 |
||
268 |
CleanupStack::PopAndDestroy( &emptyRowData ); |
|
269 |
||
270 |
CleanupStack::PopAndDestroy( &commonClauseOne ); |
|
271 |
||
272 |
return ( test == KErrNone ); |
|
273 |
} |
|
274 |