/*
* 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_CMDMSQLDBMAINTENANCE_H
#define C_CMDMSQLDBMAINTENANCE_H

#include <e32base.h>

/** Literals */
_LIT( KCmDatabase, "c:\\System\\Data\\MediaServant\\cm_database.sq");
_LIT( KCmDbDir, "c:\\System\\Data\\MediaServant\\");

/* Forward declarations. */
class CCmDmSQLiteConnection;

/**
 *  CCmDmSqlDbMaintenance class
 *  Part of Database manager. Database manager is part of
 *  Content manager component.CCMDMSqlDbMaintenance creates needed
 *  database tables and initializes connenction to the database
 *
 *  @lib cmdatabasemanager.lib
 *
 *  @since S60 5.1
 */
class CCmDmSqlDbMaintenance : public CBase
    {

public:

    /**
     * Two-phased constructor.
     */
    IMPORT_C static CCmDmSqlDbMaintenance* NewL();
    
    /**
     * Two-phased constructor.
     */
    IMPORT_C static CCmDmSqlDbMaintenance* NewLC();

    /**
     * Destructor.
     */
    virtual ~CCmDmSqlDbMaintenance();    
    
    /**
     * Initializes database connection
     *
     * @since S60 5.1
     * @param None
     * @return TInt, Error code
     */    
    TInt InitConnection( CCmDmSQLiteConnection& aConnection );

    /**
     * Closes database connection
     *
     * @since S60 5.1
     * @param None
     * @return None
     */        
    void CloseConnection( CCmDmSQLiteConnection& aConnection );

    /**
     * Creates db file
     *
     * @since S60 5.1
     * @param aConnection, reference to connection class
     * @return TInt, Error code
     */  
    TInt CreateDbFile( CCmDmSQLiteConnection& aConnection );
        
    /**
     * Creates database tables
     *
     * @since S60 5.1
     * @param aConnection, sqlite connection
     * @return None
     */        
    void CreateDb( CCmDmSQLiteConnection& aConnection );

    /**
     * Creates database indexes
     *
     * @since S60 5.1
     * @param aConnection, sqlite connection
     * @return None
     */        
    void CreateIndexes( CCmDmSQLiteConnection& aConnection );

private:

    /**
     * Performs the first phase of two phase construction.
     */
    CCmDmSqlDbMaintenance();

    /**
     * Performs the second phase construction.
     */
    void ConstructL();

    };

#endif //  C_CMDMSQLDBMAINTENANCE_H