/** @file
 * Copyright (c) 2009 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 : SQLite Connection class
 *
 */

#ifndef UPNPSECURITYDBCONNECTION_H
#define UPNPSECURITYDBCONNECTION_H

// INCLUDES
#include <e32base.h>
#include <sqldb.h>
#include <f32file.h> //TDriveNumber

class TInetAddr;

// CLASS DECLARATION

/**
 * 
 */
class CUpnpSecurityDbConnection : public CBase
    {
    
public:

    /* Constructors and destructor. */

    /**
     * Creates new CUpnpSecurityDbConnection class and initializes 
     * connection to SQLite.
     * @return  pointer to CUpnpSecurityDbConnection class
     */
    static CUpnpSecurityDbConnection* NewL();

    /**
     * Creates new CUpnpSecurityDbConnection class and initializes 
     * connection to SQLite and 
     * leaves the instance in the cleanup stack.
     * @return  pointer to CUpnpSecurityDbConnection class
     */
    static CUpnpSecurityDbConnection* NewLC();

    /**
     * Destructor.
     */
    virtual ~CUpnpSecurityDbConnection();

public:
    /**
     * Open database.
     */
    TInt OpenDb( const TDesC& aDb );

    /**
     * Close opened database
     */
    void CloseDb();

    /**
     * Creates db file.
     * @param aDb, Database filename and path
     * @return error code
     */
    TInt CreateDbFile( const TDesC& aDb );

    /**
     * Validates database existence and format.
     *
     * @return ETrue if db valid
     */
    TBool Validate();

    /**
     * Executes sql command.
     *
     * @param aCommand, command to be executed
     */
    void ExecuteL( const TDesC8& aCommand );

    /**
     * Create tables.
     */
    void CreateTablesL();

    /**
     * Add item (IP address) to DB.
     */
    void AddIpAddressL( const TInetAddr& aIpAddress );

    /**
     * Add item (file name) to DB.
     */
    void AddFilenameL( const TDesC& aFilename );

    /**
     * Delete item (IP address) from DB.
     */
    void DeleteIpAddressL( const TInetAddr& aIpAddress );

    /**
     * Delete item (file name) from DB.
     */
    void DeleteFilenameL( const TDesC& aFilename );

    /**
     * Delete all items (IP addresses) from DB.
     */
    void DeleteAllIpAddressesL();

    /**
     * Delete all items (file names) from DB.
     */
    void DeleteAllFilenamesL();

    /**
     * Retreive data from DB.
     */
    void GetAllIpAddressesL( RArray<TInetAddr>& aAddressArray );

    /**
     * Retreive data from DB.
     */
    void GetAllFilenamesL( RPointerArray<HBufC>& aFilenameArray );

    /**
     * Prepare database for use, create new if not exist.
     */
    void OpenDatabaseL();

private:

    /**
     * Constructor.
     */
    CUpnpSecurityDbConnection();

    /**
     * Second-phase constructor.
     */
    void ConstructL();
    
    /**
     * Leaves if there is not enough disk space 
     */
    void EnsureDiskSpaceL();

    /**
     * Returns drive where db files are stored
     */
    TDriveNumber DatabaseDrive();
    
    /**
     * Execute given db command
     * 
     * @param aCommand command do execute
     * @param aType type of statement
     */
    void ExecStatementL( const TDesC8& aCommand );

    /**
     * Execute given db command
     * 
     * @param aCommand command do execute
     * @param aTextToBind command text argument
     */
    void ExecStatementL( const TDesC8& aCommand, const TDesC& aTextToBind );
    
    /**
     * Execute given db command
     *
     * @param aCommand command do execute
     * @param aType command int argument 
     */
    void ExecStatementL( const TDesC8& aCommand, const TInt aIntToBind );
    
private:
    // data

    // iDatabase, interface to Sqlite database
    RSqlDatabase iDatabase;

    // database file name
    TFileName iDbFileName;

    //
    RFs iFs;
    
    };

#endif //  UPNPSECURITYDBCONNECTION
// End of File