Active Record and different field names

[JZ]

I have several mysql tables and I would like to start using Active Record
instead of direct sql queries. The problem is I cannot find how to join to
these tables when they have different names for their primary keys. As i
understand AR and Rails assumes "id" as a field name for primary keys. What
if I have totally different names for fields? How to join to such tables
using AR? I couldn't find the answer in API for AR.

 

[David Heinemeier Hansson]

As i understand AR and Rails assumes "id" as a field name for primary

keys. What
if I have totally different names for fields? How to join to such
tables
using AR? I couldn't find the answer in API for AR.

You can specify a different primary key than id using set_primary_key,
like:

class Person < ActiveRecord::Base
set_primary_key "iPeopleId"
end

Similar construct for a unguessable table name with set_table_name.