New hydration modes for Doctrine 1.1

Tags: update, Doctrine 1.1

Posted about 1 year ago by romanb

I would like to announce the addition of two new hydration modes to the 1.1 branch that will be included in the 1.1 release.

  • HYDRATE_SCALAR - flat array where the key is made up of the query component alias + field name. This method offers access to all the same data in a flat array and the hydration process for it is much faster.
  • HYDRATE_SINGLE_SCALAR - Allows you to easily access single value results, bypassing the expensive hydration process.

We feel that they fill an important gap between HYDRATE_NONE and HYDRATE_RECORD/HYDRATE_ARRAY.

You can read more about the new hydration modes in the docs. Starting at "Fetching data". You can also take a look at the new test case.

We encourage everyone to try them out and give us some feedback. Note that this is a feature preview and the implementation and syntax might change (or not) until the final 1.1 release, depending on how many issues arise and depending on the feedback.


Comments (7) [ add comment ]

Update Posted by Robert Henniger about about 1 year ago.

Thanks, thats a great improvement. It was very time wasting to write own "hydration" on top of the output of doctrine. Now the HYDRATE_SCALAR fits my needs. Thanks for this great framework and the perfect support. Robert

Great improvement Posted by nodkz about about 1 year ago.

Cool! It is exactly that thing, which takes forward place in our system.

GREAT Posted by Hélder Silva about about 1 year ago.

What a relief :P i'm currently using HYDRATE_NONE in one function of my code, but this will help me remove some of my old raw sql code.

Many thanks.

P.S:I'm trying to make my companie to make some notation to the doctrine project, since it help'ed us alot :)

Broken LInk Posted by Daniel about 11 months ago.

The link "in the docs" is broken .. i wish i could read more about Hydration modes....

Broken link Posted by about about 3 months ago.

http://www.doctrine-project.org/projects/orm/1.2/docs/manual/data-hydrators/en#data-hydrators

Do not duplicate the row Posted by samuel about 25 days ago.

Imagine we have user with emails (more than one). The query 'select u e from User u leftJoin u.emails' will produce one row for each email the user has. I would like to get instead one row for each user with the array of emails.

So instead of something like:

0 => array(3) { "u_id" => int(1) "u_name" => string(4) "John" "e_email" => string(13) "john@john.com" } 1 => array(3) { "u_id" => int(1) "u_name" => string(4) "John" "e_email" => string(13) "john@john.org" }

I would like to get:

0 => array(3) { "u_id" => int(1) "u_name" => string(4) "John" "e_email" => array(2) { string(13) "john@john.com" string(13) "john@john.org" } }

So, I want scalar results, but, if there is more than one result for some property, I would like to have it in the array, and do not duplicate the row.

Do duplicate the row Posted by davo about 16 days ago.

The above idea from samuel is silly. That just complexifies the hydration code in Doctrine and few people will want it: SQL doesn't work like that.

Create Comment