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)]…
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,…