from sqlalchemy import Column, Integer, String, Boolean, DateTime, func
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship

Base = declarative_base()

class Category(Base):
    __tablename__ = "categories"

    id = Column(Integer, primary_key=True, index=True)
    category_name = Column(String, nullable=False)
    category_desc = Column(String, nullable=False)
    is_active = Column(Boolean, nullable=False, default=True)
    created_at = Column(DateTime, nullable=False, server_default=func.now())  # Valeur par défaut
    def category_to_dict(self):
        return {
            "id": self.id,
            "category_name": self.category_name,
            "category_desc": self.category_desc,
            "is_active": self.is_active,
            "created_at": self.created_at
    }
    def as_dict(self):
        return {
            "id": self.id,
            "category_name": self.category_name,
            "category_desc": self.category_desc,
            "is_active": self.is_active,
            "created_at": self.created_at
        }
    # employees = relationship("Employee", back_populates="category")