Ticket 74 (Open)

Created: by Markus Kolb Feb 12, 2007
Severity: Enhancement Request (1 of 5)
Priority: Medium (2 of 4)
Attached: Plus Nothing
Assigned: to Peter Jones

Hardcoded Table Names

The ActiveRecord::Base.table_name_prefix and suffix stuff doesn't work because you use hardcoded table names in the code. So you can't overwrite the prefix and/or suffix in the environment.rb for multiple installations in one database. The simplest patch is to add #{ActiveRecord::Base.table_name_prefix}hardcoded_table_name in the places where you use it. I haven't tested all functions of Devalot so I can't submit a proofed patch up to now.

Tags:

This ticket hasn't been tagged yet.

Comments:

Bubble

Peter Jones, Feb 12, 2007
Level 5 (Governator with 10,067 points)


Why would you want to run more than one copy of Devalot inside the same database instance?

Bubble

Markus Kolb, Feb 28, 2007
Level 2 (Tourist with 1 point)


Because a webspace may have only one database and there could be multiple domains and web apps. So if devalot uses a table users there can't be any other app with another table users. For this ActiveRecord has the feature to set a table prefix and suffix.

Bubble

Peter Jones, Mar 07, 2007
Level 5 (Governator with 10,067 points)


Okay, after I get a few more things in place, I'll go back and audit the code and get those table names removed.

Have something to say? Login to post a comment.