Using INSERT INTO.. ON DUPLICATE KEY UPDATE on Doctrine

Question

im using Doctrine on Symfony2 and im trying to insert some values on my table, but if I try to insert a duplicate key I got an error from the system:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'test-1-2-2016-10-11-13' for key 'Unique'

That's my code:

                $insert = new Alerts();
                $insert->setAlKeyword($alert_keyword);
                $insert->setAlLocation($alert_location);
                $insert->setAlDevice($alert_device);
                $insert->setAlSource($alert_source);
                $insert->setAlSubDate(new \DateTime($alert_date);
                $insert->setAlSubHour($alert_time);
                $insert->setAlTotal(+1);
                $em = $this->getDoctrine()->getManager("my_em");
                $em->persist($insert);
                $em->flush();

The problem is about the DUPLICATE KEY UPDATE statement: how can I use that statement in doctrine?

Thanks a lot

This might be useful: http://stackoverflow.com/questions/9699613/insert-ignore-on-duplicate-entries-in-doctrine2-symfony2 — Alok Patel, Oct 12 '16 at 10:21

score -3 · Answer 1 · edited May 23 '17 at 12:09

-3

Make use of the Unique constraint. This will prevent you trying to save when the unique index already exists.

Apply this to the entity for the unique index you have set in your table.

If it is a composite primary key, look at this answer.

edited May 23 '17 at 12:09

Community

1
1

answered Oct 12 '16 at 10:15

Rooneyl

7,802
6
52
81

Preventing duplicates is not the question. – Nils Rückmann Dec 12 '17 at 10:18

score -3 · Answer 2 · answered Oct 12 '16 at 10:16

-3

Remove unique: true on non-unique statement from your doctrine configuration place

answered Oct 12 '16 at 10:16

Stephan Yamilov

605
7
14

That's not a proper solution. You'll end up with 2 rows while OP asked for a duplicate key update statement. – Quentin S. Oct 21 '17 at 21:03

Using INSERT INTO.. ON DUPLICATE KEY UPDATE on Doctrine

2 Answers2