Load Doctrine2 fixtures with foreign keys disabled

WebTestCase.php

<?php

use Doctrine\Common\DataFixtures\Loader;
use Doctrine\Common\DataFixtures\Purger\ORMPurger;
use Doctrine\Common\DataFixtures\Executor\ORMExecutor;
use Symfony\Bundle\FrameworkBundle\Test\WebTestCase as SfWebTestCase;
use Project\DummyBundle\DataFixtures\ORM\MyFixture;

abstract class WebTestCase extends SfWebTestCase {
	public function setUp() {
		// prepare entity manager
		$client    = static::createClient();
		$container = $client->getContainer();
		$em        = $container->get('doctrine')->getEntityManager();

		// make sure foreign keys don't fuck up the TRUNCATE queries
		$em->getConnection()->exec('SET foreign_key_checks = 0');

		// load our fixture (have to inject the container manually... don't know why, but the above query seems to break it)
		$fixture = new MyFixture();
		$loader  = new Loader();

		$fixture->setContainer($container);
		$loader->addFixture($fixture);

		// execute the fixture
		$purger   = new ORMPurger($em);
		$executor = new ORMExecutor($em, $purger);
		$executor->execute($loader->getFixtures());

		// and revert the setting
		$em->getConnection()->exec('SET foreign_key_checks = 1');
	}
}