Connection multiply databases and tables

Hi,

I have an external (company)database with 2 tables depart, and
countries, wich i want to use in my rails-app.

Setup:

development (Local):
  adapter: mysql
  database: fly (tables > pages ect.)
  username: root
  password:
  host: localhost

extern(company):
  adapter: mysql
  database: fly2 (tables > depart, countries)
  username: root
  password:
  host: localhost

I created a depart model on my local sever

Class Depart < ActiveRecord ::Base
set_table_name = "depart"
establisch_connection :extern
end

This works fine from my console; looks like this

Page.connection.instance_eval{@config:database]}
"fly"
Depart.connection.instance_eval{@config:database]}
"fly2"

Because the tables depart, countries is on our central server i set the
Pluralization off by the "set_table_name"

Now i want to connect also to the countries table with the same
database-connection.

I have read that a creation of an external-class do the job

class External < ActiveRecord ::Base
establisch_connection :extern
end

class Depart < External
end

class Countries < External
end

Question: where i define my set_table_name for each class??

remco

Remco Zwaan wrote:

end

Question: where i define my set_table_name for each class??

remco

In the model.

hth

ilan