/*

* Copyright (c) 2008 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:      SQL database maintenance class

*

*/

#ifndef C_CMSQLDBMAINTENANCE_H

#define C_CMSQLDBMAINTENANCE_H

#include <e32base.h>

// Forward declarations

class CCmSqlConnection;

/**

 *  CCmSqlDbMaintenance class

 *  Part of SQL wrapper. SQL wrapper is part of

 *  Content manager component.CCmSqlDbMaintenance creates needed

 *  database tables and initializes connenction to the database

 *

 *  @lib cmsqlwrapper.lib

 *

 *  @since S60 v3.1

 */

class CCmSqlDbMaintenance : public CBase

    {

public:

    /**

     * Two-phased constructor.

     */

    static CCmSqlDbMaintenance* NewL();

    /**

     * Two-phased constructor.

     */

    static CCmSqlDbMaintenance* NewLC();

    /**

     * Destructor.

     */

    virtual ~CCmSqlDbMaintenance();    

    /**

     * Initializes database connection

     *

     * @since S60 5.1

     * @param aConnection, reference to connection class

     * @return Error code

     */    

    TInt InitConnection( CCmSqlConnection& aConnection );

    /**

     * Closes database connection

     *

     * @since S60 5.1

     * @param aConnection, reference to connection class

     * @return None

     */        

    void CloseConnection( CCmSqlConnection& aConnection );

    /**

     * Creates db file

     *

     * @since S60 5.1

     * @param aConnection, reference to connection class

     * @return Error code

     */  

    TInt CreateDbFile( CCmSqlConnection& aConnection );    

    /**

     * Creates database tables

     *

     * @since S60 5.1

     * @param aConnection, reference to connection class

     * @return None

     */        

    void CreateDb( CCmSqlConnection& aConnection );

    /**

     * Creates database indexes

     *

     * @since S60 5.1

     * @param aConnection, reference to connection class

     * @return None

     */        

    void CreateIndexes( CCmSqlConnection& aConnection );

private:

    /**

     * Performs the first phase of two phase construction.

     */

    CCmSqlDbMaintenance();

    /**

     * Performs the second phase construction.

     */

    void ConstructL();

private: // data

    };

#endif //  C_CMSQLDBMAINTENANCE_H