forked from GuiaBolso/darwin
-
Notifications
You must be signed in to change notification settings - Fork 3
/
main.go
59 lines (48 loc) · 1.01 KB
/
main.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
package main
import (
"database/sql"
"flag"
"fmt"
"log"
"github.com/dimiro1/darwin"
_ "github.com/mattn/go-sqlite3"
)
var (
migrations = []darwin.Migration{
{
Version: 1,
Description: "Creating table posts",
Script: `CREATE TABLE posts (
id INTEGER PRIMARY KEY,
title TEXT
);;`,
},
{
Version: 2,
Description: "Adding column body",
Script: "ALTER TABLE posts ADD body TEXT AFTER title;",
},
}
)
func main() {
var info bool
flag.BoolVar(&info, "info", false, "If you want get info from database")
flag.Parse()
database, err := sql.Open("sqlite3", "database.sqlite3")
if err != nil {
log.Fatal(err)
}
driver := darwin.NewGenericDriver(database, darwin.SqliteDialect{})
d := darwin.New(driver, migrations)
if info {
infos, _ := d.Info()
for _, info := range infos {
fmt.Printf("%d %s %s\n", info.Migration.Version, info.Status, info.Migration.Description)
}
} else {
err = d.Migrate()
if err != nil {
log.Println(err)
}
}
}