Reading from a separate database

Hi everyone,

I’m working on an app that needs to READ data from a separate database
which is constantly being updated by a cron job. If anyone here is
familiar with it, it’s a database populated by SNMP data from an open
source project called RTG (

What I need to do is connect to this database and grab the info. Now,
the DB has a number of tables, each of which look something like this:






Those numbers can increase at any time so creating a model for each one
seems like it won’t work out too well in the long run.

I started off by creating a model for each and establishing a connection
to that DB with those, but like I said that probably won’t work out over
time as more tables are added by the cron job outside the scope of the
app. Is there some magical Rails way of making something amazingly great
like… oh, I don’t know… Rtg.ifOutOctets_1.find(:all)?

Haha, OK, something more realistic then?

Well, I woudn’t use it for your case, but here it is ->

But i think going into straight SQL from a activerecord connection
object might be a lot simpler.

Maurício Linhares (pt-br) |

On Wed, Apr 8, 2009 at 4:57 PM, Jack B.

That actually seems to work, but why do you think I shouldn’t use it?

"cos you would still fall into the ifInUcastPkts_3, ifInUcastPkts_2
and ifInUcastPkts_1models problem.

Doing it with straight SQL, you could just query the database about
which tables are available and read them. A simple “show tables” query
would to the trick on MySQL for example.

Maurício Linhares (pt-br) |

On Wed, Apr 8, 2009 at 5:48 PM, Jack B.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs