[Known-issue] Doctrine entities could not be woven

[TheCelavi]

Doctrine entities can not be weaved - class metadata gets all messed up.

Engine generates Entity__AopProxied, which is copy of original class, and then generates class Entity that extends Entity__AopProxied and contains weaved methods/properties.

Issue is that Entity__AopProxied contains doctrine metadata, so Doctrine actually generates such metadata that Entity__AopProxied is main class and every relation is bound to that class, not Entity.

Side effects are that, per example, table name gets suffix "__aop_proixed", while relations gets all screwed up, so any join is broken because different aliases are generated with SQL walker. Lazy loading does not work as well.

Possible solution would be (in order to preserve BC compatibility) to provide possibility to specify different method of weaving for certain classes. Per example, in this case, in order to work as it should, Entity__AopProxied should not be generated and inherited, it should be generated only Entity class.

Yes, maybe we will loose nice debugging and breakpoints, however, for now, we can sacrifice that for working code.

[TheCelavi]

Note - I am using annotations to map entities.

[TheCelavi]

Tried to use different mapping method - just for testing purposes, no love. Which is reasonable, Entity__AopProxied is not valid superclass....

Here is the example of wrong SQL:

An exception occurred while executing 'SELECT t1.id AS id_2, t1.feed_item_id AS feed_item_id_3, t1.url AS url_4, t1.platform AS platform_5, t1.views AS views_6, t1.likes AS likes_7, t1.dislikes AS dislikes_8, t1.comments AS comments_9, t1.shares AS shares_10, t1.created_at AS created_at_11, t1.updated_at AS updated_at_12, t1.created_by AS created_by_13, t1.updated_by AS updated_by_14, t1.offer_id AS offer_id_15 FROM report_item t1 WHERE t0.offer_id = ?'

SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.offer_id' in 'where clause'").

Note how generated alias for report_item is t1, but for where statement is t0 ? This is simple, lazy loaded relation.

[TheCelavi]

Ok, this does not allow me to sleep at all. By playing around, going trough code, I think that there is a workaround in for this situation, however, Doctrine mapping must be modified (tried with hardcoding just to test theory, works).

When Entity__AopProxied class is generated, its mapping data must exists and must be appropriately set. It should contain all Entity mapping data, with exception, it must be set as MappedSuperclass (see http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/inheritance-mapping.html#mapped-superclasses). In that matter Entity__AopProxied would become a mapping superclass, while generated Entity would have all required metadata as concrete class with mapping info from superclass.

It is not just simple "replace annotation" process, Doctrine supports mapping via XML, YML, annotations and PHP...

So, in order to do so successfully, we have to find out a certain point of time, or a method, that we can modify, intercept, whatever, so we can do this modification.

Maybe @Ocramius, @beberlei (or someone else) could give us some pointers or advices how to do this properly...?

[Ocramius]

I don't think I want to go there with the ORM: we are already doing our magic, and then you want to add a layer of it on top. This will get out of hand extremely quickly.

…

On 8 Jul 2017 3:44 AM, "Nikola Svitlica" ***@***.***> wrote: Ok, this does not allow me to sleep at all. By playing around, going trough code, I think that there is a workaround in for this situation, however, Doctrine mapping must be modified (tried with hardcoding just to test theory, works). When Entity__AopProxied class is generated, its mapping data must exists and must be appropriately set. It should contain all Entity mapping data, with exception, it must be set as MappedSuperclass (see http://docs.doctrine-project.org/projects/doctrine-orm/en/ latest/reference/inheritance-mapping.html#mapped-superclasses). In that matter Entity__AopProxied would become a mapping superclass, while generated Entity would have all required metadata as concrete class with mapping info from superclass. It is not just simple "replace annotation" process, Doctrine supports mapping via XML, YML, annotations and PHP... So, in order to do so successfully, we have to find out a certain point of time, or a method, that we can modify, intercept, whatever, so we can do this modification. Maybe @Ocramius <https://github.com/ocramius>, @beberlei <https://github.com/beberlei> (or someone else) could give us some pointers or advices how to do this properly...? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#327 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAJakIAEC7hRrn_jRgTcg1LcLglTtj3Cks5sLt7mgaJpZM4ORdkS> .

[TheCelavi]

@Ocramius not that I have that choice, either way, it seams as easy to solve/add support for doctrine entities.

Only thing required is to modify ClassMetadata for __AopProxied entity. For what I have seen, it should be an easy pick with Doctrine's loadclassmetadata event - just to set isMappedSupperclass to true.

I will try that approach today, I think that it will work.

[TheCelavi]

@lisachenko Ok, got it, here is a bastebin of listener that could handle this mapping issue with Doctrine entities which are weaved: https://pastebin.com/LwdJ0hXn

It gives a basis support, it works with my use case scenario, but in general, it is quite possible, Doctrine seams very flexible when it comes to metadata. I would create a PR for this project, an optional listener for Doctrine that can be used, if required.

For symfony bundle, I would add a compiler pass which would determine if there is a doctrine ORM included, and if that is true, it would auto register listener.

Feedback?

[lisachenko]

@TheCelavi this issue is very cumbersome, yes. There is no place for double magic (goaop + doctrine), so yes, unicorns are expected )

Just to check one more idea, could we somehow use Proxies\__CG__ namespace to make doctrine trust our generated entities? /cc @Ocramius

[lisachenko]

Closed via 6e2a0fe