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

// CdcLargeNumberChangefeed
// Init CDC Components: tidb cluster / sink (mysql)
// Create amount of changefeeds with config filter, each changefeed sync one sysbench table
// Init and run workload: sysbench
// Wait workload finish: even though workload finished, but it does not mean changefeed has synced all data
// Check consistency.
var _ = common.AddTestCase("cdc_large_number_changefeed", func() steps.Step {
	var (
		loopLifeTime                = time.Hour
		loopCron                    = 1 * time.Second
		changeFeedPrefix            = "cdc-large-number-changefeed-"
		changefeedCategory          = `[filter]`
		changefeeCount              = 300
		dbNameVar                   = common.DBName
		createChangefeedsWithConfig []steps.Step
		removeChangefeed            []steps.Step
		changefeedContentFinishmark = fmt.Sprintf(`rules = ['%s.finishmark']`, common.DBName)
		sqlStatement					= "set GLOBAL max_connections=20000;"
	)
	for i := 0; i <= changefeeCount; i++ {
		tableName := fmt.Sprintf("sbtest%d", i)
		changeFeedName := fmt.Sprintf("%s%d", changeFeedPrefix, i)
		changefeedContent := fmt.Sprintf(`rules = ['%s.%s']`, dbNameVar, tableName)

		createChangefeedsWithConfig = append(createChangefeedsWithConfig, steps.NewChangeFeedConfig(&changefeedCategory, &changefeedContent))
		createChangefeedsWithConfig = append(createChangefeedsWithConfig, steps.NewChangeFeedTask(&ticdc.ChangeFeedCreateFlags{SinkType: ticdc.SinkTypeMySQL, ID: changeFeedName, Config: true}))

		removeChangefeed = append(removeChangefeed, steps.NewChangeFeedTask(&ticdc.ChangeFeedAdminJobFlags{JobType: model.AdminRemove, ID: changeFeedName, ForceRemove: true}))
	}

	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).
		InitChangefeedConfig(&changefeedCategory, &changefeedContentFinishmark).
		OperateChangeFeed(&ticdc.ChangeFeedCreateFlags{SinkType: ticdc.SinkTypeMySQL, ID: "finishmark-task", Config: true}).
		RunLoopTask(loopLifeTime, loopCron, false, createChangefeedsWithConfig...).
		CreateDatabase(common.ResourceHandleSource, dbNameVar).
		ExecuteSqlStatement(common.ResourceHandleMySQL, &sqlStatement).
		InitWorkload(common.ResourceHandleWorkload).
		RunWorkload(common.Spec.GetWorkloadOption(workload.CommandTypePrepare)).
		RunWorkload(common.Spec.GetWorkloadOption(workload.CommandTypeRun)).
		// TODO: Find a new criteria for cdc sync has finished, since "create table finimark" is not the last sql executed.
		Sleep(10 * time.Minute).
		SendFinishMark(dbNameVar).
		WaitFinishMark(common.ResourceHandleMySQL, dbNameVar, 2*time.Hour).
		CheckConsistency(common.ResourceHandleSource, common.ResourceHandleMySQL, dbNameVar).
		DropDatabasesIfExists(common.ResourceHandleSource, &dbNameVar).
		Sleep(1*time.Minute).
		RunLoopTask(loopLifeTime, loopCron, false, removeChangefeed...).
		Build()
},
)