Resetting the Database

Yo @jmwamser!

Hmm, I have no idea tbh. I've never used MSSQL, and I don't think the creator of Foundry has either, so it's quite possible that it's not coded correctly for that. You could try using https://github.com/dmaicher/doctrine-test-bundle instead to see if you have more luck.

Cheers!

Didn't have much luck there either. So i took a look at the old Testing Tutorial you guys had and was able to create a custom method to help me out. As well some of Foundries core methods.

protected function setUp(): void
    {
        parent::setUp();
        self::bootKernel();
        $this->truncateEntities();
        $this->runCommand(self::createApplication(), 'doctrine:migrations:migrate', ['-n' => true,'-e'=>self::$kernel->getEnvironment()]);
        self::ensureKernelShutdown();
    }
    
...

private function truncateEntities(): void
    {
        $entityManager = $this->getEntityManager();
        $connection = $entityManager->getConnection();
        $databasePlatform = $connection->getDatabasePlatform();
        $schemaManager = $databasePlatform->createSchemaManager($connection);

        foreach ($schemaManager->introspectSchema()->toDropSql($databasePlatform) as $dropSqlQuery) {
            $connection->executeQuery($dropSqlQuery);
        }

    }

...

private function runCommand(Application $application, string $command, array $parameters = [], bool $canFail = false): void
    {
        $exit = $application->run(
            new ArrayInput(\array_merge(['command' => $command], $parameters)),
            $output = new BufferedOutput()
        );

        if (0 !== $exit && !$canFail) {
            throw new \RuntimeException(\sprintf('Error running "%s": %s', $command, $output->fetch()));
        }
    }
    
private static function createApplication(): Application
    {
        if (!self::$booted) {
            self::bootKernel();
        }

        $application = new Application(self::$kernel);
        $application->setAutoExit(false);

        return $application;
    }    

I dug into the guts of DBAL to find this wonderful stuff as well.