/
migration.go
108 lines (86 loc) · 1.84 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
package migrate
import (
"bufio"
"bytes"
"context"
"fmt"
"io/fs"
"strings"
"time"
"github.com/uptrace/bun"
)
type Migration struct {
bun.BaseModel `bun:"alias:m"`
ID int64
Name string
GroupID int64
MigratedAt time.Time `bun:",notnull,default:current_timestamp"`
Up MigrationFunc `bun:"-"`
Down MigrationFunc `bun:"-"`
}
type MigrationFunc func(ctx context.Context, db *bun.DB) error
func NewSQLMigrationFunc(fsys fs.FS, name string) MigrationFunc {
return func(ctx context.Context, db *bun.DB) error {
isTx := strings.HasSuffix(name, ".tx.up.sql") || strings.HasSuffix(name, ".tx.down.sql")
f, err := fsys.Open(name)
if err != nil {
return err
}
scanner := bufio.NewScanner(f)
var queries []string
var query []byte
for scanner.Scan() {
b := scanner.Bytes()
const prefix = "--bun:"
if bytes.HasPrefix(b, []byte(prefix)) {
b = b[len(prefix):]
if bytes.Equal(b, []byte("split")) {
queries = append(queries, string(query))
query = query[:0]
continue
}
return fmt.Errorf("bun: unknown directive: %q", b)
}
query = append(query, b...)
query = append(query, '\n')
}
if len(query) > 0 {
queries = append(queries, string(query))
}
if err := scanner.Err(); err != nil {
return err
}
var dbi bun.DBI
if isTx {
tx, err := db.BeginTx(ctx, nil)
if err != nil {
return err
}
dbi = tx
} else {
conn, err := db.Conn(ctx)
if err != nil {
return err
}
dbi = conn
}
for _, q := range queries {
_, err = dbi.ExecContext(ctx, q)
if err != nil {
return err
}
}
if tx, ok := dbi.(bun.Tx); ok {
return tx.Commit()
} else if conn, ok := dbi.(bun.Conn); ok {
return conn.Close()
}
panic("not reached")
}
}
const goTemplate = `package main
`
const sqlTemplate = `SELECT 1
--bun:split
SELECT 2
`