package kafka

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

// CdcLargeTransactionKafkaSync
// Init CDC Components: tidb cluster / sink (kafka)
// 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: even though workload finished, but it does not mean changefeed has synced all data
// Check consistency.
var _ = common.AddTestCase("cdc_large_transaction_kafka_sync", func() steps.Step {
	var (
		changeFeedID = "cdc-large-transaction-kafka"
		dbNameVar    = common.DBName
		loopLifeTime = 10 * time.Minute
		loopCron     = 5 * time.Minute
	)
	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.SinkTypeKafka,
			ID:       changeFeedID,
			Options: map[string]string{
				"topic":             "cdc-event-large-transaction",
				"max-message-bytes": "1048576",
				"protocol":          "canal-json",
			},
		}).
		CreateDatabase(common.ResourceHandleSource, dbNameVar).
		InitWorkload(common.ResourceHandleWorkload).
		RunWorkload(common.Spec.GetWorkloadOption(workload.CommandTypePrepare)).
		RunWorkload(common.Spec.GetWorkloadOption(workload.CommandTypeRun)).
		Parallel(
			steps.NewLoopTask(loopLifeTime, 8*time.Minute, true,
				steps.NewSwitchOwner(common.ResourceHandleSource, 20*time.Second),
			),
			steps.NewLoopTask(loopLifeTime, loopCron, true,
				steps.NewExecuteSQL(common.ResourceHandleSource, dbNameVar, "UPDATE sbtest1 SET k=k+1  WHERE id < 2000000"),
			),
		).
		SendFinishMark(dbNameVar).
		// WaitFinishMark(dbName, 1*time.Hour).
		// CheckConsistency(common.ResourceHandleSource, common.ResourceHandleMySQL, dbName).
		DropDatabasesIfExists(common.ResourceHandleSource, &dbNameVar).
		Sleep(1 * time.Minute).
		OperateChangeFeed(&ticdc.ChangeFeedAdminJobFlags{JobType: model.AdminRemove, ID: changeFeedID, ForceRemove: true}).
		Build()
},
)