2

I am structuring a Symfony 4 application which is also using API Platform. The problem is that we have a demand that a User will have to connect to its own database. So each time it logs in to a centralized domain (just for access purposes), the application will have to connect him to his own database.

I've done some research, and found out that the closest thing specified in Symfony 4 docs is the Multiple Entity Managers and Connections.

The problem here is that although it shows how to create multiple configurations for different database connections, it just specifies how to create them for a specific Entity Manager, or how to get stuff from another Entity Manager inside a Symfony Controller.

In my case, we don't have any Controllers. Instead, there is an API with a couple of services endpoints which connect to the database to manage resources though HTTP requests. Currently, we are using always the default database connection, which gets the configuration from the .env variable.

I know that will have to store this database configuration information in a session (or anything similar) or verify which database is the right one for the given user at each API request. But I'm not so sure what's the best way to deal with this problem.

Also, I thought of creating a listener to the onKernelRequest event, as described in this thread

Any thoughts or ideas how should I proceed with this?

EDIT

This is the packages/doctrine.yaml file. Everything is configured for default.

parameters:
    # Adds a fallback DATABASE_URL if the env var is not set.
    # This allows you to run cache:warmup even if your
    # environment variables are not available yet.
    # You should not need to change this value.
    env(DATABASE_URL): ''

doctrine:
    dbal:
        # configure these for your database server
        driver: 'pdo_mysql'
        server_version: '5.7'
        charset: utf8mb4
        default_table_options:
            charset: utf8mb4
            collate: utf8mb4_unicode_ci

        url: '%env(resolve:DATABASE_URL)%'
    orm:
        auto_generate_proxy_classes: true
        naming_strategy: doctrine.orm.naming_strategy.underscore
        auto_mapping: true
        mappings:
            App:
                is_bundle: false
                type: annotation
                dir: '%kernel.project_dir%/src/Entity'
                prefix: 'App\Fst\Entity'
                alias: App

And for the .env file:

DATABASE_URL=mysql://db_user:[email protected]:3306/db_name

which is overrided in the .env.local file.

Also, services.yaml has default configuration, with autowiring enabled.

Improve this question
3
  • 1
    Please provide some code examples of how you're working with your Symfony app. Such as how you are currently using the default connection. Normally you use DependncyInjection with the autowire configuration of your services.yml and the specified entity_manager from your packages/doctrine.yml, which will function the same on the __construct(EntityManagerInterface $em) of your service(s) as it does the controller action methods. Alternatively you can manually define which connection you want in your services.yml ie arguments: { $em: '@doctrine.orm.custom_entity_manager' } Commented May 15, 2019 at 0:05
  • Which service I have to change in the services.yaml to change the default entity manager? And even if I manage to do so, the problem is how do I change that on the fly? There is no setDefaultEntityManager method or similar to switch between entity managers programatically, right? Commented May 15, 2019 at 14:35
  • 1
    I was referring to an example of how you are issuing queries or interfacing with the ORM in your app. With DI you can specify whatever services and arguments you like to the desired service used when instantiating it, including using expressions The dbal config can also be configured with a wrapper_class. Something like stackoverflow.com/a/29256296/1144627 Commented May 15, 2019 at 15:00
Related questions
3
Multiple databases support in Symfony
2
Symfony project with models stored in multiple databases
0
Symfony2 multiple databases, specify database for each table
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.