aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rwxr-xr-xbolt2
-rw-r--r--internal/commands/downgrade.go70
-rw-r--r--internal/commands/migrate.go16
-rw-r--r--internal/services/migration.go15
-rw-r--r--pkg/cli/cli.go3
5 files changed, 96 insertions, 10 deletions
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()