// Copyright 2023 PingCAP, Inc.
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
//     http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.

package importer_test

import (
	"context"
	"os"
	"path"
	"testing"

	"github.com/google/uuid"
	"github.com/pingcap/errors"
	"github.com/pingcap/tidb/br/pkg/mock"
	"github.com/pingcap/tidb/pkg/disttask/framework/proto"
	"github.com/pingcap/tidb/pkg/executor/importer"
	"github.com/pingcap/tidb/pkg/lightning/backend/encode"
	"github.com/pingcap/tidb/pkg/lightning/backend/kv"
	"github.com/pingcap/tidb/pkg/lightning/checkpoints"
	"github.com/pingcap/tidb/pkg/lightning/common"
	"github.com/pingcap/tidb/pkg/lightning/config"
	"github.com/pingcap/tidb/pkg/lightning/log"
	"github.com/pingcap/tidb/pkg/lightning/metric"
	"github.com/pingcap/tidb/pkg/lightning/mydump"
	verify "github.com/pingcap/tidb/pkg/lightning/verification"
	tidbmetrics "github.com/pingcap/tidb/pkg/metrics"
	"github.com/pingcap/tidb/pkg/parser/ast"
	"github.com/pingcap/tidb/pkg/parser/model"
	"github.com/pingcap/tidb/pkg/parser/mysql"
	"github.com/pingcap/tidb/pkg/session"
	"github.com/pingcap/tidb/pkg/testkit"
	"github.com/pingcap/tidb/pkg/types"
	"github.com/pingcap/tidb/pkg/util/promutil"
	"github.com/pingcap/tidb/pkg/util/syncutil"
	"github.com/prometheus/client_golang/prometheus"
	"github.com/stretchr/testify/require"
	"go.uber.org/mock/gomock"
)

func getCSVParser(ctx context.Context, t *testing.T, fileName string) mydump.Parser {
	file, err := os.Open(fileName)
	require.NoError(t, err)
	csvParser, err := mydump.NewCSVParser(ctx, &config.CSVConfig{Separator: `,`, Delimiter: `"`},
		file, importer.LoadDataReadBlockSize, nil, false, nil)
	require.NoError(t, err)
	return csvParser
}

