"""
models/workspace.py
Workspace = organisation/team.
All data is isolated per workspace (multi-tenancy).
"""
import uuid
from datetime import datetime
from sqlalchemy import Column, String, DateTime, Integer, Enum as SAEnum
from sqlalchemy.dialects.postgresql import UUID
from sqlalchemy.orm import relationship
from app.database import Base
import enum


class PlanType(str, enum.Enum):
    starter      = "starter"
    professional = "professional"
    enterprise   = "enterprise"


class Workspace(Base):
    __tablename__ = "workspaces"

    id                 = Column(UUID(as_uuid=True), primary_key=True, default=uuid.uuid4)
    name               = Column(String, nullable=False)
    plan               = Column(SAEnum(PlanType), default=PlanType.starter, nullable=False)
    stripe_customer_id = Column(String, nullable=True, unique=True)
    stripe_sub_id      = Column(String, nullable=True)
    transcripts_used   = Column(Integer, default=0)   # resets monthly
    projects_count     = Column(Integer, default=0)
    billing_cycle_start = Column(DateTime, default=datetime.utcnow)
    created_at         = Column(DateTime, default=datetime.utcnow)
    updated_at         = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)

    users    = relationship("User", back_populates="workspace")
    projects = relationship("Project", back_populates="workspace")

    def __repr__(self):
        return f"<Workspace {self.name} [{self.plan}]>"