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)
	}

}