I am trying to update the properties of my entity. For example, in the TestEntity class: class TestEntity { #[ORMId] #[ORMGeneratedValue] #[ORMColumn] private ?int $id = null; #[ORMColumn(length: 255)] private ?string $testMe = null; public function getId(): ?int { return…
I added an auto-update timestamp to an entity like in this blog post and it works just fine. Here is the code snippet: #[Entity] class Article { #[Column(type: "datetime", columnDefinition: "TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP", insertable: false, updatable: false,…
If I have a Querybuilder instance and apply something like this: $queryBuilder->addSelect(" CASE WHEN c.modifyStamp > c.createStamp THEN 'draft' ELSE 'published' END AS state "); then, on using getResult, I will get something like this: [ 0 => [ 0…
I have this entity called Employee where one of the field is an ArrayCollection which contains another entity called Invoice stored as the invoice id. Its worth mentioning here is that Employee and Invoice has many-to-many relationship. That is 1…
I've a association in my EntityDefinition: ... class ParentEntityDefinition extends EntityDefinition { ... protected function defineFields(): FieldCollection { return new FieldCollection([ (new OneToOneAssociationField( 'childEntity', 'id', 'parent_entity_id', ChildEntityDefinition::class, false)), ]); } ... } The ChildEntity has a fk_field to currency_entity. To…
There's isDefault property in an entity. If it's set to true, the isDefault property of all other entities must be set to false. Is there a clean solution without the QueryBuilder or plain SQL? And if so, what is the…
I was wondering if there was still no way to work with fake or generated (virtual?) properties in Doctrine? I take an old example: a Person entity with a firstname and a lastname (based on a table with these two…
I did a fresh installation. OS: Ubuntu Linux 22.04.1 Kernel: Linux 5.15.0-58-generic on x86_64 PHP 8.1.2 Symfony 6.2.6 (env: dev, debug: true) Doctrine: 2.14.1 This is what I did to create an empty project with Symfony: cd /var/www/html symfony new…
I have this simple entity for example: <?php namespace AppEntityCreator; use AppRepositoryCreatorActivityContactRepository; use DoctrineORMMapping as ORM; #[ORMEntity(repositoryClass: ActivityContactRepository::class)] #[ORMIndex(columns: ['contact_id'])] class ActivityContact { #[ORMId] #[ORMManyToOne(targetEntity: Activity::class, cascade: ['persist'])] private Activity $activity; #[ORMId] #[ORMColumn(name: 'contact_id', type: 'integer')] private int $contactId; public…
I've got a program whose database is synced with an external database (unidirectional, the other program/database is always the sender). Everytime the sync takes place, I create, update or delete records. The other program always sends all its entities of…