3 files changed, 80 insertions, 0 deletions
diff --git a/cmd/migrator/migrate/init.go b/cmd/migrator/migrate/init.go
new file mode 100644
index 0000000..6f06c2d
--- /dev/null
+++ b/cmd/migrator/migrate/init.go
@@ -0,0 +1,18 @@
+package migrate
+
+import (
+	"context"
+
+	"git.neonxp.ru/neonxp/guessr/cmd/migrator/migrator"
+	"git.neonxp.ru/neonxp/guessr/migrations"
+	"github.com/urfave/cli/v3"
+)
+
+func Init(ctx context.Context, c *cli.Command) error {
+	m, err := migrator.New(c, migrations.Migrations)
+	if err != nil {
+		return err
+	}
+
+	return m.Init(ctx)
+}
diff --git a/cmd/migrator/migrate/migrate.go b/cmd/migrator/migrate/migrate.go
new file mode 100644
index 0000000..6245879
--- /dev/null
+++ b/cmd/migrator/migrate/migrate.go
@@ -0,0 +1,31 @@
+package migrate
+
+import (
+	"context"
+	"fmt"
+
+	"git.neonxp.ru/neonxp/guessr/cmd/migrator/migrator"
+	"git.neonxp.ru/neonxp/guessr/migrations"
+	"github.com/urfave/cli/v3"
+)
+
+func Migrate(ctx context.Context, c *cli.Command) error {
+	m, err := migrator.New(c, migrations.Migrations)
+	if err != nil {
+		return err
+	}
+
+	group, err := m.Migrate(ctx)
+	if err != nil {
+		return err
+	}
+
+	if group.ID == 0 {
+		fmt.Printf("there are no new migrations to run\n")
+		return nil
+	}
+
+	fmt.Printf("migrated to %s\n", group)
+
+	return nil
+}
diff --git a/cmd/migrator/migrate/rollback.go b/cmd/migrator/migrate/rollback.go
new file mode 100644
index 0000000..af56654
--- /dev/null
+++ b/cmd/migrator/migrate/rollback.go
@@ -0,0 +1,31 @@
+package migrate
+
+import (
+	"context"
+	"fmt"
+
+	"git.neonxp.ru/neonxp/guessr/cmd/migrator/migrator"
+	"git.neonxp.ru/neonxp/guessr/migrations"
+	"github.com/urfave/cli/v3"
+)
+
+func Rollback(ctx context.Context, c *cli.Command) error {
+	m, err := migrator.New(c, migrations.Migrations)
+	if err != nil {
+		return err
+	}
+
+	group, err := m.Rollback(ctx)
+	if err != nil {
+		return err
+	}
+
+	if group.ID == 0 {
+		fmt.Printf("there are no groups to roll back\n")
+		return nil
+	}
+
+	fmt.Printf("rolled back %s\n", group)
+
+	return nil
+}