Attachments to Doctrine Jira Issue DDC-300 - https://github.com/doctrine/doctrine2/issues/3766

10344_RunSqlTaskWithSqlFile.patch

Index: RunSqlTask.php
===================================================================
--- RunSqlTask.php	(revision 7103)
+++ RunSqlTask.php	(working copy)
@@ -99,7 +99,37 @@
         $arguments = $this->getArguments();
         
         if (isset($arguments['file'])) {
-            //TODO
+            $fileName = $arguments['file'];
+            if (!file_exists($fileName)) {
+                throw new CliException(sprintf('The SQL file [%s] does not exist.', $fileName));
+            } elseif ( ! is_readable($fileName)) {
+                throw new CliException(sprintf('The SQL file [%s] does not have read permissions.', $fileName));
+            }
+
+            $em = $this->getConfiguration()->getAttribute('em');
+
+            $resultSet = array();
+
+            $executedCount = 0;
+
+            $this->getPrinter()->writeln('Processing file...');
+
+            foreach (file($fileName) as $sql) {
+                if (preg_match('/^select/i', $sql)) {
+                    $stmt = $em->getConnection()->execute($sql);
+                    $resultSet[] = $stmt->fetchAll(\Doctrine\DBAL\Connection::FETCH_ASSOC);
+                } else {
+                    $resultSet[] = $em->getConnection()->executeUpdate($sql);
+                }
+                $executedCount ++;
+            }
+
+            $this->getPrinter()->writeln(sprintf('%d statements executed.', $executedCount));
+
+            $maxDepth = isset($arguments['depth']) ? $arguments['depth'] : 7;
+
+            Debug::dump($resultSet);
+            
         } else if (isset($arguments['sql'])) {
             $em = $this->getConfiguration()->getAttribute('em');