实施“如果存在则更新"在学说 ORM [英] implementing "update if exists" in Doctrine ORM

问题描述

我正在尝试在一个事务中INSERT OR UPDATE IF EXISTS.

I am trying to INSERT OR UPDATE IF EXISTS in one transaction.

在 mysql 中，我通常会使用 DUPLICATE KEY(UPDATE ON DUPLICATE KEY".)我知道许多使用各种 SQL 变体和子查询，但我试图在 Doctrine (PHP ORM) 中实现它.似乎有 Doctrine 方法可以做到这一点，因为它的功能如此丰富，但我没有找到任何东西.出于某种原因，使用 PHP ORM 包会出现这种问题吗?或者是否有任何 Doctrine 专家知道如何通过黑客或任何方式实现这一目标?

in mysql, I would generally use DUPLICATE KEY ("UPDATE ON DUPLICATE KEY".) I'm aware of many solutions to this problem using various SQL variants and sub-queries, but I'm trying to implement this in Doctrine (PHP ORM). It seems there would be Doctrine methods for doing this since it's so feature packed, but I'm not finding anything. Is this sort of thing a problem using PHP ORM packages for some reason? Or do any Doctrine experts know how to achieve this through hacks or any means?

推荐答案

根据 https://www.vivait.co.uk/labs/updating-entities-when-an-insert-has-a-duplicate-key-in-教义 这可以通过 $entityManager->merge() 来实现.

According to https://www.vivait.co.uk/labs/updating-entities-when-an-insert-has-a-duplicate-key-in-doctrine this can be achieved with $entityManager->merge().

$entity = new Table();
$entity->setId(1);
$entity->setValue('TEST');

$entityManager->merge($entity);
$entityManager->flush();

这篇关于实施“如果存在则更新"在学说 ORM的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！