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

// cdc periodically DDL case
// create tidb cluster / mysql / workload
// create changefeed
// create database named `workload`
// create table / truncate table / drop table periodically
// send finishmark
// wait for finishmark
// check the changefeed status whether is normal or not.
var _ = common.AddTestCase("cdc_periodic_ddl", func() steps.Step {
	var (
		changeFeedID          = "periodic-ddl-sync"
		loopLifeTime          = time.Hour
		loopCron              = 2 * time.Second
		waitFinishMarkTimeout = time.Hour

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

		dbNameVar = common.DBName
	)

	var loopSteps []steps.Step
	loopSteps = append(loopSteps, steps.NewRunWorkload(prepareOption)) // only prepare table, no need to run
	for _, name := range prepareOption.GetTableNames() {
		query := fmt.Sprintf("truncate table %s", name)
		loopSteps = append(loopSteps, steps.NewExecuteSQL(common.ResourceHandleSource, dbNameVar, query))

		query = fmt.Sprintf("drop table %s", name)
		loopSteps = append(loopSteps, 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).
		DropDatabasesIfExists(common.ResourceHandleSource, &dbNameVar).
		DropDatabasesIfExists(common.ResourceHandleMySQL, &dbNameVar).
		OperateChangeFeed(&ticdc.ChangeFeedCreateFlags{SinkType: ticdc.SinkTypeMySQL, ID: changeFeedID}).
		CreateDatabase(common.ResourceHandleSource, dbNameVar).
		InitWorkload(common.ResourceHandleWorkload).
		RunLoopTask(loopLifeTime, loopCron, false, loopSteps...).
		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()
})