Several variable connections with Propel and Symfony2

Question

I am creating an application in Symfony2 where each user gets their own database, that is, all users have their own set of credentials for the database. The user does not know these credentials, they are stored in the application.

Depending on which user is logged in, the application retrieves the user credentials and stores the data in a specific user database.

I use Propel as an ORM, and I know that I can configure multiple connections. But all the solutions that I encountered require knowing the details of the connection in advance, but I do not know that the user will register and log in.

So my question is: how can I initiate a proper database connection?

Answer 1

Suppose you already have a connection (if necessary, with a dummy database), you can change the connection settings by doing the following

// Get current configuration $config = \Propel::getConfiguration(); // Change DB configuration $config['datasources']['default']['connection']['dsn'] = 'mysql:host=127.0.0.1;port=3306;dbname=dbname;charset=UTF8'; $config['datasources']['default']['connection']['user'] = 'username'; $config['datasources']['default']['connection']['password'] = 'password'; // Apply configuration \Propel::setConfiguration($config); \Propel::initialize();