On Nov 2, 10:26 pm, Iain Barnett <[email protected]> wrote:
> Hi,
>
> While trying out some new associations with dataset procs, I noticed that
> joins to a model would return a result as an instance of that model. For
> example:
>
> User.join( Role )
> => #<Sequel::SQLite::Dataset: "SELECT * FROM `users` INNER JOIN
> `roles`">
> User.join( Role ).first.class
> => User
>
> I would expect a hash, as in my mind it's equivalent to
>
> DB[:users].join( DB[:roles] )
> => #<Sequel::SQLite::Dataset: "SELECT * FROM `users` INNER JOIN (SELECT
> * FROM `roles`) AS 't1'">
> DB[:users].join( DB[:roles] ).first.class
> => Hash
>
> Is there an option to make it return a hash? Otherwise, the extra fields
> don't have accessors as they're not defined on the model. I could use
> `User.join( Role ).to_hash.first` but that isn't quite the same thing, and
> my first thought would be that it added a lot of overhead, especially to
> large datasets (but then I was wrong about the hash too! :)
Dataset#naked does what you want (removes the row_proc that turns
hashes into model objects). I wouldn't expect Model.join to remove
the row_proc, I doubt most other Sequel users would expect it, and it
would break backwards compatibility. If you want joins to remove the
row_proc by default, you can easily do it yourself:
Model.def_dataset_method(:join_table){|*a, &block| super(*a,
&block).naked}
Jeremy
--
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.
