Symfony2: Connect to additional database, without all the extras?

Question

I'm looking to Connect to another database to run some arbitrary queries, but don't want to describe the data using Entities and Repositories and the like. Symfony will not "own" this data or manage anything about it. I'm simply looking for recommendations on how to:

Put the connection parameters in my config.yml file (and parameters.yml)
Connect do it using Symfony components (Doctrine?) to run prepared statements.

The only similar question I could find was Temporary Connection to External Database with Symfony/Doctrine, but that seems to apply to Symfony 1 since Doctrine_Manager doesn't exist in Symfony 2.

well it sounds u just need the abstraction layer for doctrine instead of the full ORM. Just create few services that contain your custom queries and off you go :) — Songo
– Songo, Commented Jan 22, 2014 at 16:30

Cerad · Accepted Answer · 2014-01-22 15:40:22Z

7

http://symfony.com/doc/current/cookbook/doctrine/multiple_entity_managers.html

Shows how to setup multiple Doctrine 2 DBAL connections (ignore the entity manager part).

doctrine:
dbal:
    default_connection:   default
    connections:
        default:
            driver:   "%database_driver%"
            host:     "%database_host%"
            port:     "%database_port%"
            dbname:   "%database_name%"
            user:     "%database_user%"
            password: "%database_password%"
            charset:  UTF8
        customer:
            driver:   "%database_driver2%"
            host:     "%database_host2%"
            port:     "%database_port2%"
            dbname:   customer
            user:     "%database_user2%"
            password: "%database_password2%"
            charset:  UTF8

This will yield a service called: doctrine.dbal.customer_connection which you can pull from the service container.

The DBAL connection is a thin wrapper around the standard PHP PDO connection object.

http://docs.doctrine-project.org/projects/doctrine-dbal/en/latest/reference/data-retrieval-and-manipulation.html

Shows how to use the connection. Basically the same as the PDO object.

You could also just create a service using the PDO object itself. I don't have an example handy but it's easy enough to do. That would eliminate the need for Doctrine 2 completely.

answered Jan 22, 2014 at 15:40

Cerad

49k9 gold badges92 silver badges94 bronze badges

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

1 Comment

Brian Over a year ago

Thanks! Exactly what I needed. I was a little standoff-ish from the Symfony docs because they all seemed to imply Symfony would own the data of any additional database.

Collectives™ on Stack Overflow

Symfony2: Connect to additional database, without all the extras?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related