Agile Web Development with Rails, Edition 4

12.3 Iteration G3: Pagination

Add in the will_paginate gem

edit Gemfile

# source 'https://rubygems.org'

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

gem "arel", :path => "/home/rubys/git/arel"

gem "journey", :path => "/home/rubys/git/journey"

# Bundle edge Rails instead:

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

gem 'sqlite3'

gem 'json'

# 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.2.3'

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

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

  # gem 'therubyracer', :platforms => :ruby

  gem 'uglifier', '>= 1.0.3'

end

gem 'jquery-rails'

# To use ActiveModel has_secure_password

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

# To use Jbuilder templates for JSON

# gem 'jbuilder'

# Use unicorn as the app server

# gem 'unicorn'

# Deploy with Capistrano

# gem 'capistrano'

# To use debugger

# gem 'ruby-debug'

gem 'will_paginate', '~> 3.0'

bundle show

Gems included by the bundle:

  * actionmailer (3.2.8)

  * actionpack (3.2.8)

  * activemodel (3.2.8)

  * activerecord (3.2.8)

  * activeresource (3.2.8)

  * activesupport (3.2.8)

  * arel (3.0.2.20120221150532 b454667)

  * builder (3.0.3)

  * bundler (1.2.0)

  * coffee-rails (3.2.2 c8f3df3)

  * coffee-script (2.2.0)

  * coffee-script-source (1.3.3)

  * erubis (2.7.0)

  * execjs (1.4.0)

  * hike (1.2.1)

  * i18n (0.6.1)

  * journey (1.0.4.20120614141756 ebe574d)

  * jquery-rails (2.1.3)

  * json (1.7.5)

  * mail (2.4.4)

  * mime-types (1.19)

  * multi_json (1.3.6)

  * polyglot (0.3.3)

  * rack (1.4.1)

  * rack-cache (1.2)

  * rack-ssl (1.3.2)

  * rack-test (0.6.2)

  * rails (3.2.8 b65c40e)

  * railties (3.2.8)

  * rake (0.9.2.2)

  * rdoc (3.12)

  * sass (3.2.1)

  * sass-rails (3.2.5 bdfeb7b)

  * sprockets (2.7.0)

  * sqlite3 (1.3.6)

  * thor (0.16.0)

  * tilt (1.3.3)

  * treetop (1.4.11)

  * tzinfo (0.3.33)

  * 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, :method => :delete,

              :data => { :confirm => 'Are you sure?' } %></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 →