func TestFileChunkProcess(t *testing.T) {
	store := testkit.CreateMockStore(t)
	tk := testkit.NewTestKit(t, store)
	ctx := context.Background()
	ctrl := gomock.NewController(t)
	defer ctrl.Finish()
	tempDir := t.TempDir()

	stmt := "create table test.t(a int, b int, c int, key(a), key(b,c))"
	tk.MustExec(stmt)
	do, err := session.GetDomain(store)
	require.NoError(t, err)
	table, err := do.InfoSchema().TableByName(context.Background(), model.NewCIStr("test"), model.NewCIStr("t"))
	require.NoError(t, err)

	fieldMappings := make([]*importer.FieldMapping, 0, len(table.VisibleCols()))
	for _, v := range table.VisibleCols() {
		fieldMapping := &importer.FieldMapping{
			Column: v,
		}
		fieldMappings = append(fieldMappings, fieldMapping)
	}
	logger := log.L()
	mode, err := mysql.GetSQLMode(mysql.DefaultSQLMode)
	require.NoError(t, err)
	encoder, err := importer.NewTableKVEncoder(
		&encode.EncodingConfig{
			SessionOptions: encode.SessionOptions{
				SQLMode: mode,
			},
			Table:  table,
			Logger: logger,
		},
		&importer.TableImporter{
			LoadDataController: &importer.LoadDataController{
				ASTArgs:       &importer.ASTArgs{},
				InsertColumns: table.VisibleCols(),
				FieldMappings: fieldMappings,
			},
		},
	)
	require.NoError(t, err)
	diskQuotaLock := &syncutil.RWMutex{}

	t.Run("process success", func(t *testing.T) {
		var dataKVCnt, indexKVCnt int
		fileName := path.Join(tempDir, "test.csv")
		sourceData := []byte("1,2,3\n4,5,6\n7,8,9\n")
		require.NoError(t, os.WriteFile(fileName, sourceData, 0o644))
		csvParser := getCSVParser(ctx, t, fileName)
		defer func() {
			require.NoError(t, csvParser.Close())
		}()
		metrics := tidbmetrics.GetRegisteredImportMetrics(promutil.NewDefaultFactory(),
			prometheus.Labels{
				proto.TaskIDLabelName: uuid.New().String(),
			})
		ctx = metric.WithCommonMetric(ctx, metrics)
		defer func() {
			tidbmetrics.UnregisterImportMetrics(metrics)
		}()
		bak := importer.MinDeliverRowCnt
		importer.MinDeliverRowCnt = 2
		defer func() {
			importer.MinDeliverRowCnt = bak
		}()

		dataWriter := mock.NewMockEngineWriter(ctrl)
		indexWriter := mock.NewMockEngineWriter(ctrl)
		dataWriter.EXPECT().AppendRows(gomock.Any(), gomock.Any(), gomock.Any()).DoAndReturn(
			func(ctx context.Context, columnNames []string, rows encode.Rows) error {
				dataKVCnt += len(rows.(*kv.Pairs).Pairs)
				return nil
			}).AnyTimes()
		indexWriter.EXPECT().AppendRows(gomock.Any(), gomock.Any(), gomock.Any()).DoAndReturn(
			func(ctx context.Context, columnNames []string, rows encode.Rows) error {
				group := rows.(kv.GroupedPairs)
				for _, pairs := range group {
					indexKVCnt += len(pairs)
				}
				return nil
			}).AnyTimes()

		chunkInfo := &checkpoints.ChunkCheckpoint{
			Chunk: mydump.Chunk{EndOffset: int64(len(sourceData)), RowIDMax: 10000},
		}
		checksum := verify.NewKVGroupChecksumWithKeyspace(nil)
		processor := importer.NewFileChunkProcessor(
			csvParser, encoder, nil,
			chunkInfo, logger.Logger, diskQuotaLock, dataWriter, indexWriter, checksum,
		)
		require.NoError(t, processor.Process(ctx))
		require.True(t, ctrl.Satisfied())
		checksumDataKVCnt, checksumIndexKVCnt := checksum.DataAndIndexSumKVS()
		require.Equal(t, uint64(3), checksumDataKVCnt)
		require.Equal(t, uint64(6), checksumIndexKVCnt)
		dataKVSize, indexKVSize := checksum.DataAndIndexSumSize()
		require.Equal(t, uint64(348), dataKVSize+indexKVSize)
		require.Equal(t, 3, dataKVCnt)
		require.Equal(t, 6, indexKVCnt)
		require.Equal(t, float64(len(sourceData)), metric.ReadCounter(metrics.BytesCounter.WithLabelValues(metric.StateRestored)))
		require.Equal(t, float64(3), metric.ReadCounter(metrics.RowsCounter.WithLabelValues(metric.StateRestored, "")))
		require.Equal(t, uint64(2), *metric.ReadHistogram(metrics.RowEncodeSecondsHistogram).Histogram.SampleCount)
		require.Equal(t, uint64(2), *metric.ReadHistogram(metrics.RowReadSecondsHistogram).Histogram.SampleCount)
	})

	t.Run("encode error", func(t *testing.T) {
		fileName := path.Join(tempDir, "test.csv")
		sourceData := []byte(`1,2,3\n4,aa,6\n7,8,9\n`)
		require.NoError(t, os.WriteFile(fileName, sourceData, 0o644))
		csvParser := getCSVParser(ctx, t, fileName)
		defer func() {
			require.NoError(t, csvParser.Close())
		}()

		dataWriter := mock.NewMockEngineWriter(ctrl)
		indexWriter := mock.NewMockEngineWriter(ctrl)
		dataWriter.EXPECT().AppendRows(gomock.Any(), gomock.Any(), gomock.Any()).Return(nil).AnyTimes()
		indexWriter.EXPECT().AppendRows(gomock.Any(), gomock.Any(), gomock.Any()).Return(nil).AnyTimes()

		chunkInfo := &checkpoints.ChunkCheckpoint{
			Chunk: mydump.Chunk{EndOffset: int64(len(sourceData)), RowIDMax: 10000},
		}
		processor := importer.NewFileChunkProcessor(
			csvParser, encoder, nil,
			chunkInfo, logger.Logger, diskQuotaLock, dataWriter, indexWriter, nil,
		)
		err = processor.Process(ctx)
		require.ErrorIs(t, err, common.ErrEncodeKV)
		require.ErrorContains(t, err, "[Import:ErrCastValue]Value conversion failed for column '")
		require.True(t, ctrl.Satisfied())
	})

	t.Run("invalid file", func(t *testing.T) {
		fileName := path.Join(tempDir, "test.csv")
		sourceData := []byte(`1,"`)
		require.NoError(t, os.WriteFile(fileName, sourceData, 0o644))
		csvParser := getCSVParser(ctx, t, fileName)
		defer func() {
			require.NoError(t, csvParser.Close())
		}()

		dataWriter := mock.NewMockEngineWriter(ctrl)
		indexWriter := mock.NewMockEngineWriter(ctrl)
		dataWriter.EXPECT().AppendRows(gomock.Any(), gomock.Any(), gomock.Any()).Return(nil).AnyTimes()
		indexWriter.EXPECT().AppendRows(gomock.Any(), gomock.Any(), gomock.Any()).Return(nil).AnyTimes()

		chunkInfo := &checkpoints.ChunkCheckpoint{
			Chunk: mydump.Chunk{EndOffset: int64(len(sourceData)), RowIDMax: 10000},
		}
		processor := importer.NewFileChunkProcessor(
			csvParser, encoder, nil,
			chunkInfo, logger.Logger, diskQuotaLock, dataWriter, indexWriter, nil,
		)
		require.ErrorIs(t, processor.Process(ctx), common.ErrEncodeKV)
		require.True(t, ctrl.Satisfied())
	})

	t.Run("data KV write error", func(t *testing.T) {
		fileName := path.Join(tempDir, "test.csv")
		sourceData := []byte("1,2,3\n4,5,6\n7,8,9\n")
		require.NoError(t, os.WriteFile(fileName, sourceData, 0o644))
		csvParser := getCSVParser(ctx, t, fileName)
		defer func() {
			require.NoError(t, csvParser.Close())
		}()

		dataWriter := mock.NewMockEngineWriter(ctrl)
		indexWriter := mock.NewMockEngineWriter(ctrl)
		dataWriter.EXPECT().AppendRows(gomock.Any(), gomock.Any(), gomock.Any()).Return(errors.New("data write error"))

		chunkInfo := &checkpoints.ChunkCheckpoint{
			Chunk: mydump.Chunk{EndOffset: int64(len(sourceData)), RowIDMax: 10000},
		}
		processor := importer.NewFileChunkProcessor(
			csvParser, encoder, nil,
			chunkInfo, logger.Logger, diskQuotaLock, dataWriter, indexWriter, nil,
		)
		require.ErrorContains(t, processor.Process(ctx), "data write error")
		require.True(t, ctrl.Satisfied())
	})

	t.Run("index KV write error", func(t *testing.T) {
		fileName := path.Join(tempDir, "test.csv")
		sourceData := []byte("1,2,3\n4,5,6\n7,8,9\n")
		require.NoError(t, os.WriteFile(fileName, sourceData, 0o644))
		csvParser := getCSVParser(ctx, t, fileName)
		defer func() {
			require.NoError(t, csvParser.Close())
		}()

		dataWriter := mock.NewMockEngineWriter(ctrl)
		indexWriter := mock.NewMockEngineWriter(ctrl)
		dataWriter.EXPECT().AppendRows(gomock.Any(), gomock.Any(), gomock.Any()).Return(nil)
		indexWriter.EXPECT().AppendRows(gomock.Any(), gomock.Any(), gomock.Any()).Return(errors.New("index write error"))

		chunkInfo := &checkpoints.ChunkCheckpoint{
			Chunk: mydump.Chunk{EndOffset: int64(len(sourceData)), RowIDMax: 10000},
		}
		processor := importer.NewFileChunkProcessor(
			csvParser, encoder, nil,
			chunkInfo, logger.Logger, diskQuotaLock, dataWriter, indexWriter, nil,
		)
		require.ErrorContains(t, processor.Process(ctx), "index write error")
		require.True(t, ctrl.Satisfied())
	})
}

