/*

* 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_*/