-
Notifications
You must be signed in to change notification settings - Fork 0
/
migration.go
46 lines (37 loc) · 1.24 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
// Copyright (c) 2022 Gobalsky Labs Limited
//
// Use of this software is governed by the Business Source License included
// in the LICENSE file and at https://www.mariadb.com/bsl11.
//
// Change Date: 18 months from the later of the date of the first publicly
// available Distribution of this version of the repository, and 25 June 2022.
//
// On the date above, in accordance with the Business Source License, use
// of this software will be governed by version 3 or later of the GNU General
// Public License.
package store
import (
"embed"
"fmt"
"github.com/elysiumstation/fury/logging"
"github.com/jackc/pgx/v4/stdlib"
"github.com/pkg/errors"
"github.com/pressly/goose/v3"
)
//go:embed migrations/*.sql
var EmbedMigrations embed.FS
const SQLMigrationsDir = "migrations"
func MigrateToLatestSchema(log *logging.Logger, config Config) error {
goose.SetBaseFS(EmbedMigrations)
goose.SetLogger(log.Named("db migration").GooseLogger())
poolConfig, err := config.Postgres.ToPgxPoolConfig()
if err != nil {
return errors.Wrap(err, "migrating schema")
}
db := stdlib.OpenDB(*poolConfig.ConnConfig)
defer db.Close()
if err := goose.Up(db, SQLMigrationsDir); err != nil {
return fmt.Errorf("error migrating sql schema: %w", err)
}
return nil
}