From 29ae857b5ca13fa12f1d07d4a30597ff9ce28767 Mon Sep 17 00:00:00 2001
From: xengineering <me@xengineering.eu>
Date: Sun, 31 May 2026 21:34:44 +0200
Subject: Add UserVersion()

This function gets the user_version SQLite3 field describing which
migration was the last executed one.

A test checking this before applying any migrations and after each
migration is included.
---
 database.go | 13 +++++++++++++
 1 file changed, 13 insertions(+)

(limited to 'database.go')

diff --git a/database.go b/database.go
index c71ff78..44a172d 100644
--- a/database.go
+++ b/database.go
@@ -66,3 +66,16 @@ func Migrate(db *sql.DB, index int) error {
 		return err
 	})
 }
+
+func UserVersion(db *sql.DB) (int, error) {
+	var version int
+
+	err := Transaction(db, func(tx *sql.Tx) error {
+		return tx.QueryRow(`PRAGMA user_version`).Scan(&version)
+	})
+	if err != nil {
+		return 0, err
+	}
+
+	return version, nil
+}
-- 
cgit v1.3.1