-
Notifications
You must be signed in to change notification settings - Fork 568
/
mysql.go
65 lines (59 loc) · 1.95 KB
/
mysql.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
package dockertestenv
import (
"context"
"testing"
"time"
"github.com/go-sql-driver/mysql"
"github.com/pachyderm/pachyderm/v2/src/internal/backoff"
"github.com/pachyderm/pachyderm/v2/src/internal/dbutil"
"github.com/pachyderm/pachyderm/v2/src/internal/log"
"github.com/pachyderm/pachyderm/v2/src/internal/pachsql"
"github.com/pachyderm/pachyderm/v2/src/internal/pctx"
"github.com/pachyderm/pachyderm/v2/src/internal/require"
"github.com/pachyderm/pachyderm/v2/src/internal/testutil"
)
const (
mysqlPort = 9100
MySQLPassword = "root"
mysqlUser = "root"
)
func NewEphemeralMySQLDB(ctx context.Context, t testing.TB) (*pachsql.DB, string) {
name := testutil.GenerateEphemeralDBName(t)
return testutil.OpenDBURL(t, newMySQLEphemeralURL(ctx, t, name), MySQLPassword), name
}
// NewMySQLURL returns a pachsql.URL to an ephemeral database.
func NewMySQLURL(ctx context.Context, t testing.TB) pachsql.URL {
dbName := testutil.GenerateEphemeralDBName(t)
return newMySQLEphemeralURL(ctx, t, dbName)
}
func newMySQLEphemeralURL(ctx context.Context, t testing.TB, name string) pachsql.URL {
dclient := newDockerClient()
err := backoff.Retry(func() error {
return ensureContainer(ctx, dclient, "pach_test_mysql", containerSpec{
Image: "mysql:latest",
PortMap: map[uint16]uint16{
mysqlPort: 3306,
},
Env: map[string]string{
"MYSQL_ROOT_PASSWORD": MySQLPassword,
},
})
}, backoff.NewConstantBackOff(time.Second*3))
require.NoError(t, err)
u := pachsql.URL{
Protocol: pachsql.ProtocolMySQL,
User: mysqlUser,
Host: getDockerHost(),
Port: mysqlPort,
Database: "",
}
db := testutil.OpenDBURL(t, u, MySQLPassword)
ctx, cf := context.WithTimeout(ctx, 30*time.Second)
defer cf()
mysql.SetLogger(log.NewStdLogAt(pctx.Child(pctx.TODO(), "ephemeral-mysql"), log.DebugLevel)) //nolint:errcheck
require.NoError(t, dbutil.WaitUntilReady(ctx, db))
testutil.CreateEphemeralDB(t, db, name)
u2 := u
u2.Database = name
return u2
}