from sqlalchemy import Column, String, Integer, Float, DateTime, Boolean, Text, LargeBinary, JSON, ForeignKey
from datetime import datetime, timezone

from app.db.base import Base

class Video(Base):
    """Database model for video metadata."""
    __tablename__ = "videos"
    
    id = Column(String, primary_key=True, index=True)
    original_filename = Column(String, nullable=False)
    upload_date = Column(DateTime, default=lambda: datetime.now(timezone.utc))
    file_path = Column(String, nullable=False)
    size = Column(Integer, nullable=False)
    duration = Column(Float, nullable=True)
    status = Column(String, default="uploaded")
    
class ProcessingResult(Base):
    """Database model for video processing results."""
    __tablename__ = "processing_results"
    
    id = Column(String, primary_key=True, index=True)
    video_id = Column(String, ForeignKey('videos.id'), nullable=False)
    processing_date = Column(DateTime, default=lambda: datetime.now(timezone.utc))
    transcript = Column(Text, nullable=True)
    emotion_analysis = Column(JSON, nullable=True)
    overall_summary = Column(Text, nullable=True)
    transcript_analysis = Column(JSON, nullable=True)
    recommendations = Column(JSON, nullable=True) 
    body_language_analysis = Column(JSON, nullable=True)
    body_language_data = Column(JSON, nullable=True)
    eye_contact_analysis = Column(JSON, nullable=True)
    eye_contact_data = Column(JSON, nullable=True)
    face_analysis_data = Column(JSON, nullable=True)

class User(Base):
    """Database model for user data."""
    __tablename__ = "users"
    
    id = Column(String, primary_key=True, index=True)
    email = Column(String, unique=True, index=True, nullable=False)
    first_name = Column(String, nullable=False)
    last_name = Column(String, nullable=False)
    hashed_password = Column(String, nullable=False)
    created_at = Column(DateTime, default=lambda: datetime.now(timezone.utc))
    updated_at = Column(DateTime, default=lambda: datetime.now(timezone.utc), onupdate=lambda: datetime.now(timezone.utc))
    is_active = Column(Boolean, default=True)