With <3 for Hosiplan

DbalBatchFile.php

<?php

namespace Kdyby\Doctrine\Console;


use Kdyby;
use Kdyby\Doctrine\BatchImportException;
use Kdyby\Doctrine\Helpers;
use Rixxi;
use Symfony;
use Symfony\Component\Console\Input\InputArgument;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Output\OutputInterface;


class DbalBatchFile extends Symfony\Component\Console\Command\Command
{

	protected function configure()
	{
		$this->setName('dbal:batch-file');
		$this->setAliases(['dbal:batch:file']);
		$this->addArgument('file', InputArgument::REQUIRED, 'SQL batch file to run');
		$this->setDescription('Self explanatory...');
	}


	protected function execute(InputInterface $input, OutputInterface $output)
	{
		if (!is_readable($file = $input->getArgument('file'))) {
			$output->writeLn(sprintf("<error>Cannot read file '%s'.</error>", $file));
			return 1;
		}

		$emHelper = $this->getHelper('em');

		/* @var $em \Doctrine\ORM\EntityManager */
		$em = $emHelper->getEntityManager();

		Helpers::loadFromFile($em->getConnection(), $file);
	}

}