Doctrine2 Reverse Engineer Sqlite Database

doctrine2_reverse_engineer.php

use \Doctrine\ORM\Tools\EntityGenerator,
    \Doctrine\Common\ClassLoader,
    \Doctrine\ORM\Configuration,
    \Doctrine\Common\Cache\ArrayCache,
    \Doctrine\ORM\EntityManager,
    \Doctrine\ORM\Mapping\Driver\DatabaseDriver,
    \Doctrine\ORM\Tools\DisconnectedClassMetadataFactory;

// autoload
$classLoader = new ClassLoader( 'Entities', __DIR__ );
$classLoader->register();

$classLoader = new ClassLoader( 'Proxies', __DIR__ );
$classLoader->register();

// config
$config = new Configuration;
$config->setMetadataDriverImpl( $config->newDefaultAnnotationDriver( sprintf( '%s/Entities', __DIR__ ) ) );
$config->setMetadataCacheImpl( new ArrayCache );
$config->setProxyDir( sprintf( '%s/Proxies', __DIR__ ) );
$config->setProxyNamespace( 'Proxies' );

// entity manager
$em = EntityManager::create( array(
        'driver' => 'pdo_sqlite',
        'path' => __DIR__ . '/example.config.sqlite',
    ),
    $config
);

// custom datatypes (not mapped for reverse engineering)
$em->getConnection()->getDatabasePlatform()->registerDoctrineTypeMapping( 'set', 'string' );
$em->getConnection()->getDatabasePlatform()->registerDoctrineTypeMapping( 'enum', 'string' );

// fetch metadata
$em->getConfiguration()->setMetadataDriverImpl(
    new DatabaseDriver(
        $em->getConnection()->getSchemaManager()
    )
);

$cmf = new DisconnectedClassMetadataFactory;
$cmf->setEntityManager( $em ); 

$generator = new EntityGenerator;
$generator->setUpdateEntityIfExists( true );
$generator->setGenerateStubMethods( true );
$generator->setGenerateAnnotations( true );
$generator->generate( $cmf->getAllMetadata(), sprintf( '%s/Entities', __DIR__ ) );