我运行rake db:drop(成功)并运行rake db:create(成功)但rake db:schema:load抛出一个我无法弄清楚的奇怪错误. ** Invoke db:schema:load (first_time)** Invoke environment (first_time)** Execute environmentrake abort
** Invoke db:schema:load (first_time)
** Invoke environment (first_time)
** Execute environment
rake aborted! PG::UndefinedTable: ERROR: relation "admins" does not exist
LINE 5: WHERE a.attrelid = '"admins"'::regclass
^
: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"admins"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
有什么建议?
如果您正在使用FactoryBot(FactoryGirl)并且您的工厂包含任何模型类型引用,请确保它们用大括号括起来.这可以防止db:schema:加载爆炸,你不必注释掉你的工厂.例如,假设您有一个带轮子和引擎的Car模型,您的种子数据中有两种类型的引擎,并且使用特征来指定引擎类型.
这段代码将炸毁db:schema:load:
FactoryBot.define do
factory :car do
wheels
trait(:v8) {
engine Engine.find_by_type('V8')
}
trait(:i4) {
engine Engine.find_by_type('I4')
}
end
end
这将阻止db:schema:加载爆炸:
FactoryBot.define do
factory :car do
wheels
trait(:v8) {
engine { Engine.find_by_type('V8') }
}
trait(:i4) {
engine { Engine.find_by_type('I4') }
}
end
end
以下是对它的讨论:https://github.com/thoughtbot/factory_bot_rails/issues/134
更新:在为工厂指定类时也会发生这种情况:
这段代码将炸毁db:schema:load:
FactoryBot.define do factory :hot_rod, class: Car do
这将阻止db:schema:加载(使用符号而不是模型类型):
FactoryBot.define do factory :hot_rod, class: :car do
