symfony 连接mysql,如何在Symfony2中使用Doctrine2创建2个连接（mysql和postgresql）

I'm new to Symfony2. And my question quite simple.

I would use 2 connections to DB at different host and driver in one bundle.

Could you help me with this?

解决方案

You can do something like:

doctrine:

dbal:

default_connection: alpha

connections:

alpha:

driver: pdo_mysql

host: localhost

dbname: alpha

user: root

charset: UTF8

beta:

driver: pdo_pgsql

host: localhost

dbname: beta

user: root

charset: UTF8

orm:

auto_generate_proxy_classes: %kernel.debug%

entity_managers:

alpha:

connection: alpha

beta:

connection: beta

You see, we declare two connections in the dbal section and two entity managers in the orm one.

After that, you can use both:

$emAlpha = $this->getDoctrine()->getEntityManager('alpha');

$emBeta = $this->getDoctrine()->getEntityManager('beta');

As the alpha one was defined as the default one, you can access it without specifying its name:

$emAlpha = $this->getDoctrine()->getEntityManager();