|
1 /* |
|
2 * Copyright (c) 2008 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: SQL database maintenance class |
|
15 * |
|
16 */ |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 #include "cmdmsqliteconnection.h" |
|
24 #include "cmdmsqlmaintenanceclauses.h" |
|
25 #include "cmdmsqldbmaintenance.h" |
|
26 #include "cmdmsqlclausedef.h" |
|
27 #include "msdebug.h" |
|
28 |
|
29 // --------------------------------------------------------------------------- |
|
30 // CCmDmSqlDbMaintenance::NewL |
|
31 // --------------------------------------------------------------------------- |
|
32 // |
|
33 CCmDmSqlDbMaintenance* CCmDmSqlDbMaintenance::NewL() |
|
34 { |
|
35 LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::NewL()")); |
|
36 |
|
37 CCmDmSqlDbMaintenance* self = CCmDmSqlDbMaintenance::NewLC(); |
|
38 CleanupStack::Pop( self ); |
|
39 |
|
40 return self; |
|
41 } |
|
42 |
|
43 // --------------------------------------------------------------------------- |
|
44 // CCmDmSqlDbMaintenance::NewLC |
|
45 // --------------------------------------------------------------------------- |
|
46 // |
|
47 CCmDmSqlDbMaintenance* CCmDmSqlDbMaintenance::NewLC() |
|
48 { |
|
49 LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::NewLC()")); |
|
50 |
|
51 CCmDmSqlDbMaintenance* self = new ( ELeave ) CCmDmSqlDbMaintenance(); |
|
52 CleanupStack::PushL( self ); |
|
53 self->ConstructL(); |
|
54 |
|
55 return self; |
|
56 } |
|
57 |
|
58 // --------------------------------------------------------------------------- |
|
59 // CCmDmSqlDbMaintenance::~CCmDmSqlDbMaintenance |
|
60 // --------------------------------------------------------------------------- |
|
61 // |
|
62 CCmDmSqlDbMaintenance::~CCmDmSqlDbMaintenance() |
|
63 { |
|
64 LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::~CCmDmSqlDbMaintenance()")); |
|
65 } |
|
66 |
|
67 // --------------------------------------------------------------------------- |
|
68 // CCmDmSqlDbMaintenance::InitConnection |
|
69 // --------------------------------------------------------------------------- |
|
70 // |
|
71 TInt CCmDmSqlDbMaintenance::InitConnection( |
|
72 CCmDmSQLiteConnection& aConnection ) |
|
73 { |
|
74 LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::InitConnection()")); |
|
75 return aConnection.OpenDb( KCmDatabase ); |
|
76 } |
|
77 |
|
78 // --------------------------------------------------------------------------- |
|
79 // CCmDmSqlDbMaintenance::CloseConnection |
|
80 // --------------------------------------------------------------------------- |
|
81 // |
|
82 void CCmDmSqlDbMaintenance::CloseConnection( |
|
83 CCmDmSQLiteConnection& aConnection ) |
|
84 { |
|
85 LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::CloseConnection()")); |
|
86 aConnection.CloseDb(); |
|
87 } |
|
88 |
|
89 // --------------------------------------------------------------------------- |
|
90 // CCmDmSqlDbMaintenance::CreateDbFile |
|
91 // --------------------------------------------------------------------------- |
|
92 // |
|
93 TInt CCmDmSqlDbMaintenance::CreateDbFile( |
|
94 CCmDmSQLiteConnection& aConnection ) |
|
95 { |
|
96 LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::CreateDbFile()")); |
|
97 return aConnection.CreateDbFile( KCmDatabase ); |
|
98 } |
|
99 |
|
100 // --------------------------------------------------------------------------- |
|
101 // CCmDmSqlDbMaintenance::CreateDb |
|
102 // --------------------------------------------------------------------------- |
|
103 // |
|
104 void CCmDmSqlDbMaintenance::CreateDb( |
|
105 CCmDmSQLiteConnection& aConnection ) |
|
106 { |
|
107 LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::CreateDb()")); |
|
108 |
|
109 /// DROP tables |
|
110 TRAP_IGNORE( aConnection.ExecuteL( KDropFillRuleGroup )); |
|
111 TRAP_IGNORE( aConnection.ExecuteL( KDropRules )); |
|
112 TRAP_IGNORE( aConnection.ExecuteL( KDropRuleParams )); |
|
113 TRAP_IGNORE( aConnection.ExecuteL( KDropRuleGroupServers )); |
|
114 TRAP_IGNORE( aConnection.ExecuteL( KDropMediaServers )); |
|
115 TRAP_IGNORE( aConnection.ExecuteL( KDropHashValues )); |
|
116 TRAP_IGNORE( aConnection.ExecuteL( KDropStored )); |
|
117 TRAP_IGNORE( aConnection.ExecuteL( KDropFilled )); |
|
118 TRAP_IGNORE( aConnection.ExecuteL( KDropIDs )); |
|
119 TRAP_IGNORE( aConnection.ExecuteL( KDropStoreRules )); |
|
120 TRAP_IGNORE( aConnection.ExecuteL( KDropStoreRuleParams )); |
|
121 TRAP_IGNORE( aConnection.ExecuteL( KDropStoreRuleServers )); |
|
122 TRAP_IGNORE( aConnection.ExecuteL( KDropFillFiles )); |
|
123 TRAP_IGNORE( aConnection.ExecuteL( KDropStoreFiles )); |
|
124 TRAP_IGNORE( aConnection.ExecuteL( KDropStoreFileServers )); |
|
125 TRAP_IGNORE( aConnection.ExecuteL( KDropImageShrinkingInfo )); |
|
126 TRAP_IGNORE( aConnection.ExecuteL( KDropTransferInfo )); |
|
127 TRAP_IGNORE( aConnection.ExecuteL( KDropSyncTime )); |
|
128 TRAP_IGNORE( aConnection.ExecuteL( KDropProgressInfo )); |
|
129 TRAP_IGNORE( aConnection.ExecuteL( KDropDrivesInfo )); |
|
130 |
|
131 // Create tables |
|
132 TRAP_IGNORE( aConnection.ExecuteL( KCreateFillRuleGroup ) ); |
|
133 TRAP_IGNORE( aConnection.ExecuteL( KCreateRules ) ); |
|
134 TRAP_IGNORE( aConnection.ExecuteL( KCreateRuleParams ) ); |
|
135 TRAP_IGNORE( aConnection.ExecuteL( KCreateRuleGroupServers ) ); |
|
136 TRAP_IGNORE( aConnection.ExecuteL( KCreateMediaServers ) ); |
|
137 TRAP_IGNORE( aConnection.ExecuteL( KCreateHashValues ) ); |
|
138 TRAP_IGNORE( aConnection.ExecuteL( KCreateStored ) ); |
|
139 TRAP_IGNORE( aConnection.ExecuteL( KCreateIDs ) ); |
|
140 TRAP_IGNORE( aConnection.ExecuteL( KCreateStoreRules ) ); |
|
141 TRAP_IGNORE( aConnection.ExecuteL( KCreateStoreRuleParams ) ); |
|
142 TRAP_IGNORE( aConnection.ExecuteL( KCreateStoreRuleServers ) ); |
|
143 TRAP_IGNORE( aConnection.ExecuteL( KCreateFillFiles ) ); |
|
144 TRAP_IGNORE( aConnection.ExecuteL( KCreateStoreFiles ) ); |
|
145 TRAP_IGNORE( aConnection.ExecuteL( KCreateStoreFileServers ) ); |
|
146 TRAP_IGNORE( aConnection.ExecuteL( KCreateImageShrinkingInfo ) ); |
|
147 TRAP_IGNORE( aConnection.ExecuteL( KCreateTransferInfo ) ); |
|
148 TRAP_IGNORE( aConnection.ExecuteL( KCreateSyncTime ) ); |
|
149 TRAP_IGNORE( aConnection.ExecuteL( KCreateProgressInfo ) ); |
|
150 TRAP_IGNORE( aConnection.ExecuteL( KCreateDrivesInfo )); |
|
151 |
|
152 // Init clauses |
|
153 TRAP_IGNORE( aConnection.ExecuteL( KInitShrinkingTime ) ); |
|
154 } |
|
155 |
|
156 // --------------------------------------------------------------------------- |
|
157 // CCmDmSqlDbMaintenance::CreateIndexes |
|
158 // --------------------------------------------------------------------------- |
|
159 // |
|
160 void CCmDmSqlDbMaintenance::CreateIndexes( |
|
161 CCmDmSQLiteConnection& aConnection ) |
|
162 { |
|
163 LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::CreateIndexes()")); |
|
164 |
|
165 // Drop indexes |
|
166 TRAP_IGNORE( aConnection.ExecuteL( KDropFillListIdIndex ) ); |
|
167 TRAP_IGNORE( aConnection.ExecuteL( KDropFillItemRefIndex ) ); |
|
168 TRAP_IGNORE( aConnection.ExecuteL( KDropStoreStatusIndex ) ); |
|
169 TRAP_IGNORE( aConnection.ExecuteL( KDropFillStatusIndex ) ); |
|
170 |
|
171 // Create indexes |
|
172 TRAP_IGNORE( aConnection.ExecuteL( KCreateFillListIdIndex ) ); |
|
173 TRAP_IGNORE( aConnection.ExecuteL( KCreateFillItemRefIndex ) ); |
|
174 TRAP_IGNORE( aConnection.ExecuteL( KCreateStoreStatusIndex ) ); |
|
175 TRAP_IGNORE( aConnection.ExecuteL( KCreateFillStatusIndex ) ); |
|
176 } |
|
177 |
|
178 // --------------------------------------------------------------------------- |
|
179 // CCmDmSqlDbMaintenance::CCmDmSqlDbMaintenance |
|
180 // --------------------------------------------------------------------------- |
|
181 // |
|
182 CCmDmSqlDbMaintenance::CCmDmSqlDbMaintenance() |
|
183 { |
|
184 LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::CCmDmSqlDbMaintenance()")); |
|
185 } |
|
186 |
|
187 // --------------------------------------------------------------------------- |
|
188 // CCmDmSqlDbMaintenance::ConstructL |
|
189 // --------------------------------------------------------------------------- |
|
190 // |
|
191 void CCmDmSqlDbMaintenance::ConstructL() |
|
192 { |
|
193 LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::ConstructL()")); |
|
194 } |
|
195 |
|
196 // End of file |
|
197 |