-
Notifications
You must be signed in to change notification settings - Fork 64
/
serve_migrate.go
54 lines (50 loc) 路 1.21 KB
/
serve_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
43
44
45
46
47
48
49
50
51
52
53
54
package cmd
import (
"database/sql"
"fmt"
"log"
"os"
"path/filepath"
"github.com/charmbracelet/charm/server"
"github.com/charmbracelet/charm/server/db/sqlite"
"github.com/charmbracelet/charm/server/db/sqlite/migration"
"github.com/spf13/cobra"
_ "modernc.org/sqlite" // sqlite driver
)
// ServeMigrationCmd migrate server db.
var ServeMigrationCmd = &cobra.Command{
Use: "migrate",
Aliases: []string{"migration"},
Hidden: true,
Short: "Run the server migration tool.",
Long: paragraph("Run the server migration tool to migrate the database."),
Args: cobra.NoArgs,
RunE: func(cmd *cobra.Command, args []string) error {
cfg := server.DefaultConfig()
dp := filepath.Join(cfg.DataDir, "db", sqlite.DbName)
_, err := os.Stat(dp)
if err != nil {
return fmt.Errorf("database does not exist: %s", err)
}
db := sqlite.NewDB(dp)
for _, m := range []migration.Migration{
migration.Migration0001,
} {
log.Printf("Running migration: %04d %s\n", m.ID, m.Name)
err = db.WrapTransaction(func(tx *sql.Tx) error {
_, err := tx.Exec(m.SQL)
if err != nil {
return err
}
return nil
})
if err != nil {
break
}
}
if err != nil {
return err
}
return nil
},
}