from typing import List, Optional from sqlalchemy.orm import Session from app.crud.base import CRUDBase from app.models.category import Category from app.schemas.category import CategoryCreate, CategoryUpdate class CRUDCategory(CRUDBase[Category, CategoryCreate, CategoryUpdate]): def get_by_name(self, db: Session, *, name: str) -> Optional[Category]: return db.query(Category).filter(Category.name == name).first() def search(self, db: Session, *, query: str, skip: int = 0, limit: int = 100) -> List[Category]: return db.query(Category).filter( Category.name.ilike(f"%{query}%") | Category.description.ilike(f"%{query}%") ).offset(skip).limit(limit).all() category = CRUDCategory(Category)