47 _LIT( KSQLInsertToGroup, "INSERT INTO CA_GROUP_ENTRY \ |
47 _LIT( KSQLInsertToGroup, "INSERT INTO CA_GROUP_ENTRY \ |
48 (GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION) \ |
48 (GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION) \ |
49 VALUES ( :GE_GROUP_ID, :GE_ENTRY_ID, :GE_POSITION )" ); |
49 VALUES ( :GE_GROUP_ID, :GE_ENTRY_ID, :GE_POSITION )" ); |
50 |
50 |
51 _LIT( KSQLInsertToIcon, "INSERT INTO CA_ICON \ |
51 _LIT( KSQLInsertToIcon, "INSERT INTO CA_ICON \ |
52 (IC_FILENAME,IC_BITMAP_ID,IC_MASK_ID,IC_SKINMAJOR_ID,IC_SKINMINOR_ID) \ |
52 (IC_FILENAME,IC_SKIN_ID,IC_APP_ID) \ |
53 VALUES ( :IC_FILENAME, :IC_BITMAP_ID, :IC_MASK_ID, \ |
53 VALUES ( :IC_FILENAME, :IC_SKIN_ID, :IC_APP_ID )" ); |
54 :IC_SKINMAJOR_ID, :IC_SKINMINOR_ID )" ); |
|
55 |
54 |
56 _LIT( KSQLInsertToLaunch, "INSERT INTO CA_LAUNCH \ |
55 _LIT( KSQLInsertToLaunch, "INSERT INTO CA_LAUNCH \ |
57 (LA_ENTRY_ID, LA_LAUNCH_TIME) \ |
56 (LA_ENTRY_ID, LA_LAUNCH_TIME) \ |
58 VALUES ( :LA_ENTRY_ID, :LA_LAUNCH_TIME )" ); |
57 VALUES ( :LA_ENTRY_ID, :LA_LAUNCH_TIME )" ); |
59 |
58 |
94 |
93 |
95 |
94 |
96 // Update Icon |
95 // Update Icon |
97 _LIT( KSQLUpdateIconId, "ICON_ID = :ICON_ID " ); |
96 _LIT( KSQLUpdateIconId, "ICON_ID = :ICON_ID " ); |
98 _LIT( KSQLUpdateIconFileName, "IC_FILENAME = :IC_FILENAME " ); |
97 _LIT( KSQLUpdateIconFileName, "IC_FILENAME = :IC_FILENAME " ); |
99 _LIT( KSQLUpdateIconBitmapId, "IC_BITMAP_ID = :IC_BITMAP_ID " ); |
98 _LIT( KSQLUpdateIconSkinId, "IC_SKIN_ID = :IC_SKIN_ID " ); |
100 _LIT( KSQLUpdateIconMaskId, "IC_MASK_ID = :IC_MASK_ID " ); |
99 _LIT( KSQLUpdateIconAppId, "IC_APP_ID = :IC_APP_ID " ); |
101 _LIT( KSQLUpdateIconSkinMajorId, "IC_SKINMAJOR_ID = :IC_SKINMAJOR_ID " ); |
|
102 _LIT( KSQLUpdateIconSkinMinorId, "IC_SKINMINOR_ID = :IC_SKINMINOR_ID " ); |
|
103 _LIT( KSQLUpdateIconWhere, "WHERE ICON_ID = :ICON_ID" ); |
100 _LIT( KSQLUpdateIconWhere, "WHERE ICON_ID = :ICON_ID" ); |
104 |
101 |
105 // Update property |
102 // Update property |
106 _LIT( KSQLUpdateProperty, "UPDATE CA_DB_PROPERTIES \ |
103 _LIT( KSQLUpdateProperty, "UPDATE CA_DB_PROPERTIES \ |
107 SET DB_VALUE = :DB_VALUE WHERE DB_PROPERTY = :DB_PROPERTY "); |
104 SET DB_VALUE = :DB_VALUE WHERE DB_PROPERTY = :DB_PROPERTY "); |
134 LT_ATTRIBUTE_NAME, LT_STRING_ID, LT_ROW_ID \ |
131 LT_ATTRIBUTE_NAME, LT_STRING_ID, LT_ROW_ID \ |
135 FROM CA_LOCALIZATION_TEXT" ); |
132 FROM CA_LOCALIZATION_TEXT" ); |
136 |
133 |
137 _LIT( KSQLGetListByEntryIds, "SELECT ENTRY_ID, EN_TEXT, EN_DESCRIPTION, \ |
134 _LIT( KSQLGetListByEntryIds, "SELECT ENTRY_ID, EN_TEXT, EN_DESCRIPTION, \ |
138 EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, EN_CREATION_TIME, EN_UID, EN_FLAGS, \ |
135 EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, EN_CREATION_TIME, EN_UID, EN_FLAGS, \ |
139 IC_FILENAME, IC_BITMAP_ID, IC_MASK_ID, IC_SKINMAJOR_ID, IC_SKINMINOR_ID \ |
136 IC_FILENAME,IC_SKIN_ID,IC_APP_ID \ |
140 FROM CA_ENTRY LEFT JOIN CA_ICON ON EN_ICON_ID = ICON_ID \ |
137 FROM CA_ENTRY LEFT JOIN CA_ICON ON EN_ICON_ID = ICON_ID \ |
141 WHERE ENTRY_ID IN ( %S )" ); |
138 WHERE ENTRY_ID IN ( %S )" ); |
142 |
139 |
143 _LIT( KSQLGetList, "SELECT ENTRY_ID, EN_TEXT, EN_DESCRIPTION, EN_ROLE, \ |
140 _LIT( KSQLGetList1, "SELECT ENTRY_ID, EN_TEXT, EN_DESCRIPTION, EN_ROLE, \ |
144 EN_TYPE_NAME, EN_ICON_ID, EN_CREATION_TIME, EN_UID, EN_FLAGS, IC_FILENAME, \ |
141 EN_TYPE_NAME, EN_ICON_ID, EN_CREATION_TIME, EN_UID, EN_FLAGS, IC_FILENAME, \ |
145 IC_BITMAP_ID, IC_MASK_ID, IC_SKINMAJOR_ID, IC_SKINMINOR_ID FROM \ |
142 IC_SKIN_ID, IC_APP_ID FROM CA_ENTRY " ); |
146 CA_ENTRY LEFT JOIN CA_ICON ON EN_ICON_ID = ICON_ID " ); |
143 |
147 |
144 _LIT( KSQLGetList2, "LEFT JOIN CA_ICON ON EN_ICON_ID = ICON_ID " ); |
148 _LIT( KSQLGetListByParentId, "SELECT ENTRY_ID, EN_TEXT, EN_DESCRIPTION, \ |
145 |
|
146 |
|
147 _LIT( KSQLGetListByParentId1, "SELECT ENTRY_ID, EN_TEXT, EN_DESCRIPTION, \ |
149 EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, EN_CREATION_TIME, EN_UID, EN_FLAGS, \ |
148 EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, EN_CREATION_TIME, EN_UID, EN_FLAGS, \ |
150 IC_FILENAME, IC_BITMAP_ID, IC_MASK_ID, IC_SKINMAJOR_ID, IC_SKINMINOR_ID, \ |
149 IC_FILENAME, IC_SKIN_ID, IC_APP_ID, \ |
151 GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION FROM CA_ENTRY \ |
150 GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION FROM CA_ENTRY " ); |
152 LEFT JOIN CA_ICON ON EN_ICON_ID = ICON_ID LEFT JOIN CA_GROUP_ENTRY ON \ |
151 |
|
152 _LIT( KSQLGetListByParentId2, "LEFT JOIN CA_ICON ON EN_ICON_ID = ICON_ID LEFT JOIN CA_GROUP_ENTRY ON \ |
153 GE_ENTRY_ID = ENTRY_ID WHERE GE_GROUP_ID = :GE_GROUP_ID %S " ); |
153 GE_ENTRY_ID = ENTRY_ID WHERE GE_GROUP_ID = :GE_GROUP_ID %S " ); |
154 |
154 |
155 //Get all attributes by entry id |
155 //Get all attributes by entry id |
156 //:Entry_Id_List is a list of Integers seperated by commas. |
156 //:Entry_Id_List is a list of Integers seperated by commas. |
157 _LIT( KSQLGetAttributesByEntryId, "SELECT \ |
157 _LIT( KSQLGetAttributesByEntryId, "SELECT \ |
160 |
160 |
161 //Select most used |
161 //Select most used |
162 // %S - the input table to work on. |
162 // %S - the input table to work on. |
163 _LIT( KSQLGetListByLaunchDataPart1,"SELECT ENTRY_ID, EN_TEXT, \ |
163 _LIT( KSQLGetListByLaunchDataPart1,"SELECT ENTRY_ID, EN_TEXT, \ |
164 EN_DESCRIPTION, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, EN_CREATION_TIME, \ |
164 EN_DESCRIPTION, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, EN_CREATION_TIME, \ |
165 EN_UID, EN_FLAGS, IC_FILENAME, IC_BITMAP_ID, IC_MASK_ID, IC_SKINMAJOR_ID, \ |
165 EN_UID, EN_FLAGS, IC_FILENAME, IC_SKIN_ID, IC_APP_ID FROM ("); |
166 IC_SKINMINOR_ID FROM ("); |
|
167 |
166 |
168 // %S - the table to match e.g KSQLGetMostUsed or KSQLGetLastUsed |
167 // %S - the table to match e.g KSQLGetMostUsed or KSQLGetLastUsed |
169 // The column USAGE_DATA is used to order the items |
168 // The column USAGE_DATA is used to order the items |
170 _LIT( KSQLGetListByLaunchDataPart2,") LEFT JOIN("); |
169 _LIT( KSQLGetListByLaunchDataPart2,") LEFT JOIN("); |
171 _LIT( KSQLGetListByLaunchDataPart3,") ON ENTRY_ID = LA_ENTRY_ID \ |
170 _LIT( KSQLGetListByLaunchDataPart3,") ON ENTRY_ID = LA_ENTRY_ID \ |
176 |
175 |
177 _LIT( KSQLNotINIds," AND GE_GROUP_ID NOT IN( %S )" ); |
176 _LIT( KSQLNotINIds," AND GE_GROUP_ID NOT IN( %S )" ); |
178 |
177 |
179 _LIT( KSQLGetIconId,"SELECT ICON_ID AS Data FROM CA_ICON \ |
178 _LIT( KSQLGetIconId,"SELECT ICON_ID AS Data FROM CA_ICON \ |
180 WHERE IC_FILENAME = :IC_FILENAME AND \ |
179 WHERE IC_FILENAME = :IC_FILENAME AND \ |
181 IC_BITMAP_ID = :IC_BITMAP_ID AND \ |
180 IC_SKIN_ID = :IC_SKIN_ID AND \ |
182 IC_MASK_ID = :IC_MASK_ID AND \ |
181 IC_APP_ID = :IC_APP_ID"); |
183 IC_SKINMAJOR_ID = :IC_SKINMAJOR_ID AND \ |
|
184 IC_SKINMINOR_ID = :IC_SKINMINOR_ID"); |
|
185 |
182 |
186 _LIT( KSQLGetEntryIdFromEntryTable,"SELECT ENTRY_ID AS Data FROM CA_ENTRY \ |
183 _LIT( KSQLGetEntryIdFromEntryTable,"SELECT ENTRY_ID AS Data FROM CA_ENTRY \ |
187 WHERE ENTRY_ID = :ENTRY_ID"); |
184 WHERE ENTRY_ID = :ENTRY_ID"); |
188 |
185 |
189 _LIT( KSQLGETIconIdFromEntryTable, "SELECT EN_ICON_ID AS Data FROM CA_ENTRY \ |
186 _LIT( KSQLGETIconIdFromEntryTable, "SELECT EN_ICON_ID AS Data FROM CA_ENTRY \ |
190 WHERE ENTRY_ID = :ENTRY_ID"); |
187 WHERE ENTRY_ID = :ENTRY_ID"); |
191 |
188 |
192 _LIT( KSQLGetIconDataByIdIcon,"SELECT ICON_ID, IC_FILENAME, IC_BITMAP_ID, \ |
189 _LIT( KSQLGetIconDataByIdIcon,"SELECT ICON_ID, IC_FILENAME, IC_SKIN_ID, IC_APP_ID \ |
193 IC_MASK_ID, IC_SKINMAJOR_ID, IC_SKINMINOR_ID \ |
|
194 FROM CA_ICON WHERE ICON_ID = :EN_ICON_ID"); |
190 FROM CA_ICON WHERE ICON_ID = :EN_ICON_ID"); |
195 |
191 |
196 _LIT( KSQLGetIconsItems,"SELECT ENTRY_ID, EN_TEXT, EN_DESCRIPTION, EN_ROLE, \ |
192 _LIT( KSQLGetIconsItems,"SELECT ENTRY_ID, EN_TEXT, EN_DESCRIPTION, EN_ROLE, \ |
197 EN_TYPE_NAME, EN_ICON_ID, EN_CREATION_TIME, EN_UID, EN_FLAGS, IC_FILENAME, \ |
193 EN_TYPE_NAME, EN_ICON_ID, EN_CREATION_TIME, EN_UID, EN_FLAGS, IC_FILENAME, \ |
198 IC_BITMAP_ID, IC_MASK_ID, IC_SKINMAJOR_ID, IC_SKINMINOR_ID FROM \ |
194 IC_SKIN_ID, IC_APP_ID FROM \ |
199 CA_ENTRY LEFT JOIN CA_ICON ON EN_ICON_ID = ICON_ID \ |
195 CA_ENTRY LEFT JOIN CA_ICON ON EN_ICON_ID = ICON_ID \ |
200 WHERE EN_ICON_ID = :EN_ICON_ID"); |
196 WHERE EN_ICON_ID = :EN_ICON_ID"); |
201 |
197 |
202 _LIT( KSQLGetMostUsed,"SELECT LA_ENTRY_ID, COUNT(*) AS USAGE_DATA FROM \ |
198 _LIT( KSQLGetMostUsed,"SELECT LA_ENTRY_ID, COUNT(*) AS USAGE_DATA FROM \ |
203 CA_LAUNCH GROUP BY LA_ENTRY_ID" ); |
199 CA_LAUNCH GROUP BY LA_ENTRY_ID" ); |
253 _LIT( KWhere, " WHERE " ); |
249 _LIT( KWhere, " WHERE " ); |
254 _LIT( KDesc, " DESC " ); |
250 _LIT( KDesc, " DESC " ); |
255 _LIT( KAnd, " AND " ); |
251 _LIT( KAnd, " AND " ); |
256 _LIT( KLimit, " LIMIT "); |
252 _LIT( KLimit, " LIMIT "); |
257 _LIT( KSingleQuotes, "\'" ); |
253 _LIT( KSingleQuotes, "\'" ); |
|
254 _LIT( KDot, "." ); |
|
255 _LIT( KEqual, " = "); |
|
256 _LIT( KEmpty, "" ); |
|
257 _LIT( KGroupBy, " GROUP BY " ); |
|
258 _LIT( KAt, " at" ); |
|
259 _LIT( KLeftJoinCaAttrubute1, " LEFT JOIN CA_ATTRIBUTE as at" ); |
|
260 _LIT( KLeftJoinCaAttrubute2, " ON ENTRY_ID = at" ); |
|
261 _LIT( KLeftJoinCaAttrubute3, ".AT_ENTRY_ID " ); |
258 |
262 |
259 _LIT( KSQLSortOrderNameAsc, " ORDER BY EN_TEXT ASC" ); |
263 _LIT( KSQLSortOrderNameAsc, " ORDER BY EN_TEXT ASC" ); |
260 _LIT( KSQLSortOrderNameDesc, " ORDER BY EN_TEXT DESC" ); |
264 _LIT( KSQLSortOrderNameDesc, " ORDER BY EN_TEXT DESC" ); |
261 _LIT( KSQLSortOrderCreatedTimestampAsc, " ORDER BY EN_CREATION_TIME ASC" ); |
265 _LIT( KSQLSortOrderCreatedTimestampAsc, " ORDER BY EN_CREATION_TIME ASC" ); |
262 _LIT( KSQLSortOrderCreatedTimestampDesc, " ORDER BY EN_CREATION_TIME DESC" ); |
266 _LIT( KSQLSortOrderCreatedTimestampDesc, " ORDER BY EN_CREATION_TIME DESC" ); |
281 _LIT( KSQLGEEntryId, ":GE_ENTRY_ID" ); |
285 _LIT( KSQLGEEntryId, ":GE_ENTRY_ID" ); |
282 _LIT( KSQLGEPosition, ":GE_POSITION" ); |
286 _LIT( KSQLGEPosition, ":GE_POSITION" ); |
283 |
287 |
284 _LIT( KSQLIconId, ":ICON_ID" ); |
288 _LIT( KSQLIconId, ":ICON_ID" ); |
285 _LIT( KSQLIcFileName, ":IC_FILENAME" ); |
289 _LIT( KSQLIcFileName, ":IC_FILENAME" ); |
286 _LIT( KSQLIcBitmapId, ":IC_BITMAP_ID" ); |
290 _LIT( KSQLIcSkinId, ":IC_SKIN_ID" ); |
287 _LIT( KSQLIcMaskId, ":IC_MASK_ID" ); |
291 _LIT( KSQLIcAppId, ":IC_APP_ID" ); |
288 _LIT( KSQLIcSkinMajorId, ":IC_SKINMAJOR_ID" ); |
|
289 _LIT( KSQLIcSkinMinorId, ":IC_SKINMINOR_ID" ); |
|
290 |
292 |
291 _LIT( KSQLLaunchId, ":LAUNCH_ID" ); |
293 _LIT( KSQLLaunchId, ":LAUNCH_ID" ); |
292 _LIT( KSQLLaLaunchTime, ":LA_LAUNCH_TIME" ); |
294 _LIT( KSQLLaLaunchTime, ":LA_LAUNCH_TIME" ); |
293 _LIT( KSQLLaLaunchEntryId, ":LA_ENTRY_ID" ); |
295 _LIT( KSQLLaLaunchEntryId, ":LA_ENTRY_ID" ); |
294 |
296 |
328 _LIT( KColumnGEIdGroup, "GE_GROUP_ID" ); |
330 _LIT( KColumnGEIdGroup, "GE_GROUP_ID" ); |
329 _LIT( KColumnGEPosition, "GE_POSITION" ); |
331 _LIT( KColumnGEPosition, "GE_POSITION" ); |
330 |
332 |
331 _LIT( KColumnIconId, "ICON_ID" ); |
333 _LIT( KColumnIconId, "ICON_ID" ); |
332 _LIT( KColumnIcFileName, "IC_FILENAME" ); |
334 _LIT( KColumnIcFileName, "IC_FILENAME" ); |
333 _LIT( KColumnIcBitmapId, "IC_BITMAP_ID" ); |
335 _LIT( KColumnIcSkinId, "IC_SKIN_ID" ); |
334 _LIT( KColumnIcMaskId, "IC_MASK_ID" ); |
336 _LIT( KColumnIcAppId, "IC_APP_ID" ); |
335 _LIT( KColumnIcSkinMajorId, "IC_SKINMAJOR_ID" ); |
|
336 _LIT( KColumnIcSkinMinorId, "IC_SKINMINOR_ID" ); |
|
337 |
337 |
338 _LIT( KColumnLaunchId, "LAUNCH_ID" ); |
338 _LIT( KColumnLaunchId, "LAUNCH_ID" ); |
339 _LIT( KColumnLaLaunchTime, "LA_LAUNCH_TIME" ); |
339 _LIT( KColumnLaLaunchTime, "LA_LAUNCH_TIME" ); |
340 |
340 |
341 _LIT( KColumnAttributeId, "ATTRIBUTE_ID" ); |
341 _LIT( KColumnAttributeId, "ATTRIBUTE_ID" ); |