package sqluser

import (
	"strconv"
	"testing"

	"github.com/smartystreets/goconvey/convey"
	"go.uber.org/mock/gomock"

	globalserverlessv1 "github.com/tidbcloud/tidb-management-service/api/spec/global/serverless/v1"
	regionalserverlessv1 "github.com/tidbcloud/tidb-management-service/api/spec/regional/serverless/v1"
	"github.com/tidbcloud/tidb-management-service/serverless-global-service/domain/adapter/mock_adapter"
	"github.com/tidbcloud/tidb-management-service/serverless-global-service/domain/repository/mock_repository"
	"github.com/tidbcloud/tidb-management-service/serverless-global-service/domain/testdata"
	"github.com/tidbcloud/tidb-management-service/utilities/clusterproxy/mock_clusterproxy"
)

func TestDeleteUserSvc(t *testing.T) {
	convey.Convey("TesDeleteUserSvc", t, func() {
		ctrl := gomock.NewController(t)
		defer ctrl.Finish()

		clusterRepo := mock_repository.NewMockClusterRepo(ctrl)
		clusterProxy := mock_clusterproxy.NewMockClusterProxy(ctrl)
		clusterProxyProvider := mock_clusterproxy.NewMockProvider(ctrl)
		encryptSvc := mock_adapter.NewMockEncryptorService(ctrl)
		regionalSvc := mock_adapter.NewMockRegionalService(ctrl)
		sys9Lifecycle := mock_adapter.NewMockSys9Lifecycle(ctrl)
		cluster := testdata.GetCluster()
		regionalCluster := testdata.GetRegionalCluster()

		clusterIdInt, err := strconv.ParseUint(cluster.ClusterId, 10, 64)
		convey.So(err, convey.ShouldBeNil)

		req := &globalserverlessv1.SqlUserServiceDeleteSqlUserRequest{
			Operator:  testdata.GetDBUserOperator(),
			ClusterId: cluster.ClusterId,
			Username:  "u1",
		}
		params := &DeleteUserParams{
			Operator: testdata.GetDBUserOperator(),
			Cluster:  regionalCluster,
			Username: "u1",
		}
		// enable token-based auth
		cluster.Attributes.TokenBasedAuthEnabled = true
		svc := NewSqlUserService(encryptSvc, clusterProxyProvider, clusterRepo, regionalSvc, sys9Lifecycle, nil, nil)

		convey.Convey("Delete", func() {
			regionalSvc.EXPECT().
				ListCluster(gomock.Any(), gomock.Any(), gomock.Any()).
				Return([]*regionalserverlessv1.ServerlessRegionalServiceClusterInfo{regionalCluster}, nil)
			clusterRepo.EXPECT().Get(gomock.Any(), cluster.ClusterId, false).Return(cluster, nil)
			clusterProxyProvider.EXPECT().
				GetClusterProxy(gomock.Any(), clusterIdInt, regionalCluster.ProxyEndpoint, regionalCluster.Version, BuildClusterOperator(req.Operator)).
				Return(clusterProxy, nil)
			clusterProxy.EXPECT().ExecuteSQL(gomock.Any(), `DROP USER IF EXISTS 'u1';`)

			err := svc.DeleteSqlUser(testdata.Ctx, req)
			convey.So(err, convey.ShouldBeNil)
		})
		convey.Convey("checkParams", func() {
			convey.Convey("should be ok if all is well", func() {
				err := deleteSqlUserCheck(params, cluster)
				convey.So(err, convey.ShouldBeNil)
			})
		})
	})
}