title: Symfony / Doctrine UnitTests with SQLite memory DB
body: <p>I'm still working on PHP unit tests for testing my symfony2 controllers. My test classes are derivations of WebTestCase and the tests are doing GET or POST requests do check if everything works fine.
  I want to test all underlying layers, but I don't want to mess up my database with the tests. I don't want to use mock ups, but an in-memory SQLite db, where I can set up a test scenario to check all modifications.
  I found a lot of hints how to do this with doctrine 1.x, but they don't work any more.
  So I want something like this:</p>
  
  <pre><code>class BlahblahTest extends WebTestCase {
      public function testXXXYYY() {
          // 1. Setup a new database with SQLite:memory:
          // 2. create the database and all tables according the entities in my project
          $this-&gt;createTestScenario(); // 3.
          $crawler = $this-&gt;client-&gt;request('GET', '/testpage');  // 4.
          // 5. Lots of checks against the database and / or the $crawler data
      }
  }
  </code></pre>
  
  <p>Any chance to get this work?</p>
  
  <p>Thanks in advance
  Hennes</p>