/
mysql.go
51 lines (48 loc) · 1.39 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
// Package mysql defines and registers usql's MySQL driver.
//
// Alias: memsql, SingleStore MemSQL
// Alias: vitess, Vitess Database
// Alias: tidb, TiDB
//
// See: https://github.com/go-sql-driver/mysql
// Group: base
package mysql
import (
"io"
"strconv"
"github.com/go-sql-driver/mysql" // DRIVER
"github.com/xo/usql/drivers"
"github.com/xo/usql/drivers/metadata"
mymeta "github.com/xo/usql/drivers/metadata/mysql"
)
func init() {
drivers.Register("mysql", drivers.Driver{
AllowMultilineComments: true,
AllowHashComments: true,
LexerName: "mysql",
UseColumnTypes: true,
ForceParams: drivers.ForceQueryParameters([]string{
"parseTime", "true",
"loc", "Local",
"sql_mode", "ansi",
}),
Err: func(err error) (string, string) {
if e, ok := err.(*mysql.MySQLError); ok {
return strconv.Itoa(int(e.Number)), e.Message
}
return "", err.Error()
},
IsPasswordErr: func(err error) bool {
if e, ok := err.(*mysql.MySQLError); ok {
return e.Number == 1045
}
return false
},
NewMetadataReader: mymeta.NewReader,
NewMetadataWriter: func(db drivers.DB, w io.Writer, opts ...metadata.ReaderOption) metadata.Writer {
return metadata.NewDefaultWriter(mymeta.NewReader(db, opts...))(db, w)
},
Copy: drivers.CopyWithInsert(func(int) string { return "?" }),
NewCompleter: mymeta.NewCompleter,
}, "memsql", "vitess", "tidb")
}