-
Notifications
You must be signed in to change notification settings - Fork 1
/
migration.go
202 lines (163 loc) · 4 KB
/
migration.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
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
package mymigrate
import (
"context"
"fmt"
"sort"
"time"
)
var (
// set of project's migrations
migrations = make(map[string]mig)
// database provider
dbProvider DbProvider
// function to get list of applied migrations
getApplied = defaultAppliedFunc
// function to mark migration as aplied
markApplied = defaultMarkAppliedFunc
// function to down migrations
down = defaultDownFunc
)
func defaultAppliedFunc(provider DbProvider) ([]string, error) {
err := provider.CreateMigrationsTable()
if err != nil {
return nil, err
}
ctx, _ := context.WithTimeout(context.Background(), 30*time.Second)
return provider.GetApplied(ctx)
}
func defaultMarkAppliedFunc(provider DbProvider, name string) error {
err := provider.CreateMigrationsTable()
if err != nil {
return err
}
ctx, _ := context.WithTimeout(context.Background(), 30*time.Second)
return provider.MarkApplied(ctx, name, time.Now())
}
func defaultDownFunc(provider DbProvider, names []string) ([]string, error) {
err := provider.CreateMigrationsTable()
if err != nil {
return nil, err
}
downed := make([]string, 0, len(names))
for _, name := range names {
mig, ok := migrations[name]
if !ok {
return downed, fmt.Errorf("can't find migration '%s'", name)
}
err = mig.down(provider.GetDb())
if err != nil {
return downed, err
}
ctx, _ := context.WithTimeout(context.Background(), 30*time.Second)
err = provider.DeleteApplied(ctx, name)
if err != nil {
return downed, err
}
downed = append(downed, name)
}
return downed, nil
}
// Add adds mig to queue
// Use this function in init()
func Add(name string, up UpFunc, down DownFunc) {
migrations[name] = mig{
name: name,
up: up,
down: down,
}
}
// SetDatabaseProvider sets a DbProvider that we should use for applying migrations
func SetDatabaseProvider(provider DbProvider) {
dbProvider = provider
}
// NewNames returns names of new migrations
func NewNames() ([]string, error) {
appliedNames, err := getApplied(dbProvider)
if err != nil {
return nil, err
}
applied := map[string]bool{}
for _, name := range appliedNames {
applied[name] = true
}
result := make([]string, 0)
for name := range migrations {
if !applied[name] {
result = append(result, name)
}
}
sort.Strings(result)
return result, nil
}
// Apply func applies migrations
func Apply() ([]string, error) {
newNames, err := NewNames()
if err != nil {
return nil, err
}
applied := make([]string, 0, len(newNames))
for _, name := range newNames {
err = migrations[name].up(dbProvider.GetDb())
if err != nil {
return applied, err
}
err = markApplied(dbProvider, name)
if err != nil {
return applied, err
}
applied = append(applied, name)
}
return applied, nil
}
// datedMigrationName returns dated migration name
func datedMigrationName(name string) string {
return fmt.Sprintf("%s-%s", time.Now().Format("20060102-150405"), name)
}
// Template func returns a new migration template and the name of the migration
func Template(pkg, name string) (string, string) {
if len(pkg) == 0 {
pkg = "migrations"
}
template := `package %s
import (
"database/sql"
"github.com/iamsalnikov/mymigrate"
)
func init() {
mymigrate.Add(
"%s",
func(db *sql.DB) error {
// TODO: write UP logic
return nil
},
func(db *sql.DB) error {
// TODO: write down logic
return nil
},
)
}
`
name = datedMigrationName(name)
return fmt.Sprintf(template, pkg, name), name
}
// History func returns chronological history of applied migrations
func History() ([]string, error) {
return getApplied(dbProvider)
}
// Down func reverts particular number of migrations
// Pass 0 as a number to revert all migrations
func Down(number int) ([]string, error) {
appliedNames, err := getApplied(dbProvider)
if err != nil {
return nil, err
}
if len(appliedNames) == 0 {
return []string{}, nil
}
endIndex := number
if number >= len(appliedNames) || number == 0 {
endIndex = len(appliedNames)
}
namesToDown := appliedNames[:endIndex]
return down(dbProvider, namesToDown)
}