50 |
50 |
51 _LIT( KSQLInsertToIcon, "INSERT INTO CA_ICON \ |
51 _LIT( KSQLInsertToIcon, "INSERT INTO CA_ICON \ |
52 (IC_FILENAME,IC_SKIN_ID,IC_APP_ID) \ |
52 (IC_FILENAME,IC_SKIN_ID,IC_APP_ID) \ |
53 VALUES ( :IC_FILENAME, :IC_SKIN_ID, :IC_APP_ID )" ); |
53 VALUES ( :IC_FILENAME, :IC_SKIN_ID, :IC_APP_ID )" ); |
54 |
54 |
55 _LIT( KSQLInsertToLaunch, "INSERT INTO CA_LAUNCH \ |
|
56 (LA_ENTRY_ID, LA_LAUNCH_TIME) \ |
|
57 VALUES ( :LA_ENTRY_ID, :LA_LAUNCH_TIME )" ); |
|
58 |
|
59 _LIT( KSQLInsertToAttribute, "REPLACE INTO CA_ATTRIBUTE \ |
55 _LIT( KSQLInsertToAttribute, "REPLACE INTO CA_ATTRIBUTE \ |
60 (AT_ENTRY_ID, AT_NAME,AT_VALUE) \ |
56 (AT_ENTRY_ID, AT_NAME,AT_VALUE) \ |
61 VALUES ( :AT_ENTRY_ID, :AT_NAME, :AT_VALUE )" ); |
57 VALUES ( :AT_ENTRY_ID, :AT_NAME, :AT_VALUE )" ); |
62 |
58 |
63 _LIT( KSQLAddLocalization, "INSERT INTO CA_LOCALIZATION_TEXT \ |
59 _LIT( KSQLAddLocalization, "INSERT INTO CA_LOCALIZATION_TEXT \ |
67 //update Data |
63 //update Data |
68 _LIT( KSQLUpdateEntry, "UPDATE CA_ENTRY SET " ); |
64 _LIT( KSQLUpdateEntry, "UPDATE CA_ENTRY SET " ); |
69 _LIT( KSQLUpdateGroup, "UPDATE CA_GROUP_ENTRY SET " ); |
65 _LIT( KSQLUpdateGroup, "UPDATE CA_GROUP_ENTRY SET " ); |
70 _LIT( KSQLUpdateIcon, "UPDATE CA_ICON SET " ); |
66 _LIT( KSQLUpdateIcon, "UPDATE CA_ICON SET " ); |
71 _LIT( KSQLUpdateEntryUsedFlag, "UPDATE CA_ENTRY SET \ |
67 _LIT( KSQLUpdateEntryUsedFlag, "UPDATE CA_ENTRY SET \ |
72 EN_FLAGS = EN_FLAGS | :EN_FLAGS WHERE ENTRY_ID = :LA_ENTRY_ID"); |
68 EN_FLAGS = EN_FLAGS | :EN_FLAGS WHERE ENTRY_ID = :ENTRY_ID"); |
73 _LIT( KSQLLocalizeTextEntry, "UPDATE CA_ENTRY SET \ |
69 _LIT( KSQLLocalizeTextEntry, "UPDATE CA_ENTRY SET \ |
74 EN_TEXT = :LT_STRING WHERE ENTRY_ID = :LT_ROW_ID"); // WHERE ENTRY_ID must be changed if an attribute |
70 EN_TEXT = :LT_STRING WHERE ENTRY_ID = :LT_ROW_ID"); // WHERE ENTRY_ID must be changed if an attribute |
75 _LIT( KSQLLocalizeDescriptionEntry, "UPDATE CA_ENTRY SET \ |
71 _LIT( KSQLLocalizeDescriptionEntry, "UPDATE CA_ENTRY SET \ |
76 EN_DESCRIPTION = :LT_STRING WHERE ENTRY_ID = :LT_ROW_ID"); // WHERE ENTRY_ID must be changed if an attribute |
72 EN_DESCRIPTION = :LT_STRING WHERE ENTRY_ID = :LT_ROW_ID"); // WHERE ENTRY_ID must be changed if an attribute |
77 _LIT( KSQLLocalizeShortNameAttribute, "UPDATE CA_ATTRIBUTE SET \ |
73 _LIT( KSQLLocalizeShortNameAttribute, "UPDATE CA_ATTRIBUTE SET \ |
78 AT_VALUE = :LT_STRING WHERE AT_ENTRY_ID = :LT_ROW_ID AND AT_NAME = \"short_name\""); |
74 AT_VALUE = :LT_STRING WHERE AT_ENTRY_ID = :LT_ROW_ID AND AT_NAME = \"short_name\""); |
79 _LIT( KSQLLocalizeTitleNameAttribute, "UPDATE CA_ATTRIBUTE SET \ |
75 _LIT( KSQLLocalizeTitleNameAttribute, "UPDATE CA_ATTRIBUTE SET \ |
80 AT_VALUE = :LT_STRING WHERE AT_ENTRY_ID = :LT_ROW_ID AND AT_NAME = \"title_name\""); |
76 AT_VALUE = :LT_STRING WHERE AT_ENTRY_ID = :LT_ROW_ID AND AT_NAME = \"title_name\""); |
81 |
77 |
82 _LIT( KSQLUpdatePositionInGroup, "UPDATE CA_GROUP_ENTRY SET \ |
78 _LIT( KSQLUpdatePositionInGroup, "UPDATE CA_GROUP_ENTRY SET \ |
83 GE_POSITION = :GE_POSITION WHERE \ |
79 GE_POSITION = :GE_POSITION WHERE \ |
84 GE_ENTRY_ID = :GE_ENTRY_ID AND GE_GROUP_ID = :GE_GROUP_ID" ); |
80 GE_ENTRY_ID = :GE_ENTRY_ID AND GE_GROUP_ID = :GE_GROUP_ID" ); |
85 |
81 |
98 _LIT( KSQLUpdateEntryUid, "EN_UID = :EN_UID " ); |
94 _LIT( KSQLUpdateEntryUid, "EN_UID = :EN_UID " ); |
99 _LIT( KSQLUpdateEntryUidNULL, "EN_UID = NULL " ); |
95 _LIT( KSQLUpdateEntryUidNULL, "EN_UID = NULL " ); |
100 _LIT( KSQLUpdateEntryFlags, "EN_FLAGS = :EN_FLAGS " ); |
96 _LIT( KSQLUpdateEntryFlags, "EN_FLAGS = :EN_FLAGS " ); |
101 _LIT( KSQLUpdateWhere, "WHERE ENTRY_ID = :ENTRY_ID " ); |
97 _LIT( KSQLUpdateWhere, "WHERE ENTRY_ID = :ENTRY_ID " ); |
102 |
98 |
103 // Null Icon params |
99 // Null Icon params |
104 _LIT( KSQLEmptyIconFileName, "(IC_FILENAME IS NULL OR IC_FILENAME = '')" ); |
100 _LIT( KSQLEmptyIconFileName, "(IC_FILENAME IS NULL OR IC_FILENAME = '')" ); |
105 _LIT( KSQLEmptyIconSkinId, "(IC_SKIN_ID IS NULL OR IC_SKIN_ID = '')" ); |
101 _LIT( KSQLEmptyIconSkinId, "(IC_SKIN_ID IS NULL OR IC_SKIN_ID = '')" ); |
106 _LIT( KSQLEmptyIconAppId, "(IC_APP_ID IS NULL OR IC_APP_ID = '')" ); |
102 _LIT( KSQLEmptyIconAppId, "(IC_APP_ID IS NULL OR IC_APP_ID = '')" ); |
107 |
103 |
108 // Update Icon |
104 // Update Icon |
111 _LIT( KSQLUpdateIconSkinId, "IC_SKIN_ID = :IC_SKIN_ID " ); |
107 _LIT( KSQLUpdateIconSkinId, "IC_SKIN_ID = :IC_SKIN_ID " ); |
112 _LIT( KSQLUpdateIconAppId, "IC_APP_ID = :IC_APP_ID " ); |
108 _LIT( KSQLUpdateIconAppId, "IC_APP_ID = :IC_APP_ID " ); |
113 _LIT( KSQLUpdateIconWhere, "WHERE ICON_ID = :ICON_ID" ); |
109 _LIT( KSQLUpdateIconWhere, "WHERE ICON_ID = :ICON_ID" ); |
114 |
110 |
115 // Update property |
111 // Update property |
116 _LIT( KSQLUpdateProperty, "UPDATE CA_DB_PROPERTIES \ |
112 _LIT( KSQLUpdateProperty, "REPLACE INTO CA_DB_PROPERTIES \ |
117 SET DB_VALUE = :DB_VALUE WHERE DB_PROPERTY = :DB_PROPERTY "); |
113 ( DB_PROPERTY, DB_VALUE ) VALUES ( :DB_PROPERTY, :DB_VALUE )"); |
118 |
114 |
119 // Update localization table entry |
115 // Update localization table entry |
120 |
116 |
121 _LIT( KSQLUpdateLocalization, "UPDATE CA_LOCALIZATION_TEXT SET \ |
117 _LIT( KSQLUpdateLocalization, "UPDATE CA_LOCALIZATION_TEXT SET \ |
122 LT_STRING_ID = :LT_STRING , LT_QMFILENAME = :LT_QMFILENAME \ |
118 LT_STRING_ID = :LT_STRING , LT_QMFILENAME = :LT_QMFILENAME \ |
123 WHERE LT_TABLE_NAME = :LT_TABLE AND LT_ATTRIBUTE_NAME = :LT_ATTRIBUTE \ |
119 WHERE LT_TABLE_NAME = :LT_TABLE AND LT_ATTRIBUTE_NAME = :LT_ATTRIBUTE \ |
124 AND LT_ROW_ID = :LT_ROW_ID" ); |
120 AND LT_ROW_ID = :LT_ROW_ID" ); |
125 |
121 |
126 //Delete Data |
122 //Delete Data |
127 _LIT( KSQLDeleteLaunch, "DELETE FROM CA_LAUNCH \ |
|
128 WHERE LA_ENTRY_ID = :ENTRY_ID" ); |
|
129 _LIT( KSQLDeleteOldFromLaunch, "DELETE FROM CA_LAUNCH \ |
|
130 WHERE LA_LAUNCH_TIME < :LA_LAUNCH_TIME" ); |
|
131 _LIT( KSQLDeleteEntryFromGroup, "DELETE FROM CA_GROUP_ENTRY \ |
123 _LIT( KSQLDeleteEntryFromGroup, "DELETE FROM CA_GROUP_ENTRY \ |
132 WHERE GE_ENTRY_ID = :ENTRY_ID" ); |
124 WHERE GE_ENTRY_ID = :ENTRY_ID" ); |
133 _LIT( KSQLDeleteGroupFromGroup, "DELETE FROM CA_GROUP_ENTRY \ |
125 _LIT( KSQLDeleteGroupFromGroup, "DELETE FROM CA_GROUP_ENTRY \ |
134 WHERE GE_GROUP_ID = :ENTRY_ID" ); |
126 WHERE GE_GROUP_ID = :ENTRY_ID" ); |
135 _LIT( KSQLDeleteAttribute, "DELETE FROM CA_ATTRIBUTE \ |
127 _LIT( KSQLDeleteAttribute, "DELETE FROM CA_ATTRIBUTE \ |
182 //:Entry_Id_List is a list of Integers seperated by commas. |
174 //:Entry_Id_List is a list of Integers seperated by commas. |
183 _LIT( KSQLGetAttributesByEntryId, "SELECT \ |
175 _LIT( KSQLGetAttributesByEntryId, "SELECT \ |
184 ATTRIBUTE_ID, AT_ENTRY_ID, AT_NAME, AT_VALUE FROM CA_ATTRIBUTE \ |
176 ATTRIBUTE_ID, AT_ENTRY_ID, AT_NAME, AT_VALUE FROM CA_ATTRIBUTE \ |
185 WHERE AT_ENTRY_ID IN ( %S )" ); |
177 WHERE AT_ENTRY_ID IN ( %S )" ); |
186 |
178 |
187 //Select most used |
|
188 // %S - the input table to work on. |
|
189 _LIT( KSQLGetListByLaunchDataPart1,"SELECT ENTRY_ID, EN_TEXT, \ |
|
190 EN_DESCRIPTION, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, EN_CREATION_TIME, \ |
|
191 EN_UID, EN_FLAGS, IC_FILENAME, IC_SKIN_ID, IC_APP_ID FROM ("); |
|
192 |
|
193 // %S - the table to match e.g KSQLGetMostUsed or KSQLGetLastUsed |
|
194 // The column USAGE_DATA is used to order the items |
|
195 _LIT( KSQLGetListByLaunchDataPart2,") LEFT JOIN("); |
|
196 _LIT( KSQLGetListByLaunchDataPart3,") ON ENTRY_ID = LA_ENTRY_ID \ |
|
197 ORDER BY USAGE_DATA"); |
|
198 |
179 |
199 _LIT( KSQLGetParentIds,"SELECT DISTINCT GE_GROUP_ID FROM CA_GROUP_ENTRY \ |
180 _LIT( KSQLGetParentIds,"SELECT DISTINCT GE_GROUP_ID FROM CA_GROUP_ENTRY \ |
200 WHERE GE_ENTRY_ID IN ( %S )" ); |
181 WHERE GE_ENTRY_ID IN ( %S )" ); |
201 |
182 |
202 _LIT( KSQLNotINIds," AND GE_GROUP_ID NOT IN( %S )" ); |
183 _LIT( KSQLNotINIds," AND GE_GROUP_ID NOT IN( %S )" ); |
216 EN_TYPE_NAME, EN_ICON_ID, EN_CREATION_TIME, EN_UID, EN_FLAGS, IC_FILENAME, \ |
197 EN_TYPE_NAME, EN_ICON_ID, EN_CREATION_TIME, EN_UID, EN_FLAGS, IC_FILENAME, \ |
217 IC_SKIN_ID, IC_APP_ID FROM \ |
198 IC_SKIN_ID, IC_APP_ID FROM \ |
218 CA_ENTRY LEFT JOIN CA_ICON ON EN_ICON_ID = ICON_ID \ |
199 CA_ENTRY LEFT JOIN CA_ICON ON EN_ICON_ID = ICON_ID \ |
219 WHERE EN_ICON_ID = :EN_ICON_ID"); |
200 WHERE EN_ICON_ID = :EN_ICON_ID"); |
220 |
201 |
221 _LIT( KSQLGetMostUsed,"SELECT LA_ENTRY_ID, COUNT(*) AS USAGE_DATA FROM \ |
|
222 CA_LAUNCH GROUP BY LA_ENTRY_ID" ); |
|
223 |
|
224 _LIT( KSQLGetLastUsed,"SELECT LA_ENTRY_ID, MAX(LA_LAUNCH_TIME) \ |
|
225 AS USAGE_DATA FROM CA_LAUNCH GROUP BY LA_ENTRY_ID" ); |
|
226 |
202 |
227 _LIT( KSQLGetProperty, "SELECT DB_VALUE FROM CA_DB_PROPERTIES WHERE DB_PROPERTY = :DB_PROPERTY "); |
203 _LIT( KSQLGetProperty, "SELECT DB_VALUE FROM CA_DB_PROPERTIES WHERE DB_PROPERTY = :DB_PROPERTY "); |
228 |
204 |
229 |
205 |
230 //Organize statements |
206 //Organize statements |
240 ( SELECT GE_POSITION FROM CA_GROUP_ENTRY \ |
216 ( SELECT GE_POSITION FROM CA_GROUP_ENTRY \ |
241 WHERE GE_ENTRY_ID = :Entry_Id_Before ) ) "); |
217 WHERE GE_ENTRY_ID = :Entry_Id_Before ) ) "); |
242 |
218 |
243 _LIT( KSQLOrganizeInsertToGroupPrepend,"INSERT INTO CA_GROUP_ENTRY \ |
219 _LIT( KSQLOrganizeInsertToGroupPrepend,"INSERT INTO CA_GROUP_ENTRY \ |
244 (GE_GROUP_ID,GE_ENTRY_ID,GE_POSITION) \ |
220 (GE_GROUP_ID,GE_ENTRY_ID,GE_POSITION) \ |
245 VALUES ( :GE_GROUP_ID, :GE_ENTRY_ID, 1 ) "); |
221 VALUES ( :GE_GROUP_ID, :GE_ENTRY_ID, 1 ) "); |
246 |
222 |
247 //Statement to append the entry at end of table |
223 //Statement to append the entry at end of table |
248 _LIT( KSQLOrganizeAppendToGroup,"INSERT INTO CA_GROUP_ENTRY \ |
224 _LIT( KSQLOrganizeAppendToGroup,"INSERT INTO CA_GROUP_ENTRY \ |
249 (GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION) \ |
225 (GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION) \ |
250 VALUES ( :GE_GROUP_ID, :GE_ENTRY_ID, \ |
226 VALUES ( :GE_GROUP_ID, :GE_ENTRY_ID, \ |
311 _LIT( KSQLIconId, ":ICON_ID" ); |
287 _LIT( KSQLIconId, ":ICON_ID" ); |
312 _LIT( KSQLIcFileName, ":IC_FILENAME" ); |
288 _LIT( KSQLIcFileName, ":IC_FILENAME" ); |
313 _LIT( KSQLIcSkinId, ":IC_SKIN_ID" ); |
289 _LIT( KSQLIcSkinId, ":IC_SKIN_ID" ); |
314 _LIT( KSQLIcAppId, ":IC_APP_ID" ); |
290 _LIT( KSQLIcAppId, ":IC_APP_ID" ); |
315 |
291 |
316 _LIT( KSQLLaunchId, ":LAUNCH_ID" ); |
|
317 _LIT( KSQLLaLaunchTime, ":LA_LAUNCH_TIME" ); |
|
318 _LIT( KSQLLaLaunchEntryId, ":LA_ENTRY_ID" ); |
|
319 |
|
320 _LIT( KSQLAttributeId, ":ATTRIBUTE_ID" ); |
292 _LIT( KSQLAttributeId, ":ATTRIBUTE_ID" ); |
321 _LIT( KSQLAttrEntryID, ":AT_ENTRY_ID" ); |
293 _LIT( KSQLAttrEntryID, ":AT_ENTRY_ID" ); |
322 _LIT( KSQLAttrName, ":AT_NAME" ); |
294 _LIT( KSQLAttrName, ":AT_NAME" ); |
323 _LIT( KSQLAttrValue, ":AT_VALUE" ); |
295 _LIT( KSQLAttrValue, ":AT_VALUE" ); |
324 |
296 |
360 _LIT( KColumnIconId, "ICON_ID" ); |
332 _LIT( KColumnIconId, "ICON_ID" ); |
361 _LIT( KColumnIcFileName, "IC_FILENAME" ); |
333 _LIT( KColumnIcFileName, "IC_FILENAME" ); |
362 _LIT( KColumnIcSkinId, "IC_SKIN_ID" ); |
334 _LIT( KColumnIcSkinId, "IC_SKIN_ID" ); |
363 _LIT( KColumnIcAppId, "IC_APP_ID" ); |
335 _LIT( KColumnIcAppId, "IC_APP_ID" ); |
364 |
336 |
365 _LIT( KColumnLaunchId, "LAUNCH_ID" ); |
|
366 _LIT( KColumnLaLaunchTime, "LA_LAUNCH_TIME" ); |
|
367 |
|
368 _LIT( KColumnAttributeId, "ATTRIBUTE_ID" ); |
337 _LIT( KColumnAttributeId, "ATTRIBUTE_ID" ); |
369 _LIT( KColumnAttrEntryID, "AT_ENTRY_ID" ); |
338 _LIT( KColumnAttrEntryID, "AT_ENTRY_ID" ); |
370 _LIT( KColumnAttrName, "AT_NAME" ); |
339 _LIT( KColumnAttrName, "AT_NAME" ); |
371 _LIT( KColumnAttrValue, "AT_VALUE" ); |
340 _LIT( KColumnAttrValue, "AT_VALUE" ); |
372 |
341 |