package go_ora

import (
	"bytes"
	"database/sql"
	"fmt"
	"reflect"
	"testing"
	"time"
)

var (
	conn      = &Connection{tcpNego: &TCPNego{ServernCharset: 870, ServerCharset: 0x230}}
	expNilPar = ParameterInfo{
		DataType: NCHAR,
		Flag:     3,
		MaxLen:   1,
	}
)

func checkParInfo(par *ParameterInfo, expPar *ParameterInfo) error {
	if par.CharsetForm != expPar.CharsetForm {
		return fmt.Errorf("expected charset form %v and get %v", expPar.CharsetForm, par.CharsetForm)
	}
	if par.CharsetID != expPar.CharsetID {
		return fmt.Errorf("expected charset id %v and get %v", expPar.CharsetID, par.CharsetID)
	}
	if par.DataType != expPar.DataType {
		return fmt.Errorf("expected data type %v and get %v", expPar.DataType, par.DataType)
	}
	if par.Flag != expPar.Flag {
		return fmt.Errorf("expected flag %v and get %v", expPar.Flag, par.Flag)
	}
	if par.ContFlag != expPar.ContFlag {
		return fmt.Errorf("exptected cont flag %v and get %v", expPar.ContFlag, par.ContFlag)
	}
	if par.MaxLen != expPar.MaxLen {
		return fmt.Errorf("expected max len %v and get %v", expPar.MaxLen, par.MaxLen)
	}
	if par.MaxCharLen != expPar.MaxCharLen {
		return fmt.Errorf("expected max char len %v and get %v", expPar.MaxCharLen, par.MaxCharLen)
	}

	if !reflect.DeepEqual(par.iPrimValue, expPar.iPrimValue) {
		return fmt.Errorf("expected primary values %v and get %v", expPar.iPrimValue, par.iPrimValue)
	}
	if bytes.Compare(par.BValue, expPar.BValue) != 0 {
		return fmt.Errorf("expected binary value %v and get %v", expPar.BValue, par.BValue)
	}
	return nil
}

//func testEncodeValue(t *testing.T, title string, par *ParameterInfo, value interface{}, expType TNSType, flag, contFlag, charsetID, charsetForm, maxLen, maxCharLen int) error {
//	t.Log(title)
//	err := par.encodeValue(value, -1, conn)
//	if err != nil {
//		return err
//	}
//	err = checkParInfo(par, expType, flag, contFlag, charsetID, charsetForm, maxLen, maxCharLen)
//	if err != nil {
//		return err
//	}
//	t.Logf("value: %v", par.Value)
//	t.Logf("primitive value: %v", par.iPrimValue)
//	t.Logf("network value: %v", par.BValue)
//	t.Log()
//	return nil
//}

