contentstorage/castorage/inc/casqlcommands.h
changeset 61 8e5041d13c84
parent 60 f62f87b200ec
child 66 32469d7d46ff
equal deleted inserted replaced
60:f62f87b200ec 61:8e5041d13c84
    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" );