Mercurial Mercurial > oss > MCL > sf > os > persistentdata / diff
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
loggingservices/eventlogger/LogServ/inc/LogServSqlStrings.h
changeset 0 08ec8eefde2f
child 10 31a8f755b7fe 
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/loggingservices/eventlogger/LogServ/inc/LogServSqlStrings.h	Fri Jan 22 11:06:30 2010 +0200
@@ -0,0 +1,144 @@
+// Copyright (c) 2005-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 __LOGSERVSQLSTRINGS_H__
+#define __LOGSERVSQLSTRINGS_H__
+
+#include <e32std.h>
+
+#ifdef __LOGSRV_STRINGS__
+	#define CONST_LIT8(var, val) extern const TLitC8<sizeof(val)> var = {sizeof(val) - 1, val}
+	#define CONST_LIT16(var, val) extern const TLitC16<sizeof(L##val)/2> var = {sizeof(L##val)/2 - 1, L##val}
+	#define CONST_TTEXT(var, val) extern const TText var = val
+#else
+	#define CONST_LIT8(var, val) extern const TLitC8<sizeof(val)> var
+	#define CONST_LIT16(var, val) extern const TLitC16<sizeof(L##val)/2> var
+	#define CONST_TTEXT(var, val) extern const TText var
+#endif
+
+#ifdef _UNICODE
+	#define CONST_LIT(var, val) CONST_LIT16(var, val)
+#else
+	#define CONST_LIT(var, val) CONST_LIT8(var, val)
+#endif
+
+const  TInt KMaxSqlStringLength = 1024;
+extern TBuf<KMaxSqlStringLength> TheSql;
+
+/////////// Create tables
+#ifdef SYMBIAN_ENABLE_EVENTLOGGER_DUALSIM	
+CONST_LIT(KLogTableEventString, "CREATE TABLE Event (Id INTEGER NOT NULL, EType UNSIGNED TINYINT NOT NULL, Remote CHAR(%d), Direction SMALLINT, ETime DATE NOT NULL, DType TINYINT NOT NULL, Duration UNSIGNED INTEGER, Status SMALLINT, Subject CHAR(%d), Number CHAR(%d), Contact INTEGER, Link UNSIGNED INTEGER, Data LONG VARBINARY, Recent TINYINT, Duplicate INTEGER, Flag1 BIT NOT NULL, Flag2 BIT NOT NULL, Flag3 BIT NOT NULL, Flag4 BIT NOT NULL, SimId UNSIGNED INTEGER)");
+#else
+CONST_LIT(KLogTableEventString, "CREATE TABLE Event (Id INTEGER NOT NULL, EType UNSIGNED TINYINT NOT NULL, Remote CHAR(%d), Direction SMALLINT, ETime DATE NOT NULL, DType TINYINT NOT NULL, Duration UNSIGNED INTEGER, Status SMALLINT, Subject CHAR(%d), Number CHAR(%d), Contact INTEGER, Link UNSIGNED INTEGER, Data LONG VARBINARY, Recent TINYINT, Duplicate INTEGER, Flag1 BIT NOT NULL, Flag2 BIT NOT NULL, Flag3 BIT NOT NULL, Flag4 BIT NOT NULL)");
+#endif
+CONST_LIT(KLogTableTypeString, "CREATE TABLE Type (Id SMALLINT NOT NULL, UId UNSIGNED INTEGER NOT NULL, Description CHAR(%d) NOT NULL, Enabled BIT)");
+CONST_LIT(KLogTableStringString, "CREATE TABLE String (Id SMALLINT NOT NULL, TEXT CHAR(%d) NOT NULL)");
+CONST_LIT(KLogTableConfigString, "CREATE TABLE Config (Size UNSIGNED SMALLINT NOT NULL, Recent UNSIGNED TINYINT NOT NULL, Age UNSIGNED INTEGER NOT NULL)");
+/////////// Config table: operations 
+CONST_LIT(KLogSqlInsertConfigString, "INSERT INTO Config VALUES (%d, %d, %d)") ;
+/////////// Type table: operations
+CONST_LIT(KLogSqlUpdateTypeString, "UPDATE Type SET Description = '%S', Enabled = %d WHERE UId = %d") ;
+CONST_LIT(KLogSqlDeleteTypeString, "DELETE FROM Type WHERE UId = %d") ;
+//
+CONST_LIT(KLogSqlSelectOldestString, "SELECT Id FROM Event WHERE ETime <= #%S#") ;
+CONST_LIT(KLogSqlDeleteOldestString, "DELETE FROM Event WHERE ETime <= #%S#") ;
+CONST_LIT(KLogSqlSelectAllRecent,    "SELECT Id, Recent, Duplicate FROM Event") ;
+CONST_LIT(KLogSqlSelectDuplicateString, "SELECT Id, Duplicate FROM EVENT WHERE Recent = %d %S AND NOT Id = %d ORDER BY Id DESC") ;
+CONST_LIT(KLogSqlGetRecent, "SELECT Id FROM Event WHERE Recent = %d AND Duplicate IS NULL ORDER BY Id DESC") ;
+CONST_LIT(KLogSqlRemoveDuplicateEvents, "UPDATE Event SET Recent = NULL, Duplicate = NULL WHERE ");
+//The next 4 queries must have exactly the same set of columns in the list => see CLogServViewBase::InitializeColumnsL()
+_LIT(KLogViewSelectColList, "SELECT Id, EType, Flag1, Flag2, Flag3, Flag4 FROM Event");
+_LIT(KLogSqlEventViewString,        "%S %S ORDER BY Id DESC") ;
+_LIT(KLogSqlAllRecentViewString,    "%S WHERE Recent IS NOT NULL AND Duplicate IS NULL %S ORDER BY Id DESC") ;
+_LIT(KLogSqlRecentViewString,       "%S WHERE Recent=%d AND Duplicate IS NULL %S ORDER BY Id DESC") ;
+_LIT(KLogSqlDuplicateViewString2,   "%S WHERE Duplicate=%d %S ORDER BY Id DESC");
+// Selects all duplicate events for a particular recent list
+_LIT(KLogSqlSelectAllDuplicatesString, "SELECT Id, Recent, Duplicate FROM Event WHERE Recent = %d AND Duplicate IS NOT NULL");
+// Get duplicate events
+CONST_LIT(KLogSqlDuplicateViewString, "SELECT Id, EType, Duplicate, Flag1, Flag2, Flag3, Flag4 FROM Event WHERE Duplicate = %d %S ORDER BY Id DESC");
+// Remove duplicate event
+CONST_LIT(KLogSqlRemoveDuplicateString, "UPDATE Event SET Recent = NULL, Duplicate = NULL WHERE Id = %d AND Duplicate = %d");
+//Field names
+CONST_LIT(KLogNameEventString, "Event") ;
+CONST_LIT(KLogNameTypeString, "Type");
+CONST_LIT(KLogNameStringString, "String");
+CONST_LIT(KLogNameConfigString, "Config");
+CONST_LIT(KLogFieldIdString, "Id");
+CONST_LIT(KLogFieldEventTypeString, "EType");
+CONST_LIT(KLogFieldEventRemoteString, "Remote");
+CONST_LIT(KLogFieldEventDirectionString, "Direction");
+CONST_LIT(KLogFieldEventTimeString, "ETime");
+CONST_LIT(KLogFieldEventDTypeString, "DType");
+CONST_LIT(KLogFieldEventDurationString, "Duration");
+CONST_LIT(KLogFieldEventStatusString,  "Status");
+CONST_LIT(KLogFieldEventSubjectString,  "Subject");
+CONST_LIT(KLogFieldEventNumberString, "Number");
+CONST_LIT(KLogFieldEventContactString, "Contact");
+CONST_LIT(KLogFieldEventLinkString, "Link");
+CONST_LIT(KLogFieldEventDataString, "Data");
+CONST_LIT(KLogFieldEventRecentString, "Recent");
+CONST_LIT(KLogFieldEventDuplicateString, "Duplicate");
+CONST_LIT(KLogFieldEventFlagString, "Flag%d");
+#ifdef SYMBIAN_ENABLE_EVENTLOGGER_DUALSIM	
+CONST_LIT(KLogFieldEventSimId, "SimId");
+#endif
+CONST_LIT(KLogFieldTypeIdString, "Id");
+CONST_LIT(KLogFieldTypeUidString, "UId");
+CONST_LIT(KLogFieldTypeEnabledString, "Enabled");
+CONST_LIT(KLogFieldTypeDescriptionString, "Description");
+CONST_LIT(KLogFieldStringIdString, "Id");
+CONST_LIT(KLogFieldStringTextString, "Text");
+CONST_LIT(KLogFieldConfigSizeString, "Size");
+CONST_LIT(KLogFieldConfigRecentString, "Recent");
+CONST_LIT(KLogFieldConfigAgeString, "Age");
+
+CONST_LIT(KLogNameEventIdx1, "Index1") ;
+CONST_LIT(KLogFlagString, "Flag");
+CONST_LIT(KIdEqStr, "Id=");
+CONST_LIT(KDuplicateEqStr, "Duplicate=");
+CONST_LIT(KLogOpenBracket, "(");
+CONST_LIT(KLogCloseBracket, ")");
+CONST_LIT(KLogAnd, " AND ");
+CONST_LIT(KLogOr, " OR ");
+CONST_LIT(KLogWhere, " WHERE ");
+CONST_LIT(KLogStringPredicate, "%S='%S'");
+CONST_LIT(KLogNumberPredicate, "%S=%d");
+CONST_LIT(KLogUNumberPredicate, "%S=%u");
+CONST_LIT(KLogFlagPredicate, "%S%d=%d");
+CONST_LIT(KLogNullPredicate, "%S IS NULL");
+CONST_LIT(KLogLikePredicate, "%S LIKE '*%S'");
+CONST_LIT(KLogDateBeforePredicate, "%S<=#%S#");
+CONST_LIT(KLogDateAfterPredicate, "%S>=#%S#");
+
+//
+CONST_LIT(KLogUnknownString, "Unknown") ;
+
+CONST_LIT(KLogServ, "LogServ");
+
+#ifdef SYSLIBS_TEST
+//Complex recent list with a lot of fields. These are the fields values.
+CONST_LIT(KLogRctTListRemoteParty, "TestRemParty");
+CONST_LIT(KLogRctTListDirection, "TestDir");
+CONST_LIT(KLogRctTListStatus, "TestStatus");
+CONST_LIT(KLogRctTListNumber, "11111999");
+const TInt KLogRctTListDurationType = 123;
+const TUint KLogRctTListFlags = 0x9;
+#ifdef SYMBIAN_ENABLE_EVENTLOGGER_DUALSIM	
+const TUint KLogRctTListSimId = 891711;
+#endif
+const TInt KLogRctTListId = 97;
+#endif//SYSLIBS_TEST
+
+#endif
MCL/sf/os/persistentdata