=========== Persistence =========== .. sectionauthor:: Karsten Dambekalns This chapter explains how to use object persistence in Flow. .. tip:: If you have experience with Doctrine 2 already, your knowledge can be applied fully in Flow. If you have not worked with Doctrine 2 in the past, it might be helpful to learn more about it, as that might clear up questions this documentation might leave open. Introductory Example ==================== Let's look at the following example as an introduction to how Flow handles persistence. We have a domain model of a Blog, consisting of Blog, Post, Comment and Tag objects: .. figure:: Images/Persistence_BlogDomainModel.png :alt: The objects of the Blog domain model :class: screenshot-detail The objects of the Blog domain model Connections between those objects are built (mostly) by simple references in PHP, as a look at the ``addPost()`` method of the ``Blog`` class shows: *Example: The Blog's addPost() method* :: /** * @param \Neos\Blog\Domain\Model\Post $post * @return void */ public function addPost(\Neos\Blog\Domain\Model\Post $post) { $post->setBlog($this); $this->posts->add($post); } The same principles are applied to the rest of the classes, resulting in an object tree of a blog object holding several posts, those in turn having references to their associated comments and tags. But now we need to make sure the ``Blog`` and the data in it are still available the next time we need them. In the good old days of programming you might have added some ugly database calls all over the system at this point. In the currently widespread practice of loving Active Record you'd still add ``save()`` methods to all or most of your objects. But can it be even easier? To access an object you need to hold some reference to it. You can get that reference by creating an object or by following some reference to it from some object you already have. This leaves you at a point where you need to find that "first object". This is done by using a *Repository*. A Repository is the librarian of your system, knowing about all the objects it manages. In our model the ``Blog`` is the entry point to our object tree, so we will add a ``BlogRepository``, allowing us to find ``Blog`` instances by the criteria we need. Now, before we can find a ``Blog``, we need to create and save one. What we do is create the object and ``add`` it to the ``BlogRepository``. This will automagically persist your Blog and you can retrieve it again later. For all that magic to work as expected, you need to give some hints. This doesn't mean you need to write tons of XML, a few annotations in your code are enough: *Example: Persistence-related annotations in the Blog class* :: namespace Neos\Blog\Domain\Model; /** * A Blog object * * @Flow\Entity */ class Blog { /** * @var string * @Flow\Validate(type="Text") * @Flow\Validate(type="StringLength", options={ "minimum"=1, "maximum"=80 }) * @ORM\Column(length=80) */ protected $title; /** * @var \Doctrine\Common\Collections\ArrayCollection<\Neos\Blog\Domain\Model\Post> * @ORM\OneToMany(mappedBy="blog") * @ORM\OrderBy({"date" = "DESC"}) */ protected $posts; ... } The first annotation to note is the ``Entity`` annotation, which tells the persistence framework it needs to persist ``Blog`` instances if they have been added to a Repository. In the ``Blog`` class we have some member variables, they are persisted as well by default. The persistence framework knows their types by looking at the ``@var`` annotation you use anyway when documenting your code (you do document your code, right?). The *Column* annotation on ``$title`` is an optimization since we allow only 80 chars anyway. In case of the ``$posts`` property the persistence framework persists the objects held in that ``ArrayCollection`` as independent objects in a one-to-many relationship. Apart from those annotations your domain object's code is completely unaware of the persistence infrastructure. Let's conclude by taking a look at the BlogRepository code: *Example: Code of a simple BlogRepository* :: use Neos\Flow\Annotations as Flow; /** * A BlogRepository * * @Flow\Scope("singleton") */ class BlogRepository extends \Neos\Flow\Persistence\Repository { } As you can see we get away with very little code by simply extending the Flow-provided repository class, and still we already have methods like ``findAll()`` and even magic calls like ``findOneBy()`` available. If we need some specialized find methods in our repository, we can make use of the query building API: *Example: Using the query building API in a Repository* :: /** * A PostRepository */ class PostRepository extends \Neos\Flow\Persistence\Repository { /** * Finds posts by the specified tag and blog * * @param \Neos\Blog\Domain\Model\Tag $tag * @param \Neos\Blog\Domain\Model\Blog $blog The blog the post must refer to * @return \Neos\Flow\Persistence\QueryResultInterface The posts */ public function findByTagAndBlog(\Neos\Blog\Domain\Model\Tag $tag, \Neos\Blog\Domain\Model\Blog $blog) { $query = $this->createQuery(); return $query->matching( $query->logicalAnd( $query->equals('blog', $blog), $query->contains('tags', $tag) ) ) ->setOrderings(array( 'date' => \Neos\Flow\Persistence\QueryInterface::ORDER_DESCENDING) ) ->execute(); } } If you like to do things the hard way you can get away with implementing ``\Neos\Flow\Persistence\RepositoryInterface`` yourself, though that is something the normal developer never has to do. .. note:: With the query building API it is possible to query for properties of sub-entities easily via a dot-notation path. When querying multiple properties of a collection property, it is ambiguous if you want to select a single sub-entity with the given matching constraints, or multiple sub-entities which each matching a part of the given constraints. Since 4.0 Flow will translate such a query to "find all entities where a single sub-entity matches all the constraints", which is the more common case. If you intend a different querying logic, you should fall back to DQL or native SQL queries instead. Basics of Persistence in Flow ============================= On the Principles of DDD ------------------------ From Evans, the rules we need to enforce include: * The root Entity has global identity and is ultimately responsible for checking invariants. * Root Entities have global identity. Entities inside the boundary have local identity, unique only within the Aggregate. * Value Objects do not have identity. They are only identified by the combination of their properties and are therefore immutable. * Nothing outside the Aggregate boundary can hold a reference to anything inside, except to the root Entity. The root Entity can hand references to the internal Entities to other objects, but they can only use them transiently (within a single method or block). * Only Aggregate Roots can be obtained directly with database queries. Everything else must be done through traversal. * Objects within the Aggregate can hold references to other Aggregate roots. * A delete operation must remove everything within the Aggregate boundary all at once. * When a change to any object within the Aggregate boundary is committed, all invariants of the whole Aggregate must be satisfied. On the relationship between adding and retrieving ------------------------------------------------- When you ``add()`` something to a repository and do a ``findAll()`` immediately afterwards, you might be surprised: the freshly added object will not be found. This is not a bug, but a decision we took on purpose. Here is why. When you add an object to a repository, it is added to the internal identity map and will be persisted later (when ``persistAll()`` is called). It is therefore still in a transient state - but all query operations go directly to the underlying data storage, because we need to check that anyway. So instead of trying to query the in-memory objects we decided to ignore transient objects for queries [#]_. If you need to query for objects you just created, feel free to have the ``PersistenceManager`` injected and use ``persistAll()`` in your code. How changes are persisted ------------------------- When you ``add`` or ``remove`` an object to or from a repository, the object will be added to or removed from the underlying persistence as expected upon ``persistAll``. But what about changes to already persisted objects? As we have seen, those changes are only persisted, if the changed object is given to ``update`` on the corresponding repository. Now, for objects that have no corresponding repository, how are changes persisted? In the same way you fetch those objects from their parent - by traversal. Flow follows references from objects managed in a repository (aggregate roots) for all persistence operations, unless the referenced object itself is an aggregate root. When using the Doctrine 2 persistence, this is done by virtually creating cascade attributes on the mapped associations. That means if you changed an object attached to some aggregate root, you need to hand that aggregate root to ``update`` for the change to be persisted. Safe request methods are read-only ---------------------------------- According to the HTTP 1.1 specification, so called "safe request methods" (usually GET or HEAD requests) should not change your data on the server side and should be considered read-only. If you need to add, modify or remove data, you should use the respective request methods (POST, PUT, DELETE and PATCH). Flow supports this principle because it helps making your application more secure and perform better. In practice that means for any Flow application: if the current request is a "safe request method", the persistence framework will NOT trigger ``persistAll()`` at the end of the script run. You are free to call ``PersistenceManager->persistAll()`` manually or use allowed objects if you need to store some data during a safe request (for example, logging some data for your analytics). Allowed objects --------------- There are rare cases which still justify persisting objects during safe requests. For example, your application might want to generate thumbnails of images during a GET request and persist the resulting PersistentResource instances. For these cases it is possible to allow specific objects via the Persistence Manager:: $this->persistenceManager->allowObject($thumbnail); $this->persistenceManager->allowObject($thumbnail->getResource()); Be very careful and think twice before using this method since many security measures are not active during "safe" request methods. Dealing with big result sets ---------------------------- If the amount of the stored data increases, receiving all objects using a ``findAll()`` may consume a lot more memory than available. In this cases, you can use the ``findAllIterator()``. This method returns an ``IterableResult`` over which you can iterate, getting only one object at a time:: $iterator = $this->postRepository->findAllIterator(); foreach ($this->postRepository->iterate($iterator) as $post) { // Iterate over all posts } On Flow's use of UUIDs as primary keys -------------------------------------- Flow uses UUIDs as the identifier of anything stored in the database by default. This is in rather stark contrast to the de-facto standard of using some auto-incremented integer for that purpose. Such "UUID string identifiers" can lead to performance issues. Is that only an "academic discussion" or a real-life problem? It is a bit slower than integer primary keys and very tiny bit slower than bin(16) UUIDs. Insertion performance is the primary bottleneck then, as for reads as long as things are in the cache a few bytes likely don't make a difference. With integer (autoinc) primary keys you lose all the benefits of UUIDs (conflict-free backup and restore, potential for horizontal write scaling, client generated ids, ...). The trade-off then for bin(16) vs string UUIDs is human readability vs. performance in high insertion scenarios, which is very rarely the case. So unless you fall under such a high-throughput business case, you shouldn't really need to care and that's why Flow chooses this format by default. If you want to optimize performance with UUIDs the first thing is to choose another encoding which contains the timestamp in the first bytes (see the article https://www.percona.com/blog/2014/12/19/store-uuid-optimized-way/ and try https://uuid.ramsey.dev/en/latest/customize/timestamp-first-comb-codec.html) and then possibly switch the column type to bin(16). The primary benefit you have from the binary format is that a few more entries fit into cache, so any bottleneck is primarily shifted a bit back, but not generally removed. If insertion performance is an issue, then the timestamp-first UUIDs will yield much better improvements due to how RDBMS handle data internally (b-tree). Keep in mind we're talking about multiple thousand insertions per second on commodity server hardware here. In which case one should first investigate what drives that high throughout in the first place and if it is a real business cause or accidental complexity from e.g. a suboptimal domain model with an ORM or alike. Only if you then still find UUIDs to be a bottleneck, closely investigate alternatives (though auto-inc/int most likely isn't a solution then, because at that point you are having scalability issues and integer primary keys suffer in that part as mentioned, as they need a single central counter instance). Auto-inc keys also suffer from the fact that you need to cascade relation inserts - you need to insert the parent first, then retrieve the generated ID and only then can insert the children. This quite easily becomes a real bottleneck, because you need to cross the network multiple times, which is orders of magnitude slower than int vs string key insertion. Plus, with int IDs you always run into the issue of disclosing guessable identifiers in URLs, which you then hack around with offsets, some encoding or eventually add another secondary random identifier, at which point you pay the performance for both types. Conventions for File and Class Names ==================================== To allow Flow to detect the object type a repository is responsible for, certain conventions need to be followed: * Domain models should reside in a *Domain/Model* directory * Repositories should reside in a *Domain/Repository* directory and be named ``Repository`` * Aside from ``Model`` versus ``Repository`` the qualified class class names should be the same for corresponding classes * Repositories must implement ``\Neos\Flow\Persistence\RepositoryInterface`` (which is already the case when extending ``\Neos\Flow\Persistence\Repository`` or ``\Neos\Flow\Persistence\Doctrine\Repository``) *Example: Conventions for model and repository naming* .. code-block:: text \Neos \Blog \Domain \Model Blog Post \Repository BlogRepository PostRepository Another way to bind a repository to a model is to define a class constant named ``ENTITY_CLASSNAME`` in your repository and give it the desired model name as value. This should be done only when following the conventions outlined above is not feasible. Lazy Loading ============ Lazy Loading is a feature that can be equally helpful and dangerous when it comes to optimizing your application. Flow defaults to lazy loading when using Doctrine, i.e. it loads all the data in an object as soon as you fetch the object from the persistence layer but does not fetch data of associated objects. This avoids massive amounts of objects being reconstituted if you have a large object tree. Instead it defers property thawing in objects until the point when those properties are really needed. The drawback of this: If you access associated objects, each access will fire a request to the persistent storage now. So there might be situations when eager loading comes in handy to avoid excessive database roundtrips. Eager loading can be achieved for the Doctrine 2 ORM by using join operations in DQL or specifying the fetch mode in the mapping configuration. Doctrine Persistence ==================== Doctrine 2 ORM is used by default in Flow. Aside from very few internal changes it consists of the regular Doctrine ORM, DBAL, Migrations and Common libraries and is tied into Flow by some glue code and (most important) a custom annotation driver for metadata consumption. Requirements and restrictions ----------------------------- There are some rules imposed by Doctrine (and/or Flow) you need to follow for your entities (and value objects). Most of them are good practice anyway, and thus are not really restrictions. * Entity classes must not be ``final`` or contain ``final`` methods. * Persistent properties of any entity class should always be ``protected``, not ``public``, otherwise lazy-loading might not work as expected. * Implementing ``__clone()`` or ``__wakeup()`` is not a problem with Flow, as the instances always have an identity. If using your own identity properties, you must wrap any code you intend to run in those methods in an identity check. * Entity classes in a class hierarchy that inherit directly or indirectly from one another must not have a mapped property with the same name. * Entities cannot use ``func_get_args()`` to implement variable parameters. The proxies generated by Doctrine do not support this for performance reasons and your code might actually fail to work when violating this restriction. Persisted instance variables must be accessed only from within the entity instance itself, not by clients of the entity. The state of the entity should be available to clients only through the entity’s methods, i.e. getter/setter methods or other business methods. Collection-valued persistent fields and properties must be defined in terms of the ``Doctrine\Common\Collections\Collection`` interface. The collection implementation type may be used by the application to initialize fields or properties before the entity is made persistent. Once the entity becomes managed (or detached), subsequent access must happen through the interface type. Metadata mapping ---------------- The Doctrine 2 ORM needs to know a lot about your code to be able to persist it. Natively Doctrine 2 supports the use of annotations, XML, YAML and PHP to supply that information. In Flow, only annotations are supported, as this aligns with the philosophy behind the framework. Annotations for the Doctrine Persistence ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ The following table lists the most common annotations used by the persistence framework with their name, scope and meaning: :title:`Persistence-related code annotations` +------------------+----------+----------------------------------------------------------+ | Annotation | Scope | Meaning | +==================+==========+==========================================================+ | ``Entity`` | Class | Declares a class as an Entity. | +------------------+----------+----------------------------------------------------------+ | ``ValueObject`` | Class | Declares a class as a Value Object, allowing the | | | | persistence framework to reuse an existing object if one | | | | exists. | +------------------+----------+----------------------------------------------------------+ | ``Column`` | Variable | Allows to take influence on the column actually | | | | generated for this property in the database. | | | | Particularly useful with string properties to limit the | | | | space used or to enable storage of more than 255 | | | | characters. | +------------------+----------+----------------------------------------------------------+ | ``ManyToOne``, | Variable | Defines the type of object associations, refer to the | | ``OneToMany``, | | Doctrine 2 documentation for details. The most obvious | | ``ManyToMany``, | | difference to plain Doctrine 2 is that the | | ``OneToOne`` | | ``targetEntity`` parameter can be omitted, it is taken | | | | from the ``@var`` annotation. | | | | | | | | See below for unidirectional ``OneToMany`` relations! | | | | | | | | The ``cascade`` attribute is set to cascade all | | | | operations on associations within aggregate boundaries. | | | | In that case orphanRemoval is turned on as well. | +------------------+----------+----------------------------------------------------------+ | ``@var`` | Variable | Is used to detect the type a variable has. For | | | | collections, the type is given in angle brackets. | +------------------+----------+----------------------------------------------------------+ | ``Transient`` | Variable | Makes the persistence framework ignore the variable. | | | | Neither will it's value be persisted, nor will it be | | | | touched during reconstitution. | +------------------+----------+----------------------------------------------------------+ | ``Identity`` | Variable | Marks the variable as being relevant for determining | | | | the identity of an object in the domain. For all class | | | | properties marked with this, a (compound) unique index | | | | will be created in the database. | +------------------+----------+----------------------------------------------------------+ Doctrine supports many more annotations, for a full reference please consult the Doctrine 2 ORM documentation. On unidirectional ``OneToMany`` relations ----------------------------------------- Inside a single aggregate `OneToMany` relations are normally best modeled unidirectionally. Bidirectional relations always are harder to manage correctly and can easily lead to unintentional traversal of entity hierarchies with all the drawbacks. Since Doctrines `OneToMany` annotation is always bidrectional and also dictates the owning side of the relation (at the unexpected side from a modeling PoV), it is not straightforward to model this correctly. In Flow specifically, we try to follow DDD best practices in modelling and this means, that the aggregate root is the entry point and the entity that is sent to a repository to persist it and all its sub-entities. This can not be achieved with the standard doctrine `OneToMany` annotation when the one side is supposed to be closer to the root. So Flow allows the you to annotate such a relation simply as: .. code-block:: php /** * @ORM\OneToMany * @var Collection */ This is done by remapping `OneToMany` annotations without a `mappedBy` as `ManyToMany` with an unique constraint. On Value Object handling with Doctrine -------------------------------------- Doctrine 2.5 supports value objects in the form of embeddable objects [#]_. This means that the value object properties will directly be included in the parent entities table schema. However, Doctrine doesn't currently support embeddable collections [#]_. Therefore, Flow supports two types of value objects: readonly entities and embedded By default, since 7.0 Flow will use the embedded version, as that is the more fitting storage schema. If you need to include your value object in a collection, you need to mark it as `@Flow\ValueObject(embedded=false)`. The value object thereby is actually treated like an entity with an identifier, that is derived from its properties. The behaviour of non-embedded Value Objects is as follows: * Value Objects are marked immutable as with the ``ReadOnly`` annotation of Doctrine. * Each Value Object will internally be referenced by an identifier that is automatically generated from it's property values after construction. * If the relation to a Value Object is annotated as OneTo* or ManyTo*, the Value Object will be persisted in it's own table. Otherwise, unless you override the type using ``Column`` Value Objects will be stored as serialized object in the database. * Upon persisting Value Objects already present in the underlying database they will be deduplicated by being referenced through the identifier. For cases where a \*ToMany relation to a Value Object is not needed, the embedded form is the more natural way to persist value objects. The behaviour of embedded Value Objects is as follows: * Every entity having a property of type embedded Value Object will get all the properties of the Value Object included in it's schema. * Unless you specify the ``Embedded`` Annotation on the relation property, the schema prefix will be the property name. .. code-block:: php /** * @Flow\ValueObject */ class ValueObject { /** * @var string */ protected $value; ... } class SomeEntity { /** * @var ValueObject */ protected $valueObject; This will result in the `SomeEntity` schema having a table column `valueobject_value` by default. Custom Doctrine mapping types ----------------------------- Doctrine provides a way to develop custom mapping types as explained in the documentation ([#doctrineMappingTypes]). Registration of those types in a Flow application is done through settings: .. code-block:: yaml Neos: Flow: persistence: doctrine: # DBAL custom mapping types can be registered here dbal: mappingTypes: 'mytype': dbType: 'db_mytype' className: 'Acme\Demo\Doctrine\DataTypes\MyType' The custom type can then be used: .. code-block:: php class SomeModel { /** * Some custom type property * * @ORM\Column(type="mytype") * @var string */ protected $mytypeProperty; .. [#doctrineMappingTypes] http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/cookbook/custom-mapping-types.html On the Doctrine Event System ---------------------------- Doctrine provides a flexible event system to allow extensions to plug into different parts of the persistence. Therefore two methods to get notification of doctrine events are possible - through the EventSubscriber interface and registering EventListeners. Flow allows for easily registering both with Doctrine through the configuration settings ``Neos.Flow.persistence.doctrine.eventSubscribers`` and ``Neos.Flow.persistence.doctrine.eventListeners`` respectively. EventSubscribers need to implement the ``Doctrine\Common\EventSubscriber`` Interface and provide a list of the events they want to subscribe to. EventListeners need to be configured for the events they want to listen on, but do not need to implement any specific Interface. See the documentation ([#]_) for more information on the Doctrine Event System. *Example: Configuration for Doctrine EventSubscribers and EventListeners*: .. code-block:: yaml Neos: Flow: persistence: doctrine: eventSubscribers: - 'Foo\Bar\Events\EventSubscriber' eventListeners: - events: ['onFlush', 'preFlush', 'postFlush'] listener: 'Foo\Bar\Events\EventListener' On the Doctrine Filter System ----------------------------- Doctrine provides a filter system that allows developers to add SQL to the conditional clauses of queries, regardless the place where the SQL is generated (e.g. from a DQL query, or by loading). Flow allows for easily registering Filters with Doctrine through the configuration setting ``Neos.Flow.persistence.doctrine.filters``. *Example: Configuration for Doctrine Filters*: .. code-block:: yaml Neos: Flow: persistence: doctrine: filters: 'my-filter-name': 'Acme\Demo\Filters\MyFilter' See the Doctrine documentation ([#]_) for more information on the Doctrine Filter System. .. note:: If you create a filter and run into fatal errors caused by overriding a final ``__construct()`` method in one of the Doctrine classes, you need to add ``@Flow\Proxy(false)`` to your filter class to prevent Flow from building a proxy, which causes this error. .. warning:: Custom SqlFilter implementations - watch out for data privacy issues! If using custom SqlFilters, you have to be aware that the SQL filter is cached by doctrine, thus your SqlFilter might not be called as often as you might expect. This may lead to displaying data which is not normally visible to the user! Basically you are not allowed to call `setParameter` inside `addFilterConstraint`; but setParameter must be called *before* the SQL query is actually executed. Currently, there's no standard Doctrine way to provide this; so you manually can receive the filter instance from `$entityManager->getFilters()->getEnabledFilters()` and call `setParameter()` then. Alternatively, you can register a global context object in `Neos.Flow.aop.globalObjects` and use it to provide additional identifiers for the caching by letting these global objects implement `CacheAwareInterface`; effectively segregating the Doctrine cache some more. Custom Doctrine DQL functions ----------------------------- Doctrine allows custom functions for use in DQL. In order to configure these for the use in Flow, use the following Settings: .. code-block:: yaml Neos: Flow: persistence: doctrine: dql: customStringFunctions: 'SOMEFUNCTION': 'Acme\Demo\Persistence\Ast\SomeFunction' customNumericFunctions: 'FLOOR': 'Acme\Demo\Persistence\Ast\Floor' 'CEIL': 'Acme\Demo\Persistence\Ast\Ceil' customDatetimeFunctions: 'UTCDIFF': 'Acme\Demo\Persistence\Ast\UtcDiff' See the Doctrine documentation ([#doctrineDqlFunctions]_) for more information on the Custom DQL functions. .. [#doctrineDqlFunctions] http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/dql-doctrine-query-language.html#adding-your-own-functions-to-the-dql-language Metadata and Query Cache ------------------------ Flow automatically configures a cache for the Doctrine metadata, the used cache is the ``Flow_Persistence_Doctrine`` cache. The result cache is configured as well, the used cache is ``Flow_Persistence_Doctrine_Results``. This happens in ``\Neos\Flow\Persistence\Doctrine\EntityManagerConfiguration::applyCacheConfiguration(…)`` The use of the result cache can be enabled globally using the ``Neos.Flow.persistence.cacheAllQueryResults`` setting or on a per-query level by using the ``$cacheResult`` parameter of the ``Query::execute()`` method. See https://www.doctrine-project.org/projects/doctrine-dbal/en/2.13/reference/caching.html for more information. Using Doctrine's Second Level Cache ----------------------------------- Doctrine provides a second level cache that further improves performance of relation queries beyond the result query cache. See the Doctrine documentation ([#doctrineSecondLevelCache]_) for more information on the second level cache. Flow allows you to enable and configure the second level cache through the configuration setting ``Neos.Flow.persistence.doctrine.secondLevelCache``. *Example: Configuration for Doctrine second level cache*: .. code-block:: yaml Neos: Flow: persistence: doctrine: secondLevelCache: enable: true defaultLifetime: 3600 regions: 'my_entity_region': 7200 .. [#doctrineSecondLevelCache] https://www.doctrine-project.org/projects/doctrine-orm/en/2.10/reference/second-level-cache.html Customizing Doctrine EntityManager ---------------------------------- For any cases that are not covered with the above options, Flow provides two convenient signals to hook into the setup of the doctrine EntityManager. The `beforeDoctrineEntityManagerCreation` signal provides you with the DBAL connection, the doctrine configuration and EventManager classes, that you can change before the actual EntityManager is instantiated. The `afterDoctrineEntityManagerCreation` signal provides the doctrine configuration and EntityManager instance, in order to to further set options. .. note:: All above configuration options through the settings are actually implemented as slots to the before mentioned signals. If you want to take some look how this works, check the `Neos\Flow\Persistence\Doctrine\EntityManagerConfiguration` class. Differences between Flow and plain Doctrine ------------------------------------------- The custom annotation driver used by Flow to collect mapping information from the code makes a number of things easier, compared to plain Doctrine 2. ``Entity`` ``repositoryClass`` can be left out, if you follow the naming rules for your repository classes explained above. ``Table`` ``name`` does not default to the unqualified entity classname, but a name is generated from class name, package key and more elements to make it unique. ``Id`` Can be left out, as it is automatically generated, this means you also do not need ``@GeneratedValue``. Every entity will get a property injected that is filled with an UUID upon instantiation and used as technical identifier. If an ``@Id`` annotation is found, it is of course used as is and no magic will happen. ``Column`` Can usually be left out altogether, as the vital *type* information can be read from the ``@var`` annotation on a class member. .. important:: Since PHP does not differentiate between short and long strings, but databases do, you must use ``@Column(type="text")`` if you intend to store more than 255 characters in a string property. ``OneToOne``, ``OneToMany``, ``ManyToOne``, ``ManyToMany`` ``targetEntity`` can be omitted, it is read from the ``@var`` annotation on the property. Relations to Value Objects will be ``cascade`` ``persist`` by default and relations to non aggregate root entities will be ``cascade`` ``all`` by default. ``JoinTable``, ``JoinColumn`` Can usually be left out completely, the needed information is gathered automatically But *when using a self-referencing association*, you will need to help Flow a little, so it doesn't generate a join table with only one column. *Example: JoinTable annotation for a self-referencing annotation* :: /** * @var \Doctrine\Common\Collections\ArrayCollection<\Neos\Blog\Domain\Model\Post> * @ORM\ManyToMany * @ORM\JoinTable(inverseJoinColumns={@ORM\JoinColumn(name="related_id")}) */ protected $relatedPosts; Without this, the created table would not contain two columns but only one, named after the identifiers of the associated entities - which is the same in this case. ``DiscriminatorColumn``, ``DiscriminatorMap`` Can be left out, as they are automatically generated. The generation of this metadata is slightly more expensive compared to the plain Doctrine ``AnnotationDriver``, but since this information can be cached after being generated once, we feel the gain when developing outweighs this easily. .. tip:: Anything you explicitly specify in annotations regarding Doctrine, has precedence over the automatically generated metadata. This can be used to fully customize the mapping of database tables to models. Here is an example to illustrate the things you can omit, due to the automatisms in the Flow annotation driver. *Example: Annotation equivalents in Flow and plain Doctrine 2* An entity with only the annotations needed in Flow:: /** * @Flow\Entity */ class Post { /** * @var \Neos\Blog\Domain\Model\Blog * @ORM\ManyToOne(inversedBy="posts") */ protected $blog; /** * @var string * @ORM\Column(length=100) */ protected $title; /** * @var \DateTime */ protected $date; /** * @var ?string * @ORM\Column(type="text") */ protected $content; /** * @var \Doctrine\Common\Collections\ArrayCollection<\Neos\Blog\Domain\Model\Comment> * @ORM\OneToMany(mappedBy="post") * @ORM\OrderBy({"date" = "DESC"}) */ protected $comments; The same code with all annotations needed in plain Doctrine 2 to result in the same metadata:: /** * @ORM\Entity(repositoryClass="Neos\Blog\Domain\Model\Repository\PostRepository") * @ORM\Table(name="blog_post") */ class Post { /** * @var string * @ORM\Id * @ORM\Column(name="persistence_object_identifier", type="string", length=40) */ protected $Persistence_Object_Identifier; /** * @var \Neos\Blog\Domain\Model\Blog * @ORM\ManyToOne(targetEntity="Neos\Blog\Domain\Model\Blog", inversedBy="posts") * @ORM\JoinColumn(name="blog_blog", referencedColumnName="persistence_object_identifier") */ protected $blog; /** * @var string * @ORM\Column(type="string", length=100) */ protected $title; /** * @var \DateTime * @ORM\Column(type="datetime") */ protected $date; /** * @var string * @ORM\Column(type="text", nullable=true) */ protected $content; /** * @var \Doctrine\Common\Collections\ArrayCollection<\Neos\Blog\Domain\Model\Comment> * @ORM\OneToMany(targetEntity="Neos\Blog\Domain\Model\Comment", mappedBy="post", cascade={"all"}, orphanRemoval=true) * @ORM\OrderBy({"date" = "DESC"}) */ protected $comments; Schema management ================= Doctrine offers a *Migrations* system as an add-on part of its DBAL for versioning of database schemas and easy deployment of changes to them. There exist a number of commands in the Flow CLI toolchain to create and deploy migrations. A Migration is a set of commands that bring the schema from one version to the next. In the simplest form that means creating a new table, but it can be as complex as renaming a column and converting data from one format to another along the way. Migrations can also be reversed, so one can migrate up and down. Each Migration is represented by a PHP class that contains the needed commands. Those classes come with the package they relate to, they have a name that is based on the time they were created. This allows correct ordering of migrations coming from different packages. Query the schema status ----------------------- To learn about the current schema and migration status, run the following command: .. code-block:: bash $ ./flow flow:doctrine:migrationstatus This will produce output similar to the following, obviously varying depending on the actual state of schema and active packages: *Example: Migration status report* .. code-block:: text +----------------------+-------------------------------------------+------------------------------------------------------------------------+ | Configuration | +----------------------+-------------------------------------------+------------------------------------------------------------------------+ | Storage | Type | Doctrine\Migrations\Metadata\Storage\TableMetadataStorageConfiguration | | | Table Name | flow_doctrine_migrationstatus | | | Column Name | version | |-------------------------------------------------------------------------------------------------------------------------------------------| | Database | Driver | Doctrine\DBAL\Driver\PDO\MySQL\Driver | | | Name | flowdev | |-------------------------------------------------------------------------------------------------------------------------------------------| | Versions | Previous | Neos\Flow\Persistence\Doctrine\Migrations\Version20180827132710 | | | Current | Neos\Flow\Persistence\Doctrine\Migrations\Version20200908155620 | | | Next | Already at latest version | | | Latest | Neos\Flow\Persistence\Doctrine\Migrations\Version20200908155620 | |-------------------------------------------------------------------------------------------------------------------------------------------| | Migrations | Executed | 27 | | | Executed Unavailable | 0 | | | Available | 27 | | | New | 0 | |-------------------------------------------------------------------------------------------------------------------------------------------| | Migration Namespaces | Neos\Flow\Persistence\Doctrine\Migrations | /Users/karsten/Sites/flowdev/Data/DoctrineMigrations | +----------------------+-------------------------------------------+------------------------------------------------------------------------+ Whenever a version number needs to be given to a command, use the short form as shown in parentheses in the output above. The migrations directory in the output is only used when creating migrations, see below for details on that. Deploying migrations -------------------- On a pristine database it is very easy to create the tables needed with the following command: .. code-block:: bash $ ./flow flow:doctrine:migrate This will result in output that looks similar to the following: .. code-block:: text Migrating up to Neos\Flow\Persistence\Doctrine\Migrations\Version20200908155620 -> ALTER TABLE neos_flow_resourcemanagement_persistentresource DROP md5 [notice] finished in 75.8ms, used 34M memory, 1 migrations executed, 1 sql queries This will deploy all migrations delivered with the currently active packages to the configured database. During that process it will display all the SQL statements executed and a summary of the deployed migrations at the and. You can do a dry run using: .. code-block:: bash $ ./flow flow:doctrine:migrate --dry-run This will result in output that looks similar to the following: .. code-block:: text Migrating (dry-run) up to Neos\Flow\Persistence\Doctrine\Migrations\Version20200908155620 -> UPDATE neos_flow_security_account SET roleidentifiers=REPLACE(roleidentifiers, 'TYPO3.Flow:', 'Neos.Flow:') -> UPDATE neos_flow_security_account SET roleidentifiers=REPLACE(roleidentifiers, 'TYPO3.Neos:', 'Neos.Neos:') -> UPDATE neos_flow_security_account SET roleidentifiers=REPLACE(roleidentifiers, 'TYPO3.TYPO3CR:', 'Neos.ContentRepository:') -> UPDATE neos_flow_security_account SET roleidentifiers=REPLACE(roleidentifiers, 'TYPO3.Setup:', 'Neos.Setup:') -> DROP INDEX flow_identity_typo3_flow_security_account ON neos_flow_security_account -> CREATE UNIQUE INDEX flow_identity_neos_flow_security_account ON neos_flow_security_account (accountidentifier, authenticationprovidername) -> CREATE INDEX IDX_35DC14F03332102A ON neos_flow_resourcemanagement_persistentresource (sha1) -> CREATE INDEX IDX_535A651E772E836ADCCB5599802C8F9D ON neos_flow_mvc_routing_objectpathmapping (identifier, uripattern, pathsegment) -> ALTER TABLE neos_flow_resourcemanagement_persistentresource DROP md5 [notice] finished in 59.6ms, used 36M memory, 5 migrations executed, 9 sql queries to see the same output but without any changes actually being done to the database. If you want to inspect and possibly adjust the statements that would be run and deploy manually, you can write to a file: .. code-block:: bash $ ./flow flow:doctrine:migrate --path This will result in output that looks similar to the following: .. code-block:: text Writing migration file to "" .. important:: When actually making manual changes, you need to keep the ``flow_doctrine_migrationstatus`` table updated as well! This is done with the ``flow:doctrine:migrationversion`` command. It takes a ``--version`` option together with either an ``--add`` or ``--delete`` flag to add or remove the given version in the ``flow_doctrine_migrationstatus`` table. It does not execute any migration code but simply marks the given version as migrated or not. Reverting migrations -------------------- The migrate command takes an optional ``--version`` option. If given, migrations will be executed up or down to reach that version. This can be used to revert changes, even completely: .. code-block:: bash $ ./flow flow:doctrine:migrate --version --dry-run This will result in output that looks similar to the following: .. code-block:: text Migrating (dry-run) down to Neos\Flow\Persistence\Doctrine\Migrations\Version20161124185047 -> ALTER TABLE neos_flow_resourcemanagement_persistentresource ADD md5 VARCHAR(32) NOT NULL -> DROP INDEX IDX_535A651E772E836ADCCB5599802C8F9D ON neos_flow_mvc_routing_objectpathmapping -> DROP INDEX IDX_35DC14F03332102A ON neos_flow_resourcemanagement_persistentresource -> DROP INDEX flow_identity_neos_flow_security_account ON neos_flow_security_account -> CREATE UNIQUE INDEX flow_identity_typo3_flow_security_account ON neos_flow_security_account (accountidentifier, authenticationprovidername) -> UPDATE neos_flow_security_account SET roleidentifiers=REPLACE(roleidentifiers, 'Neos.Flow:', 'TYPO3.Flow:') -> UPDATE neos_flow_security_account SET roleidentifiers=REPLACE(roleidentifiers, 'Neos.Neos:', 'TYPO3.Neos:') -> UPDATE neos_flow_security_account SET roleidentifiers=REPLACE(roleidentifiers, 'Neos.ContentRepository:', 'TYPO3.TYPO3CR:') -> UPDATE neos_flow_security_account SET roleidentifiers=REPLACE(roleidentifiers, 'Neos.Setup:', 'TYPO3.Setup:') [notice] finished in 101.1ms, used 36M memory, 5 migrations executed, 9 sql queries Executing or reverting a specific migration ------------------------------------------- Sometimes you need to deploy or revert a specific migration, this is possible as well. .. code-block:: bash $ ./flow flow:doctrine:migrationexecute --version --direction --dry-run This will result in output that looks similar to the following: .. code-block:: text $ ./flow doctrine:migrationexecute --version 'Neos\Flow\Persistence\Doctrine\Migrations\Version20161124185047' --direction down Migrating down to Neos\Flow\Persistence\Doctrine\Migrations\Version20161124185047 -> RENAME TABLE neos_flow_mvc_routing_objectpathmapping TO typo3_flow_mvc_routing_objectpathmapping -> RENAME TABLE neos_flow_resourcemanagement_persistentresource TO typo3_flow_resourcemanagement_persistentresource -> RENAME TABLE neos_flow_security_account TO typo3_flow_security_account [notice] finished in 64.2ms, used 36M memory, 1 migrations executed, 3 sql queries As you can see you need to specify the migration ``--version`` you want to execute. If you want to revert a migration, you need to give the ``--direction`` as shown above, the default is to migrate "up". The ``--dry-run`` and and ``--output`` options work as with ``flow:doctrine:migrate``. Creating migrations ------------------- Migrations make the schema match when a model changes, but how are migrations created? The basics are simple, but rest assured that database details and certain other things make sure you'll need to practice... The command to scaffold a migration is the following: .. code-block:: bash $ ./flow flow:doctrine:migrationgenerate This will result in output that looks similar to the following: .. code-block:: text Generated new migration class! Do you want to move the migration to one of these packages? [0] Don't Move [1] Neos.Http.Factories [2] … You should pick the package that your new migration covers, it will then be moved as requested. The command will output the path to generated migration and suggest some next steps to take. .. important:: If you decide not to move the file, it will be put into `Data/DoctrineMigrations/`. That directory is only used when creating migrations. The migrations visible to the system are read from *Migrations/* in each package. The ** represents the target platform, e.g. ``Mysql`` (as in Doctrine DBAL but with the first character uppercased). Looking into that file reveals a basic migration class already filled with the differences detected between the current schema and the current models in the system: *Example: Migration generated based on schema/model differences* :: abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.'); $this->addSql("CREATE TABLE party_abstractparty (…) ENGINE = InnoDB"); } public function down(Schema $schema) : void { // this down() migration is auto-generated, please modify it to your needs $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.'); $this->addSql("DROP TABLE party_abstractparty"); } } To create an empty migration skeleton, pass ``--diff-against-current 0`` to the command. After you generated a migration, you will probably need to clean up a little, as there might be differences being picked up that are not useful or can be optimized. An example is when you rename a model: The migration will drop the old table and create the new one, but what you want instead is to *rename* the table. Also you must to make sure each finished migration file only deals with one package and then move it to the *Migrations* directory in that package. This way different packages can be mixed and still a reasonable migration history can be built up. Ignoring tables --------------- For tables that are not known to the schema because they are code-generated or come from a different system sharing the same database, the ``flow:doctrine:migrationgenerate`` command will generate corresponding ``DROP TABLE`` statements. In this case you can use the ``--filter-expression`` flag to generate migrations only for tables matching the given pattern: .. code-block:: bash $ ./flow flow:doctrine:migrationgenerate --filter-expression '^your_package_.*' Will only affect tables starting with "your_package\_". To permanently skip certain tables the ``ignoredTables`` setting can be used: .. code-block:: yaml Neos: Flow: persistence: doctrine: migrations: ignoredTables: 'autogenerated_.*': true 'wp_.*: true Will ignore table starting with "autogenerated\_" or "wp\_" by default (the `--filter-expression` flag overrules this setting). Schema updates without migrations --------------------------------- Migrations are the recommended and preferred way to bring your schema up to date. But there might be situations where their use is not possible (e.g. no migrations are available yet for the RDBMS you are using) or not wanted (because of, um… something). The there are two simple commands you can use to create and update your schema. To create the needed tables you can call ``./flow flow:doctrine:create`` and it will create all needed tables. If any target table already exists, an error will be the result. To update an existing schema to match with the current mapping metadata (i.e. the current model structure), use ``./flow flow:doctrine:update`` to have missing items (fields, indexes, ...) added. There is a flag to disable the safe mode used by default. In safe mode, Doctrine tries to keep existing data as far as possible, avoiding lossy actions. .. warning:: Be careful, the update command might destroy data, as it could drop tables and fields irreversibly. It also doesn't respect the ``ignoredTables`` settings (see previous section). Both commands also support ``--output `` to write the SQL statements to the given file instead of executing it. .. tip:: If you created or updated the schema this way, you should afterwards execute ``flow:doctrine:migrationversion --version all --add`` to avoid migration errors later. Doctrine Connection Wrappers - Master/Slave Connections ------------------------------------------------------- Doctrine 2 allows to create Connection wrapper classes, that change the way Doctrine connects to your database. A common use case is a master/slave replication setup, with one master server and several slaves that share the load for all reading queries. Doctrine already provides a wrapper for such a connection and you can configure Flow to use that connection wrapper by setting the following options in your packages ``Settings.yaml``: .. code-block:: text Neos: Flow: persistence: backendOptions: wrapperClass: 'Doctrine\DBAL\Connections\MasterSlaveConnection' master: host: '127.0.0.1' # adjust to your master database host dbname: 'master' # adjust to your database name user: 'user' # adjust to your database user password: 'pass' # adjust to your database password slaves: slave1: host: '127.0.0.1' # adjust to your slave database host dbname: 'slave1' # adjust to your database name user: 'user' # adjust to your database user password: 'pass' # adjust to your database password With this setup, Doctrine will use one of the slave connections picked once per request randomly for all queries until the first writing query (e.g. insert or update) is executed. From that point on the master server will be used solely. This is to solve the problems of replication lag and possibly inconsistent query results. .. tip:: You can also setup the master database as a slave, if you want to also use it for load-balancing reading queries. However, this might lead to higher load on the master database and should be well observed. Known issues ------------ * When using PostgreSQL the use of the ``object``, and ``array`` mapping types is not possible, this is caused by Doctrine using ``serialize()`` to prepare data that is stored in text column (contained zero bytes truncate the string and lead to error during hydration). [#]_ The Flow mapping types ``flow_json_array`` and ``objectarray`` provide solutions for this. * When using PostgreSQL the use of the ``json_array`` mapping type can lead to issues when queries need comparisons on such columns (e.g. when grouping or doing distinct queries), because the ``json`` type used by Doctrine doesn't support comparisons. The Flow mapping type ``flow_json_array`` uses the ``jsonb`` type available as of PostgreSQL 9.4, circumventing this restriction. .. [#] An alternative would have been to do an implicit persist call before a query, but that seemed to be confusing. .. [#] https://doctrine-orm.readthedocs.org/en/latest/tutorials/embeddables.html .. [#] https://github.com/doctrine/doctrine2/issues/3579 .. [#] https://doctrine-orm.readthedocs.org/en/latest/reference/events.html .. [#] https://doctrine-orm.readthedocs.org/en/latest/reference/filters.html#filters .. [#] http://www.doctrine-project.org/jira/browse/DDC-3241