forked from lxh/go-wxhelper
29 lines
664 B
Go
29 lines
664 B
Go
|
package client
|
||
|
|
|
||
|
|
import (
|
||
|
|
"gorm.io/driver/mysql"
|
||
|
|
"gorm.io/gorm"
|
||
|
|
"log"
|
||
|
|
)
|
||
|
|
|
||
|
|
// MySQL客户端
|
||
|
|
var MySQL *gorm.DB
|
||
|
|
|
||
|
|
func InitMySQLClient() {
|
||
|
|
dsn := "wechat:wechat123@tcp(10.0.0.31:3307)/wechat?charset=utf8mb4&parseTime=True&loc=Local"
|
||
|
|
|
||
|
|
// 创建连接对象
|
||
|
|
mysqlConfig := mysql.Config{
|
||
|
|
DSN: dsn,
|
||
|
|
DontSupportRenameIndex: true, // 重命名索引时采用删除并新建的方式
|
||
|
|
DontSupportRenameColumn: true, // 用 `change` 重命名列
|
||
|
|
}
|
||
|
|
conn, err := gorm.Open(mysql.New(mysqlConfig))
|
||
|
|
if err != nil {
|
||
|
|
log.Panicf("初始化MySQL连接失败, 错误信息: %v", err)
|
||
|
|
} else {
|
||
|
|
log.Println("MySQL连接成功")
|
||
|
|
}
|
||
|
|
MySQL = conn
|
||
|
|
}
|