From 09c34e0f373d48f5993598c76fa176c8ed2fd4cd Mon Sep 17 00:00:00 2001
From: xengineering <me@xengineering.eu>
Date: Fri, 20 Mar 2026 21:10:12 +0100
Subject: Add DB schema version check

This version is only compatible with the schema version 0. No migrations
are implemented. Thus the DB is only accessed if the schema version
saved as user_version is as expected.
---
 lib/data.dart | 10 ++++++++--
 1 file changed, 8 insertions(+), 2 deletions(-)

(limited to 'lib/data.dart')

diff --git a/lib/data.dart b/lib/data.dart
index 302908c..c9c8b4d 100644
--- a/lib/data.dart
+++ b/lib/data.dart
@@ -64,7 +64,13 @@ class AppState with ChangeNotifier {
 
     final Database db = sqlite3.open(dbPath);
     try {
-      final ResultSet result = db.select(
+      ResultSet result = db.select('PRAGMA user_version;');
+      final int version = result.first.values.first as int;
+      if (version != 0) {
+        return;  // DB schema version 0 required, no migrations implemented
+      }
+
+      result = db.select(
         'SELECT value FROM key_value WHERE key = \'server_fqdn\';'
       );
       if (result.length == 1) {
@@ -72,7 +78,7 @@ class AppState with ChangeNotifier {
         notifyListeners();
       }
     } catch (e) {
-      // loading persistence is optional
+      return;
     } finally {
       db.close();
     }
-- 
cgit v1.3