package query_set

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 querySetId int64
	BeforeEach(func() {
		_, err := pG.DB.QueryOne(
			pg.Scan(&querySetId),
			"INSERT INTO query_sets (query_set_id, type, flag, name, pin_name, parent_id, status, query_set_info, query_components, sort, created_at, updated_at, deleted_at, context) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING query_set_id",
			"testQuerySetId", "testType", "testFlag", "testName", "testPinName", "testParentId", "testStatus", "testQuerySetInfo", "testQueryComponents", "testSort", "testCreatedAt", "testUpdatedAt", "testDeletedAt", "testContext")
		Expect(err).NotTo(HaveOccurred())
	})
	Describe("根据参数移除查询集合服务", func() {
		Context("传入有效的querySetId", func() {
			It("返回被移除查询集合的数据", func() {
				httpExpect := httpexpect.New(GinkgoT(), server.URL)
				httpExpect.DELETE("/query-sets/{Id}").
					Expect().
					Status(http.StatusOK).
					JSON().
					Object().
					ContainsKey("code").ValueEqual("code", 0).
					ContainsKey("msg").ValueEqual("msg", "ok").
					ContainsKey("data").Value("data").Object()
			})
		})
	})
	AfterEach(func() {
		_, err := pG.DB.Exec("DELETE FROM query_sets WHERE true")
		Expect(err).NotTo(HaveOccurred())
	})
})