--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/tzservices/tzloc/inc/TzLocalizationDbAccessor.h Tue Feb 02 10:12:00 2010 +0200
@@ -0,0 +1,103 @@
+// Copyright (c) 2004-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 __TZLOCALIZATION_DB_ACCESSOR_H__
+#define __TZLOCALIZATION_DB_ACCESSOR_H__
+
+#include <e32base.h>
+#include <d32dbms.h>
+#include "TzLocalizationDataTypes.h"
+#include <tz.h>
+
+_LIT(KTzMutexName, "TZ_GlobalMutex");
+
+/**
+Provides access to the time zone localization database
+through a RDbs session.
+The database is stored in the DBMS private directory
+@internalTechnology
+*/
+class CTzLocalizationDbAccessor : public CBase
+ {
+ public:
+ //Enumerations used for column ordering in the database.
+ //The database columns MUST be created in the same order they appear in this enumeration
+ enum TTzCityColumn
+ {
+ // Enum will used as a DB column index, so it must start at 1
+ ETzCityId =1,
+ ETzCityCity,
+ ETzCityGroup,
+ ETzCityResourceId,
+ };
+
+ enum TTzZoneColumn
+ {
+ // Enum will used as a DB column index, so it must start at 1
+ ETzZoneId =1,
+ ETzZoneStdName,
+ ETzZoneDSTName,
+ ETzZoneShortStdName,
+ ETzZoneShortDSTName,
+ ETzZoneCity,
+ ETzZoneGroupId,
+ ETzZoneResourceId,
+ ETzZoneCityIndex,
+ };
+
+ // enum that specifies the maximum length of the strings corresponding
+ // to time zone IDs and group IDs
+ enum TTzStringLength
+ {
+ // Group ID is an unsigned 8-bit integer
+ EMaxGroupIdStringLength = 3,
+ // Time Zone ID is an unsigned 16-bit integer
+ EMaxTimeZoneIdStringLength = 5
+ };
+
+ public:
+ //Construction / Destruction
+ static CTzLocalizationDbAccessor* NewL();
+ static CTzLocalizationDbAccessor* NewLC();
+ ~CTzLocalizationDbAccessor();
+
+ void PrepareCityViewL(const TDesC& aSqlQuery);
+ void PrepareZoneViewL();
+
+ TBool DbNeedsUpdatingL();
+ void RecreateDbL(RTz& aTzSession);
+
+ protected:
+ CTzLocalizationDbAccessor();
+ //Second phase construction
+ void ConstructL();
+ static void ReleaseMutex(TAny *target) ;
+
+ private:
+ TInt CreateFrequentlyUsedZoneTableL();
+ TInt CreateUserCityTableL();
+ void CloseDb();
+ void OpenDbL();
+
+ protected:
+ //Member data
+ RDbs iDbsSession; //DBMS server session
+ RDbNamedDatabase iLocalizedTimeZoneDb; //Database
+ RDbView iCityView; //Rowset
+ RDbView iZoneView; //Rowset
+ RMutex iZoneMutex ; // protecting iZoneView changes
+ };
+
+#endif //__TZLOCALIZATION_DB_ACCESSOR_H__