/*
* 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: Provides static functions which handles database creation
*								and deletion.
*
*
*/


#ifndef POSLMDATABASEMANAGER_H
#define POSLMDATABASEMANAGER_H

#include <e32base.h>
#include <d32dbms.h>

/**
*  This class contains static functions which handles database creation
*  and deletion.
*/
class PosLmDatabaseManager
    {
    public:
        enum TLmDbChangeType
            {
            ELmDbAdded = 0,
            ELmDbRemoved
            };

    public: // New functions

        /**
        * Deletes a database.
        * @param[in] aDatabaseUri A database URI.
        */
        static void DeleteDatabaseL( const TDesC& aUri );

        /**
        * Creates a landmark database at the specified location.
        *
        * @param[in] aUri A database URI.
        * @param[in] aReplaceDatabase If ETrue, the database will be replaced
        *   if it exists. If EFalse, the database will be created.
        */
        static void CreateDatabaseL(
            const TDesC& aUri,
            TBool aDefaultDatabase = EFalse,
            TBool aReplaceDatabase = EFalse );

        /**
        * Copies a database.
        *
        * @param[in] aSourceUri URI for the source database that shall be copied.
        * @param[in] aTargetUri URI for the new database copy.
        */
        static void CopyDatabaseL(
            const TDesC& aSourceUri,
            const TDesC& aTargetUri );

        /** Creates table with info of server-maintained indexes */
        static void CreateIndexTableL( RDbNamedDatabase& aDb );
        
    private: // New functions

        /*
        * Creates the tables in the landmark database.
        * @param[in] aDb Opened database that will contain the created tables.
        */
        static void CreateTablesL( RDbNamedDatabase& aDb );

        /*
        * Creates the landmark table.
        * @param[in] aDb Opened database that will contain the created table.
        */
        static void CreateLandmarkTableL( RDbNamedDatabase& aDb );

        /*
        * Creates the landmark field table.
        * @param[in] aDb Opened database that will contain the created table.
        */
        static void CreateLandmarkFieldTableL( RDbNamedDatabase& aDb );

        /*
        * Creates the category table.
        * @param[in] aDb Opened database that will contain the created table.
        */
        static void CreateCategoryTableL( RDbNamedDatabase& aDb );

        /*
        * Creates the landmark-category table.
        * @param[in] aDb Opened database that will contain the created table.
        */
        static void CreateLmCategoryTableL( RDbNamedDatabase& aDb );

        /*
        * Creates the icon table.
        * @param[in] aDb Opened database that will contain the created table.
        */
        static void CreateIconTableL( RDbNamedDatabase& aDb );

        /*
        * Creates the settings table.
        * @param[in] aDb Opened database that will contain the created table.
        */
        static void CreateSettingsTableL( RDbNamedDatabase& aDb );

        /*
        * Creates the indexes in the landmark database.
        * @param[in] aDb Opened database that will contain the created indexes.
        */
        static void CreateIndexesL( RDbNamedDatabase& aDb );

        /*
        * Creates an index in the landmark database.
        *
        * @param[in] aDb Opened database that will contain the created indexes.
        * @param[in] aIndex An index name.
        * @param[in] aTable An table name.
        * @param[in] aColumn An column name.
        * @param[in] aUnique Tells whether this index should be unique or not.
        */
        static void CreateIndexL(
            RDbNamedDatabase& aDb,
            const TDesC& aIndex,
            const TDesC& aTable,
            const TDesC& aColumn,
            TBool aUnique );

        /*
        * Sets a counter to one and not zero for the specified table in the
        * specified database.
        *
        * @param[in] aDb Opened database to change.
        * @param[in] aTable The table to modify.
        */
        static void SetCounterToOneL(
            RDbNamedDatabase& aDb,
            const TDesC& aTable );

    };

#endif      // POSLMDATABASEMANAGER_H

// End of File