Clearing the Database

Somehow for me the url key was not working, as I got the following errors:

[Doctrine\ORM\Tools\ToolsException]
Schema-Tool failed with Error 'An exception occurred in driver: SQLSTATE[HY000] [14] unable to open database file' while executing DDL: CREATE TABLE dinosaurs (id INTEGER NOT NULL, encl
osure_id INTEGER DEFAULT NULL, length INTEGER NOT NULL, genus VARCHAR(255) NOT NULL, is_carnivorous BOOLEAN NOT NULL, PRIMARY KEY(id), CONSTRAINT FK_B1DE6E91D04FE1E5 FOREIGN KEY (enclos
ure_id) REFERENCES enclosure (id) NOT DEFERRABLE INITIALLY IMMEDIATE)

[Doctrine\DBAL\Exception\ConnectionException]
An exception occurred in driver: SQLSTATE[HY000] [14] unable to open database file

[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[HY000] [14] unable to open database file

[PDOException]
SQLSTATE[HY000] [14] unable to open database file

In the end I resolved it by replacing the url key by path, and removing the sqlite:// part. As in:

doctrine:
  dbal:
    driver: pdo_sqlite
    path: '%kernel.project_dir%/var/data/test.sqlite'

That did the trick for me.

I use Symfony 5 with php 8.1 and having problems to use the ORMPurger.

in the moment i call $puger->purge() i got a null reference error.

has there anything changed what is is not listed?

class MyIntegrationTest extends KernelTest 
{
    public function setUp() {
       self::bootKernel();

       $purger = new ORMPurger();
       $purger->purge();
    }
}

<blockquote>Error : Call to a member function getMetadataFactory() on null</blockquote>

What changes do I have to make incase I'm using PostGRE SQL.

What do you say to the argument that one doesn't need to test against the database, since it such tests you're basically just testing that the entity manager works (which you can safely assume without needing to test it). Instead, you should mock the EM and write unit tests. It's not a position I'm advocating, but I can't think of a good response to it.

If you get "[Doctrine\DBAL\Exception\DriverException] An exception occurred in driver: could not find driver", simply uncomment extension=pdo_sqlite in php.ini in your php installation folder (by deleting ";").

I have a question about testing APIs. Say I have a Symfony 5 app, which serves a number of endpoints. I want to test that when I hit endpoint `cats/x/fleas` I get a list of fleas for cat number x. So in my test, i:

1. Create a cat, persist it to the db, and get its ID (e.g. 5).
2. Use HTTPClient to hit `https://localhost/cats/5/fleas`.

My problem is, in step 1 I am using my test database, i.e. in my `test` environment. When I hit the endpoint with my HTTPClient, I am hitting the `dev` environment (which uses a different, `dev`, database). So it can't find the cat I created in the test database. One way to solve this is to set my local dev environment to `test`. But that's not ideal. Any ideas how to get around this? Thanks!