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 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 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…
for the current project that I am going to work on, I need to create many entities using the make:entity command. Each time a new entity is created it needs to have the following columns that need to be defined…
I am trying to install the migrations on a fresh install of laravel 9, however I am getting this error Problem 1 Root composer.json requires laravel-doctrine/migrations ^2.3 -> satisfiable by laravel-doctrine/migrations[2.3.0, 2.3.1, 2.x-dev]. laravel-doctrine/migrations[2.3.0, ..., 2.x-dev] require illuminate/config ^6.0|^7.0|^8.0 ->…
We are working with Symfony and Doctrine ORM. We mostly use MySQL / MariaDB, and for a new project we are considering trying PostgreSQL. Obviously using an ORM like Doctrine is doing a lot of the work for us, and…
I want to show a count of a related table to the one building the query builder. The working native query is the following one: select id, name, (select count(*) from houses where status = 1 and street_id = s.id)…
This query has so many joins and i have to apply conditions on joined table columns to get the desired results but query becomes slow when i apply condition on a datetime column. Here is the query select distinct v0_.id…
As Doctrine seems to have completely removed annotations support in their latest updates, I am trying to convert the annotations in my entities to attributes using Rector. I followed the (seemingly) simple official tutorial - I have the exact same…
There's a solution via RFE for this in RFE; solve problem with bin commands and php versions I'm dealing with a new app in symfony 5.4 and php 7.4 to test the new additions and changes in symfony 6. I've…