/
db.go
120 lines (99 loc) · 2.16 KB
/
db.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
118
119
120
package main
import (
"crypto/tls"
"database/sql"
"fmt"
"net/http"
"net/url"
"os"
mysql "github.com/go-sql-driver/mysql"
_ "github.com/lib/pq"
)
func dbHandler(w http.ResponseWriter, r *http.Request) {
ssl := r.FormValue("ssl") != "false"
service := r.FormValue("service")
err := testDBConnection(ssl, service)
if err != nil {
http.Error(w, err.Error(), http.StatusInternalServerError)
return
}
writeJson(w, map[string]interface{}{
"success": true,
})
}
func testDBConnection(ssl bool, service string) error {
var err error
var db *sql.DB
if service == "" {
service = "postgres"
}
switch service {
case "mysql":
dbu := os.Getenv("DATABASE_URL")
db, err = mysqlOpen(dbu, ssl)
if err != nil {
return err
}
return testSQLConnection(db)
case "postgres":
dbu := os.Getenv("DATABASE_URL")
db, err = postgresOpen(dbu, ssl)
if err != nil {
return err
}
return testSQLConnection(db)
default:
return fmt.Errorf("unknown service: " + service)
}
}
func testSQLConnection(db *sql.DB) error {
defer db.Close()
_, err := db.Exec("CREATE TABLE foo(id integer)")
if err != nil {
return err
}
defer func() {
db.Exec("DROP TABLE foo")
}()
_, err = db.Exec("INSERT INTO foo VALUES(42)")
if err != nil {
return err
}
var id int
err = db.QueryRow("SELECT * FROM foo LIMIT 1").Scan(&id)
if err != nil {
return err
}
if id != 42 {
return fmt.Errorf("Expected 42, got %d", id)
}
return nil
}
func postgresOpen(dbu string, ssl bool) (*sql.DB, error) {
u, err := url.Parse(dbu)
if err != nil {
return nil, err
}
if ssl {
u.RawQuery = "sslmode=verify-full"
} else {
u.RawQuery = "sslmode=disable"
}
return sql.Open("postgres", u.String())
}
func mysqlOpen(dbu string, ssl bool) (*sql.DB, error) {
u, err := url.Parse(dbu)
if err != nil {
return nil, err
}
if ssl {
u.RawQuery = "tls=custom"
if err := mysql.RegisterTLSConfig("custom", &tls.Config{ServerName: u.Hostname()}); err != nil {
return nil, err
}
} else {
u.RawQuery = "tls=false"
}
connString := fmt.Sprintf("%s@tcp(%s:%s)%s?%s", u.User.String(), u.Hostname(), u.Port(), u.EscapedPath(), u.RawQuery)
return sql.Open("mysql", connString)
}