How can I force the singular table name on Rails scaffold generator?

Question

I'm working with a legacy database and need to create some CRUD's. How can I use the scaffold generator and tell him the exact name of the table avoiding the pluralize process??

Also the tables are in spanish.

Check this but I dont recomend using scaffold http://api.rubyonrails.org/classes/ActiveSupport/Inflector.html — emerak, Jul 12 '14 at 22:53
Isn't the easiest way just to set the table name on each model? `self.table_name = 'name of legacy table'` — Eyeslandic, Jul 12 '14 at 22:59
Yeah, I've also found something on the inflector, or the 'table_name' But there are like 50 tables, I'm looking for something like a config thing that I can write once... =P — mariowise, Jul 12 '14 at 23:02
Convention over configuration is the rails way. Why are you fighting the conventions? — Fred, Jul 12 '14 at 23:31
`self.table_name` is the best way, if you have postgresql schemas/namespace for your tables, then I can show you how to set that up — Mohamed El Mahallawy, Jul 13 '14 at 00:06
@mohamed-el-mahallawy how would you do that with namespaces? — Dan Tappin, Aug 17 '16 at 14:59

score 27 · Answer 1 · edited Sep 17 '16 at 20:09

27

You can just use ActiveRecord::Base.table_name= method to manually set the table name.

So, in your model you can do:

class OrderDetail < ActiveRecord::Base
  self.table_name = 'order_detail'
end

edited Sep 17 '16 at 20:09

MauroPorras

5,079
5
30
41

answered Jul 13 '14 at 00:21

1andsock

1,557
10
15

3

I like this one better because when one usually needs that is in a case of an exceptional class name. Your answer is a little bit misleading though. Table name is usually in `lowercase_separated_by_underscores` as found in `Schema.rb`. What you written is used for class names called `UpperCamelCase`. – Ayman Salah Sep 17 '16 at 13:36

score 24 · Accepted Answer · answered Jul 13 '14 at 00:58

24

I think you want

ActiveRecord::Base.pluralize_table_names = false

Found this here:

http://justinram.wordpress.com/2006/04/04/pluralize-table-names-no-thanks/

http://guides.rubyonrails.org/3_1_release_notes.html

answered Jul 13 '14 at 00:58

Chris Valentine

1,557
1
19
36

1

Upvote! I think this solution is better when you deal with multiple classes. – Askar Apr 16 '15 at 03:37

How can I force the singular table name on Rails scaffold generator?

2 Answers2