package import_cases

import (
	"github.com/tidbcloud/qa-PlatformAPIAuto/models"
	"testing"

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

/* source_database.go contains basic operation for import test cases.

operations:
1. aurora

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

type SourceDatabasesTest struct {
	imp.BaseImportScene
}

func (t *SourceDatabasesTest) Run() {
	allure.Test(
		t.T,
		allure.Epic("TestImportSourceDatabases"),
		allure.Feature("CreateImportTillCompleted"),
		allure.Description("1. create aurora database"),
		allure.Action(func() {
			t.CreateClusterStep()
			t.CreateTargetTableStep(auroraOperationTable)
			// 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 schema and data from s3
			// each test should init data
			t.initData(imp.ImportDataFormatAurora, "NoTargetTable")
			t.ImportPreCheckStep()
			t.CreateImportTillCompletedStep()

			//import into pre-created tables
			t.TruncateTargetTableStep(auroraOperationTable)
			t.initData(imp.ImportDataFormatAurora, "TargetTable")
			t.SearchImportFiles()
			t.ImportPreCheckStep()
			t.CreateImportTillCompletedStep()
		}),
	)
}

// RunImportTestBasicOperationInDedicatedAws is a test case for
// basic import operations, like create import, cancel import, in dedicated aws.
func RunImportTestSourceDatabases(t *testing.T, clusterId, provider string, isServerless bool) {
	test := &SourceDatabasesTest{}

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

var auroraOperationTable = imp.Table{
	SchemaName:      "test",
	TableName:       "item",
	SchemaStatement: "CREATE TABLE IF NOT EXISTS `test`.`item` (\n\t  `i_id` int(11) NOT NULL,\n\t  `i_im_id` int(11) DEFAULT NULL,\n\t  `i_name` varchar(24) DEFAULT NULL,\n\t  `i_price` decimal(5,2) DEFAULT NULL,\n\t  `i_data` varchar(50) DEFAULT NULL,\n\t  PRIMARY KEY (`i_id`)\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 *SourceDatabasesTest) initData(dataFormat imp.ImportDataFormat, model string) {
	var importData *models.ClusterIdImportsBody
	var searchImportFile *models.ImportsSearchimportfilesBody
	var precheckData *models.ImportsValidateBody
	var url string
	targetTable := &models.CommonTable{
		Schema: auroraOperationTable.SchemaName,
		Table:  auroraOperationTable.TableName,
	}
	targetTableInfo.TargetTable = targetTable
	targetTableInfo.CustomFile = ""
	if t.Provider == imp.AwsProvider {
		url = "s3://import-scene-test/source-database/aurora-parquet/"
		arn := t.ImportArnName()
		region := "ap-southeast-1"
		importData = &models.ClusterIdImportsBody{
			SourceUrl:      url,
			DataSourceType: int64(imp.ImportDataSourceTypeS3),
			Region:         region,
			DataFormat:     int64(dataFormat),
			AwsRoleArn:     arn,
		}
		precheckData = &models.ImportsValidateBody{
			DataFormat:     int64(dataFormat),
			DataSourceType: int64(imp.ImportDataSourceTypeS3),
			SourceUrl:      url,
			CheckItems:     []models.DataflowImportValidationItem{models.IMPORT_PRECHECK_DataflowImportValidationItem},
			AwsRoleArn:     arn,
		}
		searchImportFile = &models.ImportsSearchimportfilesBody{
			DataFormat:     int64(dataFormat),
			DataSourceType: int64(imp.ImportDataSourceTypeS3),
			SourceUri:      url,
			AwsRoleArn:     arn,
		}
	}

	if model == "TargetTable" {
		importData.TargetTableInfos = []models.DataflowImportTargetTableInfo{targetTableInfo}
		precheckData.TargetTableInfos = []models.DataflowImportTargetTableInfo{targetTableInfo}
		searchImportFile.TargetTableInfos = []models.DataflowImportTargetTableInfo{targetTableInfo}
	}

	t.SetImportData(importData)
	t.SetPrecheckData(precheckData)
	t.SetSearchFileData(searchImportFile)
}