--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/commsconfig/commsdatabaseshim/commdbshim/INC/COMMDB.H	Thu Dec 17 09:22:25 2009 +0200
@@ -0,0 +1,475 @@
+// 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:
+// Comms Database public interface
+// 
+//
+
+/**
+ @file
+ @deprecated since v9.1. Functionality is replaced with commsdat.
+*/
+
+#ifndef COMMDB_H
+#define	COMMDB_H
+
+#include <d32dbms.h>
+#include <metadatabase.h>
+
+using namespace CommsDat;
+
+#include <dial.h>
+#include <cdbcols.h>
+#include <cdblen.h>
+
+/**
+Protection of settings: when the entire table is protected, write operations
+fail with KErrWrite. However KErrAccessDenied should be returned to client
+@internalComponent
+*/
+#define TRAPD_CONVERT(_r,_s)	TRAPD(_r,_s); if(ret == KErrWrite) ret = KErrAccessDenied;
+/**
+@internalComponent
+*/
+#define  TRAP_CONVERT(_r,_s)	TRAP(_r,_s);  if(ret == KErrWrite) ret = KErrAccessDenied;
+
+class CCommsDbTableView;
+class CCommsDbConnectionPrefTableView;
+class CCommDbTableExtension;
+class CCommsDatabaseImpl;
+
+class CCommsDatabaseBase : public CBase
+/** Base class for CCommsDatabase.
+
+This class is never instantiated, but its member functions are used through
+the derived class.
+
+Responsible for Transactions, Notifications, Write protection, Hidden
+records, Phone number resolution and Creating views. Stores the database, the
+session, transaction and notifier information.
+
+CCommsDatabaseBase is an abstract base class as the CreateDatabaseL() and
+Open() methods are pure virtual.
+@publishedAll
+@released */
+	{
+public:
+    // These classes added as friends for commdb shim
+	friend class CCommsDbTableView;
+	friend class CCommsDbConnectionPrefTableView;
+	friend class CCommsDbProtectTableView;
+	friend class CCommsDbProtectConnectPrefTableView;
+    friend class CCommsDbTemplateRecord;
+public:
+	IMPORT_C virtual ~CCommsDatabaseBase();
+
+	// Returns the version of the database server.
+	IMPORT_C TVersion Version() const;
+	// Begin a transaction. Call before `InsertRecord()` or `UpdateRecord()`.
+	IMPORT_C TInt BeginTransaction();
+	// End a transaction. Call after `InsertRecord()` or `UpdateRecord()`.
+	IMPORT_C TInt CommitTransaction();
+	// Cancel a transaction.
+	IMPORT_C void RollbackTransaction();
+	// True if BeginTransaction() has been called but not
+	//	`CommitTransaction()` or `RollbackTransaction()`.
+	IMPORT_C TBool InTransaction();
+	// True if the database has been locked.
+	IMPORT_C TBool IsDatabaseWriteLockedL();
+
+	// Enable a notification event on any change to the database.
+	IMPORT_C TInt RequestNotification(TRequestStatus& aStatus);
+	// Cancels notifications.
+	IMPORT_C void CancelRequestNotification();
+
+	// Obtain a view of all records in a table.
+	IMPORT_C CCommsDbTableView* OpenTableLC(const TDesC& aTableName);
+	// Obtain a view of the records in a table that match the query.
+	IMPORT_C CCommsDbTableView* OpenViewLC(const TDesC& aTableName, const TDesC& aSqlQuery);
+	// Obtain a view of all the records in a table for which the field
+	//	`aColumnToMatch` matches `aValueToMatch`.
+	IMPORT_C CCommsDbTableView* OpenViewMatchingUintLC(const TDesC& aTableName, const TDesC& aColumnToMatch, TUint32 aValueToMatch);
+	IMPORT_C CCommsDbTableView* OpenViewMatchingBoolLC(const TDesC& aTableName, const TDesC& aColumnToMatch, TBool aValueToMatch);
+	IMPORT_C CCommsDbTableView* OpenViewMatchingTextLC(const TDesC& aTableName, const TDesC& aColumnToMatch, const TDesC8& aValueToMatch);
+	IMPORT_C CCommsDbTableView* OpenViewMatchingTextLC(const TDesC& aTableName, const TDesC& aColumnToMatch, const TDesC16& aValueToMatch);
+
+	// Make hidden records visible
+	IMPORT_C void ShowHiddenRecords();
+
+	//  Set `aDialString` to be the appropriate string based on the directory
+	//	number, where the dial is being performed and the chargecard to use.
+	//	`ResolvePhoneNumberL()` opens a comms database to perform the
+	//	resolution
+	IMPORT_C static void ResolvePhoneNumberL(TDesC& aNumber, TDes& aDialString, TParseMode aDialParseMode, TUint32 aLocationId, TUint32 aChargecardId);
+	// Set `aDialString` to be the appropriate string based on the directory
+	//	number, where the dial is being performed and the chargecard to use.
+	IMPORT_C void ResolvePhoneNumberFromDatabaseL(TDesC& aNumber, TDes& aDialString, TParseMode aDialParseMode, TUint32 aLocationId, TUint32 aChargecardId);
+	IMPORT_C static TInt InitializeFilestore();
+
+	// Check access to database fields
+	IMPORT_C TInt CheckReadCapability( const TDesC& aField, const RMessagePtr2* aMessage );
+	IMPORT_C TInt CheckWriteCapability( const TDesC& aField, const RMessagePtr2* aMessage );
+
+protected:
+	// internal
+	// Please note that as of v9.0 TCommDbSystemAgentNotification now actually contains
+	// the notification information for the Publish and Subscribe notifications, not
+	// for System Agent notifications.
+	class TCommDbSystemAgentNotification
+	/**
+	@publishedAll
+	@deprecated
+	*/
+		{
+	public:
+		TCommDbSystemAgentNotification();
+		void Set(TUid aUid, TInt aVal);
+	public:
+		TUid iUid;
+		TInt iValue;
+		};
+
+	class TCommDbPublishSubscribeNotification
+	/**
+	@internalComponent
+	@released
+	*/
+		{
+	public:
+		TCommDbPublishSubscribeNotification();
+		void Set(TUid aUid, TInt aVal);
+	public:
+		TUid iUid;
+		TInt iValue;
+		};
+
+protected:
+	// internal
+	IMPORT_C CCommsDatabaseBase();
+	// internal
+	virtual void CreateDatabaseL() =0;
+	//
+	void DoClose();
+	CCommsDbTableView* DoOpenViewMatchingUintL(const TDesC& aTableName, const TDesC& aColumnToMatch, TUint32 aValueToMatch, TBool aIncludeHiddenRecords);
+	CCommsDbTableView* DoOpenViewMatchingTextL(const TDesC& aTableName, const TDesC& aColumnToMatch, const TDesC8& aValueToMatch, TBool aIncludeHiddenRecords);
+	CCommsDbTableView* DoOpenViewMatchingTextL(const TDesC& aTableName, const TDesC& aColumnToMatch, const TDesC16& aValueToMatch, TBool aIncludeHiddenRecords);
+	CCommsDbTableView* DoOpenTableViewL(const TDesC& aTableName, const TDesC& aSqlQuery);
+	CCommsDbTableView* DoOpenIAPTableViewL(const TDesC& aTableName,const TDesC& aSqlQuery);
+	//
+	void PopulateDialLocationL(TUint32 aId, TDialLocation& aLocation);
+	void PopulateChargeCardL(TUint32 aId, TChargeCard& aChargeCard);
+	void BeginInternalTransactionL();
+	TInt CommitInternalTransaction();
+	void RollbackInternalTransaction();
+	void DatabaseUpdateHasOccurred();
+	void NotifyChangeL(const TDesC& aSetting, TUint32 aVal);
+	TInt NotifyAllChanges();
+
+	TUint32 GetNewNumber(TUid aUid);
+	TInt CheckDBCapability( RDbs::TPolicyType aType, const TDesC& aField, const RMessagePtr2* aMessage );
+	void ConvertToUid(const TDesC& aSetting, TUint32 aVal, TCommDbPublishSubscribeNotification& aNotification);
+
+	inline RDbNamedDatabase* Database();
+protected:
+	//internal
+	CCommsDatabaseImpl* iImpl;
+	RDbNamedDatabase iDatabase;
+	RDbNotifier iNotifier;
+	// store container data for deletion after session is finished
+	//RPointerArray<CMDBElement> iTransactionCache;
+
+	TInt iNotifierOpenError;
+	TBool iShowHiddenRecords;
+	TBool iImplNotCreated;
+	TBool iInInternalTransaction;
+
+	RArray<TCommDbPublishSubscribeNotification> iNotifications;
+private:
+	// Check access to database fields
+	TInt DoCheckReadCapabilityL( const TDesC& aField, const RMessagePtr2* aMessage );
+	TInt DoCheckWriteCapabilityL( const TDesC& aField, const RMessagePtr2* aMessage );
+
+	TBool ConvertTableName(const TDesC& aTableName, TDes& aResult);
+	};
+
+class CCommsDatabase : public CCommsDatabaseBase
+/**
+Accesses the communications database through the DBMS.
+
+An object of this type must be constructed and opened by a client before any
+of the tables in the database can be accessed, e.g. to create views and access
+template records.
+
+Implements the pure virtual functions CreateDatabaseL() and DoOpen().
+Responsible for Global settings and Connection Preferences. Has utility
+functions for accessing Global and Agent tables. No additional state (to
+CCommsDatabaseBase) is stored.
+@publishedAll
+@released */
+	{
+public:
+	IMPORT_C static CCommsDatabase* NewL();
+	IMPORT_C static CCommsDatabase* NewL(TBool aUseDefaultDb);
+	IMPORT_C static CCommsDatabase* NewL(TCommDbOpeningMethod &aOpeningMethod);
+	IMPORT_C virtual ~CCommsDatabase();
+	IMPORT_C void GetGlobalSettingL(const TDesC& aSetting, TUint32& aValue);
+	IMPORT_C void GetGlobalSettingL(const TDesC& aSetting, TDes& aValue);
+	IMPORT_C void SetGlobalSettingL(const TDesC& aSetting, TUint32 aValue);
+	IMPORT_C void SetGlobalSettingL(const TDesC& aSetting, const TDesC& aValue);
+	IMPORT_C void ClearGlobalSettingL(const TDesC& aSetting);
+	IMPORT_C void GetDefaultTsyL(TDes& aValue);
+
+	// Deprecated. Past use: Gets settings (Modem, Chargecard, and Service) for the dial out IAP.
+	IMPORT_C void GetCurrentDialOutSettingL(const TDesC& aSetting, TUint32& aValue);
+	// Deprecated. Past use: Retrieve settings for the dial in IAP.
+	IMPORT_C void GetCurrentDialInSettingL(const TDesC& aSetting, TUint32& aValue);
+	// Open a connection preference view.
+	IMPORT_C CCommsDbConnectionPrefTableView* OpenConnectionPrefTableLC();
+	// Open a connection preference view containing connections of the
+	//	specified direction.
+	IMPORT_C CCommsDbConnectionPrefTableView* OpenConnectionPrefTableLC(TCommDbConnectionDirection aDirection);
+	// Open a connection preference view containing connections of the
+	// specified direction excluding connections of rank zero.
+	IMPORT_C CCommsDbConnectionPrefTableView* OpenConnectionPrefTableInRankOrderLC(TCommDbConnectionDirection aDirection);
+	// Open a connection preference view containing connections of the
+	//	specified direction and rank.
+	IMPORT_C CCommsDbConnectionPrefTableView* OpenConnectionPrefTableViewOnRankLC(TCommDbConnectionDirection aDirection, TUint32 aRank);
+
+	//DEPRECATED : Agent table has been removed. These functions have been
+	//				stubbed to return KErrNotSupported or leave with the same error.
+	// Access agent settings. `aService` is one of: (`DIAL_OUT_ISP`,
+	//	`DIAL_IN_ISP`, `OUTGOING_WCDMA'). */
+	IMPORT_C void SetAgentL(const TDesC& aService, const TDesC& aAgent);
+
+	IMPORT_C void SetAgentExtL(const TDesC& aService, const TDesC& aAgentExt);
+	IMPORT_C void GetAgentL(const TDesC& aService, TDes& aAgent);
+	IMPORT_C void GetAgentExtL(const TDesC& aService, TDes& aAgentExt);
+	IMPORT_C void ClearAgentAndExtL(const TDesC& aService);
+	IMPORT_C void SetAgentClientTimeoutL(const TDesC& aService, TInt aClientTimeout);
+	IMPORT_C void SetAgentRouteTimeoutL(const TDesC& aService, TInt aRouteTimeout);
+	IMPORT_C TInt GetAgentClientTimeoutL(const TDesC& aService);
+	IMPORT_C TInt GetAgentRouteTimeoutL(const TDesC& aService);
+
+	/** Open a view on the IAP table containing records that match the
+		bearers and direction specified. `aBearerSet` is a bit mask of type
+		`TCommDbBearer`. */
+	IMPORT_C CCommsDbTableView* OpenIAPTableViewMatchingBearerSetLC(TUint32 aBearerSet, TCommDbConnectionDirection aDirection);
+
+	/** Open a viewon the IAP table containing records which match the specified network */
+	IMPORT_C CCommsDbTableView* OpenIAPTableViewMatchingNetworkLC(TUint32 aNetwork);
+
+	// Open a view on the proxy table containing records that match the
+	//	service id and type specified.
+	IMPORT_C CCommsDbTableView* OpenViewOnProxyRecordLC(TUint32 aServiceId, const TDesC& aServiceType);
+
+	// Functionality re-implemented to facilitate BC with 6.1
+	IMPORT_C static CCommsDatabase* NewL(TCommDbDatabaseType aDbType);
+	// Creates a `CCommsDatabase` as with `NewL()`. The method of opening:
+	//	(Created, CopiedDefault or Opened) is returned in `aOpeningMethod`.
+	IMPORT_C static CCommsDatabase* NewL(TCommDbDatabaseType aDbType, TCommDbOpeningMethod &aOpeningMethod);
+
+private:
+	enum TGlobalSettingType
+		{
+		ENotASetting,
+		EGlobalSetting,
+		ECompatibilitySetting
+		};
+protected:
+	CCommsDatabase();
+	void DoOpenL(TCommDbOpeningMethod& aOpeningMethod,TBool aUseDefaultDb);
+private:
+	/** CCommsDatabaseBase pure virtuals */
+
+	virtual void CreateDatabaseL();
+	CCommsDbTableView* OpenGlobalSettingsTableLC(const TDesC& aSetting, TBool& aExists);
+	TGlobalSettingType GlobalSettingTypeL(const TDesC& aSetting) const;
+
+	};
+
+class CCommsDbTemplateRecord;
+
+class CCommsDbTableView : public CBase
+/**
+
+The view on a specific table in the database.
+
+Includes the necessary behaviour for navigating through the records in
+the view and reading and writing to columns within a record.
+
+Uses a CCommsDatabase and has an RDbView to read from and write to database. Created via
+CCommsDatabase::OpenTableLC() (which opens a view of all the records in the table) or one
+of the OpenViewLC...() functions (which open a specific view of the table):
+
+CCommsDatabase::OpenTableLC()
+
+CCommsDatabase::OpenViewMatchingUintLC()
+
+CCommsDatabase::OpenViewMatchingBoolLC()
+
+CCommsDatabase::OpenViewMatchingTextLC()
+
+CCommsDatabase::OpenViewLC()
+
+Note that the above five functions have been withdrawn in CCommsDatabase and
+are now implemented in CCommsDatabaseBase.
+@publishedAll
+@released */
+	{
+public:
+	friend class CCommsDatabaseBase;
+	friend class CCommsDbTemplateRecord;
+public:
+	// Low level view creation. Use if `CCommsDatabase::OpenTableLC()` or
+	//`CCommsDatabase::OpenViewLC...()` are not sufficient.
+	static CCommsDbTableView* NewL(CCommsDatabaseBase& aDb, const TDesC& aTableName, const TDbQuery& aQuery, TBool aUseTemplate = ETrue);
+	static CCommsDbTableView* NewLC(const TDesC& aTableName, CCommsDatabaseBase& aDb);
+	// additional constructors, commdb shim specific
+	static CCommsDbTableView* NewLC(CCommsDatabaseBase& aDb, const TDesC& aTableName, TBool aUseTamplate = ETrue); 	// ETrue if template is instantiating
+	static CCommsDbTableView* NewL(CCommsDatabaseBase& aDb, const TDesC& aTableName, const TDesC& aColumnToMatch, const TDesC8& aValueToMatch);
+	static CCommsDbTableView* NewL(CCommsDatabaseBase& aDb, const TDesC& aTableName, const TDesC& aColumnToMatch, const TDesC16& aValueToMatch);
+	static CCommsDbTableView* NewL(CCommsDatabaseBase& aDb, const TDesC& aTableName, const TDesC& aColumnToMatch, TUint32 aValueToMatch);
+	static CCommsDbTableView* NewLC(CCommsDatabaseBase& aDb, const TDesC& aTableName, const TDesC& aColumnToMatch, TBool aValueToMatch);
+	// this two are for IAP table only so table name is not needed
+	static CCommsDbTableView* NewLC(CCommsDatabaseBase& aDb, TUint32 aBearerSet,	TCommDbConnectionDirection aDirection);
+	static CCommsDbTableView* NewLC(CCommsDatabaseBase& aDb, TUint32 aNetworkId);
+	//  this one is for Proxie table only
+	static CCommsDbTableView* NewLC(CCommsDatabaseBase& aDb, TUint32 aServiceId, const TDesC& aServiceType);
+
+	CCommsDbTableView(CCommsDatabaseBase& aDb, const TDesC& aTableName);
+
+	IMPORT_C virtual ~CCommsDbTableView();
+
+	// Add a new record to this table. The record number is returned.
+	//	`PutRecordChanges()` is called to complete the transaction
+	IMPORT_C TInt InsertRecord(TUint32& aId);
+	/** Add a new record to this table. Filling all empty fields with values copied
+		from record currently pointed at. The record number is returned.
+		`PutRecordChanges()` is called to complete the transaction */
+	IMPORT_C TInt InsertCopyRecord(TUint32& aId);
+	/** Modify the current record of this view. `PutRecordChanges()` is called
+		to complete the transaction */
+	IMPORT_C TInt UpdateRecord();
+	// Remove the current record from the table.
+	IMPORT_C TInt DeleteRecord();
+	// Store an inserted or updated record back to the database.
+	IMPORT_C TInt PutRecordChanges(TBool aHidden = EFalse, TBool aReadOnly = EFalse);
+	// Cancel pending changes since an insert or update.
+	IMPORT_C void CancelRecordChanges();
+	//
+	// Navigate throught the records in the view
+	//
+	IMPORT_C TInt GotoFirstRecord();
+	IMPORT_C TInt GotoNextRecord();
+	IMPORT_C TInt GotoPreviousRecord();
+	//
+	// Access data from the current record
+	//
+	IMPORT_C void ReadTextL(const TDesC& aColumn, TDes8& aValue);
+	IMPORT_C void ReadTextL(const TDesC& aColumn, TDes16& aValue);
+	IMPORT_C HBufC* ReadLongTextLC(const TDesC& aColumn);
+	IMPORT_C void ReadUintL(const TDesC& aColumn, TUint32& aValue);
+	IMPORT_C void ReadBoolL(const TDesC& aColumn, TBool& aValue);
+	// Determine the type and attributes of a column. The type is one of:
+	//	(EDbColBit, EDbColUint32, EDbColText8, EDbColText16, EDbColLongText16).
+	//	The attribute is a bit mask of: (ENotNull and EAutoIncrement).
+	IMPORT_C void ReadTypeAttribL(const TDesC& aColumn, TDbColType& aColType, TUint32& aAttrib);
+	// Null columns return 0, integers and bools 1, strings return their length in characters.
+	IMPORT_C void ReadColumnLengthL(const TDesC& aColumn, TInt& aLength);
+
+	//
+	// Modify an inserted or modified record. Must call `PutRecordChanges()`
+	//	to store the changes.
+	//
+	IMPORT_C void WriteTextL(const TDesC& aColumn, const TDesC8& aValue);
+	IMPORT_C void WriteTextL(const TDesC& aColumn, const TDesC16& aValue);
+	IMPORT_C void WriteLongTextL(const TDesC& aColumn, const TDesC& aValue);
+	IMPORT_C void WriteUintL(const TDesC& aColumn, const TUint32& aValue);
+	IMPORT_C void WriteBoolL(const TDesC& aColumn, const TBool& aValue);
+	IMPORT_C void SetNullL(const TDesC& aColumn);
+
+	IMPORT_C void ReadColumnMaxLengthL(const TDesC& aColumn, TInt& aLength);
+	inline CCommsDatabaseBase* Database() const { return &iDb; }
+
+	void  OpenL(const TDbQuery& aQuery);
+
+	inline void GetTableName(TDes& aTableName) const;
+protected:
+	TDbColNo ColNumL(const TDesC& aColumn) const;
+	void Close();
+	void ConstructL(const TDesC& aTableName, TBool aShowHidden, TBool aUseTemplate);
+	void ConstructL(const TDbQuery& aQuery, TBool aUseTemplate);
+	RDbRowSet::TAccess GetL();
+
+	// All other ConstructructL methods are added for commdb shimm
+	void ConstructL(const TDesC& aTableName, const TDesC& aColumnToMatch, const TDesC8& aValueToMatch);
+	void ConstructL(const TDesC& aTableName, const TDesC& aColumnToMatch, const TDesC16& aValueToMatch);
+	void ConstructL(const TDesC& aTableName, const TDesC& aColumnToMatch, TUint32 aValueToMatch);
+	void ConstructL(const TDesC& aTableName, const TDesC& aColumnToMatch, TBool aValueToMatch);
+	void ConstructL(TUint32 aBearerSet,	TCommDbConnectionDirection aDirection);
+	void ConstructL(TUint32 aNetworkId);
+	void ConstructL(TUint32 aServiceId, const TDesC& aServiceType);
+	// used for template creation only
+	void ConstructL(const TDesC& aTableName);
+	
+private:
+	enum TTableState {
+		EClosed,
+		EOpenIdle,
+		EInsert,
+		EUpdate
+		};
+private:
+	TBool TableWithTemplateRecord() const;
+	TInt InsertTemplateRecord();
+	TInt DoInsertRecord(TBool aType, TUint32& aId, TBool aIsTemplate);
+	TInt DoPutRecordChanges(TBool aHidden = EFalse, TBool aReadOnly = EFalse, TBool aIsTemplateCall = EFalse);
+
+private:
+	TTableState iState;
+	CCommsDbTemplateRecord* iTemplate;
+	TBool iTsyNameChanged;
+	TUint32 iInsertedRecordIndex;
+	TUint32 iCurrentId;
+
+protected:
+	CCommsDatabaseBase& iDb;
+	TBuf<KCommsDbSvrMaxColumnNameLength> iTableName;
+	RDbView iTableView;
+	CCommDbTableExtension* iTableExt;
+	};
+
+
+
+
+
+/**
+Convert a legacy field name to a CommsDat element Id
+
+@internalTechnology
+@param aFieldName A legacy commdb field name in the format "tableName\fieldName"
+@return A Commsdat element Id
+*/
+class CommDbShimUtil
+	{
+public:
+	IMPORT_C static TMDBElementId GetElementIdFromFieldNameL(const TDesC& aFieldName);
+	};
+
+// SYMBIAN_NON_SEAMLESS_NETWORK_BEARER_MOBILITY
+
+
+#include <commdb.inl>
+
+#endif
+// COMMDB_H