ORMPurger::PURGE_MODE_TRUNCATE tries to find tables in wrong database in case of multiple databases and if bundles are shared between multiple entity manager.

Hi,
I have config something like below, to use AcmeUsersBundle entities in AcmeDemoBundle I have added AcmeUsersBundle under default.

        default:
            connection: default
            mappings:
              AcmeDemoBundle : ~
              AcmeUsersBundle : ~
        users:
            connection: ownership
            mappings:
            AcmeUsersBundle : ~

this->loadFixtures($classes, null, 'doctrine', ORMPurger::PURGE_MODE_TRUNCATE);

Tests tries to find Users database tables under default database as entities are shared, and truncate fails.

Also in case of cross database join, I had to use database name in mapping yml, e.g.

in Users.orm.yml

table: users.profile , it is with db name, so it will truncate Production database and not users_testing.profile.

What could be the solution ?

Start by tracing the ORMPurger path invoked through loadFixtures(..., 'doctrine', ORMPurger::PURGE_MODE_TRUNCATE), using the shared AcmeUsersBundle mappings and multiple entity managers described in the issue. Check that table discovery and truncation use the entity manager's database, including mappings such as users.profile, and verify that the correct test database is affected rather than the production database.