Command/UpdateSchemaDoctrineCommand.php
author ymh <ymh.work@gmail.com>
Fri, 26 Sep 2014 10:04:40 +0200
changeset 136 f209fcb0df6c
parent 42 0e57c730bb18
permissions -rwxr-xr-x
Added tag V00.18 for changeset ab728cb3632c
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
25
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
     1
<?php
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
     2
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
     3
/*
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
     4
 * This file is part of the Symfony package.
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
     5
 *
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
     6
 * (c) Fabien Potencier <fabien@symfony.com>
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
     7
 *
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
     8
 * For the full copyright and license information, please view the LICENSE
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
     9
 * file that was distributed with this source code.
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    10
 */
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    11
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    12
namespace IRI\Bundle\WikiTagBundle\Command;
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    13
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    14
use Symfony\Component\DependencyInjection\ContainerAwareInterface;
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    15
use Symfony\Component\DependencyInjection\ContainerInterface;
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    16
use Symfony\Component\Console\Input\InputArgument;
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    17
use Symfony\Component\Console\Input\InputOption;
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    18
use Symfony\Component\Console\Input\InputInterface;
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    19
use Symfony\Component\Console\Output\OutputInterface;
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    20
use Symfony\Component\Console\Output\Output;
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    21
use Doctrine\ORM\Tools\Console\Command\SchemaTool\UpdateCommand;
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    22
use Doctrine\ORM\Tools\SchemaTool;
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    23
use Symfony\Bundle\DoctrineBundle\Command\Proxy\DoctrineCommandHelper;
42
0e57c730bb18 Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents: 25
diff changeset
    24
use IRI\Bundle\WikiTagBundle\Utils\FilteredSchemaTool;
25
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    25
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    26
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    27
/**
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    28
 * Command to generate the SQL needed to update the database schema to match
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    29
 * the current mapping information.
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    30
 *
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    31
 * This file is a direct adaptation of the Symfony\Bundle\DoctrineBundle\Command\Proxy\UpdateSchemaDoctrineCommand
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    32
 *
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    33
 */
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    34
class UpdateSchemaDoctrineCommand extends UpdateCommand implements ContainerAwareInterface
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    35
{
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    36
    protected function configure()
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    37
    {
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    38
        parent::configure();
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    39
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    40
        $this
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    41
            ->setName('wikitag:schema:update')
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    42
            ->setDescription('Executes (or dumps) the SQL needed to update the database schema to match the current mapping metadata')
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    43
            ->addOption('em', null, InputOption::VALUE_OPTIONAL, 'The entity manager to use for this command')
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    44
            ->setHelp(<<<EOT
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    45
The <info>doctrine:schema:update</info> command generates the SQL needed to
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    46
synchronize the database schema with the current mapping metadata of the
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    47
default entity manager.
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    48
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    49
For example, if you add metadata for a new column to an entity, this command
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    50
would generate and output the SQL needed to add the new column to the database:
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    51
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    52
<info>php app/console doctrine:schema:update --dump-sql</info>
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    53
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    54
Alternatively, you can execute the generated queries:
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    55
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    56
<info>php app/console doctrine:schema:update --force</info>
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    57
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    58
You can also update the database schema for a specific entity manager:
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    59
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    60
<info>php app/console doctrine:schema:update --em=default</info>
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    61
EOT
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    62
        );
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    63
    }
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    64
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    65
    protected function execute(InputInterface $input, OutputInterface $output)
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    66
    {
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    67
        DoctrineCommandHelper::setApplicationEntityManager($this->getApplication(), $input->getOption('em'));
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    68
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    69
        parent::execute($input, $output);
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    70
    }
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    71
    
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    72
   /**
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    73
    * @var ContainerInterface
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    74
    */
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    75
    private $container;
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    76
    
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    77
    protected function getContainer()
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    78
    {
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    79
        if (null === $this->container) {
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    80
            $this->container = $this->getApplication()->getKernel()->getContainer();
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    81
        }
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    82
    
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    83
        return $this->container;
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    84
    }
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    85
    
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    86
    /**
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    87
     * @see ContainerAwareInterface::setContainer()
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    88
     */
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    89
    public function setContainer(ContainerInterface $container = null)
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    90
    {
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    91
        $this->container = $container;
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    92
    }
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    93
    
42
0e57c730bb18 Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents: 25
diff changeset
    94
        
25
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    95
    protected function executeSchemaCommand(InputInterface $input, OutputInterface $output, SchemaTool $schemaTool, array $metadatas)
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
    96
    {
42
0e57c730bb18 Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents: 25
diff changeset
    97
        $filteredSchemaTool = new FilteredSchemaTool($this->getHelper("em")->getEntityManager(), $this->getContainer());
0e57c730bb18 Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents: 25
diff changeset
    98
        
0e57c730bb18 Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents: 25
diff changeset
    99
        return parent::executeSchemaCommand($input, $output, $filteredSchemaTool, $metadatas);
0e57c730bb18 Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents: 25
diff changeset
   100
        
25
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
   101
    }
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
   102
    
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
   103
    
11fd79666374 add missing files
ymh <ymh.work@gmail.com>
parents:
diff changeset
   104
}