namespace Tests\Wallabag\CoreBundle\Command;
+use DAMA\DoctrineTestBundle\Doctrine\DBAL\StaticDriver;
use Doctrine\Bundle\DoctrineBundle\Command\CreateDatabaseDoctrineCommand;
use Doctrine\Bundle\DoctrineBundle\Command\DropDatabaseDoctrineCommand;
+use Doctrine\DBAL\Platforms\PostgreSqlPlatform;
+use Doctrine\DBAL\Platforms\SqlitePlatform;
use Symfony\Bundle\FrameworkBundle\Console\Application;
use Symfony\Component\Console\Input\ArrayInput;
use Symfony\Component\Console\Output\NullOutput;
use Symfony\Component\Console\Tester\CommandTester;
-use Wallabag\CoreBundle\Command\InstallCommand;
use Tests\Wallabag\CoreBundle\Mock\InstallCommandMock;
use Tests\Wallabag\CoreBundle\WallabagCoreTestCase;
+use Wallabag\CoreBundle\Command\InstallCommand;
class InstallCommandTest extends WallabagCoreTestCase
{
{
parent::setUp();
- if ($this->getClient()->getContainer()->get('doctrine')->getConnection()->getDriver() instanceof \Doctrine\DBAL\Driver\PDOPgSql\Driver) {
+ /** @var \Doctrine\DBAL\Connection $connection */
+ $connection = $this->getClient()->getContainer()->get('doctrine')->getConnection();
+ if ($connection->getDatabasePlatform() instanceof PostgreSqlPlatform) {
/*
* LOG: statement: CREATE DATABASE "wallabag"
* ERROR: source database "template1" is being accessed by other users
*
* http://stackoverflow.com/a/14374832/569101
*/
- $this->markTestSkipped('PostgreSQL spotted: can find a good way to drop current database, skipping.');
+ $this->markTestSkipped('PostgreSQL spotted: can\'t find a good way to drop current database, skipping.');
+ }
+
+ if ($connection->getDatabasePlatform() instanceof SqlitePlatform) {
+ // Environnement variable useful only for sqlite to avoid the error "attempt to write a readonly database"
+ // We can't define always this environnement variable because pdo_mysql seems to use it
+ // and we have the error:
+ // SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax;
+ // check the manual that corresponds to your MariaDB server version for the right syntax to use
+ // near '/tmp/wallabag_testTYj1kp' at line 1
+ $databasePath = tempnam(sys_get_temp_dir(), 'wallabag_test');
+ putenv("TEST_DATABASE_PATH=$databasePath");
+
+ // The environnement has been changed, recreate the client in order to update connection
+ parent::setUp();
}
+
+ // disable doctrine-test-bundle
+ StaticDriver::setKeepStaticConnections(false);
+
+ $this->resetDatabase($this->getClient());
}
- public static function tearDownAfterClass()
+ public function tearDown()
{
- $application = new Application(static::$kernel);
- $application->setAutoExit(false);
+ $databasePath = getenv('TEST_DATABASE_PATH');
+ // Remove variable environnement
+ putenv('TEST_DATABASE_PATH');
+ if ($databasePath && file_exists($databasePath)) {
+ unlink($databasePath);
+ } else {
+ // Create a new client to avoid the error:
+ // Transaction commit failed because the transaction has been marked for rollback only.
+ $client = static::createClient();
+ $this->resetDatabase($client);
+ }
- $code = $application->run(new ArrayInput([
- 'command' => 'doctrine:fixtures:load',
- '--no-interaction' => true,
- '--env' => 'test',
- ]), new NullOutput());
+ // enable doctrine-test-bundle
+ StaticDriver::setKeepStaticConnections(true);
+ parent::tearDown();
}
public function testRunInstallCommand()
$command = $application->find('wallabag:install');
- // We mock the QuestionHelper
- $question = $this->getMockBuilder('Symfony\Component\Console\Helper\QuestionHelper')
- ->disableOriginalConstructor()
- ->getMock();
- $question->expects($this->any())
- ->method('ask')
- ->will($this->returnValue('yes_'.uniqid('', true)));
-
- // We override the standard helper with our mock
- $command->getHelperSet()->set($question, 'question');
-
$tester = new CommandTester($command);
+ $tester->setInputs([
+ 'y', // dropping database
+ 'y', // create super admin
+ 'username_' . uniqid('', true), // username
+ 'password_' . uniqid('', true), // password
+ 'email_' . uniqid('', true) . '@wallabag.it', // email
+ ]);
$tester->execute([
'command' => $command->getName(),
]);
$this->assertContains('Setting up database.', $tester->getDisplay());
$this->assertContains('Administration setup.', $tester->getDisplay());
$this->assertContains('Config setup.', $tester->getDisplay());
- $this->assertContains('Installing assets.', $tester->getDisplay());
+ $this->assertContains('Run migrations.', $tester->getDisplay());
}
public function testRunInstallCommandWithReset()
$command = $application->find('wallabag:install');
- // We mock the QuestionHelper
- $question = $this->getMockBuilder('Symfony\Component\Console\Helper\QuestionHelper')
- ->disableOriginalConstructor()
- ->getMock();
- $question->expects($this->any())
- ->method('ask')
- ->will($this->returnValue('yes_'.uniqid('', true)));
-
- // We override the standard helper with our mock
- $command->getHelperSet()->set($question, 'question');
-
$tester = new CommandTester($command);
+ $tester->setInputs([
+ 'y', // create super admin
+ 'username_' . uniqid('', true), // username
+ 'password_' . uniqid('', true), // password
+ 'email_' . uniqid('', true) . '@wallabag.it', // email
+ ]);
$tester->execute([
'command' => $command->getName(),
'--reset' => true,
$this->assertContains('Checking system requirements.', $tester->getDisplay());
$this->assertContains('Setting up database.', $tester->getDisplay());
- $this->assertContains('Droping database, creating database and schema, clearing the cache', $tester->getDisplay());
+ $this->assertContains('Dropping database, creating database and schema, clearing the cache', $tester->getDisplay());
$this->assertContains('Administration setup.', $tester->getDisplay());
$this->assertContains('Config setup.', $tester->getDisplay());
- $this->assertContains('Installing assets.', $tester->getDisplay());
+ $this->assertContains('Run migrations.', $tester->getDisplay());
// we force to reset everything
- $this->assertContains('Droping database, creating database and schema, clearing the cache', $tester->getDisplay());
+ $this->assertContains('Dropping database, creating database and schema, clearing the cache', $tester->getDisplay());
}
public function testRunInstallCommandWithDatabaseRemoved()
{
+ // skipped SQLite check when database is removed because while testing for the connection,
+ // the driver will create the file (so the database) before testing if database exist
+ if ($this->getClient()->getContainer()->get('doctrine')->getConnection()->getDatabasePlatform() instanceof \Doctrine\DBAL\Platforms\SqlitePlatform) {
+ $this->markTestSkipped('SQLite spotted: can\'t test with database removed.');
+ }
+
$application = new Application($this->getClient()->getKernel());
$application->add(new DropDatabaseDoctrineCommand());
$command = $application->find('wallabag:install');
- // We mock the QuestionHelper
- $question = $this->getMockBuilder('Symfony\Component\Console\Helper\QuestionHelper')
- ->disableOriginalConstructor()
- ->getMock();
- $question->expects($this->any())
- ->method('ask')
- ->will($this->returnValue('yes_'.uniqid('', true)));
-
- // We override the standard helper with our mock
- $command->getHelperSet()->set($question, 'question');
-
$tester = new CommandTester($command);
+ $tester->setInputs([
+ 'y', // create super admin
+ 'username_' . uniqid('', true), // username
+ 'password_' . uniqid('', true), // password
+ 'email_' . uniqid('', true) . '@wallabag.it', // email
+ ]);
$tester->execute([
'command' => $command->getName(),
]);
$this->assertContains('Setting up database.', $tester->getDisplay());
$this->assertContains('Administration setup.', $tester->getDisplay());
$this->assertContains('Config setup.', $tester->getDisplay());
- $this->assertContains('Installing assets.', $tester->getDisplay());
+ $this->assertContains('Run migrations.', $tester->getDisplay());
// the current database doesn't already exist
$this->assertContains('Creating database and schema, clearing the cache', $tester->getDisplay());
$command = $application->find('wallabag:install');
- // We mock the QuestionHelper
- $question = $this->getMockBuilder('Symfony\Component\Console\Helper\QuestionHelper')
- ->disableOriginalConstructor()
- ->getMock();
-
- $question->expects($this->exactly(3))
- ->method('ask')
- ->will($this->onConsecutiveCalls(
- false, // don't want to reset the entire database
- true, // do want to reset the schema
- false // don't want to create a new user
- ));
-
- // We override the standard helper with our mock
- $command->getHelperSet()->set($question, 'question');
-
$tester = new CommandTester($command);
+ $tester->setInputs([
+ 'n', // don't want to reset the entire database
+ 'y', // do want to reset the schema
+ 'n', // don't want to create a new user
+ ]);
$tester->execute([
'command' => $command->getName(),
]);
$this->assertContains('Setting up database.', $tester->getDisplay());
$this->assertContains('Administration setup.', $tester->getDisplay());
$this->assertContains('Config setup.', $tester->getDisplay());
- $this->assertContains('Installing assets.', $tester->getDisplay());
+ $this->assertContains('Run migrations.', $tester->getDisplay());
- $this->assertContains('Droping schema and creating schema', $tester->getDisplay());
+ $this->assertContains('Dropping schema and creating schema', $tester->getDisplay());
}
public function testRunInstallCommandChooseNothing()
$command = $application->find('wallabag:install');
- // We mock the QuestionHelper
- $question = $this->getMockBuilder('Symfony\Component\Console\Helper\QuestionHelper')
- ->disableOriginalConstructor()
- ->getMock();
-
- $question->expects($this->exactly(2))
- ->method('ask')
- ->will($this->onConsecutiveCalls(
- false, // don't want to reset the entire database
- false // don't want to create a new user
- ));
-
- // We override the standard helper with our mock
- $command->getHelperSet()->set($question, 'question');
-
$tester = new CommandTester($command);
+ $tester->setInputs([
+ 'n', // don't want to reset the entire database
+ 'n', // don't want to create a new user
+ ]);
$tester->execute([
'command' => $command->getName(),
]);
$this->assertContains('Setting up database.', $tester->getDisplay());
$this->assertContains('Administration setup.', $tester->getDisplay());
$this->assertContains('Config setup.', $tester->getDisplay());
- $this->assertContains('Installing assets.', $tester->getDisplay());
+ $this->assertContains('Run migrations.', $tester->getDisplay());
$this->assertContains('Creating schema', $tester->getDisplay());
}
$command = $application->find('wallabag:install');
- // We mock the QuestionHelper
- $question = $this->getMockBuilder('Symfony\Component\Console\Helper\QuestionHelper')
- ->disableOriginalConstructor()
- ->getMock();
- $question->expects($this->any())
- ->method('ask')
- ->will($this->returnValue('yes_'.uniqid('', true)));
-
- // We override the standard helper with our mock
- $command->getHelperSet()->set($question, 'question');
-
$tester = new CommandTester($command);
$tester->execute([
'command' => $command->getName(),
- '--no-interaction' => true,
+ ], [
+ 'interactive' => false,
]);
$this->assertContains('Checking system requirements.', $tester->getDisplay());
$this->assertContains('Setting up database.', $tester->getDisplay());
$this->assertContains('Administration setup.', $tester->getDisplay());
$this->assertContains('Config setup.', $tester->getDisplay());
- $this->assertContains('Installing assets.', $tester->getDisplay());
+ $this->assertContains('Run migrations.', $tester->getDisplay());
}
}