def get_variables(session, limit: Optional[int], offset: Optional[int] = None) -> Response: """ Get all variable values """ total_entries = session.query(func.count(Variable.id)).scalar() query = session.query(Variable).order_by(Variable.id) if offset: query = query.offset(offset) if limit: query = query.limit(limit) variables = query.all() return variable_collection_schema.dump({ "variables": variables, "total_entries": total_entries, })
def get_variables(session, limit: Optional[int], order_by: str = "id", offset: Optional[int] = None) -> Response: """Get all variable values""" total_entries = session.query(func.count(Variable.id)).scalar() to_replace = {"value": "val"} allowed_filter_attrs = ['value', 'key', 'id'] query = session.query(Variable) query = apply_sorting(query, order_by, to_replace, allowed_filter_attrs) variables = query.offset(offset).limit(limit).all() return variable_collection_schema.dump({ "variables": variables, "total_entries": total_entries, })