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?