作者热门文章
- html - 出于某种原因,IE8 对我的 Sass 文件中继承的 html5 CSS 不友好?
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景?
我有以下问题。我想这是误会。但是在谷歌搜索了几个小时没有找到解决方案后,我把它贴在这里。
我在 Doctrine 中有一个本地查询:
$rsm = new ResultSetMapping;
$rsm->addEntityResult('Acme\CommentBundle\Entity\Comment', 'c');
$rsm->addFieldResult('c', 'comment_id', 'id');
$rsm->addFieldResult('c', 'slug', 'slug');
$rsm->addFieldResult('c', 'comment', 'comment');
$rsm->addFieldResult('c', 'created', 'created');
$rsm->addJoinedEntityResult('Acme\AccountBundle\Entity\Worker', 'w', 'c', 'komments');
$rsm->addFieldResult('w', 'worker_id', 'id');
$rsm->addFieldResult('w', 'worker_name', 'name');
$rsm->addJoinedEntityResult('Acme\CommentBundle\Entity\Document', 'd', 'c', 'documents');
$rsm->addFieldResult('d', 'document_id', 'id');
$rsm->addFieldResult('d', 'document_name', 'name');
return $this->getEntityManager()
->createNativeQuery('SELECT t.id, c.id AS comment_id, c.slug, c.created, c.comment, c.worker_id AS comment_worker_id, c.created AS comment_created, d.id AS document_id, d.name AS document_name, w.id AS worker_id, w.name AS worker_name
FROM comment_thread t
INNER JOIN project p ON p.comment_thread_id = t.id
LEFT JOIN comment c ON t.id = c.thread_id
INNER JOIN worker w ON c.worker_id = w.id
LEFT JOIN comment_document d ON c.id = d.comment_id
WHERE p.id = :project_id
ORDER BY c.created ASC', $rsm)
->setParameter('project_id', $
最佳答案
我的建议是映射器在附加第二个实体时重写“名称”字段。有相同的情况并通过重命名表和实体映射和实体类中的字段来修复它,因此不同的实体/表没有相同的名称属性/列。
关于Symfony/Doctrine : How does addJoinedEntityResult work for a one-to-many relationship?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/11370429/
我是一名优秀的程序员,十分优秀!