| public dropTables ( Symfony\Component\Console\Output\OutputInterface $output ) | ||
| $output | Symfony\Component\Console\Output\OutputInterface | |
public function dropTables($output)
{
$result = $this->getTables();
$query = 'SET FOREIGN_KEY_CHECKS = 0; ';
$count = 0;
foreach ($result as $tableName) {
$query .= 'DROP TABLE IF EXISTS `' . $tableName . '`; ';
$count++;
}
$query .= 'SET FOREIGN_KEY_CHECKS = 1;';
$this->getConnection()->query($query);
$output->writeln('<info>Dropped database tables</info> <comment>' . $count . ' tables dropped</comment>');
}