diff -r 7f0462e8c3da -r 1e87eb3b400f activitymanager/activitydatabase/hsactivitydbserver/inc/hsactivitystorage_p.h
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/activitymanager/activitydatabase/hsactivitydbserver/inc/hsactivitystorage_p.h	Wed Mar 24 03:15:43 2010 +0200
@@ -0,0 +1,152 @@
+/*
+* 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