Project

General

Profile

Actions

Defect #18

closed

table_name_pre/suffix support

Added by Satoru KURASHIKI over 17 years ago. Updated over 17 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
Due date:
% Done:

0%

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 #1

Updated by Jean-Philippe Lang over 17 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 #2

Updated by Jean-Philippe Lang over 17 years ago

Fix has just been committed in the repository.
Let me know if you find any other problem.

Thanks

Actions

Also available in: Atom PDF