GoYu Yan De Yi Ge Shu Ju Ku Cao Zuo Feng Zhuang
He Xin Si Xiang Shi Chuan Ru Yi Ge Jie Guo Rong Qi ,Gen Ju Rong Qi De Lei Xing Zi Dong Tian Chong Shu Ju ,Fang Bian Shi Yong
Pei Zhi
{
"test": {
"type": "mysql",
"user": "test",
"password": "34RVCy0rQBSQmLX64xjoyg==", // Shi Yong github.com/ssgo/base/passwordMaker Sheng Cheng
"host": "/tmp/mysql.sock",
"db": "test",
"maxOpens": 100, // Zui Da Lian Jie Shu ,0Biao Shi Bu Xian Zhi
"maxIdles": 30, // Zui Da Kong Xian Lian Jie ,0Biao Shi Bu Xian Zhi
"maxLiftTime": 0 // Mei Ge Lian Jie De Cun Huo Shi Jian ,0Biao Shi Yong Yuan
}
}
"test": {
"type": "mysql",
"user": "test",
"password": "34RVCy0rQBSQmLX64xjoyg==", // Shi Yong github.com/ssgo/base/passwordMaker Sheng Cheng
"host": "/tmp/mysql.sock",
"db": "test",
"maxOpens": 100, // Zui Da Lian Jie Shu ,0Biao Shi Bu Xian Zhi
"maxIdles": 30, // Zui Da Kong Xian Lian Jie ,0Biao Shi Bu Xian Zhi
"maxLiftTime": 0 // Mei Ge Lian Jie De Cun Huo Shi Jian ,0Biao Shi Yong Yuan
}
}
API
import github.com/ssgo/db
// Zi Ding Yi Jia Mi Mi Yao ,
func SetEncryptKeys(key, iv []byte){}
// Huo De Yi Ge Shu Ju Ku Cao Zuo Shi Li ,Zhe Shi Yi Ge Lian Jie Chi ,Zhi Jie Cao Zuo Ji Ke Bu Xu Yao Shi Li Hua
func GetDB(name string) (*DB, error){}
// Shi Fang Shu Ju Ku Cao Zuo Shi Li ,Zheng Chang Qing Kuang Xia Bu Ying Gai Cao Zuo ,Fou Ze Zheng Ge Lian Jie Chi Du Jiang Wu Fa Shi Yong
func (this *DB) Destroy() error{}
// Qu De Yuan Shi De sql.DB Dui Xiang ,Ke Zi Xing Cao Zuo
func (this *DB) GetConnection() *sql.DB{}
// Cha Xun Shu Ju ,Gen Ju Jie Shou Jie Guo De Dui Xiang Bu Tong Zhi Xing Bu Tong De Cha Xun
// results := make([]userInfo, 0) Qu Quan Bu Jie Guo ,Cun Wei Dui Xiang
// results := make([]map[string]interface{}, 0) Qu Quan Bu Jie Guo ,Bao Liu Yuan Shi Lei Xing
// results := make([]map[string]string, 0) Qu Quan Bu Jie Guo ,Tong Yi Zhuan Huan Wei string
// results := make([]map[string]int, 0) Qu Quan Bu Jie Guo ,Tong Yi Zhuan Huan Wei int,Bu Ke Zhuan Huan Hui Bao Cuo
// results := make([][]string, 0) Qu Quan Bu Jie Guo ,Cun Wei Shu Zu
// results := userInfo{} Qu Di Yi Xing Shu Ju ,Cun Wei Dui Xiang
// results := map[string]interface{}{} Qu Di Yi Xing Shu Ju ,Cun Wei map
// results := make([]string, 0) Qu Quan Bu Di Yi Lie Shu Ju
// var results int Qu Di Yi Xing Di Yi Lie Shu Ju
func (this *DB) Query(results interface{}, requestSql string, args ...interface{}) error {}
// Zhi Xing Pu Tong Cha Xun ,Fan Hui Ying Xiang Lie Shu
func (this *DB) Exec(requestSql string, args ...interface{}) (int64, error) {}
// Zhi Xing Pu Tong INSERTHuo REPLACE,Fan Hui lastInsertId
func (this *DB) ExecInsert(requestSql string, args ...interface{}) (int64, error) {}
// An Shu Ju Dui Xiang Zi Dong Sheng Cheng INSERTYu Ju Bing Zhi Xing ,dataZhi Chi MapHe Struct
func (this *DB) Insert(table string, data interface{}) (int64, error) {}
// An Shu Ju Dui Xiang Zi Dong Sheng Cheng REPLACEYu Ju Bing Zhi Xing ,dataZhi Chi MapHe Struct
func (this *DB) Replace(table string, data interface{}) (int64, error) {}
// An Shu Ju Dui Xiang Zi Dong Sheng Cheng UPDATEYu Ju Bing Zhi Xing ,dataZhi Chi MapHe Struct
func (this *DB) Update(table string, data interface{}, wheres string, args ...interface{}) (int64, error) {}
// Kai Qi Yi Ge Shi Wu
func (this *DB) Begin() (*Tx, error) {}
// Yu Chu Li
func (this *DB) Prepare(requestSql string) (*Stmt, error) {}
// Zai Shi Wu Zhong Cao Zuo ,Tong (this *DB)
func (this *Tx) Query(results interface{}, requestSql string, args ...interface{}) error {}
func (this *Tx) Exec(requestSql string, args ...interface{}) (int64, error) {}
func (this *Tx) ExecInsert(requestSql string, args ...interface{}) (int64, error) {}
func (this *Tx) Insert(table string, data interface{}) (int64, error) {}
func (this *Tx) Replace(table string, data interface{}) (int64, error) {}
func (this *Tx) Update(table string, data interface{}, wheres string, args ...interface{}) (int64, error) {}
func (this *Tx) Prepare(requestSql string) (*Stmt, error) {
// Ti Jiao
func (this *Tx) Commit() error {
// Hui Gun
func (this *Tx) Rollback() error {
// Pi Liang Zhi Xing ,Fan Hui Shou Ying Xiang De Lie Shu
func (this *Stmt) Exec(args ...interface{}) (int64, error) {}
// Pi Liang Zhi Xing ,Fan Hui lastInsertId
func (this *Stmt) ExecInsert(args ...interface{}) (int64, error) {}
// Guan Bi Yu Chu Li
func (this *Stmt) Close() error {}
// Zi Ding Yi Jia Mi Mi Yao ,
func SetEncryptKeys(key, iv []byte){}
// Huo De Yi Ge Shu Ju Ku Cao Zuo Shi Li ,Zhe Shi Yi Ge Lian Jie Chi ,Zhi Jie Cao Zuo Ji Ke Bu Xu Yao Shi Li Hua
func GetDB(name string) (*DB, error){}
// Shi Fang Shu Ju Ku Cao Zuo Shi Li ,Zheng Chang Qing Kuang Xia Bu Ying Gai Cao Zuo ,Fou Ze Zheng Ge Lian Jie Chi Du Jiang Wu Fa Shi Yong
func (this *DB) Destroy() error{}
// Qu De Yuan Shi De sql.DB Dui Xiang ,Ke Zi Xing Cao Zuo
func (this *DB) GetConnection() *sql.DB{}
// Cha Xun Shu Ju ,Gen Ju Jie Shou Jie Guo De Dui Xiang Bu Tong Zhi Xing Bu Tong De Cha Xun
// results := make([]userInfo, 0) Qu Quan Bu Jie Guo ,Cun Wei Dui Xiang
// results := make([]map[string]interface{}, 0) Qu Quan Bu Jie Guo ,Bao Liu Yuan Shi Lei Xing
// results := make([]map[string]string, 0) Qu Quan Bu Jie Guo ,Tong Yi Zhuan Huan Wei string
// results := make([]map[string]int, 0) Qu Quan Bu Jie Guo ,Tong Yi Zhuan Huan Wei int,Bu Ke Zhuan Huan Hui Bao Cuo
// results := make([][]string, 0) Qu Quan Bu Jie Guo ,Cun Wei Shu Zu
// results := userInfo{} Qu Di Yi Xing Shu Ju ,Cun Wei Dui Xiang
// results := map[string]interface{}{} Qu Di Yi Xing Shu Ju ,Cun Wei map
// results := make([]string, 0) Qu Quan Bu Di Yi Lie Shu Ju
// var results int Qu Di Yi Xing Di Yi Lie Shu Ju
func (this *DB) Query(results interface{}, requestSql string, args ...interface{}) error {}
// Zhi Xing Pu Tong Cha Xun ,Fan Hui Ying Xiang Lie Shu
func (this *DB) Exec(requestSql string, args ...interface{}) (int64, error) {}
// Zhi Xing Pu Tong INSERTHuo REPLACE,Fan Hui lastInsertId
func (this *DB) ExecInsert(requestSql string, args ...interface{}) (int64, error) {}
// An Shu Ju Dui Xiang Zi Dong Sheng Cheng INSERTYu Ju Bing Zhi Xing ,dataZhi Chi MapHe Struct
func (this *DB) Insert(table string, data interface{}) (int64, error) {}
// An Shu Ju Dui Xiang Zi Dong Sheng Cheng REPLACEYu Ju Bing Zhi Xing ,dataZhi Chi MapHe Struct
func (this *DB) Replace(table string, data interface{}) (int64, error) {}
// An Shu Ju Dui Xiang Zi Dong Sheng Cheng UPDATEYu Ju Bing Zhi Xing ,dataZhi Chi MapHe Struct
func (this *DB) Update(table string, data interface{}, wheres string, args ...interface{}) (int64, error) {}
// Kai Qi Yi Ge Shi Wu
func (this *DB) Begin() (*Tx, error) {}
// Yu Chu Li
func (this *DB) Prepare(requestSql string) (*Stmt, error) {}
// Zai Shi Wu Zhong Cao Zuo ,Tong (this *DB)
func (this *Tx) Query(results interface{}, requestSql string, args ...interface{}) error {}
func (this *Tx) Exec(requestSql string, args ...interface{}) (int64, error) {}
func (this *Tx) ExecInsert(requestSql string, args ...interface{}) (int64, error) {}
func (this *Tx) Insert(table string, data interface{}) (int64, error) {}
func (this *Tx) Replace(table string, data interface{}) (int64, error) {}
func (this *Tx) Update(table string, data interface{}, wheres string, args ...interface{}) (int64, error) {}
func (this *Tx) Prepare(requestSql string) (*Stmt, error) {
// Ti Jiao
func (this *Tx) Commit() error {
// Hui Gun
func (this *Tx) Rollback() error {
// Pi Liang Zhi Xing ,Fan Hui Shou Ying Xiang De Lie Shu
func (this *Stmt) Exec(args ...interface{}) (int64, error) {}
// Pi Liang Zhi Xing ,Fan Hui lastInsertId
func (this *Stmt) ExecInsert(args ...interface{}) (int64, error) {}
// Guan Bi Yu Chu Li
func (this *Stmt) Close() error {}
Yun Xing Ce Shi Yong Li
Ba tests/db.json.sample Fu Zhi Wei tests/db.json
Xiu Gai Ni Ben Di Shu Ju Ku Lian Jie Xin Xi
Shi Yong github.com/ssgo/base Zhong De passwordMaker Chuang Jian Jia Mi Hou De Mi Ma Xie Ru db.json Zhong De password
Jin Ru tests Mu Lu Yun Xing go test
Xiang Mu Zhong De Pei Zhi
Ba /db.json.sample Fu Zhi Dao Ni Xiang Mu Zhong Ming Ming Wei /db.json
Xiu Gai Ni Ben Di Shu Ju Ku Lian Jie Xin Xi
Shi Yong passwordMaker Chuang Jian Jia Mi Hou De Mi Ma Xie Ru db.json Zhong De password
Zi Ding Yi Jia Mi (Qiang Lie Tui Jian )
Ba /dbInit.go.sample Fu Zhi Dao Ni Xiang Mu Zhong Ming Ming Wei /dbInit.go
Xiu Gai Qi Zhong De key He iv De Nei Rong ,Chang Du Zhi Shao 32Zi Jie ,Bao Chi Yu passwordMaker Zhong Yi Zhi
Ye Ke Yi Yi Qi Ta Fang Shi Zhi Yao Zai init Han Shu Zhong Diao Yong db.SetEncryptKeys She Zhi Pi Pei De keyHe ivJi Ke