func TestImportIntoEncoderCastErrorMessage(t *testing.T) {
	store := testkit.CreateMockStore(t)
	tk := testkit.NewTestKit(t, store)
	tk.MustExec("use test")
	tk.MustExec("create table t(c1 tinyint)")

	do, err := session.GetDomain(store)
	require.NoError(t, err)
	tbl, err := do.InfoSchema().TableByName(context.Background(), model.NewCIStr("test"), model.NewCIStr("t"))
	require.NoError(t, err)

	encoder, err := importer.NewTableKVEncoder(
		&encode.EncodingConfig{
			Table:  tbl,
			Logger: log.L(),
			SessionOptions: encode.SessionOptions{
				SQLMode:   mysql.ModeStrictAllTables,
				Timestamp: 1234567890,
			},
		},
		&importer.TableImporter{
			LoadDataController: &importer.LoadDataController{
				ASTArgs: &importer.ASTArgs{
					ColumnsAndUserVars: []*ast.ColumnNameOrUserVar{{
						ColumnName: &ast.ColumnName{Name: tbl.VisibleCols()[0].Name},
					}},
				},
				FieldMappings: []*importer.FieldMapping{{Column: tbl.VisibleCols()[0]}},
				InsertColumns: tbl.VisibleCols(),
			},
		},
	)
	require.NoError(t, err)
	t.Cleanup(func() { require.NoError(t, encoder.Close()) })

	_, err = encoder.Encode([]types.Datum{types.NewIntDatum(10000000)}, 1)
	require.Error(t, err)
	require.Contains(t, err.Error(), "[Import:ErrCastValue]Value conversion failed for column 'c1'. Expected type: tinyint(4), received value: 10000000. Reason:")
	require.Contains(t, err.Error(), "overflows tinyint")
}

