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 have a column that it's a DateTimeImmutable that save when the user has joined the platform. I'm making the phpunit test and i would like to validate that the colum can't be updated. I would like to detect the…
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 don't understand how detach() works.. This is a use case: /** * @ORMEntity(repositoryClass="UsersRepository") * @ORMTable(name="users") */ class Users { // .... /** * @ORMManyToOne(targetEntity="AppEntityParentType") * @ORMJoinColumn(name="ID_PARENT_TYPE", referencedColumnName="ID_PARENT_TYPE") * private ParentType $parentType; } /** * @ORMEntity(repositoryClass="CustomInfoRepository") * @ORMTable(name="custom_info") */ class…
This SQL request works perfectly: SELECT f.idFile, f.FileName, f.date_file, COUNT(DISTINCT (ligne.numLigne)) AS nbCmde, COUNT(DISTINCT CASE WHEN bl.date_production != "0000-00-00 00:00:00" THEN ligne.numLigne END) AS cmdProd, COUNT(DISTINCT CASE WHEN bl.date_production = "0000-00-00 00:00:00" THEN ligne.numLigne END) AS cmdNonProd, COUNT(DISTINCT CASE WHEN…
This is what I tried: $time = date('Y/m/d'); $alerts = $repository->findBy(['datum' => $time]); and $time = date('Y/m/d'); $lessons = $repository->createQueryBuilder('q') ->where('q.datum LIKE currentDate') ->setParameter('currentDate', $time); For some reason those don't work and I have no idea why. It should be…
Running into the above error while attempting to run doctrine:schema:update in Symfony. The error is happening in AbstractPlatform (part of libDoctrinePlatformsAbstractPlatform) I'm checking and JSON is definitely registered in libDoctrineDBALTypesType.php abstract class Type { const TARRAY = 'array'; const SIMPLE_ARRAY…
I have a symfony repository method, which fetches a quite complex data set, which will then be placed in a CSV file by an export manager class. I don't want to place the whole code of handling the export job,…
What is the best way to have the same entity field in many entities? For example an 'relatedEntity' will be appearing in 8 tables. class User { #[ORMColumn(length: 255)] private ?string $relatedEntity = null; } class User2 { #[ORMColumn(length: 255)]…