12.3 Iteration G3: Pagination

Add in the will_paginate gem

edit Gemfile

# source 'http://rubygems.org'

gem 'rails', :path => "/home/rubys/git/rails" # '3.1.8'

# Bundle edge Rails instead:

# gem 'rails',     :git => 'git://github.com/rails/rails.git'

gem 'sqlite3'

# Gems used only for assets and not required

# in production environments by default.

group :assets do

  gem 'sass-rails',   :path => "/home/rubys/git/sass-rails" # '~> 3.1.5'

  gem 'coffee-rails', :path => "/home/rubys/git/coffee-rails" # '~> 3.1.1'

  # See https://github.com/sstephenson/execjs#readme for more supported runtimes

  # gem 'therubyracer'

  gem 'uglifier', '>= 1.0.3'

end

gem 'jquery-rails'

# To use ActiveModel has_secure_password

# gem 'bcrypt-ruby', '~> 3.0.0'

# Use unicorn as the web server

# gem 'unicorn'

# Deploy with Capistrano

# gem 'capistrano'

# To use debugger

# gem 'ruby-debug19', :require => 'ruby-debug'

group :test do

  # Pretty printed test output

  gem 'turn', '0.8.2', :require => false

end

gem 'will_paginate', '~> 3.0'

bundle show

Gems included by the bundle:

  * actionmailer (3.1.8)

  * actionpack (3.1.8)

  * activemodel (3.1.8)

  * activerecord (3.1.8)

  * activeresource (3.1.8)

  * activesupport (3.1.8)

  * ansi (1.4.3)

  * arel (2.2.3)

  * builder (3.0.4)

  * bundler (1.2.3)

  * coffee-rails (3.1.1 d58b0eb)

  * coffee-script (2.2.0)

  * coffee-script-source (1.4.0)

  * erubis (2.7.0)

  * execjs (1.4.0)

  * hike (1.2.1)

  * i18n (0.6.1)

  * jquery-rails (2.1.4)

  * json (1.7.5)

  * mail (2.3.3)

  * mime-types (1.19)

  * multi_json (1.2.0)

  * polyglot (0.3.3)

  * rack (1.3.6)

  * rack-cache (1.2)

  * rack-mount (0.8.3)

  * rack-ssl (1.3.2)

  * rack-test (0.6.2)

  * rails (3.1.8 144d747)

  * railties (3.1.8)

  * rake (10.0.2)

  * rdoc (3.12)

  * sass (3.2.3)

  * sass-rails (3.1.6 fc56843)

  * sprockets (2.0.4)

  * sqlite3 (1.3.6)

  * thor (0.14.6)

  * tilt (1.3.3)

  * treetop (1.4.12)

  * turn (0.8.2)

  * tzinfo (0.3.35)

  * uglifier (1.3.0)

  * will_paginate (3.0.3)

Load in a few orders

edit script/load_orders.rb

Order.transaction do

  (1..100).each do |i|

    Order.create(name: "Customer #{i}", address: "#{i} Main Street",

      email: "customer-#{i}@example.com", pay_type: "Check")

end

end

rails runner script/load_orders.rb

Modify the controller to do pagination

edit app/controllers/orders_controller.rb

  def index

    @orders = Order.paginate page: params[:page], order: 'created_at desc',

      per_page: 10

    respond_to do |format|

      format.html # index.html.erb

      format.json { render json: @orders }

end

end

Add some navigational aids

edit app/views/orders/index.html.erb

<h1>Listing orders</h1>

<table>

  <tr>

    <th>Name</th>

    <th>Address</th>

    <th>Email</th>

    <th>Pay type</th>

    <th></th>

    <th></th>

    <th></th>

  </tr>

<% @orders.each do |order| %>

  <tr>

    <td><%= order.name %></td>

    <td><%= order.address %></td>

    <td><%= order.email %></td>

    <td><%= order.pay_type %></td>

    <td><%= link_to 'Show', order %></td>

    <td><%= link_to 'Edit', edit_order_path(order) %></td>

    <td><%= link_to 'Destroy', order, confirm: 'Are you sure?', method: :delete %></td>

  </tr>

<% end %>

</table>

<br />

<%= link_to 'New Order', new_order_path %>

<p><%= will_paginate @orders %></p>

Show the orders

get /orders

Listing orders

Name	Address	Email	Pay type
Customer 100	100 Main Street	customer-100@example.com	Check	Show	Edit	Destroy
Customer 99	99 Main Street	customer-99@example.com	Check	Show	Edit	Destroy
Customer 98	98 Main Street	customer-98@example.com	Check	Show	Edit	Destroy
Customer 97	97 Main Street	customer-97@example.com	Check	Show	Edit	Destroy
Customer 96	96 Main Street	customer-96@example.com	Check	Show	Edit	Destroy
Customer 95	95 Main Street	customer-95@example.com	Check	Show	Edit	Destroy
Customer 94	94 Main Street	customer-94@example.com	Check	Show	Edit	Destroy
Customer 93	93 Main Street	customer-93@example.com	Check	Show	Edit	Destroy
Customer 92	92 Main Street	customer-92@example.com	Check	Show	Edit	Destroy
Customer 91	91 Main Street	customer-91@example.com	Check	Show	Edit	Destroy

← Previous 1 2 3 4 5 6 7 8 9 10 11 Next →