/
migrations.go
115 lines (94 loc) · 3.02 KB
/
migrations.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
package db
import (
"errors"
"fmt"
"io/fs"
"path/filepath"
"github.com/golang-migrate/migrate/v4"
"github.com/golang-migrate/migrate/v4/database/postgres"
bindata "github.com/golang-migrate/migrate/v4/source/go_bindata"
)
type Migrations struct {
*DB
*PGUrl
MigrationsTable string
}
func (m *Migrations) ListAvailable(migrationsDir fs.FS) (*bindata.AssetSource, error) {
var assetNames []string
if err := fs.WalkDir(migrationsDir, ".", func(path string, info fs.DirEntry, err error) error {
if !info.IsDir() {
assetNames = append(assetNames, info.Name())
}
return nil
}); err != nil {
return nil, fmt.Errorf("could not walk migrations directory: %w", err)
}
return bindata.Resource(
assetNames,
func(name string) ([]byte, error) {
return fs.ReadFile(migrationsDir, filepath.Join(".", name))
},
), nil
}
func (m *Migrations) driver(migrationsDir fs.FS) (*migrate.Migrate, error) {
driver, err := m.WithInstance(&postgres.Config{
MigrationsTable: m.MigrationsTable,
SchemaName: m.SchemaSearchPath(),
})
if err != nil {
return nil, fmt.Errorf("could not initialise DB driver: %w", err)
}
resources, err := m.ListAvailable(migrationsDir)
if err != nil {
return nil, err
}
if len(resources.Names) == 0 {
return nil, errors.New("no migrations found")
}
resourcesDriver, err := bindata.WithInstance(resources)
if err != nil {
return nil, fmt.Errorf("could not create migration bindata instance: %w", err)
}
return migrate.NewWithInstance("go-bindata", resourcesDriver, "dracon", driver)
}
func (m *Migrations) State(migrationsDir fs.FS) (uint, bool, error) {
migrationDriver, err := m.driver(migrationsDir)
if err != nil {
return 0, false, err
}
return migrationDriver.Version()
}
func (m *Migrations) Apply(migrationsDir fs.FS) error {
migrationDriver, err := m.driver(migrationsDir)
if err != nil {
return err
}
_, isDBDirty, err := migrationDriver.Version()
if isDBDirty {
return errors.New("some migrations failed and DB is dirty. will not proceed with migrations")
} else if err != nil && !errors.Is(err, migrate.ErrNilVersion) {
return fmt.Errorf("error getting migration version: %w", err)
}
if err = migrationDriver.Up(); err != nil && !errors.Is(err, migrate.ErrNoChange) {
return fmt.Errorf("could not migrate DB: %w", err)
}
return nil
}
func (m *Migrations) Revert(migrationsDir fs.FS, toVersion uint) error {
migrationDriver, err := m.driver(migrationsDir)
if err != nil {
return err
}
dbVersion, isDBDirty, err := migrationDriver.Version()
if isDBDirty {
return errors.New("some migrations failed and DB is dirty. will not proceed with migrations")
} else if errors.Is(err, migrate.ErrNilVersion) {
return errors.New("no migrations have been applied so nothing to revert")
} else if err != nil {
return fmt.Errorf("error getting migration version: %w", err)
}
if err = migrationDriver.Steps(int(toVersion) - int(dbVersion)); err != nil && !errors.Is(err, migrate.ErrNoChange) {
return fmt.Errorf("could not revert migrations DB: %w", err)
}
return nil
}