--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/commsconfig/commsdatabaseshim/commdbshim/INC/CDBSTD.H	Thu Dec 17 09:22:25 2009 +0200
@@ -0,0 +1,374 @@
+// Copyright (c) 2006-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:
+//
+
+/**
+ @file
+ @internalComponent
+ @deprecated since v9.1. Functionality is replaced with commsdat.
+*/
+
+#ifndef CDBSTD_H
+#define CDBSTD_H
+
+#include <commdb.h>
+
+/**
+Database location macros
+@internalComponent
+*/
+
+#define KMaxFileNameSize					220
+_LIT(KDbBaseName, "Cdbv3.dat");
+_LIT(KCDrive, "c:");
+
+
+
+
+
+
+	/** 
+	@internalComponent
+	*/  
+	_LIT(KTempDbName, "Cdbv3.temp");
+	/** 
+	@internalComponent
+	*/  
+	const TUid KCommsDbPolicyUid = {0x10004e1d}; 
+	/** 
+	@internalComponent
+	*/  
+	_LIT(KDbName, "Cdbv3.dat"); 
+	/** 
+	@internalComponent
+	*/  
+	_LIT(KTempDbNameDbsFormat, "C:Cdbv3.temp"); 
+	/** 
+	@internalComponent
+	*/  
+	_LIT(KDbDefaultFileNameDbsFormat, "Z:DefaultCdbv3.dat");
+
+	_LIT(KDbPolicyUIDString, "secure[10004e1d]");
+	_LIT(KDb, "C:\\private\\100012a5\\DBS_10004e1d_Cdbv3.dat");
+	_LIT(KDefaultDb, "Z:\\private\\100012a5\\DBS_10004e1d_DefaultCdbv3.dat");
+	_LIT(KDbFileName, "C:Cdbv3.dat");
+
+
+#if defined(_UNICODE)
+#define _I(x) L ## x
+#else
+#define _I(x) x
+#endif
+
+/**
+The _I() strings are passed as parameter s to the CDB_LIT macro
+@internalComponent
+*/
+#define CDB_LIT(name,s) const TLitC<sizeof(s)/2> name={sizeof(s)/2-1,s}
+
+/**
+Server name
+@internalComponent
+*/
+#define _SERVER_NAME				_I("CommsDbServer")
+
+/**
+Misc table names that don't need to be public
+@internalComponent
+*/
+#define _GLOBAL_SETTINGS			_I("GlobalSettings")
+#define _CONNECTION_PREFERENCES		_I("ConnectionPreferences")
+#define _ACCESS_TABLE				_I("AccessTypeTable")
+
+
+/**
+Columns for Access Type table
+@internalComponent
+*/
+#define ACCESS_TYPE_TABLE		_S("AccessTypeTable")
+#define TABLE_ACC_NAME			_S("TableName")
+#define TABLE_ACC_TYPE			_S("AccessType")
+
+
+/**
+DEPRECATED : Agent Table has been removed
+@internalComponent
+*/
+
+//#define _AGENT						_I("Agent")
+
+/**
+Specifies whether a record is hidden from the client.
+Field type: TBool.
+*/
+#define _COMMDB_HIDDEN				_I("Hidden")
+
+/**
+Specifies whether a record is read-only.
+Field type: TBool.
+*/
+#define _COMMDB_READ_ONLY			_I("ReadOnly")	
+#define _COMMDB_INT_VALUE			_I("IntValue")	//< integer value for global settings
+#define _COMMDB_TEXT_VALUE			_I("TextValue")	//< text value for global settings
+
+//
+// Columns for Connection Preferences table
+//
+/** Ranking of this connection preference.
+This information is used to specify the order in which attempts at a connection should be
+carried out. The highest ranking is 1 and is always attempted. If this fails, a preference
+with rank 2 is then attempted, and so on. Ranking of 0 indicates that a connection
+preference is only being stored and is not used for connections.
+
+For incoming connections, CommDb limits the ranking to 0 or 1. For outgoing connection
+preferences, the maximum ranking is the value in CONNECTION_ATTEMPTS field in the Global
+table.
+
+Multiple records with the same ranking (except for 0) and the same direction are not allowed.
+
+Field type: TUint32. This field may not be left as NULL.
+@internalComponent
+*/
+#define _CONNECT_PREF_RANKING		_I("Ranking")
+
+/**
+The direction of the connection. The directions are defined by the enum 
+TCommDbConnectionDirection.
+Field type: TUint32. This field may not be left as NULL.
+*/
+#define _CONNECT_PREF_DIRECTION		_I("Direction")
+/**
+The bearers that can be used for this connection. 
+
+The bearers are defined by the enum TCommDbBearer. Values can be OR'ed together to indicate 
+that either of the bearers could be used.
+Field type: TUint32. This field may not be left as NULL.
+*/
+#define _CONNECT_PREF_BEARER_SET	_I("BearerSet")
+
+/**
+Determines whether or not the user should be prompted or warned with a dialog 
+that a connection is going to be made.
+
+The options are defined by the enum TCommDbDialogPref.
+
+Field type: TUint32. This field may not be left as NULL.
+
+@see TCommDbDialogPref.
+*/
+#define _CONNECT_PREF_DIALOG_PREF	_I("DialogPref")
+
+/**
+Identifier of a preferred IAP for this connection, if this is an IAP type database.
+
+For ISP type databases, see the subsequent fields..
+
+Field type: TUint32. This field may be left as NULL.
+*/
+#define _CONNECT_PREF_IAP			_I("IAP")
+
+
+/**
+Columns for Agent table
+@internalComponent
+*/
+
+//#define _AGENT_SERVICE_TYPE			_I("AgentServiceType")
+//#define _AGENT_NAME					_I("AgentName")
+//#define _AGENT_EXT_NAME				_I("AgentExtName")
+//#define _AGENT_LAST_SOCKET_ACTIVITY_TIMEOUT	_I("AgentLastSocketActivityTimeout")
+//#define _AGENT_LAST_SESSION_CLOSED_TIMEOUT	_I("AgentLastSessionClosedTimeout")
+//#define _AGENT_LAST_SOCKET_CLOSED_TIMEOUT	_I("AgentLastSocketClosedTimeout")
+
+
+/**
+SQL query strings
+@internalComponent
+*/
+#define _SQL_START_SQL_QUERY		_I("select * from ")
+#define _SQL_WHERE_KEYWORD			_I("where")
+#define _SQL_AND_KEYWORD			_I(" and")
+#define _SQL_ORDER_KEYWORD			_I("order")
+#define _SQL_ORDER_BY_KEYWORD		_I(" order by ")
+#define _SQL_WHERE_HIDDEN			_I(" where Hidden=0")
+#define _SQL_AND_HIDDEN				_I(" and Hidden=0")
+#define _SQL_INT_MATCH				_I("%S=%d")
+#define _SQL_WHERE_INT_MATCH		_I(" where %S=%d")
+#define _SQL_WHERE_TEXT_MATCH		_I(" where %S='%S'")
+#define _SQL_AND_INT_MATCH			_I(" and %S=%d")
+#define _SQL_AND_TEXT_MATCH			_I(" and %S='%S'")
+#define _SQL_OR_TEXT_MATCH			_I(" or %S='%S'")
+#define _SQL_WHERE_INT_GREATERTHAN	_I(" where %S>%d")
+
+/**
+SQL query lengths
+@internalComponent
+*/
+const TInt KTwiceMaxFieldLength=(2*KCommsDbSvrRealMaxFieldLength);
+const TInt KBasicSqlQueryLength=KCommsDbSvrMaxColumnNameLength+29;		// 29 is length of "select * from  where Hidden=0"
+const TInt KSqlQueryWithMatch=KBasicSqlQueryLength+KCommsDbSvrMaxColumnNameLength+KTwiceMaxFieldLength+8;  // 8 is length of "='' and "
+const TInt KSqlQueryWithDoubleMatch=KSqlQueryWithMatch+KTwiceMaxFieldLength+8;  // 8 is length of "='' and "
+const TInt KSqlQueryWithDoubleMatchAndOrderBy=KSqlQueryWithDoubleMatch+KCommsDbSvrMaxColumnNameLength+10;	//10 is the length of " order by "
+const TInt KSqlQueryExtraWhereTextMatchesColumn=KTwiceMaxFieldLength+10; // 10 is length of " where %S='%S'"
+
+/**
+These names are maintained for compatibility they are deprecated
+and should be replaced in code by CDB_LIT declarations
+@internalComponent
+*/
+#define SERVER_NAME					(const TText*)_SERVER_NAME
+#define GLOBAL_SETTINGS				(const TText*)_GLOBAL_SETTINGS
+#define CONNECTION_PREFERENCES		(const TText*)_CONNECTION_PREFERENCES
+//#define AGENT						(const TText*)_AGENT
+/** 
+Specifies whether a record is hidden.
+Field type: TBool
+*/
+#define COMMDB_HIDDEN				(const TText*)_COMMDB_HIDDEN
+
+/** 
+Specifies whether a record is read only.
+Field type: TBool
+*/
+#define COMMDB_READ_ONLY			(const TText*)_COMMDB_READ_ONLY
+
+#define COMMDB_INT_VALUE			(const TText*)_COMMDB_INT_VALUE
+#define COMMDB_TEXT_VALUE			(const TText*)_COMMDB_TEXT_VALUE
+
+/**
+Ranking of this connection preference.
+
+This information is used to specify the order in which attempts at a connection 
+should be carried out. The highest ranking is 1 and is always attempted. If 
+this fails, a preference with rank 2 is then attempted, and so on. A ranking 
+of 0 indicates that a connection preference is only being stored and is not 
+used for connections.
+
+For incoming connections, CommDb limits the ranking to 0 or 1. For outgoing 
+connection preferences, the maximum ranking is the value in CONNECTION_ATTEMPTS 
+field in the Global table.
+
+Multiple records with the same ranking (except for 0) and the same direction 
+are not allowed.
+
+Type: TUint32. Null: no
+
+@see CONNECTION_ATTEMPTS 
+*/
+#define CONNECT_PREF_RANKING		(const TText*)_CONNECT_PREF_RANKING
+
+/** 
+The direction of the connection. The directions are defined by the enum 
+TCommDbConnectionDirection.
+
+Type: TUint32. Null: no 
+		
+@see TCommDbConnectionDirection
+*/
+#define CONNECT_PREF_DIRECTION		(const TText*)_CONNECT_PREF_DIRECTION
+
+/** 
+The bearers that can be used for this connection.
+
+The bearers are defined by the enum TCommDbBearer. Values can be ORed together 
+to indicate that either of the bearers could be used.
+
+Type: TUint32. Null: no
+
+@see TCommDbBearer 
+*/
+#define CONNECT_PREF_BEARER_SET		(const TText*)_CONNECT_PREF_BEARER_SET
+
+/** 
+Determines whether or not the user should be should be prompted or warned with 
+a dialog that a connection is going to be made. 
+
+The options are defined by the enum TCommDbDialogPref.
+
+Type: TUint32. Null: no
+
+@see TCommDbDialogPref 
+*/
+#define CONNECT_PREF_DIALOG_PREF	(const TText*)_CONNECT_PREF_DIALOG_PREF
+
+/** 
+Identifier of the preferred IAP for this connection, if this is an IAP type database.
+
+For ISP type databases, see the subsequent fields.
+
+Type: TUint32. Null: yes 
+*/
+#define CONNECT_PREF_IAP			(const TText*)_CONNECT_PREF_IAP
+
+//#define AGENT_SERVICE_TYPE			(const TText*)_AGENT_SERVICE_TYPE
+//#define AGENT_NAME					(const TText*)_AGENT_NAME
+//#define AGENT_EXT_NAME				(const TText*)_AGENT_EXT_NAME
+//#define AGENT_LAST_SOCKET_ACTIVITY_TIMEOUT	(const TText*)_AGENT_LAST_SOCKET_ACTIVITY_TIMEOUT
+//#define AGENT_LAST_SESSION_CLOSED_TIMEOUT	(const TText*)_AGENT_LAST_SESSION_CLOSED_TIMEOUT
+//#define AGENT_LAST_SOCKET_CLOSED_TIMEOUT	(const TText*)_AGENT_LAST_SOCKET_CLOSED_TIMEOUT
+#define SQL_START_SQL_QUERY			(const TText*)_SQL_START_SQL_QUERY
+#define SQL_WHERE_KEYWORD			(const TText*)_SQL_WHERE_KEYWORD
+#define SQL_AND_KEYWORD				(const TText*)_SQL_AND_KEYWORD
+#define SQL_ORDER_KEYWORD			(const TText*)_SQL_ORDER_KEYWORD
+#define SQL_WHERE_HIDDEN			(const TText*)_SQL_WHERE_HIDDEN
+#define SQL_AND_HIDDEN				(const TText*)_SQL_AND_HIDDEN
+#define SQL_INT_MATCH				(const TText*)_SQL_INT_MATCH
+#define SQL_WHERE_INT_MATCH			(const TText*)_SQL_WHERE_INT_MATCH
+#define SQL_WHERE_TEXT_MATCH		(const TText*)_SQL_WHERE_TEXT_MATCH
+#define SQL_AND_INT_MATCH			(const TText*)_SQL_AND_INT_MATCH
+#define SQL_AND_TEXT_MATCH			(const TText*)_SQL_AND_TEXT_MATCH
+#define SQL_OR_TEXT_MATCH			(const TText*)_SQL_OR_TEXT_MATCH
+#define SQL_WHERE_INT_GREATERTHAN	(const TText*)_SQL_WHERE_INT_GREATERTHAN
+
+/**
+
+Reasons for server Panic.
+@internalComponent */
+enum TCommsDbSvrPanic
+	{
+	ECommsDbIncorrectNumberOfDbTables,
+	ECommsDbInsertNotOpenIdle,
+	ECommsDbUpdateNotOpenIdle,
+	ECommsDbDeleteNotOpenIdle,
+	ECommsDbSvrPanicCommitNotInsertUpdate,
+	ECommsDbCancelNotInsertUpdate,
+	ECommsDbGotoFirstNotOpenIdle,
+	ECommsDbGotoNextNotOpenIdle,
+	ECommsDbGotoPreviousNotOpenIdle,
+	ECommsDbDeprecated9,
+	ECommsDbReadNotOpenIdle,
+	ECommsDbDeprecated11,
+	ECommsDbWriteNotInsertUpdate,
+	ECommsDbWritingIdColumn,
+	ECommsDbOverrideValueLengthTooShort,
+	ECommsDbColDoesNotExist,
+	ECommsDbDirectionUnknown,
+	ECommsDbDeprecated17,
+	ECommsDbDeprecated18,
+	ECommsDbMissingDefaultDatabase,
+	ECommsDBOpenNonNullColSet,
+	ECommsDbNoAccessTableView
+	,
+	ECommsDbPublishAndSubscribeError,
+     /** Unable to perform the copy of the default commdb, or restore commdb
+     operation.
+     */
+     ECommdbRestoreFailed
+	};
+
+/** Panics the calling thread. 
+@internalComponent */
+GLREF_C void CommsDbPanic(TCommsDbSvrPanic aPanic);
+
+#endif