def create_user(user: UserIn, session: Session = Depends()): session.add(User(**user.dict()))
def query_count(session: Session, query: Select) -> int: return session.execute(select( func.count()).select_from(user_cls)).scalar()
def sqla_13_all_users(session: Session = Depends(), paginate: Paginate = Depends()): query = (session.query(user_cls).options(joinedload("notes")).order_by( user_cls.id)) return paginate(query)
def query_count(session: Session, query: DbQuery) -> int: return session.execute(select(func.count(user_cls.id))).scalar()
def query_count(session: Session, query: DbQuery) -> int: return (session.query(user_cls).statement.with_only_columns( [func.count()]).scalar())
def count_user_notes(user_id: int, session: Session = Depends()) -> int: return session.execute( select(func.count( note_cls.id)).where(note_cls.user_id == user_id)).scalar()