mysql

Documentation

Index

• Variables
• func Close() (err error)
• func InitDefaultDB(username, password, ip string, port int, database, charset string, ...) (*sqlx.DB, error)
• func InitDefaultDBFromCfg(cfg *ConfigMysql) (*sqlx.DB, error)
• func NewDB(username, password, ip string, port int, database, charset string, ...) (*sqlx.DB, error)
• func NewDBFromCfg(cfg *ConfigMysql) (*sqlx.DB, error)
• type ConfigMysql

Variables

var (
	DB *sqlx.DB
)

Functions

func Close

func Close() (err error)

Close 关闭数据库

func InitDefaultDB

func InitDefaultDB(username, password, ip string, port int, database, charset string, parseTime bool, loc string, setMaxOpenConn, setMaxIdleConn int) (*sqlx.DB, error)

初始化默认的 mysql 连接池

func InitDefaultDBFromCfg

func InitDefaultDBFromCfg(cfg *ConfigMysql) (*sqlx.DB, error)

初始化默认的 mysql 连接池 从 ConfigMysql 获取有关配置

func NewDB

func NewDB(username, password, ip string, port int, database, charset string, parseTime bool, loc string, setMaxOpenConn, setMaxIdleConn int) (*sqlx.DB, error)

NewDB 构建一个 mysql 连接池

func NewDBFromCfg

func NewDBFromCfg(cfg *ConfigMysql) (*sqlx.DB, error)

NewDBFromCfg 构建一个 mysql 连接池 从 ConfigMysql 获取有关配置

Types

type ConfigMysql

type ConfigMysql struct {
	Ip             string `mapstructure:"ip" json:"ip"`
	Port           int    `mapstructure:"port" json:"port"`
	Database       string `mapstructure:"database" json:"database"`
	Charset        string `mapstructure:"charset" json:"charset"`
	Username       string `mapstructure:"username" json:"username"`
	Password       string `mapstructure:"password" json:"password"`
	ParseTime      bool   `mapstructure:"parse_time" json:"parse_time"`
	Loc            string `mapstructure:"loc" json:"loc"`
	SetMaxOpenConn int    `mapstructure:"set_max_open_conn" json:"set_max_open_conn"`
	SetMaxIdleConn int    `mapstructure:"set_max_idle_conn" json:"set_max_idle_conn"`
}

ConfigMysql mysql 有关配置