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 (http://rtg.sourceforge.net/)
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:
ifOutOctets_1
ifOutOctets_2
ifOutOctets_3
…
ifInOctets_1
ifInOctets_2
ifInOctets_3
…
ifOutUcastPkts_1
ifOutUcastPkts_2
ifOutUcastPkts_3
…
ifInUcastPkts_1
ifInUcastPkts_2
ifInUcastPkts_3
…
interface
router
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?