-
Notifications
You must be signed in to change notification settings - Fork 0
/
migrate.go
42 lines (33 loc) · 1.04 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
package migrate
import (
"embed"
"log"
"github.com/golang-migrate/migrate/v4"
"github.com/golang-migrate/migrate/v4/database/sqlite"
"github.com/golang-migrate/migrate/v4/source/iofs"
"github.com/pkg/errors"
"github.com/azuline/presage/pkg/services"
)
//go:embed sql/*.sql
var fs embed.FS
// Migrate migrates the SQLite database to the most recent version, applying
// the migrations in the `sql/` directory.
func Migrate(srv *services.Services) error {
migs, err := iofs.New(fs, "sql")
if err != nil {
return errors.Wrap(err, "failed to create migration iofs")
}
instance, err := sqlite.WithInstance(srv.PlainDB, &sqlite.Config{})
if err != nil {
return errors.Wrap(err, "failed to create sqlite instance")
}
m, err := migrate.NewWithInstance("iofs", migs, "sqlite", instance)
if err != nil {
return errors.Wrap(err, "failed to create migrate instance")
}
if err = m.Up(); err != nil && !errors.Is(err, migrate.ErrNoChange) {
return errors.Wrap(err, "failed to migrate database")
}
log.Println("Ran database migrator")
return nil
}