6.4 Iteration A3: Validate! 6.2 Creating the Products Model and Maintenance Application

rails generate migration add_price_to_product price:decimal

      invoke  active_record

      create    db/migrate/20100906011121_add_price_to_product.rb

cat db/migrate/20100906011121_add_price_to_product.rb

class AddPriceToProduct < ActiveRecord::Migration

  def self.up

    add_column :products, :price, :decimal

  end

  def self.down

    remove_column :products, :price

  end

end

edit db/migrate/20100906011121_add_price_to_product.rb

class AddPriceToProduct < ActiveRecord::Migration

  def self.up

    add_column :products, :price, :decimal,

      :precision => 8, :scale => 2, :default => 0

  end

  def self.down

    remove_column :products, :price

  end

end

rake db:migrate

mv 20100906011121_add_price_to_product.rb 20100301000002_add_price_to_product.rb

(in /home/rubys/git/awdwr/work/depot)

==  AddPriceToProduct: migrating ==============================================

-- add_column(:products, :price, :decimal, {:precision=>8, :scale=>2, :default=>0})

   -> 0.0070s

==  AddPriceToProduct: migrated (0.0071s) =====================================

sqlite3 db/development.sqlite3 .schema

CREATE TABLE "products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "description" text, "image_url" varchar(255), "created_at" datetime, "updated_at" datetime, "price" decimal(8,2) DEFAULT 0);

CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL);

CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version");

edit app/views/products/index.html.erb

<h1>Listing products</h1>

<table>

  <tr>

    <th>Title</th>

    <th>Description</th>

    <th>Image url</th>

    <th>Price</th>

    <th></th>

    <th></th>

    <th></th>

  </tr>

<% @products.each do |product| %>

  <tr>

    <td><%= product.title %></td>

    <td><%= product.description %></td>

    <td><%= product.image_url %></td>

    <td><%= product.price %></td>

    <td><%= link_to 'Show', product %></td>

    <td><%= link_to 'Edit', edit_product_path(product) %></td>

    <td><%= link_to 'Destroy', product, :confirm => 'Are you sure?',

                                        :method => :delete %></td>

  </tr>

<% end %>

</table>

<br />

<%= link_to 'New Product', new_product_path %>

edit app/views/products/_form.html.erb

<%= form_for(@product) do |f| %>

  <% if @product.errors.any? %>

    <div id="error_explanation">

      <h2><%= pluralize(@product.errors.count, "error") %> prohibited this product from being saved:</h2>

      <ul>

      <% @product.errors.full_messages.each do |msg| %>

        <li><%= msg %></li>

      <% end %>

      </ul>

    </div>

  <% end %>

  <div class="field">

    <%= f.label :title %><br />

    <%= f.text_field :title %>

  </div>

  <div class="field">

    <%= f.label :description %><br />

    <%= f.text_area :description, :rows => 6 %>

  </div>

  <div class="field">

    <%= f.label :image_url %><br />

    <%= f.text_field :image_url %>

  </div>

  <div class="field">

    <%= f.label :price %><br />

    <%= f.text_field :price %>

  </div>

  <div class="actions">

    <%= f.submit %>

  </div>

<% end %>

edit app/views/products/show.html.erb

<p id="notice"><%= notice %></p>

<p>

  <b>Title:</b>

  <%= @product.title %>

</p>

<p>

  <b>Description:</b>

  <%= @product.description %>

</p>

<p>

  <b>Image url:</b>

  <%= @product.image_url %>

</p>

<p>

  <b>Price:</b>

  <%= @product.price %>

</p>

<%= link_to 'Edit', edit_product_path(@product) %> |

<%= link_to 'Back', products_path %>

get /products

get /products/1

get /products/new

rake test

(in /home/rubys/git/awdwr/work/depot)

Loaded suite /home/rubys/.rvm/gems/ruby-1.8.7-p302/gems/rake-0.8.7/lib/rake/rake_test_loader

Started

.

Finished in 0.018082 seconds.

1 tests, 1 assertions, 0 failures, 0 errors

Loaded suite /home/rubys/.rvm/gems/ruby-1.8.7-p302/gems/rake-0.8.7/lib/rake/rake_test_loader

Started

.......

Finished in 0.158504 seconds.

7 tests, 10 assertions, 0 failures, 0 errors

edit app/views/products/show.html.erb

<p id="notice"><%= notice %></p>

<p>

  <b>Title:</b>

  <%= @product.title %>

</p>

<p>

  <b>Description:</b>

  <%= @product.description %>

</p>

<p>

  <b>Image url:</b>

  <%= @product.image_url %>

</p>

<p>

  <b>Price:</b>

  <%= @product.price %>

</p>

<%= link_to 'Edit', edit_product_path(@product) %> |

<%= link_to 'Back', products_path %>

get /products/1

6.4 Iteration A3: Validate! 6.2 Creating the Products Model and Maintenance Application