plugin/appdb: fix persistence

1 files changed, 9 insertions, 3 deletions

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();
 }