Re: generating a list of model classes, I was hoping something like this would work:
ObjectSpace.each_object(ActiveRecord::Base) {|o| puts(o)}
But no dice (in a rails console anyway)--that will enumerate instances of model classes, but not the classes themselves. I guess ObjectSpace doesn't consider classes objects? Confusing...
I guess you could troll the files under /app/models... But you were looking to go *less* hacky, eh? ;-)
-----Original Message-----
From:
rubyonrails-talk@... [mailto:
rubyonrails-talk@...] On Behalf Of Max Williams
Sent: Wednesday, September 17, 2008 9:35 AM
To:
rubyonrails-talk@...
Subject: [Rails] Get a list of all foreign keys (with their respective tables
As a general speed-up, i want to index all of my foreign keys. Rather than hand-code them all into a migration (thus probably making some mistakes), i'd like to make a little script, or method to do it.
I thought of maybe something like
sql = ActiveRecord::Base.connection
klasses = <get all model classes somehow> klasses.each do |klass|
foreign_key_columns = klass.column_names.select{|s| s.match(/_id$/)}
foreign_key_columns.each do |column_name|
sql.execute("alter table #{klass.tablename} add index
(#{column_name})")
end
end
but, this seems a bit hacky and dirty. Can anyone see a nicer way?
And, how can i get all of my model classes?
I'm using mysql, in case that's relevant.
thanks
max
--
Posted via
http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk@...
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@...
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en-~----------~----~----~----~------~----~------~--~---
