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
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
|
<!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="#_orm_the_blueprint_of_active_record">ORM The Blueprint of Active Record</a>
</li>
<li>
<a href="#_active_record_the_engine_of_rails">Active Record The Engine of Rails</a>
<ul>
<li><a href="#_rails_active_record_conventions">Rails Active Record 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>Active Record is a design pattern that mitigates the mind-numbing mental gymnastics often needed to get your application to communicate with a database. This guide uses a mix of real-world examples, metaphors and detailed explanations of the actual Rails source code to help you make the most of ActiveRecord.</p></div>
<div class="paragraph"><p>After reading this guide readers should have 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 them a stronger and better developer.</p></div>
</div>
</div>
<h2 id="_orm_the_blueprint_of_active_record">1. ORM The Blueprint of Active Record</h2>
<div class="sectionbody">
<div class="paragraph"><p>If Active Record is the engine of Rails then ORM is the blueprint of that engine. ORM is short for “Object Relational Mapping” and is a programming concept used to make structures within a system relational. As a thought experiment imagine the components that make up a typical car. There are doors, seats, windows, engines etc. Viewed independently they are simple parts, yet when bolted together through the aid of a blueprint, the parts become a more complex device. ORM is the blueprint that describes how the individual parts relate to one another and in some cases infers the part’s purpose through the way the associations are described.</p></div>
</div>
<h2 id="_active_record_the_engine_of_rails">2. Active Record The Engine of Rails</h2>
<div class="sectionbody">
<div class="paragraph"><p>Active Record is a design pattern used to access data within a database. The name “Active Record” was coined by Martin Fowler in his book “Patterns of Enterprise Application Architecture”. Essentially, when a record is returned from the database instead of being just the data it is wrapped in a class, which gives you methods to control that data with. The rails framework is built around the MVC (Model View Controller) design patten and the Active Record is used as the default Model.</p></div>
<div class="paragraph"><p>The Rails community added several useful concepts to their version of Active Record, including inheritance and associations, which are extremely useful for web applications. The associations are created by using a DSL (domain specific language) of macros, and inheritance is achieved through the use of STI (Single Table Inheritance) at the database level.</p></div>
<div class="paragraph"><p>By following a few simple conventions the Rails Active Record will automatically map between:</p></div>
<div class="ulist"><ul>
<li>
<p>
Classes & Database Tables
</p>
</li>
<li>
<p>
Class attributes & Database Table Columns
</p>
</li>
</ul></div>
<h3 id="_rails_active_record_conventions">2.1. Rails Active Record Conventions</h3>
<div class="paragraph"><p>Here are the key conventions to consider when using Active Record.</p></div>
<h4 id="_naming_conventions">2.1.1. Naming Conventions</h4>
<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)
Here are some additional Examples:</p></div>
<div class="tableblock">
<table rules="all"
frame="hsides"
cellspacing="0" cellpadding="4">
<col width="160" />
<col width="182" />
<thead>
<tr>
<th align="left">
Model / Class
</th>
<th align="left">
Table / Schema
</th>
</tr>
</thead>
<tbody valign="top">
<tr>
<td align="left">
Post
</td>
<td align="left">
posts
</td>
</tr>
<tr>
<td align="left">
LineItem
</td>
<td align="left">
line_items
</td>
</tr>
<tr>
<td align="left">
Deer
</td>
<td align="left">
deer
</td>
</tr>
<tr>
<td align="left">
Mouse
</td>
<td align="left">
mice
</td>
</tr>
<tr>
<td align="left">
Person
</td>
<td align="left">
people
</td>
</tr>
</tbody>
</table>
</div>
<h4 id="_schema_conventions">2.1.2. Schema Conventions</h4>
<div class="paragraph"><p>To take advantage of some of the magic of Rails database tables must be modeled
to reflect the ORM decisions that Rails makes.</p></div>
<div class="tableblock">
<table rules="all"
frame="hsides"
cellspacing="0" cellpadding="4">
<col width="160" />
<col width="937" />
<thead>
<tr>
<th align="left">
Convention
</th>
<th align="left">
</th>
</tr>
</thead>
<tbody valign="top">
<tr>
<td align="left">
Foreign keys
</td>
<td align="left">
These fields are named table_id i.e. (item_id, order_id)
</td>
</tr>
<tr>
<td align="left">
Primary Key
</td>
<td align="left">
Rails automatically creates a primary key column named "id" unless told otherwise.
</td>
</tr>
</tbody>
</table>
</div>
<h4 id="_magic_field_names">2.1.3. Magic Field Names</h4>
<div class="paragraph"><p>When these optional fields are used in your database table definition they give the Active Record
instance additional features.</p></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="tableblock">
<table rules="all"
frame="hsides"
cellspacing="0" cellpadding="4">
<col width="285" />
<col width="902" />
<thead>
<tr>
<th align="left">
Attribute
</th>
<th align="left">
Purpose
</th>
</tr>
</thead>
<tbody valign="top">
<tr>
<td align="left">
created_at / created_on
</td>
<td align="left">
Rails stores the current date & time to this field when creating the record.
</td>
</tr>
<tr>
<td align="left">
updated_at / updated_on
</td>
<td align="left">
Rails stores the current date & time to this field when updating the record.
</td>
</tr>
<tr>
<td align="left">
lock_version
</td>
<td align="left">
Adds optimistic locking to a model <a href="http://api.rubyonrails.com/classes/ActiveRecord/Locking.html">more about optimistic locking</a>.
</td>
</tr>
<tr>
<td align="left">
type
</td>
<td align="left">
Specifies that the model uses Single Table Inheritance <a href="http://api.rubyonrails.com/classes/ActiveRecord/Base.html">more about STI</a>.
</td>
</tr>
<tr>
<td align="left">
id
</td>
<td align="left">
All models require an id. the default is name is "id" but can be changed using the "set_primary_key" or "primary_key" methods.
</td>
</tr>
<tr>
<td align="left">
<em>table_name</em>\_count
</td>
<td align="left">
Can be used to caches the number of belonging objects on the associated class.
</td>
</tr>
</tbody>
</table>
</div>
<div class="paragraph"><p>By default rails assumes all tables will use “id” as their primary key to identify each record. Though fortunately you won’t have explicitly declare this, Rails will automatically create that field unless you tell it not to.</p></div>
<div class="paragraph"><p>For example suppose you created a database table called cars:</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>mysql<span style="color: #990000">></span> <span style="font-weight: bold"><span style="color: #0000FF">CREATE</span></span> <span style="font-weight: bold"><span style="color: #0000FF">TABLE</span></span> cars <span style="color: #990000">(</span>
id <span style="color: #009900">INT</span><span style="color: #990000">,</span>
color <span style="color: #009900">VARCHAR</span><span style="color: #990000">(</span><span style="color: #993399">100</span><span style="color: #990000">),</span>
doors <span style="color: #009900">INT</span><span style="color: #990000">,</span>
horses <span style="color: #009900">INT</span><span style="color: #990000">,</span>
model <span style="color: #009900">VARCHAR</span><span style="color: #990000">(</span><span style="color: #993399">100</span><span style="color: #990000">)</span>
<span style="color: #990000">);</span></tt></pre></div></div>
<div class="paragraph"><p>Now you created a class named Car, which is to represent an instance of a record from your table.</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> Car
<span style="font-weight: bold"><span style="color: #0000FF">end</span></span></tt></pre></div></div>
<div class="paragraph"><p>As you might expect without defining the explicit mappings between your class and the table it is impossible for Rails or any other program to correctly map those relationships.</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="color: #990000">>></span> c <span style="color: #990000">=</span> Car<span style="color: #990000">.</span>new
<span style="color: #990000">=></span> <span style="font-style: italic"><span style="color: #9A1900">#<Class:0x11e1e90></span></span>
<span style="color: #990000">>></span> c<span style="color: #990000">.</span>doors
NoMethodError<span style="color: #990000">:</span> undefined method `doors' <span style="font-weight: bold"><span style="color: #0000FF">for</span></span> <span style="font-style: italic"><span style="color: #9A1900">#<Class:0x11e1e90></span></span>
from <span style="color: #990000">(</span>irb<span style="color: #990000">):</span><span style="color: #993399">2</span></tt></pre></div></div>
<div class="paragraph"><p>Now you could define a door methods to write and read data to and from the database. In a nutshell this is what ActiveRecord does. According to the Rails API:
“Active Record objects don‘t specify their attributes directly, but rather infer them from the table definition with which they‘re linked. Adding, removing, and changing attributes and their type is done directly in the database. Any change is instantly reflected in the Active Record objects. The mapping that binds a given Active Record class to a certain database table will happen automatically in most common cases, but can be overwritten for the uncommon ones.”
Lets try our Car class again, this time inheriting from ActiveRecord.</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> Car <span style="color: #990000"><</span> ActiveRecord<span style="color: #990000">::</span>Base
<span style="font-weight: bold"><span style="color: #0000FF">end</span></span></tt></pre></div></div>
<div class="paragraph"><p>Now if we try to access an attribute of the table ActiveRecord automatically handles the mappings for us, as you can see in the following example.</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="color: #990000">>></span> c <span style="color: #990000">=</span> Car<span style="color: #990000">.</span>new
<span style="color: #990000">=></span> <span style="font-style: italic"><span style="color: #9A1900">#<Car id: nil, doors: nil, color: nil, horses: nil, model: nil></span></span>
<span style="color: #990000">>></span> c<span style="color: #990000">.</span>doors
<span style="color: #990000">=></span> <span style="font-weight: bold"><span style="color: #0000FF">nil</span></span></tt></pre></div></div>
<div class="paragraph"><p>Rails further extends this model by giving each ActiveRecord a way of describing the variety of ways records are associated with one another. We will touch on some of these associations later in the guide but I encourage readers who are interested to read the guide to ActiveRecord associations for an in-depth explanation of the variety of ways rails can model associations.
- Associations between objects controlled by meta-programming macros.</p></div>
</div>
<h2 id="_philosophical_approaches_amp_common_conventions">3. 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">4. 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">5. 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">6. Growing Your Database Relationships Naturally</h2>
<div class="sectionbody">
</div>
<h2 id="_attributes">7. 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">8. 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>
|
