データベース作成 - meowmeow @ ウィキ

DB作成

• DB名：scheduler
• テーブル：

class CreateSchedulesTable < ActiveRecord::Migration
  def self.up
    create_table :schedules do |t|    
      t.column :datetime,:timestanp
      t.column :title,:string
      t.column :content,:text
    end
  end 
  def self.down
    drop_table :schedules
  end
end

テスト

• rake

引数ナシのrakeでテストをしてくれる。

• rake -t
  • 実行されているもの（ターゲット）を出力してくれる。

(in C:/InstantRails/rails_apps/scheduler)
** Invoke default (first_time)
** Invoke test (first_time)
** Execute test
** Invoke test:units (first_time)
** Invoke db:test:prepare (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:test:prepare
** Invoke db:test:clone (first_time)
** Invoke db:schema:dump (first_time)
** Invoke environment 
** Execute db:schema:dump
** Invoke db:test:purge (first_time)
** Invoke environment 
** Execute db:test:purge
** Execute db:test:clone
** Invoke db:schema:load (first_time)
** Invoke environment 
** Execute db:schema:load
** Execute test:units
C:/InstantRails/ruby/bin/ruby-Ilib;test"C:/InstantRails/ruby/lib/ruby/gems/1.8/
gems/rake-0.7.2/lib/rake/rake_test_loader.rb""test/unit/schedule_test.rb" 
Loaded suite     C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake/rake_test_loader
Started.
Finished in 0.391 seconds.
C:/InstantRails/ruby/bin/ruby -Ilib;test "C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/
rake-0.7.2/lib/rake/rake_test_loader.rb"  "test/functional/schedules_controller_test.rb" 
1 tests, 1 assertions, 0 failures, 0 errors

test:unitsがモデルのテスト

** Invoke test:functionals (first_time)

** Invoke db:test:prepare 

** Execute test:functionals
Loaded suite C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake/rake_test_loader
Started
EEEEEEEE
Finished in 0.234 seconds.
 1) Error:
test_create(SchedulesControllerTest):
StandardError: No fixture with name 'first' found for table 'schedules'
    C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/fixtures.rb:503:in `schedules'
    ./test/functional/schedules_controller_test.rb:15:in `setup_without_fixtures'
   C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/fixtures.rb:576:in `setup'
 2) Error:
test_destroy(SchedulesControllerTest):
StandardError: No fixture with name 'first' found for table 'schedules'
    C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/fixtures.rb:503:in `schedules'
   ./test/functional/schedules_controller_test.rb:15:in `setup_without_fixtures'
   C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/fixtures.rb:576:in `setup'
 3) Error:
test_edit(SchedulesControllerTest):
StandardError: No fixture with name 'first' found for table 'schedules'
   C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/fixtures.rb:503:in `schedules'
   ./test/functional/schedules_controller_test.rb:15:in `setup_without_fixtures'
   C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/fixtures.rb:576:in `setup'
 4) Error:
test_index(SchedulesControllerTest):
StandardError: No fixture with name 'first' found for table 'schedules'
   C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/fixtures.rb:503:in `schedules'
   ./test/functional/schedules_controller_test.rb:15:in `setup_without_fixtures'
   C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/fixtures.rb:576:in `setup'
 5) Error:
test_list(SchedulesControllerTest):
StandardError: No fixture with name 'first' found for table 'schedules'
   C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/fixtures.rb:503:in `schedules'
   ./test/functional/schedules_controller_test.rb:15:in `setup_without_fixtures'
   C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/fixtures.rb:576:in `setup'
 6) Error:
test_new(SchedulesControllerTest):
StandardError: No fixture with name 'first' found for table 'schedules'
   C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/fixtures.rb:503:in `schedules'
   ./test/functional/schedules_controller_test.rb:15:in `setup_without_fixtures'
   C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/fixtures.rb:576:in `setup'
 7) Error:
test_show(SchedulesControllerTest):
StandardError: No fixture with name 'first' found for table 'schedules'
    C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/fixtures.rb:503:in `schedules'
   ./test/functional/schedules_controller_test.rb:15:in `setup_without_fixtures'
   C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/fixtures.rb:576:in `setup'
C:/InstantRails/ruby/bin/ruby -Ilib;test "C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake/rake_test_loader.rb"  
 8) Error:
test_update(SchedulesControllerTest):
StandardError: No fixture with name 'first' found for table 'schedules'
   C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/fixtures.rb:503:in `schedules'
   ./test/functional/schedules_controller_test.rb:15:in `setup_without_fixtures'
   C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/fixtures.rb:576:in `setup'
8 tests, 0 assertions, 0 failures, 8 errors

test:functionalはコントローラのテスト

** Invoke test:integration (first_time)
** Invoke db:test:prepare 
** Execute test:integration
** Execute default