# import data types 
from enum import Enum
from sqlalchemy import (Column,
                        Integer,
                        Text, 
                        DateTime, 
                        ForeignKey, 
                        Boolean,
                        func,
                        Enum as SAEnum,
                        String
                        )
from sqlalchemy.orm import relationship, backref
# import base from the db connection file 
from ..db.db_connect import Base


class ResolutionType(str, Enum):
    SUGGESTION = "suggestion"
    RESOLUTION = "resolution"

# Define the Resolution model
class Resolution(Base):
    # name of table
    __tablename__ = "resolutions"
    # define PK
    id = Column(Integer, 
                primary_key=True, 
                index=True
                )
    # define FK from tickets table
    ticket_id = Column(Integer, 
                       ForeignKey("tickets.id", ondelete="CASCADE"), 
                       nullable=False, 
                       index=True
                       )
    # define FK from users table
    author_id = Column(Integer, 
                       ForeignKey("users.id", ondelete="SET NULL"), 
                       nullable=True, 
                       index=True
                       )
    # other relevant data fields
    author_name = Column(String(255), 
                         nullable=True
                         )
                         
    content = Column(Text, 
                     nullable=False
                     )
    
    type = Column(SAEnum(ResolutionType, name="resolution_type"), 
                  nullable=False, 
                  default=ResolutionType.SUGGESTION
                  )
    
    is_accepted = Column(Boolean, 
                         nullable=True
                         )
    
    feedback = Column(Text,
                      nullable=True)
    created_at = Column(DateTime(timezone=True), 
                        nullable=False, 
                        server_default=func.now()
                        )
    updated_at = Column(DateTime(timezone=True), 
                        nullable=False, 
                        server_default=func.now(), 
                        onupdate=func.now()
                        )
    # Define relationships between tickets and users to resolutions
    ticket = relationship(
        "Ticket",
        # When a ticket is deleted, its resolutions are also deleted
        backref=backref("resolutions", passive_deletes=True),
        passive_deletes=True,
    )
    
    author = relationship("User", backref="resolutions")

    def __repr__(self) -> str:
        return (f"<Resolution id={self.id} ticket_id={self.ticket_id} author_id={self.author_id} "f"type={self.type} accepted={self.is_accepted}>" )