Fitzsimmons/arel.rb

Created October 31, 2012 19:19

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Fitzsimmons/3989225.js"></script>
Save Fitzsimmons/3989225 to your computer and use it in GitHub Desktop.

Download ZIP

Modify an existing arel query to use the window function for the non_paged_count

Raw

arel.rb

	results = arel.
	select("COUNT(#{table_name}.id) OVER () AS non_paged_count, #{table_name}.*").
	offset(offset).
	limit(per_page).all

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment