dpa84373 2015-07-23 10:07
浏览 39

具有多个数据库的symfony2查询构建器(doctrine)

I want join the abteilung table which is in another database with other access data.

Here is the right database for abteilung:

$manager = $this->getDoctrine()->getManager('olddb')->getRepository('ChrisOldUserBundle:BpDepartment');

And this is the old query i want to change:

$result = $this->getDoctrine()->getRepository('KfzBuchungBundle:Rent')
                ->createQueryBuilder('r')
                ->addSelect('abteilung')
                ->addSelect('auto')
                ->join('r.auto','auto')
                ->join('r.abteilung','abteilung')
                ->where('r.mieteStart >= :date_from')
                ->andWhere('r.mieteEnde <= :date_to')
                ->setParameter('date_from', $date_from)
                ->setParameter('date_to', $date_to)
                ->orderBy('r.mieteStart', 'ASC')
                ->distinct()
                ->getQuery()->getArrayResult();

I tried with:

$rsm = new ResultSetMapping();
            $rsm->addEntityResult('Chris\KfzBuchungBundle\Entity\Rent', 'bp');
            $rsm->addEntityResult('Chris\Bundle\OldUserBundle\Entity\BpDepartment', 'bp_dpt');
            $rsm->addFieldResult('bp','id','id');
            $query = $this->getDoctrine()->getManager()->createNativeQuery('SELECT * FROM bp_department bp_dpt', $rsm);

            $result = $query->getResult();

But same shit, i have no idea.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 微信会员卡等级和折扣规则
    • ¥15 微信公众平台自制会员卡可以通过收款码收款码收款进行自动积分吗
    • ¥15 随身WiFi网络灯亮但是没有网络,如何解决?
    • ¥15 gdf格式的脑电数据如何处理matlab
    • ¥20 重新写的代码替换了之后运行hbuliderx就这样了
    • ¥100 监控抖音用户作品更新可以微信公众号提醒
    • ¥15 UE5 如何可以不渲染HDRIBackdrop背景
    • ¥70 2048小游戏毕设项目
    • ¥20 mysql架构,按照姓名分表
    • ¥15 MATLAB实现区间[a,b]上的Gauss-Legendre积分