You are previewing Learning Rails 3.

Learning Rails 3

Cover of Learning Rails 3 by Eric J Gruber... Published by O'Reilly Media, Inc.
  1. Learning Rails 3
  2. SPECIAL OFFER: Upgrade this ebook with O’Reilly
  3. Preface
    1. Who This Book Is For
    2. Who This Book Is Not For
    3. What You’ll Learn
    4. Ruby and Rails Style
    5. Other Options
    6. Rails Versions
    7. If You Have Problems Making Examples Work
    8. If You Like (or Don’t Like) This Book
    9. Conventions Used in This Book
    10. Using Code Examples
    11. Safari® Books Online
    12. How to Contact Us
    13. Acknowledgments
  4. 1. Starting Up Ruby on Rails
    1. If You Run Windows, You’re Lucky
    2. Getting Started at the Command Line
    3. Starting Up Rails
    4. Test Your Knowledge
      1. Quiz
      2. Answers
  5. 2. Rails on the Web
    1. Creating Your Own View
    2. What Are All Those Folders?
    3. Adding Some Data
    4. How Hello World Works
    5. Adding Logic to the View
    6. Test Your Knowledge
      1. Quiz
      2. Answers
  6. 3. Adding Web Style
    1. I Want My CSS!
    2. Specifying Stylesheets
    3. Creating a Layout for a Controller
    4. Choosing a Layout from a Controller
    5. Sharing Template Data with the Layout
    6. Setting a Default Page
    7. Test Your Knowledge
      1. Quiz
      2. Answers
  7. 4. Managing Data Flow: Controllers and Models
    1. Getting Started, Greeting Guests
    2. Application Flow
    3. Keeping Track: A Simple Guestbook
      1. Connecting to a Database Through a Model
      2. Connecting the Controller to the Model
    4. Finding Data with ActiveRecord
    5. Test Your Knowledge
      1. Quiz
      2. Answers
  8. 5. Accelerating Development with Scaffolding and REST
    1. A First Look at Scaffolding
    2. REST and Controller Best Practices
      1. Websites and Web Applications
      2. Toward a Cleaner Approach
    3. Examining a RESTful Controller
      1. Index: An Overview of Data
      2. Show: Just One Row of Data
      3. New: A Blank Set of Data Fields
      4. Edit: Hand Me That Data, Please
      5. Create: Save Something New
      6. Put This Updated Record In
      7. Destroy It
    4. Escaping the REST Prison
    5. Test Your Knowledge
      1. Quiz
      2. Answers
  9. 6. Presenting Models with Forms
    1. More Than a Name on a Form
    2. Generating HTML Forms with Scaffolding
    3. Form as a Wrapper
    4. Creating Text Fields and Text Areas
    5. Labels
    6. Creating Checkboxes
    7. Creating Radio Buttons
    8. Creating Selection Lists
    9. Dates and Times
    10. Creating Helper Methods
    11. Test Your Knowledge
      1. Quiz
      2. Answers
  10. 7. Strengthening Models with Validation
    1. Without Validation
    2. The Original Model
    3. The Power of Declarative Validation
    4. Managing Secrets
      1. Customizing the Message
      2. Limiting Choices
      3. Testing Format with Regular Expressions
      4. Seen It All Before
      5. Numbers Only
    5. A Place on the Calendar
      1. Testing for Presence
    6. Beyond Simple Declarations
      1. Test It Only If
      2. Do It Yourself
    7. Test Your Knowledge
      1. Quiz
      2. Answers
  11. 8. Improving Forms
    1. Adding a Picture by Uploading a File
      1. File Upload Forms
      2. Model and Migration Changes
      3. Results
    2. Standardizing Your Look with Form Builders
      1. Supporting Your Own Field Types
      2. Adding Automation
      3. Integrating Form Builders and Styles
    3. Test Your Knowledge
      1. Quiz
      2. Answers
  12. 9. Developing Model Relationships
    1. Connecting Awards to Students
      1. Establishing the Relationship
      2. Supporting the Relationship
      3. Guaranteeing a Relationship
    2. Connecting Students to Awards
      1. Removing Awards When Students Disappear
      2. Counting Awards for Students
    3. Nesting Awards in Students
      1. Changing the Routing
      2. Changing the Controller
      3. Changing the Award Views
      4. Connecting the Student Views
      5. Is Nesting Worth It?
    4. Many-to-Many: Connecting Students to Courses
      1. Creating Tables
      2. Connecting the Models
      3. Adding to the Controllers
      4. Adding Routing
      5. Supporting the Relationship Through Views
    5. What’s Missing?
    6. Test Your Knowledge
      1. Quiz
      2. Answers
  13. 10. Managing Databases with Migrations
    1. What Migrations Offer You
    2. Migration Basics
      1. Migration Files
      2. Running Migrations Forward and Backward
    3. Inside Migrations
      1. Working with Tables
      2. Data Types
      3. Working with Columns
      4. Indexes
      5. Other Opportunities
    4. Test Your Knowledge
      1. Quiz
      2. Answers
  14. 11. Debugging
    1. Creating Your Own Debugging Messages
    2. Raising Exceptions
    3. Logging
    4. Working with Rails from the Console
    5. The Ruby Debugger
    6. Test Your Knowledge
      1. Quiz
      2. Answers
  15. 12. Testing
    1. Test Mode
    2. Setting Up a Test Database with Fixtures
    3. Unit Testing
    4. Functional Testing
      1. Calling Controllers
      2. Testing Responses
      3. Dealing with Nested Resources
    5. Integration Testing
    6. Beyond the Basics
    7. Test Your Knowledge
      1. Quiz
      2. Answers
  16. 13. Sessions and Cookies
    1. Getting Into and Out of Cookies
    2. Storing Data Between Sessions
    3. Test Your Knowledge
      1. Quiz
      2. Answers
  17. 14. Users and Authentication
    1. Installation
    2. Storing Identities
    3. Storing User Data
    4. Wiring OmniAuth into the Application
    5. Classifying Users
    6. More Options
    7. Test Your Knowledge
      1. Quiz
      2. Answers
  18. 15. Routing
    1. Creating Routes to Interpret URIs
      1. Specifying Routes with match
      2. Globbing
      3. Regular Expressions and Routing
      4. A Domain Default with root
      5. Named Routes
      6. Mapping Resources
      7. Nesting Resources
      8. Route Order and Priority
      9. Checking the Map
    2. Generating URIs from Views and Controllers
      1. Pointing url_for in the Right Direction
      2. Adding Options
    3. Infinite Possibilities
    4. Test Your Knowledge
      1. Quiz
      2. Answers
  19. 16. From CSS to SASS
    1. Getting Started
    2. Sassy Style
      1. Variables
      2. Mixins
      3. Nesting
    3. Making Everything Work Together
      1. Becoming Sassier
    4. Test Your Knowledge
      1. Quiz
      2. Answers
  20. 17. Managing Assets and Bundles
    1. The Junk Drawer
      1. Sprockets
      2. Dissecting The Pipeline
      3. Putting It All Together
      4. Bundler
    2. Test Your Knowledge
      1. Quiz
      2. Answers
  21. 18. Sending Code to the Browser: JavaScript and CoffeeScript
    1. Sending JavaScript to the Browser
    2. Simplifying with CoffeeScript
      1. Have Some Sugar with your CoffeeScript
      2. Converting to CoffeeScript
    3. Test Your Knowledge
      1. Quiz
      2. Answers
  22. 19. Mail in Rails
    1. Sending Mail Messages
    2. Receiving Mail
      1. Setup
      2. Processing Messages
    3. Test Your Knowledge
      1. Quiz
      2. Answers
  23. 20. Pushing Further into Rails
    1. Changing to Production Mode
    2. Deploying Is Much More Than Programming
    3. Joining the Rails Ecosystem
      1. Keep Up with Rails
      2. Ruby
      3. Working With and Around Rails
      4. Keep Exploring
  24. A. An Incredibly Brief Introduction to Ruby
    1. How Ruby Works
    2. How Rails Works
    3. Getting Started with Classes and Objects
    5. Variables, Methods, and Attributes
      1. Variables
      2. Methods
      3. Attributes
    6. Logic and Conditionals
      1. Operators
      2. if, else, unless, and elsif
      3. ?:
      4. case and when
      5. Loops
      6. Many More Possibilities
  25. B. An Incredibly Brief Introduction to Relational Databases
    1. Tables of Data
      1. Connecting Tables
      2. Using Tables to Connect Tables
      3. Granularity
    2. Databases, Tables, and Rails
  26. C. An Incredibly Brief Guide to Regular Expressions
    1. What Regular Expressions Do
    2. Starting Small
    3. The Simplest Expressions: Literal Strings
    4. Character Classes
    5. Escaping
    6. Modifiers
    7. Anchors
    8. Sequences, Repetition, Groups, and Choices
    9. Greed
    10. More Possibilities
  27. D. Glossary
    1. Speaking in Rails
  28. Index
  29. About the Authors
  30. Colophon
  31. SPECIAL OFFER: Upgrade this ebook with O’Reilly
  32. Copyright

