I’m going to answer my own question. innerJoin should use the keyword “WITH” instead of “ON” (Doctrine’s documentation [13.2.6. Helper methods] is inaccurate; [13.2.5. The Expr class] is correct) no need to link foreign keys in join condition as they’re already specified in the entity mapping. Therefore, the following works for me $qb->select(‘c’) ->innerJoin(‘c.phones’, ‘p’, … Read more
If you are using the ORM $em->persist($object); $em->flush(); $object->getId(); if you are using the DBAL: $conn->lastInsertId(); http://www.doctrine-project.org/api/dbal/2.5/class-Doctrine.DBAL.Connection.html#_lastInsertId
You can catch the UniqueConstraintViolationException as such: use Doctrine\DBAL\Exception\UniqueConstraintViolationException; // … try { // … $em->flush(); } catch (UniqueConstraintViolationException $e) { // …. }
You have to implement a __clone() method in your entities that sets the id to null and clones the relations if desired. Because if you keep the id in the related object it assumes that your new entity A has a relation to the existing entities B and C. Clone-method for A: public function __clone() … Read more
For default value CURRENT_TIMESTAMP: @ORM\Column(name=”created_at”, type=”datetime”, options={“default”: “CURRENT_TIMESTAMP”}) Or for older Symfony versions: @ORM\Column(name=”created_at”, type=”datetime”, options={“default”: 0}) Worked for me… However this works only with MySQL.
Wow quite odd. Something very similar happened with me in the past and It seems to be an API issue. Nothing on the code end that us developers can do. No one has found a workaround or fix either.
I’m tired, but this seems like much ado about nothing. You missed the important bit of that warning: If you use a STI/CTI entity as a many-to-one or one-to-one entity That’s not the case in your example! If you had not omitted the doctrine annotations, you might have noticed. The association User::pets is OneToMany, not … Read more
Do you know now what are the ‘important’ function to add to be able to upload the photo and rename it? See the official documentation on how to do this. There are good working examples for a simple file upload. Also check the doctrine documentation for lifecycle callbacks. How do you check the extension to … Read more
Current Symfony versions (Symfony 4, Symfony >=3.2) Since Symfony >=3.2 you can simply expect a UserInterface implementation to be injected to your controller action directly. You can then call getId() to retrieve user’s identifier: class DefaultController extends Controller { // when the user is mandatory (e.g. behind a firewall) public function fooAction(UserInterface $user) { $userId … Read more
In Doctrine 2.1 method EntityRepository#findBy() now accepts additional parameters for ordering, limit and offset. Documentation: Working with objects – Querying by simple conditions Example: public function findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null) usage: $myLimit = 30; $myOffset = 20; $product = $repository->findBy( array(‘name’ => ‘foo’), array(‘price’ => ‘ASC’), $myLimit, … Read more