Rilindo, the class method "columns" called on an ActiveRecord class is what you
want. Let's say you have a table called "books" with corresponding model Book.
Then:
Book.columns will return an array of column objects of the columns in the
table. Not so useful for a select list.
Book.columns.collect{|x| x.name} will return an array of just the column names.
But this will contain the "id" column and maybe other foreign keys you don't
want in a select list. Therefore:
Book.columns.collect{|x| x.name}.reject{|x| x == 'id' || x.match(/_id\Z/)}
might be closer to what you want,
Cheers, --Kip
Topic: A Describe Method / Pull list of Fields
Rilindo Foster <[email protected]> Dec 17 11:17PM -0500
Is there a method that can either run a describe on the table or pull a list of
fields from a table? The rationale is that I am looking for a while to
automatically populate a drop down list so that I can execute a search based on
the field name submitted from the form. I can, of course, populate it manually,
but with 8+ models, it gets old fast.
Is this the way to do it, through? Or should I try something like Sphinx for
these type of searches (which I am thinking of using anyway).
- Rilindo
--
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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