Chapter 4. Managing Data Flow: Controllers and Models

It’s time to meet the key player in Rails applications. Controllers are the components that determine how to respond to user requests and coordinate responses. They’re at the heart of what many people think of as “the program” in your Rails applications, though in many ways they’re more of a switchboard. They connect the different pieces that do the heavy lifting, providing a focal point for application development. The model is the foundation of your application’s data structures, which will let you get information into and out of your databases.


Controllers are important, certainly a “key player,” but don’t get too caught up in them. When coming from other development environments, it’s easy to think that controllers are the main place you should put application logic. As you get deeper into Rails, you’ll likely learn the hard way that a lot of code you thought belonged in the controller really belonged in the model, or sometimes in the view.

Getting Started, Greeting Guests

Controllers are Ruby objects. They’re stored in the app/controllers directory of your application. Each controller has a name, and the object inside of the controller file is called nameController.

Demonstrating controllers without getting tangled in all of Rails’ other components is difficult, so for an initial tour, the application will be incredibly simple. (You can see the first version of it in ch04/guestbook01.) Guestbooks were a common (if kind of annoying) feature on early websites, letting visitors “post messages” so that the site’s owner could tell who’d been there. (The idea has since evolved into more sophisticated messaging, like Facebook’s Timeline.)


If you’ve left any Rails applications from earlier chapters running under rails server, it would be wise to turn them off before starting a new application.

To get started, create a new Rails application, as we did in Chapter 1. If you’re working from the command line, type:

      rails new guestbook

Rails will create the usual pile of files and folders. Next, you’ll want to change to the guestbook directory and create a controller:

cd guestbook
rails generate controller entries
    create  app/controllers/entries_controller.rb
    invoke  erb
    create    app/views/entries
    invoke  test_unit
    create    test/functional/entries_controller_test.rb
    invoke  helper
    create    app/helpers/entries_helper.rb
    invoke    test_unit
    create      test/unit/helpers/entries_helper_test.rb
	invoke  assets
	invoke    coffee
	create      app/assets/javascripts/
	invoke    scss
    create      app/assets/stylesheets/entries.css.scss

If you then look at app/controllers/entries_controller.rb, which is the main file we’ll work with here, you’ll find:

class EntriesController < ApplicationController

This doesn’t do very much. However, there’s an important relationship in that first line. Your EntriesController inherits from ApplicationController. The ApplicationController object lives in app/controllers/application_controller.rb, and it also doesn’t do very much initially, but if you ever need to add functionality that is shared by all of the controllers in your application, you can put it into the ApplicationController object.

To make this controller actually do something, we’ll add a method. For right now, we’ll call it sign_in, creating the very simple object in Example 4-1.

Example 4-1. Adding an initial method to an empty controller

class EntriesController < ApplicationController

  def sign_in



We’ll also need a view, so that Rails has something it can present to visitors. You can create a sign_in.html.erb file in the app/views/entries/ directory, and then edit it, as shown in Example 4-2.


You can also have Rails create a method in the controller, as well as a basic view at the same time that it created the controller, by typing:

rails generate controller entries sign_in

You can work either way, letting Rails generate as much (or as little) code as you like.

Example 4-2. A view that lets users see a message and enter their name

<h1>Hello <%= @name %></h1>

<%= form_tag :action => 'sign_in' do %>
   <p>Enter your name:
   <%= text_field_tag 'visitor_name', @name %></p>

   <%= submit_tag 'Sign in' %>

