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