from sqlalchemy import Column, String, Integer, Text, Boolean, DateTime, ForeignKey, ARRAY
from sqlalchemy.orm import relationship
from datetime import datetime
import uuid
from utils.utils import Base


class Review(Base):
    __tablename__ = "reviews"

    id = Column(String(36), primary_key=True, default=lambda: str(uuid.uuid4()))
    booking_id = Column(String(36), ForeignKey("bookings.id"), nullable=False, index=True)
    customer_id = Column(String(36), ForeignKey("customers.id"), nullable=False, index=True)
    tour_package_id = Column(String(36), ForeignKey("tour_packages.id"), nullable=False, index=True)
    tour_guide_id = Column(String(36), ForeignKey("tour_guides.id"), nullable=True, index=True)
    overall_rating = Column(Integer, nullable=False)
    guide_rating = Column(Integer, nullable=True)
    accommodation_rating = Column(Integer, nullable=True)
    transportation_rating = Column(Integer, nullable=True)
    value_for_money_rating = Column(Integer, nullable=True)
    title = Column(String(255), nullable=True)
    comment = Column(Text, nullable=True)
    photos = Column(ARRAY(String), nullable=True)
    is_verified = Column(Boolean, nullable=False, default=True)
    is_published = Column(Boolean, nullable=False, default=False)
    management_response = Column(Text, nullable=True)
    response_date = Column(DateTime, nullable=True)
    created_at = Column(DateTime, default=datetime.utcnow, nullable=False)
    updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow, nullable=False)

    # Relationships
    booking = relationship("Booking", back_populates="reviews")
    customer = relationship("Customer", back_populates="reviews")
    tour_package = relationship("Tourpackage", back_populates="reviews")
    tour_guide = relationship("Tourguide", back_populates="reviews")