"""
Strategy Infrastructure — Scorecard Measure Repository (Django ORM).
"""

from typing import List, Optional
from uuid import UUID

from ...domain.entities.scorecard_measure import ScorecardMeasure
from ...domain.repositories.interfaces import ScorecardMeasureRepository
from ..persistence.models import ScorecardMeasureModel
from .mappers import ScorecardMeasureMapper


class DjangoScorecardMeasureRepository(ScorecardMeasureRepository):

    def find_by_id(self, measure_id: UUID) -> Optional[ScorecardMeasure]:
        try:
            model = ScorecardMeasureModel.objects.get(id=measure_id)
            return ScorecardMeasureMapper.to_entity(model)
        except ScorecardMeasureModel.DoesNotExist:
            return None

    def find_by_perspective(self, perspective_id: UUID) -> List[ScorecardMeasure]:
        qs = ScorecardMeasureModel.objects.filter(perspective_id=perspective_id)
        return [ScorecardMeasureMapper.to_entity(m) for m in qs]

    def save(self, entity: ScorecardMeasure) -> ScorecardMeasure:
        try:
            model = ScorecardMeasureModel.objects.get(id=entity.id)
            model = ScorecardMeasureMapper.to_model(entity, model)
        except ScorecardMeasureModel.DoesNotExist:
            model = ScorecardMeasureMapper.to_model(entity)
        model.save()
        return ScorecardMeasureMapper.to_entity(model)

    def delete(self, measure_id: UUID) -> bool:
        deleted, _ = ScorecardMeasureModel.objects.filter(id=measure_id).delete()
        return deleted > 0