rspec返回“ PG ::错误：错误：关系” table_name”；不存在” [英] rspec returns "PG::Error: ERROR: relation "table_name" does not exist"

问题描述

在rvm，rspec 2.8.0，rails 3.0.6和pg 0.13.2上，环境是REE（2011.12）。在CentOS 5.6上使用PostgreSQL 8.3.17。 db：migrate可以正常工作。但是rspec出现以下错误。

Environment is REE(2011.12) on rvm, rspec 2.8.0, rails 3.0.6, and pg 0.13.2. Using PostgreSQL 8.3.17 on CentOS 5.6. The db:migrate have work correctly. But rspec have got following error.

1) ApiController articles OK
 Failure/Error: Unable to find matching line from backtrace
 ActiveRecord::StatementInvalid:
   PG::Error: ERROR:  relation "table_name" does not exist
   : DELETE FROM "table_name"

我将我的项目从具有rspec 1.x系列的rails 2.3.5更新到具有rspec2的rails 3.0。复制了所有的rspec测试，然后我将旧的spec_helper.rb和新的合并（它是 rails g rspec：install 生成的）。

I'm updating my project from rails 2.3.5 with rspec 1.x series to rails 3.0 with rspec2. Copied all rspec tests, and I have merged old spec_helper.rb and new one(It was generated rails g rspec:install).

ENV["RAILS_ENV"] ||= 'test'
require File.expand_path("../../config/environment", __FILE__)
require 'rspec/rails'
require 'rspec/autorun'

Dir[Rails.root.join("spec/support/**/*.rb")].each {|f| require f}

RSpec.configure do |config|

  config.fixture_path = "#{::Rails.root}/spec/fixtures"
  config.use_transactional_fixtures = true

end

我读到与此错误类似的问题。所以我尝试了 rake db：test：prepare 或 rake db：test：load ，但这无法解决。你有什么主意吗？
似乎测试尚未在测试数据库上运行...我该怎么办？ ：（

I read similar question about this error.So I tried rake db:test:prepare or rake db:test:load, But It's not resolve. Do you have any idea? It looks like the test hasn't run on test database... How do I do? :(

推荐答案

我在两个实例中遇到了这个问题（2012年6月13日更新）：

I've run into this in two instances (updated 6/13/2012):

我尚未迁移测试数据库...

I haven't yet migrated my test database...

rake db：migrate

...在两个<$ c $之前都需要执行c> db：test：prepare 和 db：test：load 。

何时您调用rspec还是应该为您的数据库准备和 load 准备数据库。您不必手动进行此操作

When you invoke rspec it should prepare and load your database for you anyway. You shouldn't have to do that by hand.

迁移过程中的错字：我不小心颠倒了参数中的表名和列名列表。

A typo in my migration. I accidentally reversed my table and column names in the parameter list.

在Rails 3.1项目上的迁移：

A migration on a Rails 3.1 project:

def change
  add_column :had_import_errors, :studies, :boolean, :default => false
  add_column :import_data_cache, :studies, :text
end

...这是错误的，因为有导入错误和 import_data_cache 是我的列名，因此应该排第二，而不是第一。

...which is wrong, because has_import_errors and import_data_cache are my column names, and they therefore should come second, not first.

正确的迁移表名首先是：

The correct migration, with the table name first was:

def change
  add_column :studies, :had_import_errors, :boolean, :default => false
  add_column :studies, :import_data_cache, :text
end

这篇关于rspec返回“ PG ::错误：错误：关系” table_name”；不存在”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！