Doctrine2 SQL语句

$q = Doctrine_Query::create()
     ->update('WebusersTable q')
     ->set('q.login_name','?','John')
     ->where('q.webuser_id=?',1)
     ->execute();

更新：

$q = Doctrine_Query::create()
     ->update('WebusersTable q')
     ->set('q.login_name', 'John')
     ->set('q.name', 'Another value')
     ->where('q.webuser_id=?',1)
     ->execute();

更新：

$queryBuilder = $entityManager->getRepository()->createQueryBuilder('u');
$queryBuilder->update()
    ->set('u.userFirstName', 'Michael')
    ->where('u.userId = :userId')
    ->setParameter('userId', 111)
    ->getQuery()
    ->execute();

删除：

    function deleteAgree(AnswerRelationship $entity)
    {
        return  $this->query()
            ->delete('tj_answer_relationship')
            ->andWhere('taskId=:taskId')
            ->setParameter(':taskId', $entity->taskId)
            ->andWhere('questionId=:questionId')
            ->setParameter(':questionId', $entity->questionId)
            ->andWhere('studentId=:studentId')
            ->setParameter(':studentId', $entity->studentId)
            ->andWhere('tagId=:tagId')
            ->setParameter(':tagId', $entity->tagId)//1
            ->execute();
    }

 

完毕。

$q = Doctrine_Query::create()
     ->update('WebusersTable q')
     ->set('q.login_name','?','John')
     ->where('q.webuser_id=?',1)
     ->execute();