How to properly cleanup test database? about docs HOT 6 CLOSED

I do but in my experience it is not a great idea to test against a different database than the one you are running in production or trying to be smarter about bootstrapping a test database. If you are not happy with cleaning up and seeding it on every test run you can still make sure that each test cleans up its own data:

describe('\'users\' service', () => {
  it('registered the service', () => {
    const service = app.service('users');
    expect(service).toBeTruthy();
  });

  it('creates a user', async () => {
    const user = await app.service('users').create({
      email: '[email protected]',
      password: 'VerySecretP@assw0rd',
    });

    expect(user.password).not.toEqual('VerySecretP@assw0rd'');

    await app.service('users').remove(user._id);
  });
});

from docs.

This depends on the database. With NeDB yes, the most reliable way would be removing the data folder by adding shx rm -rf data/ to your test script.

from docs.

@daffl Yes I'm already doing that:

"clean": "shx rm -rf test/data/",
"jest": "npm run clean && NODE_ENV=test npm run seed && NODE_ENV=test jest --coverage --detectOpenHandles --forceExit"

But how am I supposed to deal with it when I have a single test to run?

npx jest test/services/users.test.ts 

It would be great to have something that "reset" the created data of each test.

This would be the NodeJS equivalent of this great PHP tool : https://packagist.org/packages/dama/doctrine-test-bundle

from docs.

This also why I have the npm run seed command to generate data before testing.

I would like to get rid of it and see each test load data independently and cleanup.

Linked to memory database would be the best.

Do you see my point of view?

from docs.

Yes, I will maybe do it. But this assume additional repetitive code to produce, I would like to find a more lazy way. 👍

from docs.

Imo, tests are the one place where repetitive code is ok. I've seen many a time when someone tried to be lazy and the test code became unmaintainable.

from docs.