Fixtures and Legacy Tables

I’m trying to use an existing database for a new Rails project.

In my tests the fixture accessors are not working. If I try to access
a Party fixture with “parties(:one)” I get the following error:

test_fixture(PartyTest):
NoMethodError: You have a nil object when you didn’t expect it!
You might have expected an instance of ActiveRecord::Base.
The error occurred while evaluating nil.[]
/Library/Ruby/Gems/1.8/gems/activerecord-2.1.0/lib/active_record/
fixtures.rb:887:in parties' /Library/Ruby/Gems/1.8/gems/activerecord-2.1.0/lib/active_record/ fixtures.rb:884:inmap’
/Library/Ruby/Gems/1.8/gems/activerecord-2.1.0/lib/active_record/
fixtures.rb:884:in parties' ./test/unit/party_test.rb:10:intest_fixture’
/Library/Ruby/Gems/1.8/gems/activesupport-2.1.0/lib/active_support/
testing/setup_and_teardown.rb:33:in __send__' /Library/Ruby/Gems/1.8/gems/activesupport-2.1.0/lib/active_support/ testing/setup_and_teardown.rb:33:inrun’

I have added the following to test_helper, without which it gets the
table name wrong:

set_fixture_class :parties => Party

My model is as follows:

class Party < ActiveRecord::Base
set_table_name :party
end

After some debugging it appears to me that the
@loaded_fixtures[table_name] is nil because table_name == ‘parties’
and not ‘party’. It appears that the overridden table name is not
carrying into the setup_fixture_accessors method.

Has anyone else had success using legacy tables that require a
set_table_name with fixtures in Rails 2.1?

Thanks,

Mark

On 17 Aug 2008, at 15:04, Mark Menard wrote:

I’m trying to use an existing database for a new Rails project.

In my tests the fixture accessors are not working. If I try to access
a Party fixture with “parties(:one)” I get the following error:

Looks like you can avoid some pain if you call your fixtures file
party.yml and use party(:one) instead of parties(:one)

Fred

Thanks Fred,

That worked. I’ve gone through so many iterations that I thought I’d
tried that setup already.

Mark

On Aug 17, 10:36 am, Frederick C. [email protected]