/*

 * Copyright (c) 2009 Nokia Corporation and/or its subsidiary(-ies).

 * All rights reserved.

 * This component and the accompanying materials are made available

 * under the terms of "Eclipse Public License v1.0"

 * which accompanies this distribution, and is available

 * at the URL "http://www.eclipse.org/legal/epl-v10.html".

 *

 * Initial Contributors:

 * Nokia Corporation - initial contribution.

 *

 * Contributors:

 *

 * Description:

 *

 */

#ifndef CASTORAGETESTSQLCOMMANDS_H_

#define CASTORAGETESTSQLCOMMANDS_H_

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

// add tests

_LIT(KTestName, "AddTest");

_LIT(KTestName1, "TestName1");

_LIT(KTestName2, "TestName2");

_LIT(KTestNameUpdate, "AddTestUpdate");

_LIT(KTypeName, "Folder");

_LIT(KTypeName2, "application");

const TUint flag = 4;

const TUint flagUpdate = 8;

_LIT(KAttrName_1, "Attribute_Name_1");

_LIT(KAttrName_2, "Attribute_Name_2");

_LIT(KAttrName_3, "Attribute_Name_3");

_LIT(KAttrValue_1, "Attribute_Value_1");

_LIT(KAttrValue_2, "Attribute_Value_2");

_LIT(KAttrValue_3, "Attribute_Value_3");

_LIT(KSQLCheckAttribute, "SELECT * FROM CA_ATTRIBUTE \

WHERE AT_ENTRY_ID = :ENTRY_ID");

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

// remove tests

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

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

// touch

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

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

WHERE EN_FLAGS & :EN_FLAGS = :EN_FLAGS");

const TInt KErrNoData = 1001;

const TInt KErrWrongData = 1002;

const TInt KErrBadParams = 1003;

const TInt KAllCollectionsGroupId = 2;

const TInt KMaxFlagsMask = 63;

const TInt KMaxFlagsMaskForCombinedTest = 15;

const TInt KCalendarAppUid = 268458241;

const TInt KTestAppUid = 268458111;

const TInt KTestAppUid2 = 268458112;

_LIT(KTypeNameApplication, "application");

_LIT(KTypeNameFolder, "folder");

//organize tests

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

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

_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");

//get entries tests

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

WHERE GE_GROUP_ID = :GE_GROUP_ID");

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

WHERE GE_ENTRY_ID = :GE_ENTRY_ID");

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

WHERE GE_GROUP_ID = :GE_GROUP_ID");

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

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

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

// localization

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

#endif /* CASTORAGETESTSQLCOMMANDS_H_ */