package commands import ( "context" "flag" "fmt" "git.eugenetriguba.com/bolt/cli/internal/configloader" "git.eugenetriguba.com/bolt/cli/internal/output" "git.eugenetriguba.com/bolt/cli/internal/repositories" "git.eugenetriguba.com/bolt/cli/internal/services" "git.eugenetriguba.com/bolt/cli/internal/storage" "git.eugenetriguba.com/subcmd" ) 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{}, ) subcmd.ExitStatus { consoleOutputter := output.NewConsoleOutputter() cfg, err := configloader.NewConfig() if err != nil { consoleOutputter.Error(fmt.Errorf("unable to retrieve configuration: %w", err)) return subcmd.ExitFailure } db, err := storage.NewDB(cfg.Connection) if err != nil { consoleOutputter.Error(fmt.Errorf("unable to connect to database: %w", err)) return subcmd.ExitFailure } defer db.Close() migrationDBRepo, err := repositories.NewMigrationDBRepo(cfg.Connection.MigrationsTable, db) if err != nil { consoleOutputter.Error(err) return subcmd.ExitFailure } migrationFsRepo, err := repositories.NewMigrationFsRepo(&cfg.Migrations) if err != nil { consoleOutputter.Error(err) return subcmd.ExitFailure } migrationService := services.NewMigrationService( migrationDBRepo, migrationFsRepo, consoleOutputter, ) migrations, err := migrationService.ListMigrations(services.SortOrderAsc) if err != nil { consoleOutputter.Error(fmt.Errorf("unable to list migrations: %w", err)) return subcmd.ExitFailure } if len(migrations) == 0 { consoleOutputter.Output( "No migrations have been created.\n" + "Run 'bolt new' to create your first migration.", ) return subcmd.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} } err = consoleOutputter.Table(headers, rows) if err != nil { consoleOutputter.Error( fmt.Errorf("unable to output migrations as table: %w", err), ) return subcmd.ExitFailure } return subcmd.ExitSuccess }