aboutsummaryrefslogtreecommitdiffstats
path: root/internal/commands/status.go
diff options
context:
space:
mode:
authorEugene Triguba <eugenetriguba@gmail.com>2024-01-13 18:23:48 -0500
committerEugene Triguba <eugenetriguba@gmail.com>2024-01-13 18:23:48 -0500
commit00aa327eb204d504f1e03dbe5a7cdec4af4ec913 (patch)
tree571a5bc5ce52a11e0039f9763c89b9316e7bf9d4 /internal/commands/status.go
parentTweak readme (diff)
downloadcli-00aa327eb204d504f1e03dbe5a7cdec4af4ec913.zip
Rework docs, add more output, and tweak tests
Diffstat (limited to 'internal/commands/status.go')
-rw-r--r--internal/commands/status.go100
1 files changed, 100 insertions, 0 deletions
diff --git a/internal/commands/status.go b/internal/commands/status.go
new file mode 100644
index 0000000..c20abd3
--- /dev/null
+++ b/internal/commands/status.go
@@ -0,0 +1,100 @@
+package commands
+
+import (
+ "context"
+ "flag"
+
+ "github.com/eugenetriguba/bolt/internal/configloader"
+ "github.com/eugenetriguba/bolt/internal/output"
+ "github.com/eugenetriguba/bolt/internal/repositories"
+ "github.com/eugenetriguba/bolt/internal/services"
+ "github.com/eugenetriguba/bolt/internal/storage"
+ "github.com/google/subcommands"
+)
+
+type StatusCmd struct{}
+
+func (*StatusCmd) Name() string {
+ return "status"
+}
+
+func (*StatusCmd) Synopsis() string {
+ return "list the database migrations and their statuses"
+}
+
+func (*StatusCmd) Usage() string {
+ return `status:
+ List the database migrations and their statuses
+ `
+}
+
+func (m *StatusCmd) SetFlags(f *flag.FlagSet) {}
+
+func (m *StatusCmd) Execute(
+ _ context.Context,
+ f *flag.FlagSet,
+ _ ...interface{},
+) subcommands.ExitStatus {
+ consoleOutputter := output.ConsoleOutputter{}
+
+ cfg, err := configloader.NewConfig()
+ if err != nil {
+ consoleOutputter.Error(err.Error())
+ return subcommands.ExitFailure
+ }
+
+ db, err := storage.DBConnect(
+ cfg.Connection.Driver,
+ storage.DBConnectionString(&cfg.Connection),
+ )
+ if err != nil {
+ consoleOutputter.Error(err.Error())
+ return subcommands.ExitFailure
+ }
+ defer db.Close()
+
+ migrationDBRepo, err := repositories.NewMigrationDBRepo(db)
+ if err != nil {
+ consoleOutputter.Error(err.Error())
+ return subcommands.ExitFailure
+ }
+
+ migrationFsRepo, err := repositories.NewMigrationFsRepo(cfg.MigrationsDir)
+ if err != nil {
+ consoleOutputter.Error(err.Error())
+ return subcommands.ExitFailure
+ }
+
+ migrationService := services.NewMigrationService(
+ migrationDBRepo,
+ migrationFsRepo,
+ consoleOutputter,
+ )
+ migrations, err := migrationService.ListMigrations(services.SortOrderAsc)
+ if err != nil {
+ consoleOutputter.Error(err.Error())
+ return subcommands.ExitFailure
+ }
+
+ if len(migrations) == 0 {
+ consoleOutputter.Output(
+ "No migrations have been created.\n" +
+ "Run 'bolt create' to create your first migration.",
+ )
+ return subcommands.ExitSuccess
+ }
+
+ headers := []string{"Version", "Message", "Applied"}
+ rows := make([][]string, len(migrations))
+ for i, migration := range migrations {
+ applied := ""
+ if migration.Applied {
+ applied = "X"
+ }
+
+ rows[i] = []string{migration.Version, migration.Message, applied}
+ }
+
+ consoleOutputter.Table(headers, rows)
+ return subcommands.ExitSuccess
+}