<% end %>

Example 4-2 has a lot of new pieces to it because it’s using helper methods to create a basic form. Helper methods take arguments and return text, which in this case is HTML that helps build your form. The following particular helpers are built into Rails, but you can also create your own:

  • The form_tag method takes the name of our controller method, sign_in, as its :action parameter.

  • The text_field_tag method takes two parameters and uses them to create a form field on the page. The first, visitor_name, is the identifier that the form will use to describe the field data it sends back to the controller, while the second is default text that the field will contain. If the user has filled out this form previously, and our controller populates the @name variable, it will list the user’s name. Otherwise, it will be blank.

  • The last helper method, submit_tag, provides the button that will send the data from the form back to the controller when the user clicks it.

Once again, you’ll need to enable routing for your controller. You’ll need to edit the config/routes.rb file. Remove the # that has been bolded below:

# match ':controller(/:action(/:id))(.:format)'

If you start up the server and visit http://localhost:3000/entries/sign_in, you’ll see a simple form like Figure 4-1.

A simple form generated by a Rails view

Figure 4-1. A simple form generated by a Rails view

Now that we have a way to send data to our controller, it’s time to update the controller so that it does something with that information. In this very simple case, it just means adding a line, as shown in Example 4-3.

Example 4-3. Making the sign_in method do something

class EntriesController < ApplicationController

  def sign_in
    @name = params[:visitor_name]


The extra line gets the visitor_name parameter from the request header sent back by the client and puts it into @name. (If there wasn’t a visitor_name parameter, as would be normal the first time this page is loaded, @name will just be blank.)

If you enter a name into the form, you’ll now get a pretty basic hello message in return, as shown in Figure 4-2. The name will also be sitting in the form field for another round of greetings.

A greeting that includes the name that was entered

Figure 4-2. A greeting that includes the name that was entered


