aboutsummaryrefslogtreecommitdiffstats
path: root/internal/commands/down.go
blob: 262e22915e48362ea3b6cd76a063747a51b70a97 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
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 DownCmd struct {
	version string
}

func (*DownCmd) Name() string {
	return "down"
}

func (*DownCmd) Synopsis() string {
	return "downgrade migrations against the database"
}

func (*DownCmd) Usage() string {
	return `down [-version|-v]:
	Downgrade migrations against the database
  `
}

func (cmd *DownCmd) SetFlags(f *flag.FlagSet) {
	f.StringVar(
		&cmd.version,
		"version",
		"",
		"The version to downgrade down and including to.",
	)
	f.StringVar(&cmd.version, "v", cmd.version, "alias for -version")
}

func (cmd *DownCmd) Execute(
	_ context.Context,
	f *flag.FlagSet,
	_ ...interface{},
) subcommands.ExitStatus {
	consoleOutputter := output.NewConsoleOutputter()

	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.Migrations)
	if err != nil {
		consoleOutputter.Error(err.Error())
		return subcommands.ExitFailure
	}

	migrationService := services.NewMigrationService(
		migrationDBRepo,
		migrationFsRepo,
		consoleOutputter,
	)

	if cmd.version == "" {
		err = migrationService.RevertAllMigrations()
		if err != nil {
			consoleOutputter.Error(err.Error())
			return subcommands.ExitFailure
		}
	} else {
		err = migrationService.RevertDownToVersion(cmd.version)
		if err != nil {
			consoleOutputter.Error(err.Error())
			return subcommands.ExitFailure
		}
	}

	return subcommands.ExitSuccess
}