News
使用一对多自引用方法相互关联(一个消息是父级,可以有多个子级)。更何况各有各News
与 具有正常(非自引用)一对一关系Event
and Gallery
。当我运行简单的 DQL 时:
SELECT n FROM App\Entity\News n WHERE n.parent = :id
然后通过水化结果getResults
带默认值的方法HYDRATION_OBJECT
值集,在内部某处进行额外查询getResults
方法。
SELECT t0.* FROM event t0 WHERE t0.news_id = 2 AND ((t0.deleted_at IS NULL));
SELECT t0.* FROM gallery t0 WHERE t0.news_id = 2 AND ((t0.deleted_at IS NULL));
SELECT t0.* FROM event t0 WHERE t0.news_id = 1 AND ((t0.deleted_at IS NULL));
SELECT t0.* FROM gallery t0 WHERE t0.news_id = 1 AND ((t0.deleted_at IS NULL));
Where news_id = 1
and news_id = 2
是第一个查询选择的新闻的子项。
News
也没有自引用的一对多关系(我在这里忽略了它们),但是水合不会对它们产生额外的查询。仅当存在时才会出现问题parent
涉及的关系where
陈述。
如何重现
// news Entity
/**
* @ORM\Entity(repositoryClass="App\Repository\NewsRepository")
* @ORM\Table(uniqueConstraints={@UniqueConstraint(name="news_slug_deleted", columns={"slug","deleted_at"})})
*/
class News {
use SoftDeleteableEntity;
/**
* @ORM\Id()
* @ORM\GeneratedValue()
* @ORM\Column(type="integer")
*/
private $id;
/**
* @ORM\Column(type="string", length=255)
*/
private $title;
/**
* @Gedmo\Slug(fields={"title"})
* @ORM\Column(length=128)
*/
private $slug;
/**
* @ORM\OneToOne(targetEntity="App\Entity\Gallery", mappedBy="news", cascade={"persist", "remove"}, orphanRemoval=true)
*
* @var Gallery
*/
private $gallery;
/**
* @ORM\OneToOne(targetEntity="App\Entity\Event", mappedBy="news", cascade={"persist", "remove"}, orphanRemoval=true)
*
* @var Event
*/
private $event;
/**
* One News has Many News.
* @ORM\OneToMany(targetEntity="News", mappedBy="parent")
*/
private $children;
/**
* Many News have One News.
* @ORM\ManyToOne(targetEntity="News", inversedBy="children")
* @ORM\JoinColumn(name="parent_id", referencedColumnName="id", nullable=true)
*/
private $parent;
}
/**
* @ORM\Entity(repositoryClass="App\Repository\EventRepository")
* @Gedmo\SoftDeleteable()
*/
class Event
{
use SoftDeleteableEntity;
/**
* @ORM\Id()
* @ORM\GeneratedValue()
* @ORM\Column(type="integer")
*/
private $id;
/**
* @ORM\OneToOne(targetEntity="App\Entity\News", inversedBy="event", cascade={"persist"})
* @ORM\JoinColumn(nullable=false)
*/
private $news;
Gallery
实体类似于Event
所以我在这里忽略了它。
// News controller
public function index(NewsRepository $newsRepository, $slug)
{
$news = $newsRepository->findOneBy(['slug' => $slug]);
$newsRepository->getConnectedNews($news->getId());
}
// news repository
class NewsRepository extends ServiceEntityRepository
{
public function __construct(ManagerRegistry $registry)
{
parent::__construct($registry, News::class);
}
public function getConnectedNews($newsId) {
$query = $this->createQueryBuilder('n')->andWhere('n.parent = :id')->setParameter('id', $newsId);
return $query->getQuery()->getResult(AbstractQuery::HYDRATE_OBJECT);
}
}
水合作用news
有 20 个子级,最终得到: 20 * 2 + 1 (n*r+1) 个查询,其中:
- (n) 20 是孩子的数量
- (r) 2 是一对一关系的数量
- 1 是基本查询
我想防止 Doctrine 对一对一关系进行额外的查询。是教义错误还是不需要的行为或者我在某个地方犯了错误?
总而言之,我只想获取所有没有一对一关系的自引用子项,因为我没有要求检索它们,因此它应该仅使用一个查询来获取所有子项news
无需对每个检索到的“新闻”对象进行额外的查询,并且每个对象都是一对一的关系。