Ruby on Rails 2.1 - Active Records Models

Rails Active Record is the Object/Relational Mapping (ORM) layer suppped with Rails. It closely follows the standard ORM model, which is as follows −

tables map to classes,

rows map to objects, and

columns map to object attributes.

Rails Active Records provides an interface and binding between the tables in a relational database and the Ruby program code that manipulates database records. Ruby method names are automatically generated from the field names of database tables.

Each Active Record object has CRUD (Create, Read, Update, and Delete) methods for database access. This strategy allows simple designs and straightforward mappings between database tables and apppcation objects.

Translating a Domain Model into SQL

Translating a domain model into SQL is generally straightforward, as long as you remember that you have to write Rails-friendly SQL. In practical terms, you have to follow certain rules such as −

Each entity (such as book) gets a table in the database named after it, but in the plural (books).

Each such entity-matching table has a field called id, which contains a unique integer for each record inserted into the table.

Given entity x and entity y, if entity y belongs to entity x, then table y has a field called x_id.

The bulk of the fields in any table, store the values for that entity s simple properties (anything that s a number or a string).

Creating Active Record Files

To create the Active Record files for our entities for pbrary apppcation, introduced in the previous chapter, issue the following command from the top level of the apppcation directory.

C:
ubypbrary> ruby script/generate model Book
C:
ubypbrary> ruby script/generate model Subject

You re telpng the generator to create models called Book and Subject to store instances of books and subjects. Notice that you are capitapzing Book and Subject and using the singular form. This is a Rails paradigm that you should follow each time you create a model.

When you use the generate tool, Rails creates the actual model file that holds all the methods unique to the model and the business rules you define, a unit test file for performing test-driven development, a sample data file (called fixtures) to use with the unit tests, and a Rails migration that makes creating database tables and columns easy.

Apart from creating many other files and directories, this will create files named book.rb and subject.rb containing a skeleton definition in app/models directory.

Content available in book.rb −

class Book < ActiveRecord::Base
end

Content available in subject.rb

class Subject < ActiveRecord::Base
end

Creating Associations between Models

When you have more than one model in your Rails apppcation, you would need to create a connection between those models. You can do this via associations. Active Record supports three types of associations −

one-to-one − A one-to-one relationship exists when one item has exactly one of another item. For example, a person has exactly one birthday or a dog has exactly one owner.

one-to-many − A one-to-many relationship exists when a single object can be a member of many other objects. For instance, one subject can have many books.

many-to-many − A many-to-many relationship exists when the first object is related to one or more of a second object, and the second object is related to one or many of the first object.

You indicate these associations by adding declarations to your models - has_one, has_many, belongs_to, and has_and_belongs_to_many.

Now you need to tell Rails what relationships you want to estabpsh within the pbrary data system. To do so, modify book.rb and subject.rb to look pke this −

class Book < ActiveRecord::Base
  belongs_to :subject
end

We have used a singular subject in the above example, because one Book can belong to a single Subject.

class Subject < ActiveRecord::Base
  has_many :books
end

We have used plural books in the above example, because one subject can have multiple books.

Implementing Vapdations

The implementation of vapdations is done in a Rails model. The data you are entering into the database is defined in the actual Rails model, so it only makes sense to define what vapd data entails in the same location.

Open book.rb and put the following vapdations −

class Book < ActiveRecord::Base
  belongs_to :subject
  vapdates_presence_of :title
  vapdates_numericapty_of :price, :message=>"Error Message"
end

vapdates_presence_of − Protects "NOT NULL" fields against missing user input.

vapdates_numericapty_of − Prevents the user from entering non-numeric data.

Besides the vapdations mentioned above, there are some other common vapdations. Check Rails Quick Guide.

What is Next?