package benchbot

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/tiflow/cdc/model"
)

// CDCBenchbotSysbench
// Init CDC Components: tidb cluster / sink (mysql)
// Create a changefeed
// Init/prepare/run Workload: tpcc
// Record the time when workload run completed
// Wait workload finish
// Get and save all perf data
// Update perf data to database
var _ = common.AddTestCase("cdc_benchbot_sysbench", func() steps.Step {
	var (
		changeFeedID = "cdc-benchbot-sysbench"
		dbNameVar    = common.DBName
		dbForPrepare = "test1"
		executeSql   = new(string)
		dbs 		 string
		runStartTime = new(time.Time)
	)

	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).
		LoadParamFromEnv(utils.ParamPrefix+"dsn", &dbs).
		InitCDCComponents(common.ResourceHandleSource, common.ResourceHandleMySQL).
		OperateChangeFeed(&ticdc.ChangeFeedCreateFlags{SinkType: ticdc.SinkTypeMySQL, ID: changeFeedID}).
		Sleep(20 * time.Second).
		DropDatabasesIfExists(common.ResourceHandleSource, &dbNameVar).
		CreateDatabase(common.ResourceHandleSource, dbNameVar).
		CreateDatabase(common.ResourceHandleSource, dbForPrepare).
		InitWorkload(common.ResourceHandleWorkload).
		RunWorkload(common.Spec.GetWorkloadOption(workload.CommandTypePrepare)).
		SendFinishMark(dbForPrepare).
		Sleep(1 * time.Minute).
		WaitFinishMark(common.ResourceHandleMySQL, dbForPrepare, 1*time.Hour).

		RunWorkload(common.Spec.GetWorkloadOption(workload.CommandTypeRun)).
		RecordTime(runStartTime).
		WatchCDCTiKVOOM(common.ResourceHandleSource).
		GetCDCVersion(common.ResourceHandleSource).
		GetCDCMetrics(common.ResourceHandleSource, runStartTime).
		GenerateCDCPerfSql(common.ResourceHandleSource, executeSql).
		ExecuteSqlOnPulibcDatabase(&dbs, executeSql).
		DropDatabasesIfExists(common.ResourceHandleSource, &dbNameVar).
		Sleep(1 * time.Minute).
		OperateChangeFeed(&ticdc.ChangeFeedAdminJobFlags{JobType: model.AdminRemove, ID: changeFeedID, ForceRemove: true}).
		Build()
},
)