Possible to create a calculated field in a doctrine query you can then retrieve as an object attribute?

Question

Suppose you declare a simple "license" table in a doctrine schema, consisting say of 3 fields, name, licenseNumber, expirationDate.

You can create a simple query to instantiate the collection of license objects. But what if you wanted to add a "virtual" field to it, for example,select *, (now() > expirationDate) as expired from license (in DQL, I'm using SQL as shorthand here).

Is there any way to get doctrine to make the "expired" calculated field retrievable as an attribute of the object? This is a trivial example to illustrate the point, but it could be quite helpful for more complicated calculated queries, or else I'm misunderstanding something.

Which version of symfony and doctrine are you using? – Maerlyn Apr 03 '12 at 08:35 — Maerlyn, Apr 03 '12 at 08:35

score 0 · Answer 1 · answered Oct 16 '13 at 09:52

0

You can also use a view with such a column and map your model to it instead of a db table

answered Oct 16 '13 at 09:52

sparrow

147
1
5

score 0 · Answer 2 · edited May 23 '17 at 11:56

0

No, there is no way to do what you are asking without adding a custom method to hydrate the "virtual column". Take a look at this SO post, as it gives an excellent example on how to hydrate arrays with your "virtual column".

You can also add the "virtual column" as a member object to the respective class and hydrate it like this example demonstrates.

edited May 23 '17 at 11:56

Community

1
1

answered Apr 03 '12 at 05:08

Mike Purcell

19,847
10
52
89

Were you able to figure out the custom hydration? – Mike Purcell Apr 06 '12 at 05:27

Possible to create a calculated field in a doctrine query you can then retrieve as an object attribute?

2 Answers2