/*

* 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:  Implementation for SQLite content store.

*

*/

#ifndef HSDATABASE_H

#define HSDATABASE_H

#include <QScopedPointer>

#include <QtSql>

#include "hsdomainmodel_global.h"

#include "hstest_global.h"

HOMESCREEN_TEST_CLASS(TestRuntimeServices)

HOMESCREEN_TEST_CLASS(HomeScreenStatePluginTest)

class HsSceneData;

class HsPageData;

class HsWidgetData;

class HsWidgetPresentationData;

class HSDOMAINMODEL_EXPORT HsDatabase : public QObject

{

    Q_OBJECT

public:

    static void setDatabaseName(const QString& dbName);

    static HsDatabase *instance();

    ~HsDatabase();

    bool transaction();

    bool rollback();

    bool commit();

    bool scene(HsSceneData &scene);

    bool updateScene(const HsSceneData &scene);

    bool pages(QList<HsPageData> &pages);

    bool page(int id, HsPageData &page, bool getChildren = true);

    bool insertPage(HsPageData &page);

    bool updatePage(const HsPageData &page, bool updateChildren = true);

    bool deletePage(int id);

    bool widget(int id, HsWidgetData &widget, bool getChildren = true);

    bool insertWidget(HsWidgetData &widget);

    bool insertWidget(const HsWidgetData &widget,int &databaseId);

    bool updateWidget(const HsWidgetData &widget, bool updateChildren = true);

    bool deleteWidget(int id);

    bool deleteWidgets(const QString &uri);

    bool widgetPresentation(int widgetId, const QString &key, HsWidgetPresentationData &presentation);

    bool insertWidgetPresentation(HsWidgetPresentationData &presentation);

    bool updateWidgetPresentation(const HsWidgetPresentationData &presentation);

    bool deleteWidgetPresentation(int id);

    bool setWidgetPreferenceForKey(int widgetId, const QString &key, const QString &value);

    bool widgetPreferenceForKey(int widgetId, const QString &key, QString &value);

    bool setWidgetPreferences(int widgetId, const QVariantMap &preferences);

    bool widgetPreferences(int widgetId, QVariantMap &preferences);

    bool widgetIds(const QString &uri, QList<int>& ids);

private:

    HsDatabase();

    bool openDatabase(const QString &databaseName);

    Q_DISABLE_COPY(HsDatabase)

    bool parsePage(const QSqlQuery &query, bool getChildren, HsPageData &page);

    bool parseWidget(const QSqlQuery &query, bool getChildren, HsWidgetData &widget);

    bool parseWidgetPresentation(const QSqlQuery &query, HsWidgetPresentationData &presentation);

    QVariant columnValue(const QSqlQuery &query, const QString &columnName) const;

    QSqlDatabase database() const;

private:

    static QScopedPointer<HsDatabase> mInstance;

    static QString  mDatabaseName;

    HOMESCREEN_TEST_FRIEND_CLASS(TestRuntimeServices)

    HOMESCREEN_TEST_FRIEND_CLASS(HomeScreenStatePluginTest)

};

#endif // HSDATABASE_H