diff -r 3ab5c078b490 -r c63ee96dbe5f contentstorage/castorage/tsrc/t_castorage/inc/castoragetestsqlcommands.h
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/contentstorage/castorage/tsrc/t_castorage/inc/castoragetestsqlcommands.h	Thu Sep 16 12:11:40 2010 +0100
@@ -0,0 +1,91 @@
+/*
+ * 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_ */