Extra Pagy to work with cursor pagination
Add this line to your application's Gemfile:
gem 'pagy_cursor'
And then execute:
$ bundle install
Include the backend in some controller:
require "pagy_cursor/pagy/extras/cursor"
require "pagy_cursor/pagy/extras/uuid_cursor"
include Pagy::Backend
Default
pagy_cursor(Post.all)
Before and After
pagy_cursor(Post.all, after: 10)
pagy_cursor(Post.all, before: 10)
With UUID
pagy_uuid_cursor(Post.all, after: "ce5d2741-4e52-49b2-bb76-c41b67ab3aad")
pagy_uuid_cursor(Post.all, before: "ce5d2741-4e52-49b2-bb76-c41b67ab3aad")
Ordering collection
pagy_cursor(Post.all, after: 10, order: {updated_at: :desc})
Many thanks to:
- SQLite
- Postgresql
- MySQL
To run tests in root folder of gem:
export DB=sqlite3
to work with sqlite (see support databases)bundle install
bundle exec rspec
To test on specific Rails version
export BUNDLE_GEMFILE=gemfiles/active_record_70.gemfile
to work with Rails 7
To play with app cd test/dummy and rails s -b 0.0.0.0 (before rails db:migrate).
The gem is available as open source under the terms of the MIT License.