如何限制 Doctrine2 中的关联实体结果？

发布于 2024-12-02 14:12:39 字数 863 浏览 0 评论 0原文

我有以下查询：

$query = $this->getEntityManager()->createQuery('
                      SELECT u, p, m
                      FROM MyCoreBundle:User u
                      JOIN u.programmes p
                      JOIN u.motivation m
                      ');

$result = $query->getResult();

我想限制为每个用户返回的动机对象是我在其他地方使用的第二个查询的结果（在动机存储库上）：

$query = $this->getEntityManager()->createQuery('
                      SELECT m FROM MyCoreBundle:Motivation m
                      WHERE m.user = :user
                      ORDER BY m.date DESC');

$query->setParameter('user',$user);
$query->setFirstResult(0);
$query->setMaxResults(1);
//@TODO if there is not result recorded for the user, return sth which indicates this
return $query->getResult();

有没有办法在第一个查询中限制和限制动机或者更好的方法？

原文

I have the following query:

$query = $this->getEntityManager()->createQuery('
                      SELECT u, p, m
                      FROM MyCoreBundle:User u
                      JOIN u.programmes p
                      JOIN u.motivation m
                      ');

$result = $query->getResult();

I want to restrict the motivation objects returned for each user to be the result of this second query which I am using elsewhere (On the Motivation repository):

$query = $this->getEntityManager()->createQuery('
                      SELECT m FROM MyCoreBundle:Motivation m
                      WHERE m.user = :user
                      ORDER BY m.date DESC');

$query->setParameter('user',$user);
$query->setFirstResult(0);
$query->setMaxResults(1);
//@TODO if there is not result recorded for the user, return sth which indicates this
return $query->getResult();

Is there a way to limit and restrict motivation in the first query or a better approach?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

倦话 2024-12-09 14:12:39

您无法限制联合行的数量。

如果您有 Doctrine 2.1，则可以在集合上使用 ->slice()：

$collection = $user->getMotivations();    // returns a LazyCollection, 
                                          // makes no SQL query

$motivations = $collection->slice(0, 20); // queries the first 20 motivations 
                                          // for this user (if the association
                                          // was not fetch-joint)

请参阅 http://www.doctrine-project.org/docs/orm/2.0/en/tutorials/extra-lazy-associations.html

You can't limit the number of joint rows.

If you have Doctrine 2.1 you can use ->slice() on the collection:

$collection = $user->getMotivations();    // returns a LazyCollection, 
                                          // makes no SQL query

$motivations = $collection->slice(0, 20); // queries the first 20 motivations 
                                          // for this user (if the association
                                          // was not fetch-joint)

See http://www.doctrine-project.org/docs/orm/2.0/en/tutorials/extra-lazy-associations.html

回复收藏 0 原文

~没有更多了~