Defect #18
table_name_pre/suffix support
| Status: | Closed | Start: | ||
| Priority: | Normal | Due date: | ||
| Assigned to: | - | % Done: | 0% |
|
| Category: | - | |||
| Target version: | - | |||
Description
Rails supports DB table namespaces with ActiveRecord::Base.table_name_pre/suffix.
This will be valuable for some hosting services(users can use only one db).
I tried with MySQL, but it doesn't work well.
1)db:migrate works fine.
After I added this line to config/environment.rb, 'rake db:migrate' created prefixed tables correctly.
ActiveRecord::Base.table_name_prefix = 'redmine_'
2)app/models couldn't handle prefixed tables.
Almost all actions failed, because SQL sentences couldn't find coded table_names.
(ex. "news.created_on DESC" will search 'news' table, but 'redmine_news' exists)
History
2007-03-15 14:50 - Jean-Philippe Lang
You're right. Tables names are hard coded in sql fragments when
they need to be specified.
I'll have to replace these hard coded names with something like
this Model.table_name. I'll try do it asap.
Thanks