Defect #18: table_name_pre/suffix support - Redmine

Actions

Copy link

Defect #18

closed

table_name_pre/suffix support

Added by Satoru KURASHIKI almost 18 years ago. Updated almost 18 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Category:

Target version:

Start date:

Due date:

% Done:

Estimated time:

Resolution:

Affected 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)

Actions

Copy link

Updated by Jean-Philippe Lang almost 18 years ago

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

Actions

Copy link