bookmarks/BookmarksManager.h
author hgs
Thu, 23 Sep 2010 15:31:07 -0400
changeset 12 d26902edeef5
parent 9 1d51612454b5
child 15 5ea3798f1248
permissions -rw-r--r--
201037_03
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
9
hgs
parents:
diff changeset
     1
/*
hgs
parents:
diff changeset
     2
* Copyright (c) 2009 Nokia Corporation and/or its subsidiary(-ies).
hgs
parents:
diff changeset
     3
* All rights reserved.
hgs
parents:
diff changeset
     4
*
hgs
parents:
diff changeset
     5
* This program is free software: you can redistribute it and/or modify
hgs
parents:
diff changeset
     6
* it under the terms of the GNU Lesser General Public License as published by
hgs
parents:
diff changeset
     7
* the Free Software Foundation, version 2.1 of the License.
hgs
parents:
diff changeset
     8
* 
hgs
parents:
diff changeset
     9
* This program is distributed in the hope that it will be useful,
hgs
parents:
diff changeset
    10
* but WITHOUT ANY WARRANTY; without even the implied warranty of
hgs
parents:
diff changeset
    11
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
hgs
parents:
diff changeset
    12
* GNU Lesser General Public License for more details.
hgs
parents:
diff changeset
    13
*
hgs
parents:
diff changeset
    14
* You should have received a copy of the GNU Lesser General Public License
hgs
parents:
diff changeset
    15
* along with this program.  If not, 
hgs
parents:
diff changeset
    16
* see "http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html/".
hgs
parents:
diff changeset
    17
*
hgs
parents:
diff changeset
    18
* Description: 
hgs
parents:
diff changeset
    19
*
hgs
parents:
diff changeset
    20
*/
hgs
parents:
diff changeset
    21
#ifndef BOOKMARKSMANAGER_H
hgs
parents:
diff changeset
    22
#define BOOKMARKSMANAGER_H
hgs
parents:
diff changeset
    23
hgs
parents:
diff changeset
    24
#include <QString>
hgs
parents:
diff changeset
    25
#include <QObject>
hgs
parents:
diff changeset
    26
#include <QSqlDatabase>
hgs
parents:
diff changeset
    27
#include <QSqlError>
12
d26902edeef5 201037_03
hgs
parents: 9
diff changeset
    28
#include <QMap>
9
hgs
parents:
diff changeset
    29
hgs
parents:
diff changeset
    30
#include "bookmarksapi.h"
hgs
parents:
diff changeset
    31
class QWidget;
hgs
parents:
diff changeset
    32
class BookmarkFav;
hgs
parents:
diff changeset
    33
class BookmarkResults;
hgs
parents:
diff changeset
    34
class TagResults;
hgs
parents:
diff changeset
    35
hgs
parents:
diff changeset
    36
#define BOOKMARKS_DB_NAME   "Bookmarks"
hgs
parents:
diff changeset
    37
#define BOOKMARKS_DB_FILE   "bookmarks.db"
hgs
parents:
diff changeset
    38
hgs
parents:
diff changeset
    39
class BOOKMARKSAPI_EXPORT BookmarksManager : public QObject {
hgs
parents:
diff changeset
    40
  
hgs
parents:
diff changeset
    41
  Q_OBJECT
hgs
parents:
diff changeset
    42
hgs
parents:
diff changeset
    43
public:
hgs
parents:
diff changeset
    44
    enum status {
hgs
parents:
diff changeset
    45
            SUCCESS = 0,
hgs
parents:
diff changeset
    46
            DATABASEERROR = -1,
hgs
parents:
diff changeset
    47
            FAILURE = -2
hgs
parents:
diff changeset
    48
    };
hgs
parents:
diff changeset
    49
    
hgs
parents:
diff changeset
    50
    BookmarksManager(QWidget *parent = 0);
hgs
parents:
diff changeset
    51
    ~BookmarksManager();
hgs
parents:
diff changeset
    52
hgs
parents:
diff changeset
    53
public slots:
hgs
parents:
diff changeset
    54
    int addBookmark(QString title, QString URL);
hgs
parents:
diff changeset
    55
    int modifyBookmark(int origBookmarkId, QString newTitle, QString newURl);
hgs
parents:
diff changeset
    56
    int deleteBookmark(int bookmarkId);
hgs
parents:
diff changeset
    57
    int clearAll();
hgs
parents:
diff changeset
    58
    int deleteTag(int bookmarkId, QString tag);
hgs
parents:
diff changeset
    59
    int addTag(int bookmarkId, QString tag);
hgs
parents:
diff changeset
    60
    BookmarkResults *findAllBookmarks();
hgs
parents:
diff changeset
    61
    TagResults *findAllTags();
hgs
parents:
diff changeset
    62
    BookmarkResults *findBookmarksByTag(QString tag);
hgs
parents:
diff changeset
    63
    int importBookmarks(QString xbelFilePath);
hgs
parents:
diff changeset
    64
    int exportBookmarks(QString xbelFilePath);
hgs
parents:
diff changeset
    65
    BookmarkFav* findBookmark(int bookmarkId);
hgs
parents:
diff changeset
    66
    BookmarkResults *findUntaggedBookmarks();
hgs
parents:
diff changeset
    67
    int reorderBookmark(int bookmarkID, int newIndex);
hgs
parents:
diff changeset
    68
    TagResults* findTagsByBookmark(int bookmarkID);
12
d26902edeef5 201037_03
hgs
parents: 9
diff changeset
    69
		QMap<QString, QString> findBookmarks(QString atitle);   
d26902edeef5 201037_03
hgs
parents: 9
diff changeset
    70
 
9
hgs
parents:
diff changeset
    71
 private:
hgs
parents:
diff changeset
    72
    bool doQuery(QString query);
hgs
parents:
diff changeset
    73
    void createBookmarksSchema();
hgs
parents:
diff changeset
    74
    QString normalizeUrl(const QString& url);
hgs
parents:
diff changeset
    75
    void lastErrMsg(QSqlQuery& query);
hgs
parents:
diff changeset
    76
hgs
parents:
diff changeset
    77
    QSqlDatabase  m_db;
hgs
parents:
diff changeset
    78
    // Note: One instance of a query was locking the database even after using finish() and clear()
hgs
parents:
diff changeset
    79
    //QSqlQuery*    m_query;
hgs
parents:
diff changeset
    80
};
hgs
parents:
diff changeset
    81
#endif //BOOKMARKSMANAGER_H