doctrine / DoctrineBundle

/**

 * Command to clear the metadata cache of the various cache drivers.

 */

class ClearMetadataCacheDoctrineCommand extends MetadataCommand

{

    /**

     * {@inheritDoc}

     */

    protected function configure()

    {

        parent::configure();

        $this

            ->setName('doctrine:cache:clear-metadata')

            ->setDescription('Clears all metadata cache for an entity manager')

            ->addOption('em', null, InputOption::VALUE_OPTIONAL, 'The entity manager to use for this command');

    }

    /**

     * {@inheritDoc}

     */

    protected function execute(InputInterface $input, OutputInterface $output)

    {

        DoctrineCommandHelper::setApplicationEntityManager($this->getApplication(), $input->getOption('em'));

        return parent::execute($input, $output);

    }

}

/**

 * Command to clear the query cache of the various cache drivers.

 */

class ClearQueryCacheDoctrineCommand extends QueryCommand

{

    /**

     * {@inheritDoc}

     */

    protected function configure()

    {

        parent::configure();

        $this

            ->setName('doctrine:cache:clear-query')

            ->setDescription('Clears all query cache for an entity manager')

            ->addOption('em', null, InputOption::VALUE_OPTIONAL, 'The entity manager to use for this command');

    }

    /**

     * {@inheritDoc}

     */

    protected function execute(InputInterface $input, OutputInterface $output)

    {

        DoctrineCommandHelper::setApplicationEntityManager($this->getApplication(), $input->getOption('em'));

        return parent::execute($input, $output);

    }

}

/**

 * Command to clear the result cache of the various cache drivers.

 */

class ClearResultCacheDoctrineCommand extends ResultCommand

{

    /**

     * {@inheritDoc}

     */

    protected function configure()

    {

        parent::configure();

        $this

            ->setName('doctrine:cache:clear-result')

            ->setDescription('Clears result cache for an entity manager')

            ->addOption('em', null, InputOption::VALUE_OPTIONAL, 'The entity manager to use for this command');

    }

    /**

     * {@inheritDoc}

     */

    protected function execute(InputInterface $input, OutputInterface $output)

    {

        DoctrineCommandHelper::setApplicationEntityManager($this->getApplication(), $input->getOption('em'));

        return parent::execute($input, $output);

    }

}

 * Command to execute the SQL needed to generate the database schema for

 * a given entity manager.

 */

class CreateSchemaDoctrineCommand extends CreateCommand

{

    /**

     * {@inheritDoc}

     */

    protected function configure()

    {

        parent::configure();

        $this

            ->setName('doctrine:schema:create')

            ->setDescription('Executes (or dumps) the SQL needed to generate the database schema')

            ->addOption('em', null, InputOption::VALUE_OPTIONAL, 'The entity manager to use for this command');

    }

    /**

     * {@inheritDoc}

     */

    protected function execute(InputInterface $input, OutputInterface $output)

    {

        DoctrineCommandHelper::setApplicationEntityManager($this->getApplication(), $input->getOption('em'));

        return parent::execute($input, $output);

    }

}

/**

 * Command to drop the database schema for a set of classes based on their mappings.

 */

class DropSchemaDoctrineCommand extends DropCommand

{

    /**

     * {@inheritDoc}

     */

    protected function configure()

    {

        parent::configure();

        $this

            ->setName('doctrine:schema:drop')

            ->setDescription('Executes (or dumps) the SQL needed to drop the current database schema')

            ->addOption('em', null, InputOption::VALUE_OPTIONAL, 'The entity manager to use for this command');

    }

    /**

     * {@inheritDoc}

     */

    protected function execute(InputInterface $input, OutputInterface $output)

    {

        DoctrineCommandHelper::setApplicationEntityManager($this->getApplication(), $input->getOption('em'));

        return parent::execute($input, $output);

    }

}

/**

 * Execute a Doctrine DQL query and output the results.

 */

class RunDqlDoctrineCommand extends RunDqlCommand

{

    /**

     * {@inheritDoc}

     */

    protected function configure()

    {

        parent::configure();

        $this

            ->setName('doctrine:query:dql')

            ->addOption('em', null, InputOption::VALUE_OPTIONAL, 'The entity manager to use for this command')

            ->setHelp(<<<EOT

The <info>%command.name%</info> command executes the given DQL query and

outputs the results:

<info>php %command.full_name% "SELECT u FROM UserBundle:User u"</info>

You can also optional specify some additional options like what type of

hydration to use when executing the query:

<info>php %command.full_name% "SELECT u FROM UserBundle:User u" --hydrate=array</info>

Additionally you can specify the first result and maximum amount of results to

show:

<info>php %command.full_name% "SELECT u FROM UserBundle:User u" --first-result=0 --max-result=30</info>

EOT

        );

    }

    /**

     * {@inheritDoc}

     */

    protected function execute(InputInterface $input, OutputInterface $output)

    {

        DoctrineCommandHelper::setApplicationEntityManager($this->getApplication(), $input->getOption('em'));

        return parent::execute($input, $output);

    }

}