package service

import (
	"database/sql"
	"encoding/json"
	"fmt"
	"testing"

	_ "github.com/go-sql-driver/mysql"

	"xiaoniaokuaiyan.com/xiaoniao/config"
	"xiaoniaokuaiyan.com/xiaoniao/dal"
	"xiaoniaokuaiyan.com/xiaoniao/entity"
	"xiaoniaokuaiyan.com/xiaoniao/util"
)

func TestGetByCateId(t *testing.T) {
	psrv := &ProductService{
		dal.DefaultProductDal,
	}
	cateIds := []int{11}
	pager := dal.Pager{
		PageIndex: 1,
		PageSize:  1000,
	}
	sp := dal.SortParam{
		SortBy:  "PRICE",
		SortDir: -1,
	}
	data, err := psrv.ProductGetByCateId(cateIds, pager, 0, sp)
	if err != nil {
		t.Fatal(err)
	}
	dl := data.([]*entity.ProductDB)
	for _, pitem := range dl {
		fmt.Printf("%+v", pitem)
	}
}

func TestGetProductById(t *testing.T) {
	psrv := &ProductService{
		dal.DefaultProductDal,
	}
	r, err := psrv.ProductGet([]int{3})
	if err != nil {
		t.Fatal(err)
	}
	buf, _ := json.Marshal(r)
	fmt.Println(string(buf))
}

func TestPureGetCateId(t *testing.T) {
	db, err := sql.Open("mysql", "xiaoniao_n:xn654^%$@(123.57.224.234:3306)/xiaoniao_db")
	if err != nil {
		t.Fatal(err)
	}
	rows, err := db.Query("select t2.id from t_product t2 left join t_product_category_product t1 on t1.product_id = t2.id where t1.cat_id = ? and t2.is_putaway = 0 and t2.is_delete = 0 order by sort_no desc limit ?,?", 6, 0, 1000)
	if err != nil {
		t.Fatal(err)
	}
	var pid uint64
	for rows.Next() {
		rows.Scan(&pid)
		fmt.Println(pid)
	}
}

func TestScanOrder(t *testing.T) {
	db, err := sql.Open("mysql", "xiaoniao_n:xn654^%$@(123.57.224.234:3306)/xiaoniao_db")
	if err != nil {
		t.Fatal(err)
	}
	rows, err := db.Query("select * from t_order order by created_at desc limit 5")
	if err != nil {
		t.Fatal(err)
	}
	olist := []entity.Order{}
	err = util.ScanStruct(rows, &olist)
	if err != nil {
		t.Fatal(err)
	}
	for _, oitem := range olist {
		fmt.Println(oitem)
	}
}

func TestGetTop(t *testing.T) {
	config.Reload("config.ini")
	psrv := &ProductService{
		dal.DefaultProductDal,
	}
	data, err := psrv.GetTop(3, 1)
	if err != nil {
		t.Fatal(err)
	}
	fmt.Println(data)

}