package import_cases

import (
	"fmt"
	l4g "github.com/alecthomas/log4go"
	"github.com/tidbcloud/qa-PlatformAPIAuto/models"
	"testing"

	"github.com/dailymotion/allure-go"
	imp "github.com/tidbcloud/qa-PlatformAPIAuto/webScene/import"
)

/* mapping.go contains mapping configure for import test cases.

mapping:
1. single file mapping

cluster type:
1. dedicated cluster in aws
2. dedicated cluster in gcp
3. serverless cluster in aws
*/

type MappingTest struct {
	imp.BaseImportScene
}

func (t *MappingTest) Run() {
	allure.Test(
		t.T,
		allure.Epic("TestImportMapping"),
		allure.Feature("CreateImportTillCompleted"),
		allure.Description("1. single file mapping"),
		allure.Action(func() {
			t.CreateClusterStep()

			// If the provider is aws, we should create import credential one time in the test
			if t.Provider == imp.AwsProvider {
				t.CreateImportCredentialStep()
			}
			// Each test should delete import credential
			//defer t.DeleteImportCredentialStep()

			//import into pre-created tables
			t.initData(true, true, "\"", ",", "TargetTable")
			t.CreateTargetTableStep(MappingTable)
			t.SearchImportFiles()
			t.ImportPreCheckStep()
			t.CreateImportTillCompletedStep()
		}),
	)
}

// RunImportTestMapping is a test case for mapping import case.
func RunImportTestMapping(t *testing.T, clusterId, provider string, isServerless bool) {
	test := &MappingTest{}

	test.Init(t, clusterId, provider, isServerless)
	test.Run()
}

// the table used in this test case
var MappingTable = imp.Table{
	SchemaName:      "test",
	TableName:       "t1",
	SchemaStatement: "CREATE TABLE IF NOT EXISTS `test`.`t1` (\n  `a` int(11) DEFAULT NULL,\n   `b` int(11) GENERATED ALWAYS AS (`a` + 1) VIRTUAL,\n  KEY `idx_v_b` (`b`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;",
}

// initData is used to init import data for different providers
// data should be created previously now, maybe generated by code is better later
func (t *MappingTest) initData(backslashEscape, header bool, delimiter, separator, model string) {
	var importData *models.ClusterIdImportsBody
	var searchImportFile *models.ImportsSearchimportfilesBody
	var precheckData *models.ImportsValidateBody
	var url string
	var csv *models.DataflowCustomCsvFormat
	csv = &models.DataflowCustomCsvFormat{BackslashEscape: backslashEscape, Delimiter: delimiter, Header: header, Null: "\\N", Separator: separator}
	if t.Provider == imp.AwsProvider {
		arn := t.ImportArnName()
		region := "ap-southeast-1"
		url = "s3://import-scene-test/mapping/single-file/"
		importData = &models.ClusterIdImportsBody{
			SourceUrl:      url,
			DataSourceType: int64(imp.ImportDataSourceTypeS3),
			Region:         region,
			DataFormat:     int64(imp.ImportDataFormatCsv),
			AwsRoleArn:     arn,
			CsvFormat:      csv,
		}
		precheckData = &models.ImportsValidateBody{
			AwsRoleArn:     arn,
			DataFormat:     int64(imp.ImportDataFormatCsv),
			DataSourceType: int64(imp.ImportDataSourceTypeS3),
			SourceUrl:      url,
			CheckItems:     []models.DataflowImportValidationItem{models.IMPORT_PRECHECK_DataflowImportValidationItem},
			CsvFormat:      csv,
		}
		searchImportFile = &models.ImportsSearchimportfilesBody{
			AwsRoleArn:     arn,
			DataFormat:     int64(imp.ImportDataFormatCsv),
			DataSourceType: int64(imp.ImportDataSourceTypeS3),
			SourceUri:      url,
		}
	} else {
		importData = &models.ClusterIdImportsBody{
			SourceUrl:      url,
			DataSourceType: int64(imp.ImportDataSourceTypeGcs),
			DataFormat:     int64(imp.ImportDataFormatCsv),
			CsvFormat:      csv,
		}
		precheckData = &models.ImportsValidateBody{
			DataFormat:     int64(imp.ImportDataFormatCsv),
			DataSourceType: int64(imp.ImportDataSourceTypeGcs),
			SourceUrl:      url,
			CheckItems:     []models.DataflowImportValidationItem{models.IMPORT_PRECHECK_DataflowImportValidationItem},
			CsvFormat:      csv,
		}
		searchImportFile = &models.ImportsSearchimportfilesBody{
			DataFormat:     int64(imp.ImportDataFormatCsv),
			DataSourceType: int64(imp.ImportDataSourceTypeGcs),
			SourceUri:      url,
		}
	}
	targetTable := &models.CommonTable{
		Schema: MappingTable.SchemaName,
		Table:  MappingTable.TableName,
	}
	targetTableInfo.TargetTable = targetTable
	targetTableInfo.CustomFile = fmt.Sprintf("%sa!b!.*.csv", url)

	if model == "TargetTable" {
		importData.TargetTableInfos = []models.DataflowImportTargetTableInfo{targetTableInfo}
		precheckData.TargetTableInfos = []models.DataflowImportTargetTableInfo{targetTableInfo}
		searchImportFile.TargetTableInfos = []models.DataflowImportTargetTableInfo{targetTableInfo}
		l4g.Info("precheckData++++++++++", precheckData.TargetTableInfos[0].TargetTable.Schema)
	}

	if t.Provider == imp.GcpProvider {
		t.DeleteCredential()
	}
	t.SetImportData(importData)
	t.SetPrecheckData(precheckData)
	t.SetSearchFileData(searchImportFile)

	// If the provider is gcp, we should create import credential each init new data set
	if t.Provider == imp.GcpProvider {
		t.CreateImportCredentialStep()
	}
}