Begin implementing Domain Settings using KXmlGuiWindow part 2.

[PrivacyBrowserPC.git] / src / helpers / DomainsDatabaseHelper.cpp

diff --git a/src/helpers/DomainsDatabaseHelper.cpp b/src/helpers/DomainsDatabaseHelper.cpp
new file mode 100644 (file)
index 0000000..8d127cf
--- /dev/null
+++ b/src/helpers/DomainsDatabaseHelper.cpp
@@ -0,0 +1,73 @@
+/*
+ * Copyright © 2022 Soren Stoutner <soren@stoutner.com>.
+ *
+ * This file is part of Privacy Browser PC <https://www.stoutner.com/privacy-browser-pc>.
+ *
+ * Privacy Browser PC is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Privacy Browser PC is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with Privacy Browser PC.  If not, see <http://www.gnu.org/licenses/>.
+ */
+
+// Application headers.
+#include "DomainsDatabaseHelper.h"
+
+// Qt framework headers.
+#include <QtSql>
+
+// Define the static constants.
+const QString DomainsDatabaseHelper::CONNECTION_NAME = "domains_database";
+const QString DomainsDatabaseHelper::DOMAINS_TABLE = "domains";
+
+// The default constructor.
+DomainsDatabaseHelper::DomainsDatabaseHelper() {}
+
+void DomainsDatabaseHelper::addDatabase()
+{
+    // Add the domain settings database.
+    QSqlDatabase domainsDatabase = QSqlDatabase::addDatabase("QSQLITE", CONNECTION_NAME);
+
+    // Set the database name.
+    domainsDatabase.setDatabaseName(QStandardPaths::writableLocation(QStandardPaths::AppDataLocation) + "/domains.db");
+
+    // Open the database.
+    if (domainsDatabase.open())  // Opening the database succeeded.
+    {
+        // Check to see if the domains table already exists.
+        if (domainsDatabase.tables().contains(DOMAINS_TABLE))
+        {
+            // Run schema update code.
+        }
+        else
+        {
+            // Instantiate a create table query.
+            QSqlQuery createTableQuery(domainsDatabase);
+
+            // Prepare the create table query.
+            createTableQuery.prepare("CREATE TABLE " + DOMAINS_TABLE + "("
+                "_id INTEGER PRIMARY KEY, "
+                "domain_name TEXT)"
+            );
+
+            // Execute the query.
+            if (!createTableQuery.exec())
+            {
+                // Log any errors.
+                qDebug().noquote().nospace() << "Error creating table:  " << domainsDatabase.lastError();
+            }
+        }
+    }
+    else  // Opening the database failed.
+    {
+        // Write the last database error message to the debug output.
+        qDebug().noquote().nospace() << "Error opening database:  " << domainsDatabase.lastError();
+    }
+};