1 // Go MySQL Driver - A MySQL-Driver for Go's database/sql package
3 // Copyright 2013 The Go-MySQL-Driver Authors. All rights reserved.
5 // This Source Code Form is subject to the terms of the Mozilla Public
6 // License, v. 2.0. If a copy of the MPL was not distributed with this file,
7 // You can obtain one at http://mozilla.org/MPL/2.0/.
20 fileRegister map[string]bool
21 fileRegisterLock sync.RWMutex
22 readerRegister map[string]func() io.Reader
23 readerRegisterLock sync.RWMutex
26 // RegisterLocalFile adds the given file to the file whitelist,
27 // so that it can be used by "LOAD DATA LOCAL INFILE <filepath>".
28 // Alternatively you can allow the use of all local files with
29 // the DSN parameter 'allowAllFiles=true'
31 // filePath := "/home/gopher/data.csv"
32 // mysql.RegisterLocalFile(filePath)
33 // err := db.Exec("LOAD DATA LOCAL INFILE '" + filePath + "' INTO TABLE foo")
37 func RegisterLocalFile(filePath string) {
38 fileRegisterLock.Lock()
40 if fileRegister == nil {
41 fileRegister = make(map[string]bool)
44 fileRegister[strings.Trim(filePath, `"`)] = true
45 fileRegisterLock.Unlock()
48 // DeregisterLocalFile removes the given filepath from the whitelist.
49 func DeregisterLocalFile(filePath string) {
50 fileRegisterLock.Lock()
51 delete(fileRegister, strings.Trim(filePath, `"`))
52 fileRegisterLock.Unlock()
55 // RegisterReaderHandler registers a handler function which is used
56 // to receive a io.Reader.
57 // The Reader can be used by "LOAD DATA LOCAL INFILE Reader::<name>".
58 // If the handler returns a io.ReadCloser Close() is called when the
59 // request is finished.
61 // mysql.RegisterReaderHandler("data", func() io.Reader {
62 // var csvReader io.Reader // Some Reader that returns CSV data
63 // ... // Open Reader here
66 // err := db.Exec("LOAD DATA LOCAL INFILE 'Reader::data' INTO TABLE foo")
70 func RegisterReaderHandler(name string, handler func() io.Reader) {
71 readerRegisterLock.Lock()
73 if readerRegister == nil {
74 readerRegister = make(map[string]func() io.Reader)
77 readerRegister[name] = handler
78 readerRegisterLock.Unlock()
81 // DeregisterReaderHandler removes the ReaderHandler function with
82 // the given name from the registry.
83 func DeregisterReaderHandler(name string) {
84 readerRegisterLock.Lock()
85 delete(readerRegister, name)
86 readerRegisterLock.Unlock()
89 func deferredClose(err *error, closer io.Closer) {
90 closeErr := closer.Close()
96 func (mc *mysqlConn) handleInFileRequest(name string) (err error) {
99 packetSize := 16 * 1024 // 16KB is small enough for disk readahead and large enough for TCP
100 if mc.maxWriteSize < packetSize {
101 packetSize = mc.maxWriteSize
104 if idx := strings.Index(name, "Reader::"); idx == 0 || (idx > 0 && name[idx-1] == '/') { // io.Reader
105 // The server might return an an absolute path. See issue #355.
108 readerRegisterLock.RLock()
109 handler, inMap := readerRegister[name]
110 readerRegisterLock.RUnlock()
115 if cl, ok := rdr.(io.Closer); ok {
116 defer deferredClose(&err, cl)
119 err = fmt.Errorf("Reader '%s' is <nil>", name)
122 err = fmt.Errorf("Reader '%s' is not registered", name)
125 name = strings.Trim(name, `"`)
126 fileRegisterLock.RLock()
127 fr := fileRegister[name]
128 fileRegisterLock.RUnlock()
129 if mc.cfg.AllowAllFiles || fr {
133 if file, err = os.Open(name); err == nil {
134 defer deferredClose(&err, file)
137 if fi, err = file.Stat(); err == nil {
139 if fileSize := int(fi.Size()); fileSize < packetSize {
140 packetSize = fileSize
145 err = fmt.Errorf("local file '%s' is not registered", name)
149 // send content packets
150 // if packetSize == 0, the Reader contains no data
151 if err == nil && packetSize > 0 {
152 data := make([]byte, 4+packetSize)
155 n, err = rdr.Read(data[4:])
157 if ioErr := mc.writePacket(data[:4+n]); ioErr != nil {
167 // send empty packet (termination)
169 data = make([]byte, 4)
171 if ioErr := mc.writePacket(data[:4]); ioErr != nil {
177 return mc.readResultOK()