"""
models/validation.py
Stores user validations of code results (correct/incorrect markings).
Used to build ground truth for confusion matrix and accuracy calculation.
"""
import uuid
from datetime import datetime
from sqlalchemy import Column, String, Boolean, DateTime, ForeignKey
from sqlalchemy.dialects.postgresql import UUID
from sqlalchemy.orm import relationship
from app.database import Base


class Validation(Base):
    __tablename__ = "validations"

    id              = Column(UUID(as_uuid=True), primary_key=True, default=uuid.uuid4)
    project_id      = Column(UUID(as_uuid=True), ForeignKey("projects.id", ondelete="CASCADE"), nullable=False)
    code_result_id  = Column(UUID(as_uuid=True), ForeignKey("code_results.id", ondelete="CASCADE"), nullable=False, unique=True)
    is_correct      = Column(Boolean, nullable=False)
    correct_group   = Column(String(255), nullable=True)
    correct_theme   = Column(String(255), nullable=True)
    correct_code    = Column(String(500), nullable=True)
    validated_by    = Column(UUID(as_uuid=True), ForeignKey("users.id"), nullable=True)
    created_at      = Column(DateTime, default=datetime.utcnow)

    def __repr__(self):
        return f"<Validation {self.code_result_id} correct={self.is_correct}>"