Pagination example with page total and page number

[exit99]

I've successfully implemented offset/limit based pagination, see below. But I need a page where the user can jump between the various pages, so I need to know the total items, as well as current page. Cursor based pagination doesn't do this either, as it only knows the last and next page. Can an example be provided for how to do this page type of pagination? Is it possible?

 def resolve_tickets(self, info, **kwargs):
        offset = kwargs.pop('offset', 0)
        limit = kwargs.pop('limit', 10)
        return TicketType.get_query(info).filter_by(**kwargs).offset(offset).limit(limit).all()

[exit99]

My understanding is that you would use a Connection

[exit99]

This seems to be similiar issue to #58 and is solved via this PR #104'

Lets get it merged in

[hqman]

Hi @Kazanz Could you show a full example about offset base pagination include type defs ? Thanks!

[s3rgeym]

I've successfully implemented offset/limit based pagination, see below. But I need a page where the user can jump between the various pages, so I need to know the total items, as well as current page. Cursor based pagination doesn't do this either, as it only knows the last and next page. Can an example be provided for how to do this page type of pagination? Is it possible?

 def resolve_tickets(self, info, **kwargs):
        offset = kwargs.pop('offset', 0)
        limit = kwargs.pop('limit', 10)
        return TicketType.get_query(info).filter_by(**kwargs).offset(offset).limit(limit).all()

class ConnectionField(SQLAlchemyConnectionField):
  """
  Добавляет человеческую постраничную навигацию вместо хуеты с first и after
  TODO: реализовать фильтры
  """

  def __init__(self, type, *args, **kw):
    super(ConnectionField, self).__init__(
        type, *args, page=graphene.Int(), per_page=graphene.Int(), **kw)

  @classmethod
  def get_query(cls, model, info, page=None, per_page=None, **kw):
    q = super(ConnectionField, cls).get_query(model, info, **kw)
    if per_page:
      q = q.limit(per_page)
    if page:
      q = q.offset((page - 1) * per_page)
    return q

Usage:

query {
  contacts (page: 1, perPage: 10) {
    edges {
      node {
        id
        email
      }
    }
  }
}

[CSGrandeur]

without total_count, the pagination cannot be utilized correctly. Since we don't know how many pages there are.

however, with this "page", "per_page", the total_count by #104 would not be correct any more.

[github-actions]

This issue has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related topics referencing this issue.