由于迁移有缺陷，试图重置我的数据库，如果没有SQLException甚至无法重置

Question

我试图修复一个错误的迁移，结果jsut删除了它，但现在我甚至不能重置我的rails db。我只是得到这个错误：

rake DB：重置rake中止！ActiveRecord：：StatementInvalid：sqlite3::sqlException：没有这样的表：simulations：从“simulations”中选择“simulations”.*按“simulations”的顺序。“id”DESC限制1

这些是我有1的迁移。

 class DeviseCreateUsers < ActiveRecord::Migration
  def change
    create_table(:users) do |t|
      ## Database authenticatable
      t.string :email,              :null => false, :default => "", limit: 96
      t.string :encrypted_password, :null => false, :default => "", limit: 60

      t.timestamps

      t.index :email, unique: true
    end
  end
end

2.

class CreateSimulations < ActiveRecord::Migration
  def change
    # Needs the hash column worked out before this is run 
    create_table :simulations do |t|
        t.integer :x_size
        t.integer :y_size
        t.string :verdict
        t.string :arrangement 
    end

    add_reference :simulations, :user, index: true    
  end
end

    class AddOpinionToSimulation < ActiveRecord::Migration
      def change
        add_column :simulations, :opinion, :hash
      end
    end

class RemoveVerdictFromSimulations < ActiveRecord::Migration
  def change
    remove_column :simulations, :verdict
  end
end

编辑@Ian:

# == Schema Information
#
# Table name: simulations
#
#  id          :integer          not null, primary key
#  x_size      :integer
#  y_size      :integer
#  verdict     :string
#  arrangement :string
#  user_id     :integer
#  opinion     :hash
#

FactoryGirl.define do 
    factory :simulation do |f|
        f.id (Simulation.last.nil? ? 1 : Simulation.last.id + 1)
        f.x_size 3
        f.y_size 3
        f.user_id 1
    end 
end 

Answer 1

db:reset执行db:drop db:setup。db:setup执行schema:load，它试图读取可能存在问题的db schema文件。如果您执行rake db：drop db：create db：migrate，应该可以修复它。

更多信息请参见此答案：rake db：migrate db：reset和db：schema：load之间的区别