get connection name in migration file

[oskude]

we have to use different databases for some entities, depending on some factors. and to not migrate some entities to some databases, we use the following (manually added) in the migration files:

$this->skipIf($this->connection->getDatabase() != "foobar");

but this is suboptiomal as that "foobar" is defined in parameters.yml, that the user is supposed to create (like on local devel system).

what would be nicer if we could do:

$this->skipIf($this->connection->getName() != "barfoo");

where "barfoo" is defined in config.yml, that user is not supposed to edit, like:

doctrine:
    dbal:
        default_connection: default
        connections:
            default:
                dbname: "%database_name%"
                ...
            barfoo:
                dbname: "%database_name%_barfoo"
                ...

was not sure if i should report this to "dbal" or "migrations" repo, so i reported it to the closest from user perspective.

ps. or if there is an easier way to define "this entity should go only to these connections" or "this entity should never go to these connections", i would love to hear about that!

[stof]

Well, as far as DBAL is concerned, connections don't need to have a name. the name is needed to be able to get the connection from a registry. It is not a property of the connection itself (just like the name of a variable containing the connection is not known by the connection).

This means that a Connection object will not give such way to identify itself, and so this bundle will not be able to rely on them to skip migrations

[giosh94mhz]

Maybe you can implement ContainerAwareInterface in your migrations as explained in the docs.

This way you can get the EntityManager by name (which is generally a "stable" name) and the get the associated connection.