aboutsummaryrefslogtreecommitdiffstats
path: root/internal/commands/status.go
blob: 76f74275be074869b9608ac447e0b3d7504e33b1 (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
100
101
102
103
104
105
106
107
108
109
110
package commands

import (
	"context"
	"flag"
	"fmt"

	"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.NewConsoleOutputter()

	cfg, err := configloader.NewConfig()
	if err != nil {
		consoleOutputter.Error(fmt.Errorf("unable to retrieve configuration: %w", err))
		return subcommands.ExitFailure
	}

	db, err := storage.DBConnect(
		cfg.Connection.Driver,
		storage.DBConnectionString(&cfg.Connection),
	)
	if err != nil {
		consoleOutputter.Error(fmt.Errorf("unable to connect to database: %w", err))
		return subcommands.ExitFailure
	}
	defer db.Close()

	migrationDBRepo, err := repositories.NewMigrationDBRepo(db)
	if err != nil {
		consoleOutputter.Error(err)
		return subcommands.ExitFailure
	}

	migrationFsRepo, err := repositories.NewMigrationFsRepo(&cfg.Migrations)
	if err != nil {
		consoleOutputter.Error(err)
		return subcommands.ExitFailure
	}

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

	migrations, err := migrationService.ListMigrations(services.SortOrderAsc)
	if err != nil {
		consoleOutputter.Error(fmt.Errorf("unable to list migrations: %w", err))
		return subcommands.ExitFailure
	}

	if len(migrations) == 0 {
		consoleOutputter.Output(
			"No migrations have been created.\n" +
				"Run 'bolt new' 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}
	}

	err = consoleOutputter.Table(headers, rows)
	if err != nil {
		consoleOutputter.Error(
			fmt.Errorf("unable to output migrations as table: %w", err),
		)
		return subcommands.ExitFailure
	}

	return subcommands.ExitSuccess
}