Doctrine modified DateTime is not persisted

Question

I try to modify DateTime field of the object with modify function

    $em = $this->getDoctrine()->getManager();
    $end = $session->getEndDate();
    $session->setEndDate($end->modify('+10 seconds'));
    $em->persist($session);
    $em->flush();

This is setter for $endDate field in Session class:

  /**
    * @param \DateTime $endDate
    */
   public function setEndDate(\DateTime $endDate)
   {
       $this->endDate = $endDate;
   }

Why end date changes can't be persisted to database?

You've posted as `$this->endDate = $eEndDate;` Should that instead be: `$this->endDate = $endDate;`??? — Alvin Bunk, Apr 06 '17 at 15:56
As mentioned in your previous question on the exact same topic: $end = clone $session->getEndDate(); http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/cookbook/working-with-datetime.html#datetime-changes-are-detected-by-reference — Cerad, Apr 06 '17 at 16:04

score 7 · Accepted Answer · edited May 23 '17 at 12:32

7

Doctrine won't save changes to the existing DateTime instance (due to the internals of PHP's equality testing I think)

If you clone the object and then set it back, should work. Or clone it in the setter?

See Doctrine2 ORM does not save changes to a DateTime field

edited May 23 '17 at 12:32

Community

1
1

answered Apr 06 '17 at 16:35

benlumley

11,370
2
40
39

Matteo · Answer 2 · 2017-04-06T16:04:19.957

3

You need to flush it:

$em->flush($session);

The persist is only for entity not yet created.

UPDATE:

The modify method don't return anything, affect the specify object instance, so you can simply try:

$end = $session->getEndDate();
$end->modify('+10 seconds');
$em->flush();

Hope this help

edited Apr 06 '17 at 16:04

answered Apr 06 '17 at 15:57

Matteo

37,680
11
100
115

I had flush there, forgot to include in question. DateTime still not persisted – blahblah Apr 06 '17 at 15:59
Hi Matteo. `$session` shouldn't be a parameter of flush, unless I'm missing something? – Alvin Bunk Apr 06 '17 at 16:01
@AlvinBunk The flush method accept an entity instance to flush – Matteo Apr 06 '17 at 16:02
@blahblah see my update – Matteo Apr 06 '17 at 16:04
DateTime is still not updated in db. and I checked profiler, there is no `UPDATE session SET` query to update object – blahblah Apr 06 '17 at 16:13
very strange... try debugging changing some other fields.... and see what happen in the profiler – Matteo Apr 06 '17 at 16:21

score 1 · Answer 3 · answered Apr 06 '17 at 15:58

1

You need to add merge or flush to save the update

 $end = $session->getEndDate();
 $session->setEndDate($end->modify('+10 seconds'));
 $em->persist($session);
 $em->flush();

answered Apr 06 '17 at 15:58

Sofien Benrhouma

406
3
8

score 0 · Answer 4 · answered Apr 06 '17 at 16:29

Based on @Cerad 's comments, I wonder if this will work for you:

$em = $this->getDoctrine()->getManager();
$end = new \DateTime( $session->getEndDate() );
$end->modify('+10 seconds');
$session->setEndDate( $end );
$em->persist($session);
$em->flush();

Can you try it out. I'm not certain it will make a difference though.

Doctrine modified DateTime is not persisted

4 Answers4