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