StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>You can use this class:</p> <pre><code><?php namespace Project\Bundle\Tests; require_once dirname(__DIR__).'/../../../app/AppKernel.php'; use Doctrine\ORM\Tools\SchemaTool; abstract class TestCase extends \PHPUnit_Framework_TestCase { /** * @var Symfony\Component\HttpKernel\AppKernel */ protected $kernel; /** * @var Doctrine\ORM\EntityManager */ protected $entityManager; /** * @var Symfony\Component\DependencyInjection\Container */ protected $container; public function setUp() { // Boot the AppKernel in the test environment and with the debug. $this->kernel = new \AppKernel('test', true); $this->kernel->boot(); // Store the container and the entity manager in test case properties $this->container = $this->kernel->getContainer(); $this->entityManager = $this->container->get('doctrine')->getEntityManager(); // Build the schema for sqlite $this->generateSchema(); parent::setUp(); } public function tearDown() { // Shutdown the kernel. $this->kernel->shutdown(); parent::tearDown(); } protected function generateSchema() { // Get the metadatas of the application to create the schema. $metadatas = $this->getMetadatas(); if ( ! empty($metadatas)) { // Create SchemaTool $tool = new SchemaTool($this->entityManager); $tool->createSchema($metadatas); } else { throw new Doctrine\DBAL\Schema\SchemaException('No Metadata Classes to process.'); } } /** * Overwrite this method to get specific metadatas. * * @return Array */ protected function getMetadatas() { return $this->entityManager->getMetadataFactory()->getAllMetadata(); } } </code></pre> <p>And then you can test your entity. Something like this (assuming you have a entity User)</p> <pre><code>//Entity Test class EntityTest extends TestCase { protected $user; public function setUp() { parent::setUp(); $this->user = new User(); $this->user->setUsername('username'); $this->user->setPassword('p4ssw0rd'); $this->entityManager->persist($this->user); $this->entityManager->flush(); } public function testUser(){ $this->assertEquals($this->user->getUserName(), "username"); ... } } </code></pre> <p>Hope this help.</p> <p>Source: theodo.fr/blog/2011/09/symfony2-unit-database-tests</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload