from typing import Optional
from uuid import UUID as uuid_UUID
from fastapi_users import schemas
from fastapi_users.db import SQLAlchemyBaseUserTableUUID
from sqlalchemy import ForeignKey, Column, UUID
from sqlalchemy.orm import relationship, Mapped

from .Principal import Principal
from .UserTenant import UserTenant
from .UserRole import UserRole
from .Role import Role
from .Tenant import Tenant


class User(SQLAlchemyBaseUserTableUUID, Principal):
    __tablename__ = "users"

    id = Column(UUID, ForeignKey("principals.id", ondelete="CASCADE"), primary_key=True)

    # Foreign key to current Tenant (Many-to-One relationship)
    tenant_id = Column(UUID, ForeignKey("tenants.id"))

    # Parent user — when an agent/service user creates datasets, the parent
    # inherits full permissions automatically. Null for regular human users.
    parent_user_id = Column(UUID, ForeignKey("users.id", ondelete="SET NULL"), nullable=True)

    # Many-to-Many Relationship with Roles
    roles: Mapped[list["Role"]] = relationship(
        "Role",
        secondary=UserRole.__tablename__,
        back_populates="users",
    )

    # Many-to-Many Relationship with Tenants user is a part of
    tenants: Mapped[list["Tenant"]] = relationship(
        "Tenant",
        secondary=UserTenant.__tablename__,
        back_populates="users",
    )

    # ACL Relationship (One-to-Many)
    acls = relationship("ACL", back_populates="principal", cascade="all, delete")

    __mapper_args__ = {
        "polymorphic_identity": "user",
    }


# Keep these schemas in sync with User model
class UserRead(schemas.BaseUser[uuid_UUID]):
    tenant_id: Optional[uuid_UUID] = None
    parent_user_id: Optional[uuid_UUID] = None


class UserCreate(schemas.BaseUserCreate):
    is_verified: bool = True
    parent_user_id: Optional[uuid_UUID] = None


class UserUpdate(schemas.BaseUserUpdate):
    pass