1 /*

     2  * Copyright (c) 2009 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:

    15  *

    16  */

    17 

    18 #ifndef CASTORAGETESTSQLCOMMANDS_H_

    19 #define CASTORAGETESTSQLCOMMANDS_H_

    20 

    21 _LIT(KSQLGetEntryTimestamp, "SELECT EN_CREATION_TIME AS Data FROM CA_ENTRY where ENTRY_ID = :ENTRY_ID0 ");

    22 

    23 // add tests

    24 _LIT(KTestName, "AddTest");

    25 _LIT(KTestName1, "TestName1");

    26 _LIT(KTestName2, "TestName2");

    27 _LIT(KTestNameUpdate, "AddTestUpdate");

    28 _LIT(KTypeName, "Folder");

    29 _LIT(KTypeName2, "application");

    30 const TUint flag = 4;

    31 const TUint flagUpdate = 8;

    32 

    33 _LIT(KAttrName_1, "Attribute_Name_1");

    34 _LIT(KAttrName_2, "Attribute_Name_2");

    35 _LIT(KAttrName_3, "Attribute_Name_3");

    36 _LIT(KAttrValue_1, "Attribute_Value_1");

    37 _LIT(KAttrValue_2, "Attribute_Value_2");

    38 _LIT(KAttrValue_3, "Attribute_Value_3");

    39 

    40 _LIT(KSQLCheckAttribute, "SELECT * FROM CA_ATTRIBUTE \

    41 WHERE AT_ENTRY_ID = :ENTRY_ID");

    42 

    43 _LIT(KSQLGetAttribute, "SELECT * FROM CA_ATTRIBUTE WHERE AT_ENTRY_ID = :AT_ENTRY_ID");

    44 

    45 // remove tests

    46 _LIT(KSQLGetIdCountFromEntryTable,"SELECT COUNT(*) AS Data FROM CA_ENTRY");

    47 _LIT(KSQLGetIdCountFromIconTable,"SELECT COUNT(*) AS Data FROM CA_ICON");

    48 

    49 // touch

    50 _LIT(KSQLGetIdCountFromLaunchTable,"SELECT COUNT(*) AS Data FROM CA_LAUNCH");

    51 _LIT(KSQLGetUsedFlagCountFromEntryTable, "SELECT COUNT(*) AS Data FROM CA_ENTRY \

    52 WHERE EN_FLAGS & :EN_FLAGS = :EN_FLAGS");

    53 

    54 const TInt KErrNoData = 1001;

    55 const TInt KErrWrongData = 1002;

    56 const TInt KErrBadParams = 1003;

    57 

    58 const TInt KAllCollectionsGroupId = 2;

    59 const TInt KMaxFlagsMask = 63;

    60 const TInt KMaxFlagsMaskForCombinedTest = 15;

    61 const TInt KCalendarAppUid = 268458241;

    62 const TInt KTestAppUid = 268458111;

    63 const TInt KTestAppUid2 = 268458112;

    64 

    65 _LIT(KTypeNameApplication, "application");

    66 _LIT(KTypeNameFolder, "folder");

    67 

    68 //organize tests

    69 _LIT(KSQLGetUnexistingIdFromGroup,"SELECT MAX(GE_ENTRY_ID) + 1 AS Data FROM CA_GROUP_ENTRY WHERE GE_GROUP_ID = :GE_GROUP_ID");

    70 

    71 // GE_ENTRY_ID AS GE_GROUP_ID because we don't have proper execute

    72 _LIT(KSQLGetEntryIdsFromGroupInPositionOrder, "SELECT GE_ENTRY_ID AS GE_GROUP_ID FROM CA_GROUP_ENTRY WHERE GE_GROUP_ID = :GE_GROUP_ID ORDER BY GE_POSITION");

    73 

    74 //get entries tests

    75 _LIT(KSQLGetEntriesCountFromSpecificGroup, "SELECT COUNT(*) AS Data FROM CA_GROUP_ENTRY \

    76 WHERE GE_GROUP_ID = :GE_GROUP_ID");

    77 

    78 _LIT(KSQLGetEntriesCountAsParentsForSpecificEntry, "SELECT COUNT(*) AS Data FROM CA_GROUP_ENTRY \

    79 WHERE GE_ENTRY_ID = :GE_ENTRY_ID");

    80 

    81 _LIT(KSQLGetIdEntryFromSpecificGroup, "SELECT GE_ENTRY_ID AS ENTRY_ID FROM CA_GROUP_ENTRY \

    82 WHERE GE_GROUP_ID = :GE_GROUP_ID");

    83 const TUint KFlagsOnTable[5] = { 0, 2, 5, 36, 60 };

    84 const TUint KFlagsOffTable[5] = { 1, 2, 6, 18, 25 };

    85 const TUint KFlagsOffTableMasks[5] = { 30, 29, 25, 13, 6 };

    86 

    87 // localization

    88 _LIT(KSQLCountFromLocalizationTable,"SELECT COUNT(*) AS Data FROM CA_LOCALIZATION_TEXT");

    89 

    90 

    91 #endif /* CASTORAGETESTSQLCOMMANDS_H_ */