from pydantic import BaseModel
from typing import Optional
from datetime import datetime

class CategorySchema(BaseModel):
    id: int
    category_name: str
    category_desc: str
    is_active: bool
    created_at: datetime

    class Config:
        from_attributes = True  # Permet de convertir SQLAlchemy → Pydantic

class EmployeeSchema(BaseModel):
    id: int
    first_name: str
    last_name: str
    matricule: str
    mail: str
    is_active: bool
    created_at: datetime
    last_update: datetime
    category: Optional[CategorySchema]  # Inclure la catégorie associée

    class Config:
        from_attributes = True