Symfony2 multiple databases, specify database for each table

Question

The problem is that I have 2 + databases defined in Symfony. And when I update table schema with

php app/console dotrine:schema:update --force

it makes the tables in the default database. I'd like to specify which database the table belongs to. How could i do that?

I'm using yaml(yml) format for the entities, example:

Test\ExampleBundle\Entity\TestTable:
    type: entity
    table: test_table
    id:
        id:
            type: integer
            generator:
                strategy: AUTO
    fields:
        name:
            type: string
            length: 255
        sound:
            type: smallint

This from the docs might help - symfony.com/doc/current/cookbook/doctrine/… — qooplmao
– qooplmao, Commented Nov 12, 2012 at 14:07

Ahmed Siouani · Accepted Answer · 2012-11-12 15:38:03Z

4

Take a deeper look at How to work with Multiple Entity Managers and Connections section of the documentation.

Doctrine offers you the ability to have multiple connections. You can easily add entity managers to bind your entities to different predefined connections according to the bundles they belong to.

According to the documentation, you can bind bundles to entity managers, but here is A trick on how to use two entity managers in the same bundle,

If you want to bind entities from one bundle to different entity managers you can add a "dir" attribute to define a path to a specific entities folder.

Example,

    entity_managers:
        default:
            connection:       default
            mappings:
                MyBundle:
                    dir:      Path/To/EntityFolder1
        myManager:
            connection:       myConnection
            mappings:
                MyBundle:
                    dir:      Path/To/EntityFolder2

You can then put your bundle entities into the right folders according to the connection they are bound to.

edited Nov 12, 2012 at 15:38

answered Nov 12, 2012 at 14:08

Ahmed Siouani

13.9k12 gold badges63 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

n00b Over a year ago

I tried this, but the documents u linked me to are 1.2 version and I'm using 2.0 and this is not working.

n00b Over a year ago

How about if I have 2 different databases for 1 bundle? And it has to know what table belongs to what database.

Ahmed Siouani Over a year ago

Ah thanks, I updated my answer. I don't think you can use two entity managers in one bundle, otherwise you can have a separate bundles for your entities.

Ahmed Siouani Over a year ago

I updated my answer, just try the trick I added and let me know if it works fine for you? and if this approach can help you manage your entities?

n00b Over a year ago

So since I use 2 databases for the tables, can I somehow seperate the table definitions, so I can make it like that? I managed to get all of the tables to the other database, but now I have to seperate the table definitions for each database. Is there any predefined way to seperate them?

|

Collectives™ on Stack Overflow

Symfony2 multiple databases, specify database for each table

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related