golang数据库单元测试（包含代码和数据库）

package main

import (
“database/sql”
_ “github.com/go-sql-driver/mysql”
“testing”
)

func TestDBConnection(t *testing.T) {
//尝试连接数据库
dbConn, err := sql.Open(“mysql”,
“root:root@tcp(localhost:3306)/video_serve?charset=utf8”)
if err != nil {
panic(err.Error())
}
defer dbConn.Close()
err = dbConn.Ping()
if err != nil {
panic(err.Error())
}
}
Mysql文件

---

– Table structure for users

---

DROP TABLE IF EXISTS users ;
CREATE TABLE users (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
login_name varchar(64) DEFAULT NUlL,
pwd text,
PRIMARY KEY (id)
)ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;