plugin/appdb: fix persistence

2 files changed, 9 insertions, 21 deletions

diff --git a/modules/launcher/services/Apps.qml b/modules/launcher/services/Apps.qml
index b4b766d..02d997a 100644
--- a/modules/launcher/services/Apps.qml
+++ b/modules/launcher/services/Apps.qml
@@ -74,22 +74,4 @@ Searcher {
         path: `${Paths.state}/apps.sqlite`
         entries: DesktopEntries.applications.values.filter(a => !Config.launcher.hiddenApps.includes(a.id))
     }
-
-    // Variants {
-    //     id: variants
-
-    //     model: [...DesktopEntries.applications.values].filter(a => !Config.launcher.hiddenApps.includes(a.id)).sort((a, b) => a.name.localeCompare(b.name))
-
-    //     QtObject {
-    //         required property DesktopEntry modelData
-    //         readonly property string id: modelData.id
-    //         readonly property string name: modelData.name
-    //         readonly property string desc: modelData.comment
-    //         readonly property string execString: modelData.execString
-    //         readonly property string wmClass: modelData.startupClass
-    //         readonly property string genericName: modelData.genericName
-    //         readonly property string categories: modelData.categories.join(" ")
-    //         readonly property string keywords: modelData.keywords.join(" ")
-    //     }
-    // }
 }
diff --git a/plugin/src/Caelestia/appdb.cpp b/plugin/src/Caelestia/appdb.cpp
index 20e37bb..71f7130 100644
--- a/plugin/src/Caelestia/appdb.cpp
+++ b/plugin/src/Caelestia/appdb.cpp
@@ -83,16 +83,22 @@ QString AppDb::path() const {
 }
 
 void AppDb::setPath(const QString& path) {
-    if (m_path == path) {
+    auto newPath = path.isEmpty() ? ":memory:" : path;
+
+    if (m_path == newPath) {
         return;
     }
 
-    m_path = path;
+    m_path = newPath;
     emit pathChanged();
 
     auto db = QSqlDatabase::database(m_uuid, false);
     db.close();
-    db.setDatabaseName(path);
+    db.setDatabaseName(newPath);
+    db.open();
+
+    QSqlQuery query(db);
+    query.exec("CREATE TABLE IF NOT EXISTS frequencies (id TEXT PRIMARY KEY, frequency INTEGER)");
 
     updateAppFrequencies();
 }