使用 Symfony 测试数据库插入

在每次测试运行时重新创建模式
https://stackoverflow.com/a/10463614/1177024

<小时>这是我对数据库的班级测试

namespace QkprodMangressBundleEntity;

use QkprodMangressBundleEntityGenre;
use SymfonyBundleFrameworkBundleTestWebTestCase;

    private $em;

    /**
     * Sets up environment for testing
     * Regenerates Database schema before every test-run
     */
    public function setUp() {
        static::$kernel = static::createKernel();
        static::$kernel -> boot();
        $this -> em = static::$kernel->getContainer()
                                     ->get('doctrine')
                                     ->getEntityManager();
        $this->regenerateSchema();
    }

    protected function tearDown() {
        parent::tearDown();
        $this -> em -> close();
    }

    /**
     * Drops current schema and creates a brand new one
     */
    protected function regenerateSchema() {
        $metadatas = $this->em->getMetadataFactory()->getAllMetadata();
        if (!empty($metadatas)) {
            $tool = new DoctrineORMToolsSchemaTool($this->em);
            $tool -> dropSchema($metadatas);
            $tool -> createSchema($metadatas);
        }
    }


    public function testInsert() {
        $genre = new Genre();
        $genre -> setName("testGenre");

        $this -> em -> persist($genre);
        $this -> em -> flush();

        $result = $this -> em 
                    -> createQuery("SELECT g "
                                 . " FROM QkprodMangressBundle:Genre g " 
                                 . " WHERE g.name = :name") 
                    -> setParameter("name", $genre -> getName())
                    -> getResult();

        $this -> assertEquals($result[0] -> getName(), $genre -> getName());
    }
}

无法让 LiipBundle 工作，但您可以通过设置 symfony 将 sqlite db 保存在内存而不是文件系统中来提高速度.https://stackoverflow.com/a/10460139/1177024

# app/config/config_test
doctrine:
    dbal:
        driver: pdo_sqlite
        path: :memory:
        memory: true

或者可能只创建一次架构，而不是重新创建它，只需使用新备份覆盖数据库即可.