package testcase

import (
	"fmt"
	"time"

	"github.com/pingcap/test-infra/caselib/pkg/model/ticdc"
	"github.com/pingcap/test-infra/caselib/pkg/model/workload"
	"github.com/pingcap/test-infra/caselib/pkg/steps"
	"github.com/pingcap/test-infra/caselib/ticdc/common"
	"github.com/pingcap/tiflow/cdc/model"
)

// truncate_table_sync
// create tidb cluster / mysql / workload
// create changefeed
// create database named `workload`
// run workload with sysbench, see yaml for detail
// truncate table periodically, 2s per one
// send finishmark
// wait for finishmark
// check the changefeed status whether is normal or not.
var _ = common.AddTestCase("cdc_truncate_table_sync", func() steps.Step {
	var (
		changeFeedID          = "truncate-table-sync"
		loopLifeTime          = time.Hour
		loopCron              = 2 * time.Second
		waitFinishMarkTimeout = 5 * time.Hour

		prepareOption = common.Spec.GetWorkloadOption(workload.CommandTypePrepare)
		runOption     = common.Spec.GetWorkloadOption(workload.CommandTypeRun)

		dbNameVar = common.DBName
	)

	var truncateTables []steps.Step
	for _, name := range prepareOption.GetTableNames() {
		query := fmt.Sprintf("truncate table %s", name)
		truncateTables = append(truncateTables, steps.NewExecuteSQL(common.ResourceHandleSource, dbNameVar, query))
	}

	return steps.
		NewBuilder().
		LoadEnv().
		LoadResourceFromEnv("TI_PARAM_RES_upstream", common.ResourceHandleSource).
		LoadResourceFromEnv("TI_PARAM_RES_downstream", common.ResourceHandleMySQL).
		LoadResourceFromEnv("TI_PARAM_RES_workload", common.ResourceHandleWorkload).
		InitCDCComponents(common.ResourceHandleSource, common.ResourceHandleMySQL).
		OperateChangeFeed(&ticdc.ChangeFeedCreateFlags{SinkType: ticdc.SinkTypeMySQL, ID: changeFeedID}).
		CreateDatabase(common.ResourceHandleSource, dbNameVar).
		InitWorkload(common.ResourceHandleWorkload).
		RunWorkload(prepareOption).
		RunWorkload(runOption).
		RunLoopTask(loopLifeTime, loopCron, false, truncateTables...).
		SendFinishMark(dbNameVar).
		WaitFinishMark(common.ResourceHandleMySQL, dbNameVar, waitFinishMarkTimeout).
		CheckConsistency(common.ResourceHandleSource, common.ResourceHandleMySQL, dbNameVar).
		DropDatabasesIfExists(common.ResourceHandleSource, &dbNameVar).
		Sleep(1 * time.Minute).
		OperateChangeFeed(&ticdc.ChangeFeedAdminJobFlags{JobType: model.AdminRemove, ID: changeFeedID, ForceRemove: true}).
		Build()
})