//nolint:dupl
package sink_endpoint

import (
	"context"

	"github.com/tidbcloud/dataflow-service-ng/app/repo"
	"github.com/tidbcloud/dataflow-service-ng/app/repo/entity"
	"github.com/tidbcloud/pkgv2/bizerr"
	"github.com/tidbcloud/pkgv2/db"
)

type bizSinkEndpointUsageRepoImpl struct {
	dbProvider db.Provider
}

func NewBizSLinkEndpointUsageRepo(dbProvider db.Provider) repo.BizSinkEndpointUsageRepo {
	return &bizSinkEndpointUsageRepoImpl{
		dbProvider: dbProvider,
	}
}

func (m *bizSinkEndpointUsageRepoImpl) Load(
	ctx context.Context, id uint64,
) (*entity.BizSinkEndpointUsage, bizerr.BizError) {
	rdb := m.dbProvider.ReadDB(ctx)
	bizPLEndpointUsage := new(entity.BizSinkEndpointUsage)
	if err := entity.NewBizSinkEndpointUsageQuerySet(rdb).
		IDEq(entity.ID(id)).One(bizPLEndpointUsage); err != nil {
		return nil, bizerr.WrapGormError(err, "load biz_sink_endpoint_usage error")
	}
	return bizPLEndpointUsage, nil
}

func (m *bizSinkEndpointUsageRepoImpl) List(
	ctx context.Context, ops ...repo.BizPrivateLinkEndpointUsageFilterOP,
) ([]entity.BizSinkEndpointUsage, bizerr.BizError) {
	rdb := m.dbProvider.ReadDB(ctx)
	qs := entity.NewBizSinkEndpointUsageQuerySet(rdb)
	for _, op := range ops {
		qs = op(qs)
	}

	var bizPLEndpointUsages []entity.BizSinkEndpointUsage
	if err := qs.All(&bizPLEndpointUsages); err != nil {
		return nil, bizerr.WrapGormError(err, "list biz_sink_endpoint_usages error")
	}
	return bizPLEndpointUsages, nil
}

func (m *bizSinkEndpointUsageRepoImpl) Count(
	ctx context.Context, ops ...repo.BizPrivateLinkEndpointUsageFilterOP,
) (int64, bizerr.BizError) {
	rdb := m.dbProvider.ReadDB(ctx)
	qs := entity.NewBizSinkEndpointUsageQuerySet(rdb)
	for _, op := range ops {
		qs = op(qs)
	}

	total, err := qs.Count()
	if err != nil {
		return 0, bizerr.WrapGormError(err, "count biz_sink_endpoint_usages error")
	}
	return total, nil
}

func (m *bizSinkEndpointUsageRepoImpl) Save(
	ctx context.Context, endpointUsage *entity.BizSinkEndpointUsage,
) bizerr.BizError {
	wdb := m.dbProvider.WriteDB(ctx)
	if err := entity.SaveWithVersioning(wdb, endpointUsage); err != nil {
		return err.Chain("save biz_sink_endpoint_usage error")
	}
	return nil
}

func (m *bizSinkEndpointUsageRepoImpl) Delete(ctx context.Context, id uint64) bizerr.BizError {
	wdb := m.dbProvider.WriteDB(ctx)
	if err := wdb.Delete(&entity.BizSinkEndpointUsage{}, id).Error; err != nil {
		return bizerr.WrapGormError(err, "delete biz_sink_endpoint_usage error")
	}
	return nil
}