Doctrine查询构建器删除语句 [英] Doctrine Query Builder Delete Statement

问题描述

我正在使用Symfony2，我必须使用Doctrine QueryBuilder（ http://docs.doctrine-project.org/en/latest/reference/query-builder.html ）文档没有示例说明delete或update语句。

I am using Symfony2, i must use the Doctrine QueryBuilder ( http://docs.doctrine-project.org/en/latest/reference/query-builder.html ) The documentation does not have an example for the delete or update statement.

我的实体是：

  object(stdClass)[417]
        public '__CLASS__' => string 'Les\DataBundle\Entity\News' (length=26)
        public 'id' => int 1
        public 'restoId' => int 1
        public 'category' => string 'dessert' (length=7)
        public 'text' => string 'jlkdjsalkdj sa' (length=14)
        public 'dateCreated' => string 'DateTime' (length=8)
        public 'dateModified' => null

我试图删除数据库中的一行，但我不断收到错误： p>

I am trying to delete a row in the database, but i keep getting the error:

   [Semantical Error] line 0, col 7 near 'News WHERE n.id': Error: Class 'News' is not defined.

我的查询是：

   $newsID =2 ;
    $qd = $repository->createQueryBuilder('n');
    $qd->delete('n')
        ->where('n.id = :id')
        ->setParameter('id',$newsID);
    $query = $qd->getQuery();
    $result = $query->getResult();

更新语句的结构是否相同？

And would the update statement have the same structure?

推荐答案

对于delete语句与select不同，不要选择删除列名称。

For the delete statement is different from the select, you don't specify the column name for the delete unlike select.

更正的代码

  $qd = $repository->createQueryBuilder('n');
    $qd->delete()
        ->where('n.id = :id')
        ->setParameter('id',$newsID);
    $query = $qd->getQuery();
    $result = $query->getResult();

另一种格式

    $query = $this->getDoctrine()->getManager()->createQuery('delete FROM LesDataBundle:News n where n.id = '.$newsID);
    $result = $query->getResult();

对于更新语句，它是：

    $qd = $repository->createQueryBuilder('n');
    $qd->delete()
    $qd->update()
        ->set('n.text' , ':text')
        ->where('n.id = :id')
        ->setParameters( array('id'=> $newsID, 'text' => 'Hello World') );
    $query = $qd->getQuery();
    $result = $query->getResult();

这篇关于Doctrine查询构建器删除语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！