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()