29 lines
565 B
Go
29 lines
565 B
Go
package db
|
|
|
|
import (
|
|
"excel_export/biz/util"
|
|
"fmt"
|
|
"github.com/stretchr/testify/assert"
|
|
"testing"
|
|
)
|
|
|
|
const test_db = "renzhiyuan:renzhiyuan@123@tcp(rr-2vcszlj05siu227f9qo.mysql.cn-chengdu.rds.aliyuncs.com:3306)/market?charset=utf8mb4&parseTime=True"
|
|
|
|
func TestDb_Fetch(t *testing.T) {
|
|
p := util.NewProf()
|
|
defer p.Close()
|
|
|
|
db, err := NewDb(test_db)
|
|
assert.Nil(t, err)
|
|
|
|
sql := "select * from `order` limit 10"
|
|
ret, err := db.Fetch(sql)
|
|
assert.Nil(t, err)
|
|
fmt.Printf("%v \n", ret)
|
|
item := ret.Data[0]
|
|
for _, i := range item {
|
|
fmt.Printf("%v", i)
|
|
}
|
|
|
|
}
|