func TestEncodeValue(t *testing.T) {
	// test input parameters
	// test number
	par := &ParameterInfo{Direction: Input}
	var err error
	err = par.encodeValue(-1, conn)
	if err != nil {
		t.Error(err)
		return
	}
	err = checkParInfo(par, &ParameterInfo{
		DataType: NCHAR,
		Flag:     3,
		MaxLen:   1,
	})
	if err != nil {
		t.Error(err)
		return
	}

	par.Value = 5
	err = par.encodeValue(-1, conn)
	if err != nil {
		t.Error(err)
		return
	}

	var val5 *Number
	val5, err = NewNumberFromInt64(5)
	if err != nil {
		t.Error(err)
		return
	}

	err = checkParInfo(par, &ParameterInfo{
		DataType:   NUMBER,
		Flag:       3,
		MaxLen:     22,
		BValue:     []byte{193, 6},
		iPrimValue: val5,
	})
	if err != nil {
		t.Error(err)
		return
	}

	par.Value = 10.9
	err = par.encodeValue(-1, conn)
	if err != nil {
		t.Error(err)
		return
	}

	var val10p9 *Number
	val10p9, err = NewNumberFromFloat(10.9)
	if err != nil {
		t.Error(err)
		return
	}

	err = checkParInfo(par, &ParameterInfo{
		DataType:   NUMBER,
		Flag:       3,
		MaxLen:     22,
		iPrimValue: val10p9,
		BValue:     []byte{193, 11, 91},
	})
	if err != nil {
		t.Error(err)
		return
	}

	par.Value = true
	err = par.encodeValue(-1, conn)
	if err != nil {
		t.Error(err)
		return
	}

	var val1 *Number
	val1, err = NewNumberFromInt64(1)
	if err != nil {
		t.Error(err)
		return
	}

	err = checkParInfo(par, &ParameterInfo{
		DataType:   NUMBER,
		Flag:       3,
		MaxLen:     22,
		iPrimValue: val1,
		BValue:     []byte{193, 2},
	})
	if err != nil {
		t.Error(err)
		return
	}

	par.Value = false
	err = par.encodeValue(-1, conn)
	if err != nil {
		t.Error(err)
		return
	}

	var val0 *Number
	val0, err = NewNumberFromInt64(0)
	if err != nil {
		t.Error(err)
		return
	}

	err = checkParInfo(par, &ParameterInfo{
		DataType:   NUMBER,
		Flag:       3,
		MaxLen:     22,
		iPrimValue: val0,
		BValue:     []byte{128},
	})
	if err != nil {
		t.Error(err)
		return
	}

	par.Value = sql.NullBool{false, true}
	err = par.encodeValue(-1, conn)
	if err != nil {
		t.Error(err)
		return
	}
	err = checkParInfo(par, &ParameterInfo{
		DataType:   NUMBER,
		Flag:       3,
		MaxLen:     22,
		iPrimValue: val0,
		BValue:     []byte{128},
	})
	if err != nil {
		t.Error(err)
		return
	}

	par.Value = sql.NullBool{true, false}
	err = par.encodeValue(-1, conn)
	if err != nil {
		t.Error(err)
		return
	}
	err = checkParInfo(par, &ParameterInfo{
		DataType: NUMBER,
		Flag:     3,
		MaxLen:   22,
	})
	if err != nil {
		t.Error(err)
		return
	}

	par.Value = sql.NullInt32{25, true}
	err = par.encodeValue(-1, conn)
	if err != nil {
		t.Error(err)
		return
	}

	var val25 *Number
	val25, err = NewNumberFromInt64(25)
	if err != nil {
		t.Error(err)
		return
	}

	err = checkParInfo(par, &ParameterInfo{
		DataType:   NUMBER,
		Flag:       3,
		MaxLen:     22,
		iPrimValue: val25,
		BValue:     []byte{193, 26},
	})
	if err != nil {
		t.Error(err)
		return
	}

	par.Value = sql.NullInt32{25, false}
	err = par.encodeValue(-1, conn)
	if err != nil {
		t.Error(err)
		return
	}
	err = checkParInfo(par, &ParameterInfo{
		DataType: NUMBER,
		Flag:     3,
		MaxLen:   22,
	})
	if err != nil {
		t.Error(err)
		return
	}

	stringVal := "this is a test"
	par.Value = stringVal
	err = par.encodeValue(-1, conn)
	if err != nil {
		t.Error(err)
		return
	}

	err = checkParInfo(par, &ParameterInfo{
		DataType:    LongVarChar,
		Flag:        3,
		ContFlag:    16,
		CharsetID:   0x230,
		CharsetForm: 1,
		MaxCharLen:  len(stringVal),
		MaxLen:      len(stringVal),
		iPrimValue:  stringVal,
		BValue:      []byte{116, 104, 105, 115, 32, 105, 115, 32, 97, 32, 116, 101, 115, 116},
	})
	if err != nil {
		t.Error(err)
		return
	}

	par.Value = sql.NullString{stringVal, false}
	err = par.encodeValue(-1, conn)
	if err != nil {
		t.Error(err)
		return
	}
	err = checkParInfo(par, &ParameterInfo{
		DataType:    NCHAR,
		Flag:        3,
		ContFlag:    16,
		CharsetID:   0x230,
		CharsetForm: 1,
		MaxLen:      1,
	})
	if err != nil {
		t.Error(err)
		return
	}

	par.Value = NVarChar(stringVal)
	err = par.encodeValue(-1, conn)
	if err != nil {
		t.Error(err)
		return
	}

	err = checkParInfo(par, &ParameterInfo{
		DataType:    LongVarChar,
		Flag:        3,
		ContFlag:    16,
		CharsetID:   870,
		CharsetForm: 2,
		MaxCharLen:  len(stringVal),
		MaxLen:      len(stringVal),
		iPrimValue:  stringVal,
		BValue:      []byte{116, 104, 105, 115, 32, 105, 115, 32, 97, 32, 116, 101, 115, 116},
	})
	if err != nil {
		t.Error(err)
		return
	}

	par.Value = NullNVarChar{NVarChar(stringVal), false}
	err = par.encodeValue(-1, conn)
	if err != nil {
		t.Error(err)
		return
	}
	err = checkParInfo(par, &ParameterInfo{
		DataType:    NCHAR,
		Flag:        3,
		ContFlag:    16,
		CharsetID:   870,
		CharsetForm: 2,
		MaxLen:      1,
	})
	if err != nil {
		t.Error(err)
		return
	}

	timeVal := time.Date(2023, 5, 28, 23, 38, 11, 500, time.Local)
	par.Value = timeVal
	conn.dataNego = &DataTypeNego{
		clientTZVersion: 1,
		serverTZVersion: 1,
	}
	err = par.encodeValue(-1, conn)
	if err != nil {
		t.Error(err)
		return
	}

	err = checkParInfo(par, &ParameterInfo{
		DataType:   TimeStampTZ_DTY,
		Flag:       3,
		ContFlag:   0,
		MaxLen:     13,
		iPrimValue: timeVal,
		BValue:     []byte{120, 123, 5, 28, 24, 39, 12, 0, 0, 1, 244, 20, 60},
	})
	if err != nil {
		t.Error(err)
		return
	}

	par.Value = sql.NullTime{timeVal, false}
	err = par.encodeValue(-1, conn)
	if err != nil {
		t.Error(err)
		return
	}

	err = checkParInfo(par, &ParameterInfo{
		DataType: TimeStampTZ_DTY,
		Flag:     3,
		MaxLen:   13,
	})
	if err != nil {
		t.Error(err)
		return
	}

	par.Value = TimeStamp(timeVal)
	err = par.encodeValue(-1, conn)
	if err != nil {
		t.Error(err)
		return
	}

	err = checkParInfo(par, &ParameterInfo{
		DataType:   TIMESTAMP,
		Flag:       3,
		ContFlag:   0,
		MaxLen:     11,
		iPrimValue: timeVal,
		BValue:     []byte{120, 123, 5, 28, 24, 39, 12, 0, 0, 1, 244},
	})
	if err != nil {
		t.Error(err)
		return
	}

	par.Value = NullTimeStamp{TimeStamp(time.Now()), false}
	err = par.encodeValue(-1, conn)
	if err != nil {
		t.Error(err)
		return
	}

	err = checkParInfo(par, &ParameterInfo{
		DataType: TIMESTAMP,
		Flag:     3,
		MaxLen:   11,
	})
	if err != nil {
		t.Error(err)
		return
	}

	par.Value = TimeStampTZ(timeVal)
	err = par.encodeValue(-1, conn)
	if err != nil {
		t.Error(err)
		return
	}

	err = checkParInfo(par, &ParameterInfo{
		DataType:   TimeStampTZ_DTY,
		Flag:       3,
		ContFlag:   0,
		MaxLen:     13,
		iPrimValue: timeVal,
		BValue:     []byte{120, 123, 5, 28, 24, 39, 12, 0, 0, 1, 244, 20, 60},
	})
	if err != nil {
		t.Error(err)
		return
	}

	par.Value = NullTimeStampTZ{TimeStampTZ(time.Now()), false}
	err = par.encodeValue(-1, conn)
	if err != nil {
		t.Error(err)
		return
	}
	err = checkParInfo(par, &ParameterInfo{
		DataType: TimeStampTZ_DTY,
		Flag:     3,
		MaxLen:   13,
	})
	if err != nil {
		t.Error(err)
		return
	}
}