DropCommand.php 4.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111
  1. <?php
  2. /*
  3. * $Id$
  4. *
  5. * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
  6. * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
  7. * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
  8. * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
  9. * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
  10. * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
  11. * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
  12. * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
  13. * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
  14. * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
  15. * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
  16. *
  17. * This software consists of voluntary contributions made by many individuals
  18. * and is licensed under the LGPL. For more information, see
  19. * <http://www.doctrine-project.org>.
  20. */
  21. namespace Doctrine\ORM\Tools\Console\Command\SchemaTool;
  22. use Symfony\Component\Console\Input\InputArgument,
  23. Symfony\Component\Console\Input\InputOption,
  24. Symfony\Component\Console\Input\InputInterface,
  25. Symfony\Component\Console\Output\OutputInterface,
  26. Doctrine\ORM\Tools\SchemaTool;
  27. /**
  28. * Command to drop the database schema for a set of classes based on their mappings.
  29. *
  30. * @license http://www.opensource.org/licenses/lgpl-license.php LGPL
  31. * @link www.doctrine-project.org
  32. * @since 2.0
  33. * @version $Revision$
  34. * @author Benjamin Eberlei <kontakt@beberlei.de>
  35. * @author Guilherme Blanco <guilhermeblanco@hotmail.com>
  36. * @author Jonathan Wage <jonwage@gmail.com>
  37. * @author Roman Borschel <roman@code-factory.org>
  38. */
  39. class DropCommand extends AbstractCommand
  40. {
  41. /**
  42. * @see Console\Command\Command
  43. */
  44. protected function configure()
  45. {
  46. $this
  47. ->setName('orm:schema-tool:drop')
  48. ->setDescription(
  49. 'Drop the complete database schema of EntityManager Storage Connection or generate the corresponding SQL output.'
  50. )
  51. ->setDefinition(array(
  52. new InputOption(
  53. 'dump-sql', null, InputOption::VALUE_NONE,
  54. 'Instead of try to apply generated SQLs into EntityManager Storage Connection, output them.'
  55. ),
  56. new InputOption(
  57. 'force', null, InputOption::VALUE_NONE,
  58. "Don't ask for the deletion of the database, but force the operation to run."
  59. ),
  60. new InputOption(
  61. 'full-database', null, InputOption::VALUE_NONE,
  62. 'Instead of using the Class Metadata to detect the database table schema, drop ALL assets that the database contains.'
  63. ),
  64. ))
  65. ->setHelp(<<<EOT
  66. Processes the schema and either drop the database schema of EntityManager Storage Connection or generate the SQL output.
  67. Beware that the complete database is dropped by this command, even tables that are not relevant to your metadata model.
  68. EOT
  69. );
  70. }
  71. protected function executeSchemaCommand(InputInterface $input, OutputInterface $output, SchemaTool $schemaTool, array $metadatas)
  72. {
  73. $isFullDatabaseDrop = ($input->getOption('full-database'));
  74. if ($input->getOption('dump-sql') === true) {
  75. if ($isFullDatabaseDrop) {
  76. $sqls = $schemaTool->getDropDatabaseSQL();
  77. } else {
  78. $sqls = $schemaTool->getDropSchemaSQL($metadatas);
  79. }
  80. $output->write(implode(';' . PHP_EOL, $sqls) . PHP_EOL);
  81. } else if ($input->getOption('force') === true) {
  82. $output->write('Dropping database schema...' . PHP_EOL);
  83. if ($isFullDatabaseDrop) {
  84. $schemaTool->dropDatabase();
  85. } else {
  86. $schemaTool->dropSchema($metadatas);
  87. }
  88. $output->write('Database schema dropped successfully!' . PHP_EOL);
  89. } else {
  90. $output->write('ATTENTION: This operation should not be executed in a production environment.' . PHP_EOL . PHP_EOL);
  91. if ($isFullDatabaseDrop) {
  92. $sqls = $schemaTool->getDropDatabaseSQL();
  93. } else {
  94. $sqls = $schemaTool->getDropSchemaSQL($metadatas);
  95. }
  96. if (count($sqls)) {
  97. $output->write('Schema-Tool would execute ' . count($sqls) . ' queries to drop the database.' . PHP_EOL);
  98. $output->write('Please run the operation with --force to execute these queries or use --dump-sql to see them.' . PHP_EOL);
  99. } else {
  100. $output->write('Nothing to drop. The database is empty!' . PHP_EOL);
  101. }
  102. }
  103. }
  104. }