--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/secureswitools/swisistools/source/interpretsislib/dbhelper.h	Thu Dec 17 08:51:10 2009 +0200
@@ -0,0 +1,108 @@
+/*
+* Copyright (c) 2008-2009 Nokia Corporation and/or its subsidiary(-ies).
+* All rights reserved.
+* This component and the accompanying materials are made available
+* under the terms of the License "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: 
+* DbHelper - Interfaces for accessing details from the database.
+*
+*/
+
+
+/**
+ @file 
+ @released
+ @internalTechnology
+*/
+
+#ifndef DBHELPER_H
+#define DBHELPER_H
+
+#pragma warning(disable: 4786)
+
+#include <string>
+#include <vector>
+#include "symbiantypes.h"
+
+class CDbProcessor;
+class SisRegistryObject;
+class SisRegistryToken;
+class SisRegistryPackage;
+class FileDescription;
+class CStatement;
+class SisRegistryDependency;
+class Version;
+class SisRegistryProperty;
+class TrustStatus;
+class ControllerInfo;
+
+class DbHelper
+	{
+	public:
+		DbHelper( const std::wstring& aDrivePath, bool aIsSystemDrive);
+		TBool IsInstalled(TInt32 aUid) const;
+		bool InternalizeIfExists(SisRegistryObject& aSisRegistryObject, const TUint32 aUid ) const;
+		
+		bool GetIsRemovable( TInt32 aComponentId ) const;
+		bool GetInRom( TInt32 aComponentId ) const;
+		std::wstring GetPackageName( TInt32 aComponentId ) const;
+		TUint32 GetUid( TInt32 aComponentId ) const;
+		TUint32 GetInstallType( TInt32 aComponentId ) const;
+		void RemoveEntry( TInt32 aComponentId ) const;
+		int GetSelectedDrive( TInt32 aComponentId );
+		std::vector<FileDescription*> GetFileDescriptions( TInt32 aComponentId ) const;
+		bool SidExists(const TUint32 aSid) const;
+		TUint32 GetUid(const TUint32 aSid) const;
+		std::wstring SidToFileName(TUint32 aSid) const;
+		TUint32 GetUid( const std::wstring& aSidFile ) const;
+
+		TInt32 GetComponentId(TInt32 aUid, const std::wstring aPackageName, const std::wstring aVendorName ) const;
+		TInt32 GetComponentId(TInt32 aUid, TInt32 aInstallType ) const;
+		TInt32 GetComponentId( TInt32 aUid ) const;
+		std::vector<TInt32> GetComponentIdList( TInt32 aUid ) const;
+		TInt GetIndex( TInt32 aComponentId) const;
+		TUint32 GetUidFromFileName( const std::wstring& aFileName ) const;
+		TInt GetIndex( TUint32 aPackageUid) const;
+
+	private:
+		TInt32 GetComponentPropertyIntValue( TInt32 aComponentId, std::wstring aComponentPropertyName, TInt32 aDefaultValue = DbHelper::Absent ) const;
+		TInt32 GetComponentPropertyIntFormattedValue(TInt32 aComponentId, std::wstring aComponentPropertyName, TInt32 aIntFormatter) const;
+		std::wstring GetComponentPropertyStrValue(TInt32 aComponentId, std::wstring aComponentPropertyName, TInt32 aIntFormatter) const;
+		std::wstring GetComponentPropertyStrValue(TInt32 aComponentId, std::wstring aComponentPropertyName) const;
+
+		void GetComponentDetails( TInt32 aComponentId, SisRegistryObject& aSisRegistryObject ) const;
+		void GetComponentLocalizables( TInt32 aComponentId, SisRegistryObject& aSisRegistryObject ) const;
+		void GetFileDescriptions( TInt32 aComponentId, SisRegistryObject& aSisRegistryObject ) const;
+		void GetFileDescriptionFromComponentProperties( int aComponentId, std::vector<FileDescription*>& aFileDescriptions) const;
+		void GetFileDescriptionFromFileProperties( int aComponentId, std::vector<FileDescription*>& aFileDescriptions) const;
+		void GetComponentProperties( TInt32 aComponentId, SisRegistryObject& aSisRegistryObject ) const;
+		std::vector<SisRegistryDependency*> GetDependencies( TInt32 aComponentId ) const;
+		std::vector<SisRegistryPackage*> DbHelper::GetEmbeddedPackages( TInt32 aComponentId ) const;
+		std::vector<SisRegistryProperty*> GetProperties( TInt32 aComponentId ) const;
+		TrustStatus GetTrustStatus( TInt32 aComponentId ) const;
+		std::vector<TInt> GetInstallChainIndices( TInt32 aComponentId ) const;
+		std::vector<TUint32> GetSids( TInt32 aComponentId ) const;
+		std::vector<ControllerInfo*> GetControllerInfo( TInt32 aComponentId ) const;
+
+	private:
+		// other helper methods
+		std::wstring FormatDbString(std::wstring aString, int aValue) const;
+		void AddFileDescription(CStatement* aStatement, FileDescription& aFileDescription, TInt aCount ) const;
+		Version FormatStringToVersion(std::wstring aVersionStr) const;
+
+	private:
+		CDbProcessor* iScrDbHandler;
+		
+	public:
+		const static int Absent;
+	};
+
+#endif // DBHELPER_H