func TestImportIntoEncoderCastEnumErrorMessage(t *testing.T) {
	store := testkit.CreateMockStore(t)
	tk := testkit.NewTestKit(t, store)
	tk.MustExec("use test")
	tk.MustExec("create table t(c1 enum('a','b'))")

	do, err := session.GetDomain(store)
	require.NoError(t, err)
	tbl, err := do.InfoSchema().TableByName(context.Background(), model.NewCIStr("test"), model.NewCIStr("t"))
	require.NoError(t, err)

	encoder, err := importer.NewTableKVEncoder(
		&encode.EncodingConfig{
			Table:  tbl,
			Logger: log.L(),
			SessionOptions: encode.SessionOptions{
				SQLMode:   mysql.ModeStrictAllTables,
				Timestamp: 1234567890,
			},
		},
		&importer.TableImporter{
			LoadDataController: &importer.LoadDataController{
				ASTArgs: &importer.ASTArgs{
					ColumnsAndUserVars: []*ast.ColumnNameOrUserVar{{
						ColumnName: &ast.ColumnName{Name: tbl.VisibleCols()[0].Name},
					}},
				},
				FieldMappings: []*importer.FieldMapping{{Column: tbl.VisibleCols()[0]}},
				InsertColumns: tbl.VisibleCols(),
			},
		},
	)
	require.NoError(t, err)
	t.Cleanup(func() { require.NoError(t, encoder.Close()) })

	_, err = encoder.Encode([]types.Datum{types.NewStringDatum("c")}, 1)
	require.Error(t, err)
	require.Contains(t, err.Error(), "[Import:ErrCastValue]Value conversion failed for column 'c1'. Expected type: enum('a','b'), received value: \"c\". Reason:")
	require.Contains(t, err.Error(), "Data truncated")
}