From a750aa4ecf7ecab519b53d7f3ac082425ba50686 Mon Sep 17 00:00:00 2001
From: xengineering <me@xengineering.eu>
Date: Tue, 2 Jun 2026 19:52:18 +0200
Subject: Add MigrateToLatest

This function will be used most by the production software to update
the database schema to the latest known version.
---
 database.go | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)

(limited to 'database.go')

diff --git a/database.go b/database.go
index 44a172d..3651cf2 100644
--- a/database.go
+++ b/database.go
@@ -79,3 +79,21 @@ func UserVersion(db *sql.DB) (int, error) {
 
 	return version, nil
 }
+
+func MigrateToLatest(db *sql.DB) error {
+	for i := range migrations {
+		v, err := UserVersion(db)
+		if err != nil {
+			return fmt.Errorf("Failed UserVersion() inside MigrateToLatest(): %w", err)
+		}
+
+		if i == v {
+			err = Migrate(db, i)
+			if err != nil {
+				return fmt.Errorf("Failed Migrate() inside MigrateToLatest(): %w", err)
+			}
+		}
+	}
+
+	return nil
+}
-- 
cgit v1.3.1