CLI Tools
Doctrine DBAL bundles the dbal:run-sql command that can be integrated into a Symfony console application.
The command may be added to the application as follows:
1 use Doctrine\DBAL\Connection;
use Doctrine\DBAL\Tools\Console\ConnectionProvider\SingleConnectionProvider;
use Symfony\Component\Console\Application;
/** @var Connection $connection */
$connection = /* ... */;
/** @var Application $cli */
$cli = /* ... */;
$connectionProvider = new SingleConnectionProvider($connection);
$cli->add(new RunSqlCommand($connectionProvider)); 2 3 4 5 6 7 8 9 10 11 12 13
If your application uses more than one connection, write your own implementation of ConnectionProvider and use it
instead of the SingleConnectionProvider class.