title: cakephp + phpunit + gitlab continuous integration
body: <p>I'm looking for help with my tests in cakephp + phpunit + gitlab-ci. </p>
  
  <p>I defined my test/fixtures like this: <code>public $import = ['model' =&gt; 'MyModel'];</code> to avoid having to redefine the tables schema in the fixture, and have out of sync/wrong code. </p>
  
  <p>I understand that what it does is to look for the live db and use that information to generate the tables in the test db, but what about if there is no live db?</p>
  
  <p>I'm trying to automate my testing in gitlab / continuous integration environment, and there they provide you a mysql container <strong>with a single db</strong> to run your tests. If I have a single DB, i will not be able to have both a main connection and the testing db, right?</p>
  
  <p>I was thinking on having a create-db-for-tests.sql and imprort that script BUT I understand that running a test with a fixture will remove the table, so I would need to create it again and again on every test.</p>
  
  <p>I could not use the gitlab mysql service and install mysql in the testing container to have 2 databases, like in dev,  but I would need to populate the other DB with some script too, and that's the same as defining the db structure in the fixtures.   </p>
  
  <p>How can I solve this problem?</p>
  
  <p>Any help will be gladly appreciated. </p>