com_mysql

Documentation

Index

• Constants
• func GetEnv() (halfDsn string)
• func Gorm(dsn string) (gormDB *gorm.DB, err error)
• func Sql(dsn string) (sqlDB *sql.DB, err error)
• func Sqlx(dsn string) (sqlxDB *sqlx.DB, err error)

Examples

• GetEnv

Constants

const (
	DriverName = "mysql"

	DSN = "MYSQL_DSN"
)

Functions

func GetEnv

func GetEnv() (halfDsn string)

Example

package main

import (
	"database/sql"
	"fmt"

	"github.com/zhangxiaofeng05/com/db/com_mysql"
)

func main() {
	// $ go get github.com/go-sql-driver/mysql

	// import _ "github.com/go-sql-driver/mysql"
	halfDsn := com_mysql.GetEnv()
	dsn := fmt.Sprintf("%s/%s?parseTime=true", halfDsn, "dev")
	fmt.Println(dsn)
	db, err := sql.Open(com_mysql.DriverName, dsn)
	if err != nil {
		panic(err)
	}
	defer db.Close()
	err = db.Ping()
	if err != nil {
		panic(err)
	}
}

func Gorm

func Gorm(dsn string) (gormDB *gorm.DB, err error)

func Sql

func Sql(dsn string) (sqlDB *sql.DB, err error)

Sql Standard library

func Sqlx

func Sqlx(dsn string) (sqlxDB *sqlx.DB, err error)