2 * Copyright 2023 Soren Stoutner <soren@stoutner.com>.
4 * This file is part of Privacy Browser PC <https://www.stoutner.com/privacy-browser-pc>.
6 * Privacy Browser PC is free software: you can redistribute it and/or modify
7 * it under the terms of the GNU General Public License as published by
8 * the Free Software Foundation, either version 3 of the License, or
9 * (at your option) any later version.
11 * Privacy Browser PC is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 * GNU General Public License for more details.
16 * You should have received a copy of the GNU General Public License
17 * along with Privacy Browser PC. If not, see <http://www.gnu.org/licenses/>.
20 #ifndef BOOKMARKSDATABASE_H
21 #define BOOKMARKSDATABASE_H
23 // Application headers.
24 #include "structs/BookmarkStruct.h"
26 // Qt framework headers.
29 class BookmarksDatabase
32 // The default constructor.
35 // The public functions.
36 static void addBookmark(const BookmarkStruct *bookmarkStructPointer);
37 static void addDatabase();
38 static void addFolder(const BookmarkStruct *bookmarkStructPointer);
39 static void deleteBookmark(const int databaseId);
40 static QList<QString>* getAllFolderUrls(const double folderId);
41 static BookmarkStruct* getBookmark(const int databaseId);
42 static std::list<BookmarkStruct>* getBookmarks();
43 static QList<BookmarkStruct>* getBookmarksInFolderExcept(const double folderId, QList<int> *exceptDatabaseIdsListPointer);
44 static QList<int>* getFolderContentsDatabaseIds(const double folderId);
45 static QList<int>* getFolderContentsDatabaseIdsRecursively(const double folderId);
46 static QList<BookmarkStruct>* getFolderContents(const double folderId);
47 static int getFolderDatabaseId(const double folderId);
48 static double getFolderId(const int databaseId);
49 static int getFolderItemCount(const double folderId);
50 static double getParentFolderId(const int databaseId);
51 static QList<BookmarkStruct>* getSubfolders(const double folderId);
52 static bool isFolder(const int databaseId);
53 static void updateBookmark(const BookmarkStruct *bookmarkStructPointer);
54 static void updateBookmarkName(const int databaseId, const QString &bookmarkName);
55 static void updateBookmarkUrl(const int databaseId, const QString &bookmarkUrl);
56 static void updateDisplayOrder(const int databaseId, const int displayOrder);
57 static void updateFolderContentsDisplayOrder(const double folderId);
58 static void updateParentFolderAndDisplayOrder(const int databaseId, const double parentFolderId, const int displayOrder);
60 // The public constants.
61 static const QString CONNECTION_NAME;
62 static const QString BOOKMARK_NAME;
63 static const QString BOOKMARKS_TABLE;
64 static const QString BOOKMARK_URL;
65 static const QString DISPLAY_ORDER;
66 static const QString FAVORITE_ICON;
67 static const QString FOLDER_ID;
68 static const QString ID;
69 static const QString IS_FOLDER;
70 static const QString PARENT_FOLDER_ID;
73 // The private static constants.
74 static const int SCHEMA_VERSION;
76 // The private functions.
77 static double generateFolderId();
78 static QString getFavoriteIconBase64String(const QIcon &favoriteIcon);