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/ticdc/common"
	"github.com/pingcap/tiflow/cdc/model"
)

// CdcLargeTransactionSync
// Init CDC Components: tidb cluster / sink (mysql)
// Create a changefeed
// Init Workload: sysbench
// sysbench oltp_insert to load more than 1GB data in each table
// Update 2000000 rows (1GB) data in one of table(sbtest1)
// Wait workload finish
// Check consistency.
var _ = common.AddTestCase("cdc_large_transaction_sync", func() steps.Step {
	var (
		changeFeedID  = "cdc-large-transaction-mysql"
		dbNameVar     = common.DBName
		loopLifeTime1 = 10 * time.Minute
		loopCron1     = 5 * time.Minute
		loopLifeTime2 = 1 * time.Minute
		loopCron2     = 2 * time.Second
		sql1GB        = "UPDATE sbtest1 SET k=k+1  WHERE id < 1000000"
		sql100MB      = "UPDATE sbtest2 SET k=k+1  WHERE id < 100000"
	)
	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).
		Sleep(10*time.Second).
		OperateChangeFeed(&ticdc.ChangeFeedCreateFlags{SinkType: ticdc.SinkTypeMySQL, ID: changeFeedID}).
		CreateDatabase(common.ResourceHandleSource, dbNameVar).
		InitWorkload(common.ResourceHandleWorkload).
		RunWorkload(common.Spec.GetWorkloadOption(workload.CommandTypePrepare)).
		RunWorkload(common.Spec.GetWorkloadOption(workload.CommandTypeRun)).
		Parallel(
			steps.NewLoopTask(loopLifeTime1, 8*time.Minute, true,
				steps.NewSwitchOwner(common.ResourceHandleSource, 20*time.Second),
			),
			steps.NewLoopTask(loopLifeTime1, loopCron1, true,
				steps.NewExecuteSQL(common.ResourceHandleSource, dbNameVar, sql1GB),
			),
		).
		Parallel(
			steps.NewRunWorkload(common.Spec.GetWorkloadOption(workload.CommandTypeRun)),
			steps.NewLoopTask(loopLifeTime2, loopCron2, true,
				steps.NewExecuteSQL(common.ResourceHandleSource, dbNameVar, sql100MB),
			),
		).
		SendFinishMark(dbNameVar).
		WaitFinishMark(common.ResourceHandleMySQL, dbNameVar, 6*time.Hour).
		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()
},
)