CODEWITHSUNDEEP
ruby-on-railsprefix
blinry
blinry

Reputation: 4965

Specify a table prefix for MySQL

In CakePHP, I can specify a prefix in my database configuration, i.e. "so_", so that every model looks for its table under this prefix.

Is something similar possible in Rails, too? That is, can several programs share one database?

Upvotes: 7

Views: 4745

Answers (2)

Aurril
Aurril

Reputation: 2469

You might try the following in environments.rb: In the config section add the following code

config.active_record.table_name_prefix = "so_"

Upvotes: 13

auralbee
auralbee

Reputation: 8841

You can easily specify your own table name for each model with the set_table_name method:

class Mouse < ActiveRecord::Base
  set_table_name "so_mice"
end

But you have to do it for each model, I don´t know of any global configuration option.

Upvotes: 1

Related Questions