Pablo Pablo - 1 year ago 270
MySQL Question

Symfony2 execute SQL file in Doctrine Fixtures Load

I'm migrating an old web app based on SQL Server and ASP to Symfony2 and MySQL. I made some queries and export old data to individual SQL files.
How can I execute thoses files in my fixtures, when I run the command

$php app/console doctrine:fixtures:load

Now I have some fixtures that works directly with Doctrine ORM and entities, but I have a lot of data to import.

Answer Source

I find a good solution. I didn't find an exec method in class ObjectManager, so... this work very well for me.

public function load(ObjectManager $manager)
    // Bundle to manage file and directories
    $finder = new Finder();

    foreach( $finder as $file ){
        $content = $file->getContents();

        $stmt = $this->container->get('doctrine.orm.entity_manager')->getConnection()->prepare($content);

In this solution your fixture class has to implement the ContainerAwareInterface with the method

public function setContainer( ContainerInterface $container = null )
    $this->container = $container;
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download