async def get_by_short_name(self, db: AsyncSession, short_name: str) -> Optional[ModelType]:
        """Get a single object by short name.

        Args:
        ----
            db (AsyncSession): The database session.
            short_name (str): The short name of the object  to get.

        Returns:
        -------
            Optional[ModelType]: The object with the given short name.
        """
        result = await db.execute(select(self.model).where(self.model.short_name == short_name))
        return result.unique().scalar_one_or_none()
Get a single object by short name.

        Args:
        ----
            db (AsyncSession): The database session.
            short_name (str): The short name of the object  to get.

        Returns:
        -------
            Optional[ModelType]: The object with the given short name.
        
backend/airweave/crud/_base_system.py