In my Symfony app, I have a function that saves a record using Doctrine: public function save(Car $car): void { $this->getEntityManager()->persist($car); $this->getEntityManager()->flush($car); } But in recent days, I get a lot of log entries like this: Calling DoctrineORMEntityManager::flush() with any…
I have the following Model: <?php namespace AppDomainModelMeal; use AppDomainModelHasUuid; use AppDomainModelTimestampable; use AppDomainModelUserChild; use DoctrineORMMapping as ORM; use RamseyUuidUuid; #[ORMEntity] #[ORMTable(name: 'meal_opt_out')] final class MealOptOut { use HasUuid; use Timestampable; #[ORMManyToOne(targetEntity: MealItemSchedule::class)] #[ORMJoinColumn(name: 'meal_item_schedule_id', referencedColumnName: 'id', nullable: false, onDelete:…
I have an unusual index, which is consists of: some_field, COALESCE(other_field, 0) So I'm trying to use it in description of my entity #[ORMUniqueConstraint( name: 'some_index', columns: ['some_field', 'COALESCE(other_field, 0)'] )] Of course, doctrine cannot find such column and returns…
In localhost, symfony console doctrine:database:create runs perfectly. But when I try to install the project for production on Ubunthu server, that does not work. I have a .env file with vars like : .env ###> symfony/framework-bundle ### APP_ENV=%APP_ENV% APP_SECRET=%APP_SECRET% ###<…
I try make charge test with a symfony web app. I've an Entity with 13 fields including 1 primary key and 7 foreiner keys. I've injected 40K data. My controller use a findAll() and KNP Paginator with a maximum of…
Given an entity Client, I have several columns, such as clientName, clientNo, etc. The table itself holds 250+ entries. There are several ManyToOne links, with tables that hold 500.000+ entries. For reasons I don't understand, this query: $queryBuilder = $this->getDoctrine()…
In Doctrine ORM there is a separation between persist() and flush() operations. Looks like whenever you want to insert/update your entity, you have to call two methods one by one. And most developers do it this way. But I wonder…
I recently upgraded a Laminas project from doctrine-migrations 1.4 to 3.6 and doctrine-orm-module from 1 to 5.3. On my deployment server, when running ./vendor/bin/doctrine-module sync-metadata-storage, I receive the following error: Fatal error: Uncaught DoctrineDBALException: The given 'driverClass' DoctrineDBALDriverPDOMySqlDriver has to…
Assume I have two tables related with one to many: Person: - name - age - phone Attributes: - fk - field - value for example Person: id name age phone 1 John 18 null 2 Sue 22 1234567890 3…
i am using friendsofsymfony bundle for authentication, the scenario is when i try to login, the user logged in successfully and getting access token, but in same request when some security events triggered and try to update lastLogin column in…