package table

import (
	"github.com/go-pg/pg/v10"
	"net/http"

	"github.com/gavv/httpexpect"
	. "github.com/onsi/ginkgo"
	. "github.com/onsi/gomega"
	pG "gitlab.fjmaimaimai.com/allied-creation/character-library-metadata-bastion/pkg/infrastructure/pg"
)

var _ = Describe("返回表服务列表", func() {
	var tableId int64
	BeforeEach(func() {
		_, err := pG.DB.QueryOne(
			pg.Scan(&tableId),
			"INSERT INTO tables (table_id, table_type, name, sql_name, parent_id, data_field_index, pk, data_fields, manual_fields, created_at, updated_at, deleted_at, version) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING table_id",
			"testTableId", "testTableType", "testName", "testSQLName", "testParentId", "testDataFieldIndex", "testPK", "testDataFields", "testManualFields", "testCreatedAt", "testUpdatedAt", "testDeletedAt", "testVersion")
		Expect(err).NotTo(HaveOccurred())
	})
	Describe("根据参数返回表列表", func() {
		Context("传入有效的参数", func() {
			It("返回表数据列表", func() {
				httpExpect := httpexpect.New(GinkgoT(), server.URL)
				httpExpect.GET("/tables/").
					WithQuery("offset", "int").
					WithQuery("limit", "int").
					Expect().
					Status(http.StatusOK).
					JSON().
					Object().
					ContainsKey("code").ValueEqual("code", 0).
					ContainsKey("msg").ValueEqual("msg", "ok").
					ContainsKey("data").Value("data").Object().
					ContainsKey("count").ValueEqual("count", 1).
					ContainsKey("tables").Value("tables").Array()
			})
		})
	})
	AfterEach(func() {
		_, err := pG.DB.Exec("DELETE FROM tables WHERE true")
		Expect(err).NotTo(HaveOccurred())
	})
})