symfony5之getRepository的两种使用场景:
symfony5的getRepository的两种使用场景,之前一直用的是第一种,其实有时候需要关联查询,可以直接用 createQueryBuilder 查询,如下第二种方式,第三种方式需要手动指定 from 的Entity
//方式1
$pagination = $this->entityManager->getRepository(Course::class)->getPagination($params, $request->query->getInt('page', 1));
//方式2
$res = $this->entityManager->getRepository(Course::class)->createQueryBuilder('c')->leftJoin("c.courseManages", "cm")->where('c.id = 1')->select("c.id", "cm.type")->getQuery()->getResult();
//方式3
$res = $this->entityManager->createQueryBuilder()->from("App:Course", "c")->leftJoin("c.courseManages", "cm")->where("c.id = 1")->select("c.id", "cm.type")->getQuery()->getResult();
