-
Notifications
You must be signed in to change notification settings - Fork 531
/
psql_test.go
117 lines (102 loc) · 2.87 KB
/
psql_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
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
// These tests assume there is a user sqlboiler_driver_user and a database
// by the name of sqlboiler_driver_test that it has full R/W rights to.
// In order to create this you can use the following steps from a root
// psql account:
//
// create role sqlboiler_driver_user login nocreatedb nocreaterole nocreateuser password 'sqlboiler';
// create database sqlboiler_driver_test owner = sqlboiler_driver_user;
package driver
import (
"bytes"
"encoding/json"
"flag"
"fmt"
"os"
"os/exec"
"testing"
"github.com/stretchr/testify/require"
"github.com/volatiletech/sqlboiler/v4/drivers"
)
var (
flagOverwriteGolden = flag.Bool("overwrite-golden", false, "Overwrite the golden file with the current execution results")
envHostname = drivers.DefaultEnv("DRIVER_HOSTNAME", "localhost")
envPort = drivers.DefaultEnv("DRIVER_PORT", "5432")
envUsername = drivers.DefaultEnv("DRIVER_USER", "sqlboiler_driver_user")
envPassword = drivers.DefaultEnv("DRIVER_PASS", "sqlboiler")
envDatabase = drivers.DefaultEnv("DRIVER_DB", "sqlboiler_driver_test")
)
func TestAssemble(t *testing.T) {
b, err := os.ReadFile("testdatabase.sql")
if err != nil {
t.Fatal(err)
}
out := &bytes.Buffer{}
createDB := exec.Command("psql", "-h", envHostname, "-U", envUsername, envDatabase)
createDB.Env = append([]string{fmt.Sprintf("PGPASSWORD=%s", envPassword)}, os.Environ()...)
createDB.Stdout = out
createDB.Stderr = out
createDB.Stdin = bytes.NewReader(b)
if err := createDB.Run(); err != nil {
t.Logf("psql output:\n%s\n", out.Bytes())
t.Fatal(err)
}
t.Logf("psql output:\n%s\n", out.Bytes())
tests := []struct {
name string
config drivers.Config
goldenJson string
}{
{
name: "default",
config: drivers.Config{
"user": envUsername,
"pass": envPassword,
"dbname": envDatabase,
"host": envHostname,
"port": envPort,
"sslmode": "disable",
"schema": "public",
},
goldenJson: "psql.golden.json",
},
{
name: "enum_types",
config: drivers.Config{
"user": envUsername,
"pass": envPassword,
"dbname": envDatabase,
"host": envHostname,
"port": envPort,
"sslmode": "disable",
"schema": "public",
"add-enum-types": true,
},
goldenJson: "psql.golden.enums.json",
},
}
for _, tt := range tests {
t.Run(tt.name, func(t *testing.T) {
p := PostgresDriver{}
info, err := p.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))
})
}
}