--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/landmarks/locationlandmarks/server/inc/epos_poslmserverutility.h	Tue Feb 02 01:06:48 2010 +0200
@@ -0,0 +1,89 @@
+/*
+* Copyright (c) 2007 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:  Landmarks Server's utilities
+*
+*/
+
+
+#ifndef EPOS_POSLMSERVERUTILITIES_
+#define EPOS_POSLMSERVERUTILITIES_
+
+#include <e32base.h>
+#include <f32file.h>
+#include <d32dbms.h>
+
+class CPosLmLocalDbAccess;
+
+class PosLmServerUtility
+    {
+    public:
+    
+        enum TLmOperation
+            {
+            ECreateFieldsLmIdIndex,
+            /**< Create index in fields table on Lm ID field */
+            ECreateCategoriesLmIdIndex,
+            /**< Create index in categories table on Lm ID field */
+            };
+
+    public: // New functions
+        
+        /**
+        * Method to estimate disk size impact for creating
+        * foreign index in a table.
+        * @return Estimated number of bytes.
+        */
+        static TInt EstimatedDiskSizeOfIndex(
+            TLmOperation aOperation,
+            TInt aCountOfRecords );
+
+        /**
+        * Reads the data of a long text column.
+        *
+        * @param[in] aView Prepared view.
+        * @param[in] aCol The number of the column to read from.
+        * @return Data from the column.
+        */
+        static HBufC* ReadFromLongTextColumnLC(
+            RDbRowSet& aView,
+            TDbColNo aCol );
+
+        /** Returns number of rows in a table 
+         * @param aTableName Name of the table which rowcount is needed */
+        static TUint GetTableRowCountL( 
+            CPosLmLocalDbAccess& aDbAccess,
+            const TDesC& aTableName );
+
+        static TUint TotalLandmarkCountL( CPosLmLocalDbAccess& aDbAccess );
+
+        /** Checks whether given index exists on given table */
+        static TBool IndexExistsL(
+            const RDbNamedDatabase& aDatabase,
+            const TDesC& aTable,
+            const TDesC& aIndex );
+
+        /**
+        * Reads the data of a long text column.
+        *
+        * @param[in] aView Prepared view.
+        * @param[in] aCol The number of the column to read from.
+        * @return Data from the column.
+        */
+        //Duplicate Declaration
+        /*HBufC* ReadFromLongTextColumnLC(
+            RDbRowSet& aView,
+            TDbColNo aCol );*/
+    };
+
+#endif /*EPOS_POSLMSERVERUTILITIES_*/