Add MigrateToLatest

This function will be used most by the production software to update
the database schema to the latest known version.

1 files changed, 18 insertions, 0 deletions

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