I have this: /** * @var string[] */ #[ORMColumn(type: 'json', nullable: true)] private array $roles = []; How can I change string[] to php8 attribute ? Something like #[Array(string)] I am working with Symfony and Doctrine, and I am trying…
I have a docker env set up with Symfony (5.x) & MariaDB - the docker-compose.yaml file contains the db configuration env variables. The .env.local file in the Symfony app uses the configuration variables from the docker-compose file to build out…
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…