// 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();
		TBool IsTableCreatedL(const TDesC& aTableName) const;
        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__