From fd4a08f7fce1a0085b30ebffe53b3a886b70dd76 Mon Sep 17 00:00:00 2001 From: Eugene Triguba Date: Wed, 10 Jan 2024 22:41:38 -0500 Subject: Add downgrade command and rename migrate to upgrade --- bolt | 2 +- internal/commands/downgrade.go | 70 ++++++++++++++++++++++++++++++++++++++++++ internal/commands/migrate.go | 16 +++++----- internal/services/migration.go | 15 +++++++++ pkg/cli/cli.go | 3 +- 5 files changed, 96 insertions(+), 10 deletions(-) create mode 100644 internal/commands/downgrade.go diff --git a/bolt b/bolt index 34a3a59..0d8cf7b 100755 --- a/bolt +++ b/bolt @@ -1,2 +1,2 @@ #!/bin/sh -env $(cat .env.bolt-postgres | xargs) go run ./cmd/bolt/bolt.go +env $(cat .env.bolt-postgres | xargs) go run ./cmd/bolt/bolt.go $@ diff --git a/internal/commands/downgrade.go b/internal/commands/downgrade.go new file mode 100644 index 0000000..f953286 --- /dev/null +++ b/internal/commands/downgrade.go @@ -0,0 +1,70 @@ +package commands + +import ( + "context" + "flag" + "fmt" + "os" + + "github.com/eugenetriguba/bolt/internal/configloader" + "github.com/eugenetriguba/bolt/internal/repositories" + "github.com/eugenetriguba/bolt/internal/services" + "github.com/eugenetriguba/bolt/internal/storage" + "github.com/google/subcommands" +) + +type DowngradeCmd struct{} + +func (*DowngradeCmd) Name() string { return "downgrade" } + +func (*DowngradeCmd) Synopsis() string { return "Downgrade all migrations against the database." } +func (*DowngradeCmd) Usage() string { + return `downgrade: + Downgrade all migrations against the database. + ` +} + +func (m *DowngradeCmd) SetFlags(f *flag.FlagSet) {} + +func (m *DowngradeCmd) Execute( + _ context.Context, + f *flag.FlagSet, + _ ...interface{}, +) subcommands.ExitStatus { + cfg, err := configloader.NewConfig() + if err != nil { + fmt.Fprintln(os.Stderr, err) + return subcommands.ExitFailure + } + + db, err := storage.DBConnect( + cfg.Connection.Driver, + storage.DBConnectionString(&cfg.Connection), + ) + if err != nil { + fmt.Fprintln(os.Stderr, err) + return subcommands.ExitFailure + } + defer db.Close() + + migrationDBRepo, err := repositories.NewMigrationDBRepo(db) + if err != nil { + fmt.Fprintln(os.Stderr, err) + return subcommands.ExitFailure + } + + migrationFsRepo, err := repositories.NewMigrationFsRepo(cfg.MigrationsDir) + if err != nil { + fmt.Fprintln(os.Stderr, err) + return subcommands.ExitFailure + } + + migrationService := services.NewMigrationService(migrationDBRepo, migrationFsRepo) + err = migrationService.RevertAllMigrations() + if err != nil { + fmt.Fprintln(os.Stderr, err) + return subcommands.ExitFailure + } + + return subcommands.ExitSuccess +} diff --git a/internal/commands/migrate.go b/internal/commands/migrate.go index 7c7a228..8c86291 100644 --- a/internal/commands/migrate.go +++ b/internal/commands/migrate.go @@ -13,20 +13,20 @@ import ( "github.com/google/subcommands" ) -type MigrateCmd struct{} +type UpgradeCmd struct{} -func (*MigrateCmd) Name() string { return "migrate" } +func (*UpgradeCmd) Name() string { return "upgrade" } -func (*MigrateCmd) Synopsis() string { return "Migrate the database to the latest migration." } -func (*MigrateCmd) Usage() string { - return `migrate: - Migrate the database to the latest migration. +func (*UpgradeCmd) Synopsis() string { return "Upgrade the database to the latest migration." } +func (*UpgradeCmd) Usage() string { + return `upgrade: + Upgrade the database to the latest migration. ` } -func (m *MigrateCmd) SetFlags(f *flag.FlagSet) {} +func (m *UpgradeCmd) SetFlags(f *flag.FlagSet) {} -func (m *MigrateCmd) Execute( +func (m *UpgradeCmd) Execute( _ context.Context, f *flag.FlagSet, _ ...interface{}, diff --git a/internal/services/migration.go b/internal/services/migration.go index 622ffc3..de03d3c 100644 --- a/internal/services/migration.go +++ b/internal/services/migration.go @@ -55,6 +55,21 @@ func (ms *MigrationService) ApplyMigration(migration *models.Migration) error { return nil } +func (ms *MigrationService) RevertAllMigrations() error { + migrations, err := ms.ListMigrations(SortOrderDesc) + if err != nil { + return err + } + + for _, migration := range migrations { + if migration.Applied { + ms.RevertMigration(migration) + } + } + + return nil +} + func (ms *MigrationService) RevertMigration(migration *models.Migration) error { scriptContents, err := ms.fsRepo.ReadDowngradeScript(migration) if err != nil { diff --git a/pkg/cli/cli.go b/pkg/cli/cli.go index 0ce67be..ba4ae0d 100644 --- a/pkg/cli/cli.go +++ b/pkg/cli/cli.go @@ -13,7 +13,8 @@ func Run() int { subcommands.Register(subcommands.FlagsCommand(), "") subcommands.Register(subcommands.CommandsCommand(), "") subcommands.Register(&commands.CreateCmd{}, "") - subcommands.Register(&commands.MigrateCmd{}, "") + subcommands.Register(&commands.UpgradeCmd{}, "") + subcommands.Register(&commands.DowngradeCmd{}, "") subcommands.Register(&commands.ListCmd{}, "") flag.Parse() -- cgit v1.2.3