DBのCRUD-02モデルの作成

モデルmemberの作成

$ruby script/generate model member

ファイルが作成する。

/db/migrate/001_create_members.rb

class CreateMembers < ActiveRecord::Migration
  def self.up
    create_table :members do |t|
    end
  end

  def self.down
    drop_table :members
  end
end

/db/migrate/001_create_members.rbを修正する

class CreateMembers < ActiveRecord::Migration
  def self.up
    create_table :members do |t|
      t.column :members, :name, :string
      t.column :members, :email, :string
    end
  end
  def self.down
    drop_table :members
  end
end

migrate

$ rake db:migrate
(in /Users/mono/dev/rails/Chap0420)
== CreateMembers: migrating ===================================================
-- create_table(:members)
   -> 0.0359s
== CreateMembers: migrated (0.0361s) ==========================================
***
mysql> show tables from member0420_development;
+----------------------------------+
| Tables_in_member0420_development |
+----------------------------------+
| members                          | 
| schema_info                      | 
+----------------------------------+
2 rows in set (0.00 sec)
mysql> show fields from members;
+-------+--------------+------+-----+---------+----------------+
| Field | Type         | Null | Key | Default | Extra          |
+-------+--------------+------+-----+---------+----------------+
| id    | int(11)      | NO   | PRI | NULL    | auto_increment | 
| name  | varchar(255) | YES  |     | NULL    |                | 
| email | varchar(255) | YES  |     | NULL    |                | 
+-------+--------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

データの投入。

/db/fixtures/development/members.yml