from sqlalchemy import Column, String, DateTime, JSON, Enum, ForeignKey, Integer
from sqlalchemy.orm import relationship
from uuid import uuid4, UUID
from datetime import datetime
from app.database import Base
import enum

class CloneStatus(enum.Enum):
    DRAFT = "draft"
    PUBLISHED = "published"
    ARCHIVED = "archived"

class ManagerClone(Base):
    __tablename__ = "manager_clones"

    id = Column(Integer, primary_key=True, index=True)
    clone_id = Column(String, unique=True, default=lambda: str(uuid4()))
    company_id = Column(String, index=True, nullable=False)
    profile = Column(JSON, nullable=False)  # stores ManagerProfile dict
    created_at = Column(DateTime, default=datetime.utcnow)
    # Relationships
    versions = relationship("ManagerCloneVersion", back_populates="clone", cascade="all, delete-orphan")
    knowledge = relationship("ManagerKnowledge", back_populates="clone", cascade="all, delete-orphan")
    blueprints = relationship("ManagerBlueprint", back_populates="clone", cascade="all, delete-orphan")

class ManagerCloneVersion(Base):
    __tablename__ = "manager_clone_versions"

    id = Column(Integer, primary_key=True, index=True)
    version_id = Column(String, unique=True, default=lambda: str(uuid4()))
    clone_id = Column(String, ForeignKey("manager_clones.clone_id"), nullable=False)
    created_by = Column(String, nullable=False)
    status = Column(Enum(CloneStatus), default=CloneStatus.DRAFT)
    created_at = Column(DateTime, default=datetime.utcnow)
    published_at = Column(DateTime, nullable=True)
    configuration_snapshot = Column(JSON, nullable=False)

    clone = relationship("ManagerClone", back_populates="versions")

class ManagerKnowledge(Base):
    __tablename__ = "manager_knowledge"

    id = Column(Integer, primary_key=True, index=True)
    clone_id = Column(String, ForeignKey("manager_clones.clone_id"), nullable=False)
    file_name = Column(String, nullable=False)
    file_path = Column(String, nullable=False)
    extracted_text = Column(JSON, nullable=True)
    uploaded_at = Column(DateTime, default=datetime.utcnow)

    clone = relationship("ManagerClone", back_populates="knowledge")

class ManagerBlueprint(Base):
    __tablename__ = "manager_blueprints"

    id = Column(Integer, primary_key=True, index=True)
    clone_id = Column(String, ForeignKey("manager_clones.clone_id"), nullable=False)
    version_id = Column(String, ForeignKey("manager_clone_versions.version_id"), nullable=False)
    blueprint = Column(JSON, nullable=False)  # stores validated ManagerBlueprint dict
    created_at = Column(DateTime, default=datetime.utcnow)

    clone = relationship("ManagerClone", back_populates="blueprints")
    version = relationship("ManagerCloneVersion")


class ManagerCloneAction(Base):
    """Audit / retrieval row for POST /manager-clones/{id}/actions."""

    __tablename__ = "manager_clone_actions"

    id = Column(Integer, primary_key=True, index=True)
    action_id = Column(String, unique=True, default=lambda: str(uuid4()), index=True)
    clone_id = Column(
        String, ForeignKey("manager_clones.clone_id"), nullable=False, index=True
    )
    module = Column(String, nullable=False)
    action = Column(String, nullable=False)
    status = Column(String, nullable=False, default="succeeded")
    result = Column(JSON, nullable=False, default=dict)
    error = Column(String, nullable=True)
    created_at = Column(DateTime, default=datetime.utcnow)
