package releaseacc

import (
	"sync"

	"github.com/kweaver-ai/kweaver-core/decision-agent/agent-backend/agent-factory/src/drivenadapter/dbaccess"
	"github.com/kweaver-ai/kweaver-core/decision-agent/agent-backend/agent-factory/src/infra/cmp/icmp"
	"github.com/kweaver-ai/kweaver-core/decision-agent/agent-backend/agent-factory/src/infra/common/global"
	"github.com/kweaver-ai/kweaver-core/decision-agent/agent-backend/agent-factory/src/port/driven/idbaccess"
	"github.com/kweaver-ai/kweaver-go-lib/logger"

	"github.com/kweaver-ai/proton-rds-sdk-go/sqlx"
)

var (
	releaseCategoryRelRepoOnce sync.Once
	releaseCategoryRelRepoImpl idbaccess.IReleaseCategoryRelRepo
)

type releaseCategoryRelRepo struct {
	idbaccess.IDBAccBaseRepo

	db     *sqlx.DB
	logger icmp.Logger
}

var _ idbaccess.IReleaseCategoryRelRepo = &releaseCategoryRelRepo{}

func NewReleaseCategoryRelRepo() idbaccess.IReleaseCategoryRelRepo {
	releaseCategoryRelRepoOnce.Do(func() {
		releaseCategoryRelRepoImpl = &releaseCategoryRelRepo{
			db:             global.GDB,
			logger:         logger.GetLogger(),
			IDBAccBaseRepo: dbaccess.NewDBAccBase(),
		}
	})

	return releaseCategoryRelRepoImpl
}
