* @copyright 2020 Akeneo SAS (http://www.akeneo.com) * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) */ abstract class SqlIntegrationTestCase extends KernelTestCase { protected ?MeasurementInstaller $fixturesLoader = null; protected ?Connection $connection = null; /** * {@inheritdoc} */ protected function setUp(): void { static::bootKernel(['debug' => false]); $this->fixturesLoader = $this->get('akeneo_measure.installer.measurement_installer'); $this->connection = $this->get('doctrine.dbal.default_connection'); $this->resetDB(); $this->fixturesLoader->createMeasurementTableAndStandardMeasurementFamilies(); } protected function get(string $service) { return self::getContainer()->get($service); } protected function resetDB(): void { $sql = <<connection->executeQuery($sql); } /** * {@inheritdoc} */ protected function tearDown(): void { $connectionCloser = $this->get('akeneo_integration_tests.doctrine.connection.connection_closer'); $connectionCloser->closeConnections(); $this->ensureKernelShutdown(); } }