def get_latest_items(query_base, sort_col: Column, limit: int): return query_base.order_by(Item.open_timestamp.desc()) \ .limit(15) \ .from_self() \ .order_by(sort_col.asc(), Item.open_timestamp.desc()) \ .limit(limit) \ .all()
def _windowed_lru_digests(self, q: Query, column: Column) -> Iterable[IndexEntry]: """ Generate a query for each window produced by _column_windows and yield the results one by one. """ for whereclause in self._column_windows(q.session, column): window = q.filter(whereclause).order_by(column.asc()) yield from window
def create_query_table(table_name: base, current_page: int, column_name_for_order: Column): """Get a limit count of author or genre or reader records from the DB.""" offset = LIMIT * current_page result: table_name = session \ .query(table_name) \ .order_by(column_name_for_order.asc()) \ .offset(offset) \ .limit(LIMIT) \ .all() return result
def AdminGroup(models): id = Column(Integer, primary_key=True) title = Column(String(250), nullable=False, unique=True) order = Column(Integer, nullable=False, default=0) __mapper_args__ = {'order_by': order.asc()} @property def ru_title(self): from admin.streams.admins import ROLES return dict(ROLES).get(self.title)