Symfony2 : Unit testing with sqlite

Question

I'm using phpunit with Symfony2.

I decided to use sqlite for my tests.

The issue I'm having is that the foreign keys constraints are ignored.

I know I have to execute the following query in order to use foreign keys : PRAGMA foreign_keys = ON).

My question is : is there a way to always use foreign keys when creating the database schema with sqlite ?

Thanks !

Brice · Accepted Answer · 2015-04-15 09:36:26Z

3

Unfortunately it is impossible. Accordingly to SQLite documentation:

Assuming the library is compiled with foreign key constraints enabled, it must still be enabled by the application at runtime, using the PRAGMA foreign_keys command.

I would suggest to create your own test case class and use setUp() method to enable foreign keys.

class SQLiteTestCase extends \PHPUnit_Framework_TestCase
{
  protected function setUp()
  {
    parent::setUp();
    // Here add your code to enable foreign keys
  }
}

class MyTest extends SQLiteTestCase
{
  protected function setUp()
  {
    // Setup your test data-set here
    parent::setUp();
  }
}

edited Apr 15, 2015 at 9:36

Brice

1,0269 silver badges20 bronze badges

answered Apr 7, 2015 at 16:42

Aleksander Wons

3,98721 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Symfony2 : Unit testing with sqlite

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related