Symfony 2 : Generate SQL from specific entity

Question

I'd like to generate my SQL from my entities.

I know the commands php app/console doctrine:schema:create --dump-sql and doctrine:schema:update, but apparently there is no way to filter on Entities, not even to filter on Bundle, but only on EntityManager ?!

Did I miss something ? I thought that was a pretty common need, and pretty easy to develop..

P.S. I need it because I have an old weird Database shared with others softwares that isn't exactly how Doctrine would like to, so if I don't filter I'd have some errors, or in the best case lots of useless/wrong modifications.

what would you consider a common use case for this? If you modify 1 entity that has relations to another then in order for your database to stay in sync you would need to update both entities. Can you provide why you are trying to isolate the sql for a given entity? — Chase
– Chase, Commented Mar 31, 2014 at 21:46
It's because I have hundreds of entities (previously generated by reverse engineering the Database with doctrine:mapping:import). And as I said in the "P.S", because of the weirdness of those tables it generates some errors if I doctrine:schema:update everything, and if I correct those errors it generates lots of useless and/or wrong SQL code. — Bonswouar
– Bonswouar, Commented Apr 1, 2014 at 10:05

Lulhum · Accepted Answer · 2016-05-20 12:28:57Z

7

Since the only proposed answer here did not suit me, and this topic appears to be the only one I found referencing this issue, there is my solution (note that I use this in a SF2 ContainerAwareCommand) :

namespace AppBundle\Command;

use Doctrine\DBAL\Schema\Comparator;
use Doctrine\ORM\Tools\SchemaTool;
use Symfony\Bundle\FrameworkBundle\Command\ContainerAwareCommand;

/* ... */

class MyCommand extends ContainerAwareCommand
{
    /* ... */

    protected function execute(InputInterface $input, OutputInterface $output)
    {
        $em = $this->getContainer()->get('doctrine.orm.entity_manager');

        /* Doctrine tool class for create/drop/update database schemas
        based on metadata class descriptors */
        $tool = new SchemaTool($em);

        /* Doctrine tool class for comparing differences between database
        schemas */
        $comparator = new Comparator();

        /* Create an empty schema */
        $fromSchema = $tool->getSchemaFromMetadata(array());

        /* Create the schema for our class */
        $toSchema = $tool->getSchemaFromMetadata(
            array($em->getClassMetadata('AppBundle:MyEntity'))
        );

        /* Compare schemas, and write result as SQL */
        $schemaDiff = $comparator->compare($fromSchema, $toSchema);
        $sql = $schemaDiff->toSql(
            $em->getConnection()->getDatabasePlatform()
        );
        $output->writeln($sql);
    }
}

edited May 20, 2016 at 12:28

answered May 6, 2016 at 9:59

Lulhum

83413 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

userfuser Over a year ago

Thanks @Drumnbass, this is a very useful solution and a great idea!

Alberto Fernández · Accepted Answer · 2014-03-31 15:58:32Z

2

You can filter on entity managers, but you need to register them manually in your config:

orm:
    auto_generate_proxy_classes: %kernel.debug%
    entity_managers:
        default:
            mappings:
                OneBundle:
                    type: annotation
                AnotherBundle:
                    type: annotation
        another_entity_manager:
            mappings:
                SomeOtherBundle:
                    type: annotation

This way you can use, for example:

php app/console doctrine:schema:update --dump-sql --em=another_entity_manager

This should only update the schema for the entities in SomeOtherBundle.

answered Mar 31, 2014 at 15:58

Alberto Fernández

1,60814 silver badges23 bronze badges

1 Comment

Bonswouar Over a year ago

So this is kind of a hack, isn't it ? I would create this entity manager only for generating SQL and then remove it ? I wonder why there isn't a cleaner solution.. Like just a command line option.

ZxDx · Accepted Answer · 2022-07-19 13:23:34Z

0

You can use grep:

 php bin/console doctrine:schema:create --dump-sql|grep -w 'CREATE TABLE entity_name'

answered Jul 19, 2022 at 13:23

ZxDx

591 silver badge4 bronze badges

Collectives™ on Stack Overflow

Symfony 2 : Generate SQL from specific entity

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related