1 // Copyright 2015 Google Inc. All Rights Reserved. 2 // 3 // Licensed under the Apache License, Version 2.0 (the "License"); 4 // you may not use this file except in compliance with the License. 5 // You may obtain a copy of the License at 6 // 7 // http://www.apache.org/licenses/LICENSE-2.0 8 // 9 // Unless required by applicable law or agreed to in writing, software 10 // distributed under the License is distributed on an "AS IS" BASIS, 11 // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 12 // See the License for the specific language governing permissions and 13 // limitations under the License. 14 15 package mysql_test 16 17 import ( 18 "fmt" 19 "time" 20 21 "github.com/GoogleCloudPlatform/cloudsql-proxy/proxy/dialers/mysql" 22 ) 23 24 // ExampleCfg shows how to use Cloud SQL Auth proxy dialer if you must update some 25 // settings normally passed in the DSN such as the DBName or timeouts. 26 func ExampleCfg() { 27 cfg := mysql.Cfg("project:region:instance-name", "user", "") 28 cfg.DBName = "DB_1" 29 cfg.ParseTime = true 30 31 const timeout = 10 * time.Second 32 cfg.Timeout = timeout 33 cfg.ReadTimeout = timeout 34 cfg.WriteTimeout = timeout 35 36 db, err := mysql.DialCfg(cfg) 37 if err != nil { 38 panic("couldn't dial: " + err.Error()) 39 } 40 // Close db after this method exits since we don't need it for the 41 // connection pooling. 42 defer db.Close() 43 44 var now time.Time 45 fmt.Println(db.QueryRow("SELECT NOW()").Scan(&now)) 46 fmt.Println(now) 47 } 48