/
migrate.go
103 lines (92 loc) · 2.31 KB
/
migrate.go
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
package cmd
import (
"go/types"
"strconv"
"strings"
migrate "github.com/rubenv/sql-migrate"
"github.com/spf13/cobra"
"github.com/diamcircle/go/services/regulated-assets-approval-server/internal/db"
"github.com/diamcircle/go/services/regulated-assets-approval-server/internal/db/dbmigrate"
"github.com/diamcircle/go/support/config"
"github.com/diamcircle/go/support/log"
)
type MigrateCommand struct {
DatabaseURL string
}
func (c *MigrateCommand) Command() *cobra.Command {
configOpts := config.ConfigOptions{
{
Name: "database-url",
Usage: "Database URL",
OptType: types.String,
ConfigKey: &c.DatabaseURL,
FlagDefault: "postgres://localhost:5432/?sslmode=disable",
Required: true,
},
}
cmd := &cobra.Command{
Use: "migrate [up|down] [count]",
Short: "Run migrations on the database",
PersistentPreRun: func(cmd *cobra.Command, args []string) {
configOpts.Require()
configOpts.SetValues()
},
Run: func(cmd *cobra.Command, args []string) {
c.Migrate(cmd, args)
},
}
configOpts.Init(cmd)
return cmd
}
func (c *MigrateCommand) Migrate(cmd *cobra.Command, args []string) {
db, err := db.Open(c.DatabaseURL)
if err != nil {
log.Errorf("Error opening database: %s", err.Error())
return
}
if len(args) < 1 {
cmd.Help()
return
}
dirStr := args[0]
var dir migrate.MigrationDirection
switch dirStr {
case "down":
dir = migrate.Down
case "up":
dir = migrate.Up
default:
log.Errorf("Invalid migration direction, must be 'up' or 'down'.")
return
}
var count int
if len(args) >= 2 {
count, err = strconv.Atoi(args[1])
if err != nil {
log.Errorf("Invalid migration count, must be a number.")
return
}
if count < 1 {
log.Errorf("Invalid migration count, must be a number greater than zero.")
return
}
}
migrations, err := dbmigrate.PlanMigration(db, dir, count)
if err != nil {
log.Errorf("Error planning migration: %s", err.Error())
return
}
if len(migrations) > 0 {
log.Infof("Migrations to apply %s: %s", dirStr, strings.Join(migrations, ", "))
}
n, err := dbmigrate.Migrate(db, dir, count)
if err != nil {
log.Errorf("Error applying migrations: %s", err.Error())
return
}
if n > 0 {
log.Infof("Successfully applied %d migrations %s.", n, dirStr)
} else {
log.Infof("No migrations applied %s.", dirStr)
}
}