Rails 3 ActiveRecord Table Name Issue

Question

I'm on Windows XP...
Ruby 1.9.2
Rails 3.0.9
MS SQL Server 2005

I'm using tiny_tds + activerecord-sqlserver-adapter

In my database I have table named t4. I have created a model like this: rails generate model t4 Here is my simple model t4.rb:

class T4 < ActiveRecord::Base
end

Here is migration file 20111013125957_create_t4s.rb:

class CreateT4s < ActiveRecord::Migration
 def self.up

 create_table :t4s do |t|
  t.timestamps
 end
end

def self.down
  drop_table :t4s
end

end

I have schema.rb:

...
create_table "t4", :force => true do |t|
  t.string "title", :limit => 50
end
...

Problem: When I try T4.select("title").where(["id = 3"]) I get error message: ActiveRecord::StatementInvalid: TinyTds::Error: Invalid object name 't4s'.: SELECT title FROM [t4s] WHERE (id = 3)

P.S.: I have another some tables named Adddocs and Eclaims. There are not problems with queries to them.

I guess that problem is that T4.select("title").where(["id = 3"]) maps to SELECT title FROM [t4s] WHERE (id = 3) (T4 to t4s). Why? I don't know

But when I edited file config/initializers/inflections.rb like this:

ActiveSupport::Inflector.inflections do |inflect|
  inflect.irregular 't4', 't4'
end

Everything works! But it's not suitable solution (bad tone i think) :(((

Nadeem Khan Nadeem Khan · Accepted Answer · 2014-06-23T12:25:19

By convention, if you create a model named album, rails will create a table called albums.

To override this (which isn't usually done) and use a custom defined table name you can use set_table_name method like this in your model:

  class Album < ActiveRecord::Base
      self.table_name="album" * define here whatever table name you have
    end

Rails 3 ActiveRecord Table Name Issue

2 Answers