package bench

const (
	tpccCmdTplCloud             = `go-tpc tpcc --host %s -P%s --warehouses %d run -D %s -T %s --time %s -p %s >> tpcc.output`
	benchmarksqlCmdTplCloud     = `cd benchmarksql/run; ./run.sh %s %s %s %d %s %d "%s" %s`
	chCmdTplCloud               = `go-tpc ch --host %s -P%s --warehouses %d run -D %s -T %s -t %s --queries %s --ignore-error --refresh-conn-wait 10s --conn-params="tidb_mem_quota_query=128849018880" --time %s -p %s >> ch.output`
	ycsbCmdTplCloud             = `go-ycsb run mysql -P /ycsb/workloads/%s -p mysql.host=%s -p mysql.port=%s -p threadcount=%s %s -p mysql.password=%s>> ycsb.output`
	sysbenchCmdTplCloud         = `sysbench %s run --mysql-host=%s --mysql-port=%s --mysql-user=root --db-driver=mysql --mysql-db=%s --threads=%s --time=%d --report-interval=10 %s --mysql-password=%s >> sysbench.output`
	tpchCmdTplCloud             = `go-tpc -H %s -P%s -D %s tpch --sf=50 --queries %s run --time %s -p %s--use-explain --conn-params="tidb_opt_distinct_agg_push_down=1&tidb_mem_quota_query=128849018880"  2>explain.txt 1>>tpch.output`
	tpchCmdTpl2Cloud            = `go-tpc -H %s -P%s -D %s tpch --sf=100 --queries %s run --time %s -p %s --use-explain --conn-params="tidb_isolation_read_engines='tiflash'&tidb_allow_mpp=1&tidb_opt_broadcast_join=0&tidb_mem_quota_query=128849018880" 2>explain.txt 1>>tpch.output`
	bankCmdTplCloud             = `bank --dsn "root:%s@tcp(%s:%s)/%s?charset=utf8&parseTime=True" run --transaction "open:1%%,deposit:5%%,draw:5%%,transfer:60%%,query:5%%,detquery:4%%,pay:20%%,intsettle:0,verify:0" --threads %s --time %d --amount-min 1  --amount-max 1 --log-level warn  --log-file /tmp/banktest.log  --xlsx-file /tmp/result.xlsx --prepare-stmt true --use-sql-driver >> bank.output`
	rawSQLCmdTplCloud           = `go-tpc rawsql run --use-explain -p %s -H %s -P%s -D %s --query-files %s --conn-params="tidb_mem_quota_query=128849018880" --time %s 2>../explain.txt 1>>../%s.output`
	mysqlCmdTplCloud            = `mysql -p%s --host %s -P%s -D %s -e "%s"`
	mysqlCmdTpl2Cloud           = `mysql -p%s --host %s -P%s -D %s -e '%s' -c | tee -a log.log`
	shenmaCmdTplCloud           = `bash ./shenma.sh "root:%s:@tcp(%s:%s)/test" %s >> shenma.output`
	corebankingCmdTplCloud      = `bash ./corebanking.sh %s %s %s %d %s "%s" %s %s >> corebanking.output`
	commitCmpTplCloud           = `mysql -p%s --host %s -P%s -N -e"select distinct concat('[',type,']') component_type, concat('version:',version,',') version,concat('git_hash:',git_hash) git_hash from information_schema.cluster_info" >> %s.output`
	truncateSysbenchTablesCloud = `mysql -p %s --host %s --port %s -Nse 'show tables' %s | while read table; do mysql -p %s --host %s --port %s -e "truncate table $table" %s; done`
	defaultDSNCloud             = "root:%s@tcp(%s:%s)/%s"
	cloudMonitorURL             = "https://grafana.oauth.staging.shared.aws.tidbcloud.com/d/eDbRZpnWa2/performance-overview?var-cluster_id=%s&&var-tenant_id=%s&from=%d&to=%d"
)