After a little more research, I am pretty sure there is no support for
schema reflection as yet.
Getting more detailed column_info is easy enough in principal. For
MySQL:
Application.database['show columns from entries'].map do |column|
{ :type => column[:Type].match(/^\w+/)[0].intern,
:name => column[:Field].intern }
end
# => [{:type=>:int, :name=>:id},
# {:type=>:text, :name=>:name},
# {:type=>:text, :name=>:title},
# {:type=>:text, :name=>:summary},
# {:type=>:timestamp, :name=>:created_on},
# {:type=>:timestamp, :name=>:updated_on},
# {:type=>:text, :name=>:author},
# {:type=>:text, :name=>:content}]
This is probably non-standard SQL and would have to be incorporated
into each driver. The types returned would also have to be normalized,
of course (i.e., :int to :integer).
No reflection data is presently kept in the model for associations. To
really produce a complete :record_info (or whatever it would be
called), we need to add in the association data. This could be
captured easily just by modifying the one_to_one, one_to_many, etc.,
methods and keeping the metadata around in a class instance variable.
At least, I don't see any complication from doing that.
I will work on this but would like to make sure no one else is already
doing so, so we don't duplicate efforts. Any thought / suggestions?
Regards,
Dan
On Jan 10, 4:07 pm, dan yoder <[EMAIL PROTECTED]> wrote:
> Kudos the folks working on this project. It is fantastic work.
>
> It appears that you can get access to the columnar meta-data for a
> model via the schema attribute of a database, but how can you reflect
> on the associations of a model? Is there any plan (or interest) in
> having this metadata be reflected directly from the model. I
> implemented this once for ActiveRecord, but never released it because
> I stopped working with AR. :)
>
> You would use it like this:
>
> Entries.record_info # => [ :title => :string, :author =>
> [ :one_to_one, :author ] ... etc
>
> If someone can point me to where I can reflect on associations, I can
> pull this together. Or maybe I've just missed the right place in the
> API?
>
> Tip of the hat, again. Great work.
>
> Regards,
> Dan
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sequel-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/sequel-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
