1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
|
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Active Record Basics</title>
<!--[if lt IE 8]>
<script src="http://ie7-js.googlecode.com/svn/version/2.0(beta3)/IE8.js" type="text/javascript"></script>
<![endif]-->
<link href="stylesheets/base.css" media="screen" rel="Stylesheet" type="text/css" />
<link href="stylesheets/forms.css" media="screen" rel="Stylesheet" type="text/css" />
<link href="stylesheets/more.css" media="screen" rel="Stylesheet" type="text/css" />
</head>
<body>
<div id="header" >
<div id="logo">
<a href="index.html" title="Ruby on Rails"><img src="images/rails_logo_remix.gif" alt="Rails" height="140" width="110" /></a>
</div>
<h1 id="site_title"><span>Ruby on Rails</span></h1>
<h2 id="site_title_tagline">Sustainable productivity for web-application development</h2>
<ul id="navMain">
<li class="first-child"><a href="http://www.rubyonrails.org/" title="Ruby on Rails" class="ruby_on_rails">Ruby on Rails</a></li>
<li><a class="manuals" href="index.html" title="Manuals Index">Guides Index</a></li>
</ul>
</div>
<div id="container">
<div id="sidebar">
<h2>Chapters</h2>
<ol>
<li>
<a href="#_what_8217_s_active_record">What’s Active Record</a>
</li>
<li>
<a href="#_object_relational_mapping">Object Relational Mapping</a>
</li>
<li>
<a href="#_activerecord_as_an_orm_framework">ActiveRecord as an ORM framework</a>
</li>
<li>
<a href="#_active_record_inside_the_mvc_model">Active Record inside the MVC model</a>
</li>
<li>
<a href="#_creating_activerecord_models">Creating ActiveRecord models</a>
</li>
<li>
<a href="#_convention_over_configuration_in_activerecord">Convention over Configuration in ActiveRecord</a>
<ul>
<li><a href="#_naming_conventions">Naming Conventions</a></li>
<li><a href="#_schema_conventions">Schema Conventions</a></li>
</ul>
</li>
<li>
<a href="#_philosophical_approaches_amp_common_conventions">Philosophical Approaches & Common Conventions</a>
</li>
<li>
<a href="#_activerecord_magic">ActiveRecord Magic</a>
</li>
<li>
<a href="#_how_activerecord_maps_your_database">How ActiveRecord Maps your Database.</a>
</li>
<li>
<a href="#_growing_your_database_relationships_naturally">Growing Your Database Relationships Naturally</a>
</li>
<li>
<a href="#_attributes">Attributes</a>
</li>
<li>
<a href="#_validations_amp_callbacks">Validations & Callbacks</a>
</li>
</ol>
</div>
<div id="content">
<h1>Active Record Basics</h1>
<div id="preamble">
<div class="sectionbody">
<div class="paragraph"><p>This guide will give you a strong grasp of the Active Record pattern and how it can be used with or without Rails. Hopefully, some of the philosophical and theoretical intentions discussed here will also make you a stronger and better developer.</p></div>
<div class="paragraph"><p>After reading this guide we hope that you’ll be able to:</p></div>
<div class="ulist"><ul>
<li>
<p>
Understand the way Active Record fits into the MVC model.
</p>
</li>
<li>
<p>
Create basic Active Record models and map them with your database tables.
</p>
</li>
<li>
<p>
Use your models to execute CRUD (Create, Read, Update and Delete) database operations.
</p>
</li>
<li>
<p>
Follow the naming conventions used by Rails to make developing database applications easier and obvious.
</p>
</li>
<li>
<p>
Take advantage of the way Active Record maps it’s attributes with the database tables' columns to implement your application’s logic.
</p>
</li>
<li>
<p>
Use Active Record with legacy databases that do not follow the Rails naming conventions.
</p>
</li>
</ul></div>
</div>
</div>
<h2 id="_what_8217_s_active_record">1. What’s Active Record</h2>
<div class="sectionbody">
<div class="paragraph"><p>Rails' ActiveRecord is an implementation of Martin Fowler’s <a href="http://martinfowler.com/eaaCatalog/activeRecord.html">Active Record Design Pattern</a>. This pattern is based on the idea of creating relations between the database and the application in the following way:</p></div>
<div class="ulist"><ul>
<li>
<p>
Each database table is mapped to a class.
</p>
</li>
<li>
<p>
Each table column is mapped to an attribute of this class.
</p>
</li>
<li>
<p>
Each instance of this class is mapped to a single row in the database table.
</p>
</li>
</ul></div>
<div class="paragraph"><p>The definition of the Active Record pattern in Martin Fowler’s words:</p></div>
<div class="paragraph"><p>"<em>An object that wraps a row in a database table or view, encapsulates the database access, and adds domain logic on that data."</em></p></div>
</div>
<h2 id="_object_relational_mapping">2. Object Relational Mapping</h2>
<div class="sectionbody">
<div class="paragraph"><p>The relation between databases and object-oriented software is called ORM, which is short for "Object Relational Mapping". The purpose of an ORM framework is to minimize the mismatch existent between relational databases and object-oriented software. In applications with a domain model, we have objects that represent both the state of the system and the behaviour of the real world elements that were modeled through these objects. Since we need to store the system’s state somehow, we can use relational databases, which are proven to be an excelent approach to data management. Usually this may become a very hard thing to do, since we need to create an object-oriented model of everything that lives in the database, from simple columns to complicated relations between different tables. Doing this kind of thing by hand is a tedious and error prone job. This is where an ORM framework comes in.</p></div>
</div>
<h2 id="_activerecord_as_an_orm_framework">3. ActiveRecord as an ORM framework</h2>
<div class="sectionbody">
<div class="paragraph"><p>ActiveRecord gives us several mechanisms, being the most important ones the hability to:</p></div>
<div class="ulist"><ul>
<li>
<p>
Represent models.
</p>
</li>
<li>
<p>
Represent associations between these models.
</p>
</li>
<li>
<p>
Represent inheritance hierarquies through related models.
</p>
</li>
<li>
<p>
Validate models before they get recorded to the database.
</p>
</li>
<li>
<p>
Perform database operations in an object-oriented fashion.
</p>
</li>
</ul></div>
<div class="paragraph"><p>It’s easy to see that the Rails Active Record implementation goes way beyond the basic description of the Active Record Pattern.</p></div>
</div>
<h2 id="_active_record_inside_the_mvc_model">4. Active Record inside the MVC model</h2>
<div class="sectionbody">
<div class="paragraph"><p>Active Record plays the role of model inside the MVC structure followed by Rails applications. Since model objects should encapsulate both state and logic of your applications, it’s ActiveRecord responsability to deliver you the easiest possible way to recover this data from the database.</p></div>
</div>
<h2 id="_creating_activerecord_models">5. Creating ActiveRecord models</h2>
<div class="sectionbody">
<div class="paragraph"><p>It’s very easy to create ActiveRecord models. All you have to do is to subclass the ActiveRecord::Base class and you’re good to go:</p></div>
<div class="listingblock">
<div class="content"><!-- Generator: GNU source-highlight 2.9
by Lorenzo Bettini
http://www.lorenzobettini.it
http://www.gnu.org/software/src-highlite -->
<pre><tt><span style="font-weight: bold"><span style="color: #0000FF">class</span></span> Product <span style="color: #990000"><</span> ActiveRecord<span style="color: #990000">::</span>Base<span style="color: #990000">;</span> <span style="font-weight: bold"><span style="color: #0000FF">end</span></span></tt></pre></div></div>
<div class="paragraph"><p>This will create a <tt>Product</tt> model, mapped to a <strong>products</strong> table at the database. By doing this you’ll also have the hability to map the columns of each row in that table with the attributes of the instances of your model. So, suppose that the <strong>products</strong> table was created using a SQL sentence like:</p></div>
<div class="listingblock">
<div class="content"><!-- Generator: GNU source-highlight 2.9
by Lorenzo Bettini
http://www.lorenzobettini.it
http://www.gnu.org/software/src-highlite -->
<pre><tt><span style="font-weight: bold"><span style="color: #0000FF">CREATE</span></span> <span style="font-weight: bold"><span style="color: #0000FF">TABLE</span></span> products <span style="color: #990000">(</span>
id <span style="color: #009900">int</span><span style="color: #990000">(</span><span style="color: #993399">11</span><span style="color: #990000">)</span> <span style="font-weight: bold"><span style="color: #0000FF">NOT</span></span> <span style="font-weight: bold"><span style="color: #0000FF">NULL</span></span> <span style="font-weight: bold"><span style="color: #0000FF">auto_increment</span></span><span style="color: #990000">,</span>
name <span style="color: #009900">varchar</span><span style="color: #990000">(</span><span style="color: #993399">255</span><span style="color: #990000">),</span>
<span style="font-weight: bold"><span style="color: #0000FF">PRIMARY</span></span> <span style="font-weight: bold"><span style="color: #0000FF">KEY</span></span> <span style="color: #990000">(</span>id<span style="color: #990000">)</span>
<span style="color: #990000">);</span></tt></pre></div></div>
<div class="paragraph"><p>Following the table schema above, you would be able to write code like the following:</p></div>
<div class="listingblock">
<div class="content"><!-- Generator: GNU source-highlight 2.9
by Lorenzo Bettini
http://www.lorenzobettini.it
http://www.gnu.org/software/src-highlite -->
<pre><tt>p <span style="color: #990000">=</span> Product<span style="color: #990000">.</span>new
p<span style="color: #990000">.</span>name <span style="color: #990000">=</span> <span style="color: #FF0000">"Some Book"</span>
puts p<span style="color: #990000">.</span>name <span style="font-style: italic"><span style="color: #9A1900"># "Some Book"</span></span></tt></pre></div></div>
</div>
<h2 id="_convention_over_configuration_in_activerecord">6. Convention over Configuration in ActiveRecord</h2>
<div class="sectionbody">
<div class="paragraph"><p>When writing applications using other programming languages or frameworks, it may be necessary to write a lot of configuration code. This is particulary true for ORM frameworks in general. However, if you follow the conventions adopted by Rails, you’ll need to write very little configuration (in some case no configuration at all) when creating ActiveRecord models. The idea is that if you configure your applications in the very same way most of the times then this should be the default way. In this cases, explicity configuration would be needed only in those cases where you can’t follow the conventions for any reason.</p></div>
<h3 id="_naming_conventions">6.1. Naming Conventions</h3>
<div class="paragraph"><p>By default, ActiveRecord uses some naming conventions to find out how the mapping between models and database tables should be created. Rails will pluralize your class names to find the respective database table. So, for a class <tt>Book</tt>, you should have a database table called <strong>books</strong>. The Rails pluralization mechanisms are very powerful, being capable to pluralize (and singularize) both regular and irregular words. When using class names composed of two or more words, the model class name should follow the Ruby conventions, using the camelCase form, while the table name must contain the words separated by underscores. Examples:</p></div>
<div class="paragraph"><p>Database Table - Plural with underscores separating words i.e. (book_clubs)
Model Class - Singular with the first letter of each word capitalized i.e. (BookClub)</p></div>
<div class="tableblock">
<table rules="all"
width="60%"
frame="border"
cellspacing="0" cellpadding="4">
<col width="50%" />
<col width="50%" />
<thead valign="top">
<tr>
<th align="left">Model / Class </th>
<th align="left">Table / Schema</th>
</tr>
</thead>
<tbody valign="top">
<tr>
<td align="left"><p class="table">Post</p></td>
<td align="left"><p class="table">posts</p></td>
</tr>
<tr>
<td align="left"><p class="table">LineItem</p></td>
<td align="left"><p class="table">line_items</p></td>
</tr>
<tr>
<td align="left"><p class="table">Deer</p></td>
<td align="left"><p class="table">deer</p></td>
</tr>
<tr>
<td align="left"><p class="table">Mouse</p></td>
<td align="left"><p class="table">mice</p></td>
</tr>
<tr>
<td align="left"><p class="table">Person</p></td>
<td align="left"><p class="table">people</p></td>
</tr>
</tbody>
</table>
</div>
<h3 id="_schema_conventions">6.2. Schema Conventions</h3>
<div class="paragraph"><p>ActiveRecord uses naming conventions for the columns in database tables, depending on the purpose of these columns.</p></div>
<div class="ulist"><ul>
<li>
<p>
<strong>Foreign keys</strong> - These fields should be named following the pattern table_id i.e. (item_id, order_id). These are the fields that ActiveRecord will look for when you create associations between your models.
</p>
</li>
<li>
<p>
<strong>Primary keys</strong> - By default, ActiveRecord will use a integer column named "id" as the table’s primary key. When using <a href="http://guides.rails.info/migrations.html">Rails Migrations</a> to create your tables, this column will be automaticaly created.
</p>
</li>
</ul></div>
<div class="paragraph"><p>There are also some optional column names that will create additional features to ActiveRecord instances:</p></div>
<div class="ulist"><ul>
<li>
<p>
<strong>created_at / created_on</strong> - ActiveRecord will store the current date and time to this field when creating the record.
</p>
</li>
<li>
<p>
<strong>updated_at / updated_on</strong> - ActiveRecord will store the current date and times to this field when updating the record.
</p>
</li>
<li>
<p>
<strong>lock_version</strong> - Adds <a href="http://api.rubyonrails.com/classes/ActiveRecord/Locking.html">optimistic locking</a> to a model.
</p>
</li>
<li>
<p>
<strong>type</strong> - Specifies that the model uses <a href="http://api.rubyonrails.com/classes/ActiveRecord/Base.html">Single Table Inheritance</a>
</p>
</li>
<li>
<p>
<strong>(table_name)_count</strong> - Used to cache the number of belonging objects on associations. For example, a <tt>comments_count</tt> column in a <tt>Post</tt> class that has many instances of <tt>Comment</tt> will cache the number of existent comments for each post.
</p>
</li>
</ul></div>
<div class="admonitionblock">
<table><tr>
<td class="icon">
<img src="./images/icons/note.png" alt="Note" />
</td>
<td class="content">While these column names are optional they are in fact reserved by ActiveRecord. Steer clear of reserved keywords unless you want the extra functionality. For example, "type" is a reserved keyword used to designate a table using Single Table Inheritance. If you are not using STI, try an analogous keyword like "context", that may still accurately describe the data you are modeling.</td>
</tr></table>
</div>
<div class="literalblock">
<div class="content">
<pre><tt>== STOPED HERE</tt></pre>
</div></div>
</div>
<h2 id="_philosophical_approaches_amp_common_conventions">7. Philosophical Approaches & Common Conventions</h2>
<div class="sectionbody">
<div class="paragraph"><p>Rails has a reputation of being a zero-config framework which means that it aims to get you off the ground with as little pre-flight checking as possible. This speed benefit is achieved by following “Convention over Configuration”, which is to say that if you agree to live with the defaults then you benefit from a the inherent speed-boost. As Courtneay Gasking put it to me once “You don’t want to off-road on Rails”. ActiveRecord is no different, while it’s possible to override or subvert any of the conventions of AR, unless you have a good reason for doing so you will probably be happy with the defaults. The following is a list of the common conventions of ActiveRecord</p></div>
</div>
<h2 id="_activerecord_magic">8. ActiveRecord Magic</h2>
<div class="sectionbody">
<div class="ulist"><ul>
<li>
<p>
timestamps
</p>
</li>
<li>
<p>
updates
</p>
</li>
</ul></div>
</div>
<h2 id="_how_activerecord_maps_your_database">9. How ActiveRecord Maps your Database.</h2>
<div class="sectionbody">
<div class="ulist"><ul>
<li>
<p>
sensible defaults
</p>
</li>
<li>
<p>
overriding conventions
</p>
</li>
</ul></div>
</div>
<h2 id="_growing_your_database_relationships_naturally">10. Growing Your Database Relationships Naturally</h2>
<div class="sectionbody">
</div>
<h2 id="_attributes">11. Attributes</h2>
<div class="sectionbody">
<div class="ulist"><ul>
<li>
<p>
attribute accessor method. How to override them?
</p>
</li>
<li>
<p>
attribute?
</p>
</li>
<li>
<p>
dirty records
-
== ActiveRecord handling the CRUD of your Rails application - Understanding the life-cycle of an ActiveRecord
</p>
</li>
</ul></div>
</div>
<h2 id="_validations_amp_callbacks">12. Validations & Callbacks</h2>
<div class="sectionbody">
<div class="paragraph"><p>see the Validations & Callbacks guide for more info.</p></div>
</div>
</div>
</div>
</body>
</html>
|
