/*

* 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:

*

*/

#ifndef HSACTIVITYSTORAGEPRIVATE_H

#define HSACTIVITYSTORAGEPRIVATE_H

#include "hsactivitydbclientinterface.h"

#include <QSqlDatabase>

/**

 * Class implements HsActivityDbClientInterface and storage functionality using

 * database subsystem 

 */

class HsActivityStoragePrivate: public HsActivityDbClientInterface

{

public:

    /**

     * Constructor

     */

    HsActivityStoragePrivate();

    /**

     * Destructor

     */

    ~HsActivityStoragePrivate();

    /**

     * Interface implementation.

     * @see int HsActivityDbClientInterface::addActivity(const QVariantHash&)

     */

    int addActivity(const QVariantHash &);

    /**

     * Interface implementation.

     * @see int HsActivityDbClientInterface::updateActivity(const QVariantHash&)

     */

    int updateActivity(const QVariantHash &);

    /**

     * Interface implementation.

     * @see int HsActivityDbClientInterface::removeActivity(const QVariantHash &)

     */

    int removeActivity(const QVariantHash &activity);

   /**

    * Interface implementation.

    * @see int HsActivityDbClientInterface::removeApplicationActivities(const QVariantHash &)

    */

    int removeApplicationActivities(const QVariantHash &activity);

    /**

     * Interface implementation.

     * @see int HsActivityDbClientInterface::requestedActivityName( QString &, const QVariantHash &)

     */

    int requestedActivityName(QString& result, 

                              const QVariantHash &activity);

    /**

     * Interface implementation.

     * @see int HsActivityDbClientInterface::activities(QList<QVariantHash> &)

     */

    int activities(QList<QVariantHash> &);

    /**

     * Interface implementation.

     * @see int HsActivityDbClientInterface::applicationActivities(QList<QVariantHash> &, const QVariantHash &)

     */

    int applicationActivities(QList<QVariantHash> &, const QVariantHash &);

    /**

     * Interface implementation.

     * @see int HsActivityDbClientInterface::waitActivity(const QVariantHash &)

     */

    int waitActivity(const QVariantHash &activity);

    /**

     * Interface implementation.

     * @see int HsActivityDbClientInterface::launchActivity(const QVariantHash &)

     */

    int launchActivity(const QVariantHash &activity);

private:

    /**

     * Function check database structure

     * @return true if structure is valid, false otherwise

     */

    bool checkTables();

    /**

     * Function create database structure

     */

    void recreateTables();

    /**

     * Function return last SQL query error code

     * @param querty - executed sql query

     * @return SQL query error code  

     */

    int getSqlErrorCode(const QSqlQuery& query);

    /**

     * Function exeute SQL query

     * @param query - SQL 

     * @return true on succees, false otherwise

     */

    bool exec(QSqlQuery& query);

    /**

     * Function exeute SQL query

     * @param query - SQL query that has to be executed

     * @return true on succees, false otherwise

     */

    bool exec(const QString &query, const QVariantHash& params);

    /**

     * Funciton bind provided filtering rules with prepared SQL query

     * @param query - SQL query 

     * @param activity - filtering rules

     * @param additionalData - additional filetering rules

     */

    void bind( QSqlQuery& query, 

               const QVariantHash &activity, 

               const QVariantHash &additionalData = QVariantHash());

    /**

     * Funciton get records that match conditions

     * @param result - output destination 

     * @param query - SQL query sting

     * @param conditions - query conditions

     */

    int activities(QList<QVariantHash> &results, 

                   const QString &query,

                   const QVariantHash &conditions);

private:

    /**

     * Connectioin to SQL engine

     */

    QSqlDatabase mConn;

};

#endif //HSACTIVITYSTORAGEPRIVATE_H