13

What I am trying to achieve

  • Users would be able to configure Doctrine entities through an HTML form on a website.
  • Users would be able to define new entities, as well as add and delete fields for existing entities. (Similar to Drupal's content types)
  • The Doctrine entities would get dynamic properties based on the configuration that the user supplied through the web UI.
  • Either the single DB table per Doctrine entity would be altered dynamically whenever an entity configuration changes; Or there could be multiple tables used per single entity (each new entity field would get its own table).

Done so far

I have been researching this for the past few days without much success but I stumbled across this answer which seems quite related to what I am trying to achieve.

I have registered and added the loadClassMetadata listener which maps the field foo: 

// src/DynamicMappingTest/AdminBundle/EventListener/MappingListener.php namespace DynamicMappingTest\AdminBundle\EventListener; use Doctrine\ORM\Event\LoadClassMetadataEventArgs; class MappingListener { public function loadClassMetadata(LoadClassMetadataEventArgs $eventArgs) { $classMetadata = $eventArgs->getClassMetadata(); if ($classMetadata->getName() != 'DynamicMappingTest\\AdminBundle\\Entity\\CustomNode') { // Not the CustomNode test class. Do not alter the class metadata. return; } $table = $classMetadata->table; $oldName = $table['name']; // ... or $classMetaData->getTableName() // your logic here ... $table['name'] = 'custom_node'; $classMetadata->setPrimaryTable($table); $reflClass = $classMetadata->getReflectionClass(); dump($reflClass); // ... or add a field-mapping like this $fieldMapping = array( 'fieldName' => 'foo', 'type' => 'string', 'length' => 255 ); $classMetadata->mapField($fieldMapping); } }

Now, this all works as long as I have the foo property declared in the DynamicMappingTest\AdminBundle\Entity\CustomNode class: 

// src/DynamicMappingTest/AdminBundle/Entity/CustomNode.php namespace DynamicMappingTest\AdminBundle\Entity; use Doctrine\ORM\Mapping as ORM; /** * CustomNode * * @ORM\Table() * @ORM\Entity(repositoryClass="DynamicMappingTest\AdminBundle\Entity\CustomNodeRepository") */ class CustomNode { ... private $foo; }

Problem

However, there is no way for me to know what properties the users will define for their custom entities. If I remove the foo property from the CustomNode class, the ReflectionClass that I get from the ClassMetadata will naturally not include the foo property and so I get the following exception whenever the mapField() in MappingListener is executed:

ReflectionException: Property DynamicMappingTest\AdminBundle\Entity\CustomNode::$foo does not exist in vendor/doctrine/common/lib/Doctrine/Common/Persistence/Mapping/RuntimeReflectionService.php at line 80 
77. */ 78. public function getAccessibleProperty($class, $property) 79. { 80. $reflectionProperty = new ReflectionProperty($class, $property); 81. 82. if ($reflectionProperty->isPublic()) { 83. $reflectionProperty = new RuntimePublicReflectionProperty($class, $property);

Questions

  • Is it possible to have fully configurable dynamic Doctrine entities?
  • Am I on the right track with my approach? If not, could you suggest an alternative?
  • How could I have truly dynamic class properties? Or should I be generating new Doctrine entity PHP classes whenever the users change the entity configuration?
Improve this question
4
  • Did you make any progress on this? I am in a similar predicament and could use any insights :) Commented Jun 3, 2016 at 22:20
  • @Alex.Barylski There was a similar question, maybe it will help you: stackoverflow.com/questions/37779492/… Commented Jun 14, 2016 at 11:58
  • i've developed something similar to what you want to achieve. but i used standard SQL. if you end up using standard SQL as well, you'll always need to select/update/whatever your dynamic entities with standard SQL. Commented Jul 12, 2017 at 22:13
  • SalesForce implements this concept, albeit probably not using Doctrine. Which allows users to create and associate custom objects and fields. As well as to create reports, views/forms, and dashboards on the underlying object data points. However as stated, an ORM would not be used on the backend to "generate" the objects and associations for the end user. The ORM would be used for developing the logic that ties it all together, in order to display the assigned associations to the end user; e.g. class UserObject::$fields, class UserField::$dataType, etc. Commented Apr 21, 2018 at 1:14

1 Answer 1

Reset to default
1

Is it possible to have fully configurable dynamic Doctrine entities?

Doctrine generates proxy classes for you entities. That means that doctrine generates PHP code with class, which extends your Entity class and overrides the methods - puts some custom logic and then calls the parent method.

So, I think that the only way to make this really happen is to generate the PHP code for entities in your code. That is, every time entity is created in your website, you should generate PHP file with that entity, then run migrations.

Am I on the right track with my approach? If not, could you suggest an alternative?

I don't think that you should use Doctrine ORM at all in this case, at least in the way you're trying to do that.

Generally, ORM is used for easier/more manageable programming. That is, you can set relations, use lazy-loading, unit of work (change entity properties and then just flush) etc. If your entities are generated dynamically, what features will you use at all? Developer will not write code for these entities, because, as you've said, there is no way to know what fields it will have.

You haven't provided concrete use-case - why do you want to do that in the first place. But I imagine that it could be really done in some easier way.

If users can store any structure at all, should you use MySQL at all? ElasticSearch or similar solutions could be really much better in such cases.

How could I have truly dynamic class properties? Or should I be generating new Doctrine entity PHP classes whenever the users change the entity configuration?

As I've mentioned - yes. Unless you would want to override or replace some of Doctrine code, but I imagine it could be lots of it (proxy classes etc.)

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

one use case is to give the customer the possibility to define his product classes/categories by himself. where he can define which properties a class should have and which values are possible for that property. i developed such a thing, but i used standard sql.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.