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.

1 files changed, 13 insertions, 0 deletions

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
+}