/*

* Copyright (c) 2002-2005 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

*

*

*/

#include "epos_landmarkdatabasestructure.h"

#include "epos_cposlmlocaldbaccess.h"

#include "epos_poslmserverutility.h"

const TInt KIdIndexStartSize = 1100;

const TInt KIdIndexGrowth = 9;

// ================= MEMBER FUNCTIONS =======================

// -----------------------------------------------------------------------------

// -----------------------------------------------------------------------------

//

TInt PosLmServerUtility::EstimatedDiskSizeOfIndex(

    TLmOperation aOperation,

    TInt aCountOfRecords )

    {

    ASSERT( aOperation == ECreateFieldsLmIdIndex || aOperation == ECreateCategoriesLmIdIndex );

    return KIdIndexStartSize + aCountOfRecords * KIdIndexGrowth;

    }

// -----------------------------------------------------------------------------

// -----------------------------------------------------------------------------

//

TBool PosLmServerUtility::IndexExistsL(

    const RDbNamedDatabase& aDatabase,

    const TDesC& aTable,

    const TDesC& aIndex )

    {

    TBool found( EFalse );

    CDbIndexNames* indexes = aDatabase.IndexNamesL( aTable );

    for ( TInt i = 0; i < indexes->Count(); ++i ) 

        {

        if ( (*indexes)[i].Compare( aIndex ) == 0 )

            {

            found = ETrue;

            break;

            }

        }

    delete indexes;

    return found;

    }

// -----------------------------------------------------------------------------

// -----------------------------------------------------------------------------

//

TUint PosLmServerUtility::GetTableRowCountL( 

    CPosLmLocalDbAccess& aDbAccess,

    const TDesC& aTableName )

    {

    RDbNamedDatabase db;

    aDbAccess.GetDatabase( db );

    RDbTable table;

    User::LeaveIfError( table.Open( db, aTableName, RDbRowSet::EReadOnly ) );

    CleanupClosePushL( table );

    TInt numRows = table.CountL();

    CleanupStack::PopAndDestroy( &table );

    if ( numRows < 0 )

        {

        User::Leave( KErrNotFound );

        }

    return numRows;

    }

// -----------------------------------------------------------------------------

// -----------------------------------------------------------------------------

//

TUint PosLmServerUtility::TotalLandmarkCountL( CPosLmLocalDbAccess& aDbAccess )

    {

    return PosLmServerUtility::GetTableRowCountL( aDbAccess, KPosLmLandmarkTable );

    }

// -----------------------------------------------------------------------------

// -----------------------------------------------------------------------------

//

HBufC* PosLmServerUtility::ReadFromLongTextColumnLC(

    RDbRowSet& aView,

    TDbColNo aCol )

    {

    TInt len = aView.ColLength( aCol );

    if ( len > 0 )

        {

        HBufC* text = HBufC::NewLC( len );

        TPtr ptr = text->Des();

        RDbColReadStream readStream;

        readStream.OpenL( aView, aCol );

        CleanupClosePushL( readStream );

        readStream.ReadL( ptr, len );

        CleanupStack::PopAndDestroy( &readStream );

        return text;

        }

    else

        {

        return KNullDesC().AllocLC();

        }

    }