If, instead of Figure 4-2, you get a strange error message about “wrong number of arguments (1 for 0),” check your code carefully. You’ve probably added a space between params and [, which produces a syntax error whose description isn’t exactly clear. (This seems to have gone away in Ruby 1.9.2.)

The controller is now receiving information from the user and passing it to a view, which can then pass more information.

There is one other minor point worth examining before we move on, though: how did Rails convert the http://localhost:3000/entries/sign_in URL into a call to the sign_in method of the entries controller? If you look in the config directory of your application, you’ll find the routes.rb file, which contains the rule we enabled for choosing what gets called when a request comes in:

match ':controller(/:action(/:id(.:format)))'

In this case, entries mapped to :controller, and sign_in mapped to :action. Rails used this simple mapping to decide what to call. We don’t have an :id or a :format—yet. (And as Chapter 2 demonstrated, if there hadn’t been an :action, Rails would have defaulted to an :action named index.) Figure 4-3 shows how Rails breaks down a URL to decide where to go.

How the default Rails routing rules break a URL down into component parts to decide which method to run (needs rules at top updated)

Figure 4-3. How the default Rails routing rules break a URL down into component parts to decide which method to run (needs rules at top updated)


You can also see your routes by typing rake routes from the command line. This gives you a slightly more compact version and shows how Rails interpreted the routes.rb file.

Application Flow

The Rails approach to handling requests, shown in Figure 4-4, has a lot of moving parts between users and data.

How Rails breaks down web applications

Figure 4-4. How Rails breaks down web applications

Rails handles URL processing instead of letting the web server pick which file to execute in response to the request. This allows Rails to use its own conventions for deciding how a request gets handled, called routing, and it allows developers to create their own routing conventions to meet their applications’ needs.

The router sends the request information to a controller. The controller decides how to handle the request, centralizing the logic for responding to different kinds of requests. The controller may interact with a data model (or several), and those models will interact with the database if necessary. The person writing the controller never has to touch SQL, though, and even the person writing the model should be able to stay away from it.

Once the controller has gathered and processed the information it needs, it sends that data to a view for rendering. The controller can pick and choose among different views if it needs to, making it easy to throw an XML rendering on a controller that was originally expecting to be part of an HTML-generating process. You could offer a variety of different kinds of HTML—basic, Ajax, or meant for mobile—from your applications if necessary. Rails can even, at the developer’s discretion, generate basic views automatically, a feature called scaffolding. Scaffolding makes it extremely easy to get started on the data management side of an application without getting too hung up on its presentation.

The final result comes from the view, and Rails sends it along to the user. The user, of course, doesn’t need to know how all of this came to pass—the user just gets the final view of the information, which hopefully is what they wanted.

Now that you’ve seen how this works in the big picture, it’s time to return to the details of making it happen.

Keeping Track: A Simple Guestbook

Most applications will need to do more with data—typically, at least, they’ll store the data and present it back as appropriate. It’s time to extend this simple application so that it keeps track of who has stopped by, as well as greeting them. This requires using models. (The complete application is available in ch04/guestbook02.)


As Chapter 5 will make clear, in most application development, you will likely want to create your models by letting Rails create a scaffold, since Rails won’t let you create a scaffold after a model with the same name already exists. Nonetheless, understanding the more manual approach will make it much easier to work on your applications in the long run.

Connecting to a Database Through a Model

Keeping track of visitors will mean setting up and using a database. This should be easy when you’re in development mode, as Rails now defaults to SQLite, which doesn’t require explicit configuration. (When you deploy, you’ll still want to set up a database, typically MySQL, as discussed in Chapter 20.) To test whether SQLite is installed on your system, try issuing the command sqlite3 -help from the command line. If it’s there, you’ll get a help message. If not, you’ll get an error, and you’ll need to install SQLite.

Once the database engine is functioning, it’s time to create a model. Once again, it’s easiest to use generate to lay a foundation, and then add details to that foundation. This time, we’ll create a simple model instead of a controller and call the model entry:

rails generate model entry
		      invoke  active_record
		      create    db/migrate/20110221152951_create_entries.rb
		      create    app/models/entry.rb
		      invoke    test_unit
		      create      test/unit/entry_test.rb
		      create      test/fixtures/entries.yml

For our immediate purposes, two of these files are critical. The first is app/models/entry.rb, which is where all of the Ruby logic for handling a person will go. The second, which defines the database structures and thus needs to be modified first, is in the db/migrate/ directory. It will have a name like [timestamp]_create_entries.rb, where [timestamp] is the date and time when it was created. It initially contains what’s shown in Example 4-4.

Example 4-4. The default migration for the entry model

1  class CreateEntries < ActiveRecord::Migration
2    def change
3      create_table :entries do |t|
5        t.timestamps
6      end
7    end
8  end

There’s a lot to examine here before we start making changes. First, note on line 1 that the class is called CreateEntries. The model may be for an entry, but the migration will create a table for more than one entry. Rails names tables (and migrations) for the plural, and can handle most common English irregular pluralizations. (In cases where the singular and plural would be the same, you end up with an s added for the plural, so deer become deers and sheep become sheeps.) Many people find this natural, but other people hate it. For now, just go with it—fighting Rails won’t make life any easier.

Also on line 1, you can see that this class inherits most of its functionality from the Migration class of ActiveRecord. ActiveRecord is the Rails library that handles all the database interactions. (You can even use it separately from Rails, if you want to.)

The action begins on line 2 with the change method. Rails used to have separate self.up and self.down methods, one to build tables and one to take them down, but Rails 3.1 got smarter. It’s smart enough to understand how to run change backwards to roll back the migration—effectively it provides you with “undo” functionality automatically.


This example takes the slow route through creating a model so you can see what happens. In the future, if you’d prefer to move more quickly, you can also add the names and types of data on the command line, as you will do when generating scaffolding in Chapter 5.

The change method operated on a table called Entries. Note that the migration is not concerned with what kind of database it works on. That’s all handled by the configuration information. You’ll also see that migrations, despite working pretty close to the database, don’t need to use SQL—though if you really want to use SQL, it’s available.

Storing the names people enter into this very simple application requires adding a single column:

create_table :entries do |t|
  t.string :name

The new line refers to the table (t) and creates a column of type string, which will be accessible as :name.


In older versions of Rails, that new line would have been written:

t.column :name, string

The old version still works, and you’ll definitely see migrations written this way in older applications and documents. The new form is a lot easier to read at a glance, though.

The t.timestamps line is there for housekeeping, tracking “created at” and “updated at” information. Rails also will automatically create a primary key, :id, for the table. Once you’ve entered the new line (at line 4 of Example 4-4), you can run the migration with the Rake tool:

$ rake db:migrate
(in /Users/simonstl/rails/guestbook)
==  CreateEntries: migrating ==================================================
-- create_table(:entries)
   -> 0.0021s
==  CreateEntries: migrated (0.0022s) =========================================

Rake is Ruby’s own version of the classic command-line Unix make tool, and Rails uses it for a wide variety of tasks. (For a full list, try rake --tasks.)


If you want to run precisely the version of rake that was installed with your application, run bundle exec rake db:migrate instead. It may or may not matter, depending on the details of your Rails installation. See Chapter 17 for more information on bundle. Also, in some Rails installations, you may receive a message after attempting to run rake db:migrate that the command won’t run due to version incompatibilities and, in that case, using run bundle exec may be your only option.

In this case, the db:migrate task runs all of the previously unapplied change (or self.up) migrations in your application’s db/migrate/ folder. db:rollback gives you an undo option for the previous by running the change methods backwards (or the self.down methods if present).

Now that the application has a table with a column for holding names, it’s time to turn to the app/models/entry.rb file. Its initial contents are very simple:

class Entry < ActiveRecord::Base
  # attr_accessible :title, :body

The Entry class inherits from the ActiveRecord library’s Base class, but has no functionality of its own. It used to be able to stay that way—Rails provides enough capability that nothing more was needed. Unfortunately, Rails’ superpowers turned out to create some security leaks, in particular problems with mass assignment letting attackers set values they shouldn’t. To avoid mysterious errors from Rails, and to permit your code to assign values to the :name property, you need to explicitly specify that it’s OK with attr_accessible, as the comment suggests. Change the model to look like:

class Entry < ActiveRecord::Base
  attr_accessible :name		

This tells Rails that it’s allowed to set values for :name, and only for :name.


Remember that the names in your models also need to stay away from the list of reserved words presented at

Connecting the Controller to the Model

As you may have guessed, the controller is going to be the key component transferring data that comes in from the form to the model, and then it will be the key component transferring that data back out to the view for presentation to the user.

Storing data using the model

To get started, the controller will just blindly save new names to the model, using the code highlighted in Example 4-5.

Example 4-5. Using ActiveRecord to save a name

class EntriesController < ApplicationController

  def sign_in
       @name = params[:visitor_name]
       @entry = Entry.create({:name => @name})



The highlighted line combines three separate operations into a single line of code, which might look like:

       @myEntry = = @name

The first step creates a new variable, @myEntry, and declares it to be a new Entry object. The next line sets the name property of @myEntry—effectively setting the future value of the column named “name” in the Entries table—to the @name value that came in through the form. The third line saves the @myEntry object to the table.

The Entry.create approach assumes you’re making a new object, takes the values to be stored as named parameters, and then saves the object to the database.


Both the create and the save method return a boolean value indicating whether or not saving the value to the database was successful. For most applications, you’ll want to test this, and return an error if there was a failure.

These are the basic methods you’ll need to put information into your databases with ActiveRecord. (There are many shortcuts and more elegant syntax, as Chapter 5 will demonstrate.) This approach is also a bit too simple. If you visit http://localhost:3000/entries/sign_in/, you’ll see the same empty form that was shown in Figure 4-1. However, because @entry.create was called, an empty name will have been written to the table. The log data that appears in the server’s terminal window shows:

 (0.1ms)  begin transaction
		  SQL (87.3ms)  INSERT INTO "entries" ("created_at", "name",
 "updated_at") VALUES (?, ?, ?)  [["created_at", Mon, 20 Feb 2012 16:18:14 
UTC +00:00], ["name", nil], ["updated_at", Mon, 20 
Feb 2012 16:18:14 UTC +00:00]]
		   (7.1ms)  commit transaction

The nil is the problem here because it really doesn’t make sense to add a blank name every time someone loads the form without sending a value. On the bright side, we have evidence that Rails is putting information into the Entries table, and if we enter a name, say “Zaphod,” we can see the name being entered into the table:

	(0.1ms)  begin transaction
			  SQL (0.6ms)  INSERT INTO "entries" ("created_at", "name", "updated_at") 
              VALUES (?, ?, ?)  [["created_at", Mon, 20 Feb 2012 16:18:48 UTC +00:00], 
              ["name", "Zaphod"], ["updated_at", Mon, 20 Feb 2012 16:18:48 UTC +00:00]]

It’s easy to fix the controller so that NULLs aren’t stored—though as we’ll see in Chapter 7, this kind of validation code really belongs in the model. Two lines, highlighted in Example 4-6, will keep Rails from entering a lot of blank names.

Example 4-6. Keeping blanks from turning into permanent objects

class EntriesController < ApplicationController

  def sign_in
       @name = params[:visitor_name]
     unless @name.blank?
       @entry = Entry.create({:name => @name})


Now Rails will check the @name variable to make sure that it has a value before putting it into the database. unless @name.blank? will test for both nil values and blank entries. (blank? is a Rails method extending Ruby’s String objects.)

If you want to get rid of the NULLs you put into the database, you can run rake db:rollback and rake db:migrate (or rake db:migrate:redo to combine them) to drop and rebuild the table with a clean copy. In this case, you should stop the server before running rake and restart it when you’re done.

==  CreateEntries: reverting ==================================================
 -- drop_table(:entries)
    -> 0.0012s
==  CreateEntries: reverted (0.0013s) =========================================

==  CreateEntries: migrating ==================================================
 -- create_table(:entries)
    -> 0.0015s
==  CreateEntries: migrated (0.0016s) =========================================

If you want to enter a few names to put some data into the new table, go ahead. The next example will show how to get them out.

Retrieving data from the model and showing it

Storing data is a good thing, but only if you can get it out again. Fortunately, it’s not difficult for the controller to tell the model that it wants all the data, or for the view to render it. For a guestbook, it’s especially simple, as we just want all of the data every time.

Getting the data out of the model requires one line of additional code in the controller, highlighted in Example 4-7.

Example 4-7. A controller that also retrieves data from a model

class EntriesController < ApplicationController

  def sign_in
       @name = params[:visitor_name]
     if !@name.blank? then
       @entry = Entry.create({:name => @name})

     @entries = Entry.all



The Entry object includes a find method—like new and save, inherited from its parent ActiveRecord::Base class without any additional programming. If you run this and look in the logs, you’ll see that Rails is actually making a SQL call to populate the @entry array:

	Entry Load (0.4ms)  SELECT "entries".* FROM "entries"

Next, the view, still in views/entries/sign_in.html.erb, can show the contents of that array, to the site’s visitors see who’s come by before, using the added lines shown in Example 4-8.

Example 4-8. Displaying existing users with a loop

<h1>Hello <%= @name %></h1>

<%= form_tag :action => 'sign_in' do %>
   <p>Enter your name:
   <%= text_field_tag 'visitor_name', @name %></p>

   <%= submit_tag 'Sign in' %>

<% end %>
<p>Previous visitors:</p>
<% @entries.each do |entry| %>
  <li><%= %></li>
<% end %>


The loop here iterates over the @entries array, running as many times as there are entries in @entries. @entries, of course, holds the list of names previously entered, pulled from the database by the model that was called by the controller in Example 4-7. For each entry, the view adds a list item containing the name value, referenced here as The result, depending on exactly what names you entered, will look something like Figure 4-5.

The guestbook application, now displaying the names of past visitors

Figure 4-5. The guestbook application, now displaying the names of past visitors

It’s a lot of steps, yes, but fortunately you’ll be able to skip a lot of those steps as you move deeper into Rails. Building this guestbook didn’t look very much like the “complex-application-in-five-minutes” demonstrations that Rails’ promoters like to show off, but now you should understand what’s going on underneath the magic. After the apprenticeship, the next chapter will get into some journeyman fun.

Finding Data with ActiveRecord

The find method and its relatives are common in Rails, usually in controllers. It’s constantly used as find(id) to retrieve a single record with a given id, while the similar all method retrieves an entire set of records. There are four basic ways to call find, and then a set of options that can apply to all of those uses:

find by id

The find method is frequently called with a single id, as in find(id), but it can also be called with an array of ids, like find (id1, id2, id3, ...) in which case find will return an array of values. Finally, you can call find ([id1, id2]) and retrieve everything with id values between id1 and id2.

find all

Calling the all method—User.all, for example—will return all the matching values as an array.

find first

Calling firstUser.first, for example—will return the first matching value only. If you want this to raise an error if no matching record is found, add an exclamation point, as first!.

find last

Calling lastUser.last, for example— will return the first matching value only. Just as with first, if you want this to raise an error if no matching record is found, add an exclamation point, as last!.

The options, which have evolved into chainable methods, give you much more control over what is queried and which values are returned. All of them actually modify the SQL statements used to query the database and can accept SQL syntax, but you don’t need to know SQL to use most of them. This list of options is sorted by your likely order of needing them:


The where method lets you limit which records are returned. If, for example, you set:

Users.all.where("registered = true")

then you would only see records with a registered value of true. :conditions also has another form. You could instead write:

Users.all.where(:registered => true)

This will produce the same query and makes it a little more readable to list multiple conditions. Also, if conditions are coming in from a parameter or some other data source you don’t entirely trust, you may want to use the array form of :conditions:

Users.all.where("email = ?", params[:email])

Rails will replace the ? with the value of the :email parameter that came from the user, after sanitizing it.


The order method lets you choose the order in which records are returned, though if you’re using first or last it will also determine which record you’ll see as first or last. The simplest way to use this is with a field name or comma-separated list of field names:

Users.order("family_name, given_name")

By default, the order will sort in ascending order, so the option just shown would sort family_name values in ascending order, using given_name as a second sort field when family_name values are the same. If you want to sort a field in descending order, just put DESC after the field name:

Users.order("family_name DESC, given_name DESC")

This will return the names sorted in descending order.


The limit option lets you specify how many records are returned. If you wrote:


you would receive only the first 10 records back. (You’ll probably want to specify order to ensure that they’re the ones you want.)


The offset option lets you specify a starting point from which records should be returned. If, for instance, you wanted to retrieve the next 10 records after a set you’d retrieved with limit, you could specify:


Retrieves records so that you can read them, but cannot make any changes.


The group option lets you specify a field that the results should group on, like the SQL GROUP BY clause.


Lets you test for locked rows.

joins, include, select, and from

These let you specify components of the SQL query more precisely. You may need them as you delve into complex data structures, but you can ignore them at first.

Rails also offers dynamic finders, which are methods it automatically supports based on the names of the fields in the database. If you have a given_name field, for example, you can call find_by_given_name(name) to get the first record with the specified name, or find_all_by_given_name(name) to get all records with the specified name. These are a little slower than the regular find method, but may be more readable.


Rails also offers an elegant way to create more readable queries with scopes, which you should explore after you’ve found your way around.

Test Your Knowledge


  1. Where would you put code to which you want all of your controllers to have access?

  2. How do the default routes decide which requests to send to your controller?

  3. What does the change method do in a migration?

  4. What three steps does the create method combine?

  5. How do you test to find out whether a submitted field is blank?

  6. How can you retrieve all of the values for a given object?

  7. How can you find a set of values that match a certain condition?

  8. How can you retrieve just the first item of a set?


  1. Code in the ApplicationController class, stored at app/controllers/application_controller.rb, is available to all of the controllers in the project.

  2. The default routes assume that the controller name follows the first slash within the URL, that the controller action follows the second slash, and that the ID value follows the third slash. If there’s a dot (.) after the ID, then what follows the dot is considered the format requested.

  3. The change method is called when Rake runs a migration. The code explains what to create moving forward, but Rails can also run it backwards. It usually creates tables and fields.

  4. The create method creates a new object, sets its properties to those specified in the parameters, and saves it to the database.

  5. You can test to see whether something is blank using an if statement and the blank? method, as in:

    if @name.blank? then
      something to do if blank
  6. To retrieve all values for a given object, use .all.

  7. To retrieve a set of values, use .where(conditions).

  8. To get the first of a set, use .first. You may need to set an :order parameter to make sure that your understanding of “first” and Rails’ understanding of “first” are the same.

The best content for your career. Discover unlimited learning on demand for around $1/day.