package testcase

import (
	"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/pkg/utils"
	"github.com/pingcap/test-infra/caselib/ticdc/common"
	"github.com/pingcap/test-infra/common/model/resource"
	"github.com/pingcap/tiflow/cdc/model"
)

// cdc_ddl_coverage_sync
// TODO list: will add minio get file for .sql file in the future
// check if CDC support various ddl
// create tidb cluster / mysql / workload
// create changefeed
// create database named `workload`
// execute sql statement in upstream
// wait for sync process finish
// check the data consistence between upstream and downstream
var _ = common.AddTestCase("cdc_ddl_coverage_sync", func() steps.Step {
	var (
		ddlStatement string
		lightningRes  = &resource.ResourceHandle{}
		opts          = &steps.LightningImportOpts{}
		dbNameVar     = common.DBName
		changeFeedID  = "cdc-ddl-coverage-sync-1"
	)
	return steps.
		NewBuilder().
		LoadEnv().
		LoadParamFromEnv(utils.ParamPrefix+"ddlstatement", &ddlStatement).
		LoadResourceFromEnv("TI_PARAM_RES_upstream", common.ResourceHandleSource).
		LoadResourceFromEnv("TI_PARAM_RES_downstream", common.ResourceHandleMySQL).
		LoadResourceFromEnv("TI_PARAM_RES_workload", common.ResourceHandleWorkload).
		LoadResourceFromEnv(utils.ParamPrefix+"import_basic_opts", opts).
		LoadResourceFromEnv(utils.ResourcePrefix+"lightning", lightningRes).
		//EnableTiDBGeneralLog(common.ResourceHandleSource).
		InitCDCComponents(common.ResourceHandleSource, common.ResourceHandleMySQL).
		OperateChangeFeed(&ticdc.ChangeFeedCreateFlags{SinkType: ticdc.SinkTypeMySQL, ID: changeFeedID}).
		CreateDatabase(common.ResourceHandleSource, common.DBName).
		Sleep(20 * time.Second).
		OperateChangeFeed(&ticdc.ChangeFeedAdminJobFlags{JobType: model.AdminStop, ID: changeFeedID}).
		CreateDatabase(common.ResourceHandleSource, common.DBName).
		InitWorkload(common.ResourceHandleWorkload).
		RunWorkload(common.Spec.GetWorkloadOption(workload.CommandTypePrepare)).
		OperateChangeFeed(&ticdc.ChangeFeedAdminJobFlags{JobType: model.AdminResume, ID: changeFeedID}).
		//dbName is workload, table name is sbtest1 in this case. DDL must execute in this table.
		Parallel(
			steps.NewExecuteSqlStatements(common.ResourceHandleSource, &ddlStatement),
			).
		LightningImport(opts, lightningRes, common.ResourceHandleSource).
		SendFinishMark(common.DBName).
		WaitFinishMark(common.ResourceHandleMySQL, common.DBName, 15*time.Hour).
		CheckConsistency(common.ResourceHandleSource, common.ResourceHandleMySQL, common.DBName).
		DropDatabasesIfExists(common.ResourceHandleSource, &dbNameVar).
		Sleep(1 * time.Minute).
		OperateChangeFeed(&ticdc.ChangeFeedAdminJobFlags{JobType: model.AdminRemove, ID: changeFeedID, ForceRemove: true}).
		Build()
},
)