-
Notifications
You must be signed in to change notification settings - Fork 531
/
sqlite3_test.go
90 lines (76 loc) · 1.71 KB
/
sqlite3_test.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
package driver
import (
"bytes"
"encoding/json"
"flag"
"fmt"
"math/rand"
"os"
"os/exec"
"path/filepath"
"testing"
"time"
"github.com/stretchr/testify/require"
"github.com/volatiletech/sqlboiler/v4/drivers"
_ "modernc.org/sqlite"
)
var (
flagOverwriteGolden = flag.Bool("overwrite-golden", false, "Overwrite the golden file with the current execution results")
)
func TestDriver(t *testing.T) {
rand.Seed(time.Now().Unix())
b, err := os.ReadFile("testdatabase.sql")
if err != nil {
t.Fatal(err)
}
tmpName := filepath.Join(os.TempDir(), fmt.Sprintf("sqlboiler-sqlite3-%d.sql", rand.Int()))
out := &bytes.Buffer{}
createDB := exec.Command("sqlite3", tmpName)
createDB.Stdout = out
createDB.Stderr = out
createDB.Stdin = bytes.NewReader(b)
t.Log("sqlite file:", tmpName)
if err := createDB.Run(); err != nil {
t.Logf("sqlite output:\n%s\n", out.Bytes())
t.Fatal(err)
}
t.Logf("sqlite output:\n%s\n", out.Bytes())
tests := []struct {
name string
config drivers.Config
goldenJson string
}{
{
name: "default",
config: drivers.Config{
"dbname": tmpName,
},
goldenJson: "sqlite3.golden.json",
},
}
for _, tt := range tests {
t.Run(tt.name, func(t *testing.T) {
s := &SQLiteDriver{}
info, err := s.Assemble(tt.config)
if err != nil {
t.Fatal(err)
}
got, err := json.MarshalIndent(info, "", "\t")
if err != nil {
t.Fatal(err)
}
if *flagOverwriteGolden {
if err = os.WriteFile(tt.goldenJson, got, 0664); err != nil {
t.Fatal(err)
}
t.Log("wrote:", string(got))
return
}
want, err := os.ReadFile(tt.goldenJson)
if err != nil {
t.Fatal(err)
}
require.JSONEq(t, string(want), string(got))
})
}
}