Testing with a Postgres database

Questions and Answers Database-SQL
1
System Information
  • Strapi Version: Latest
  • Operating System: Windows
  • Database: Postgres

I’ve been setting up testing with a postgres database ( I would use sqlite, however Windows has issues with this as mentioned in the docs ). I’m using Jest, and have followed the instructions in the docs.
Everything is working well, however I don’t know how to ‘clear’ the database after the tests have run. I’m not a database expert, so would appreciate being pointed in the right direction. Something like drop all tables would be sufficient I think.

I have this in my Jest app.test.js file:

afterAll(async (done) => {
  // I'm assuming that Knex would be used
  const knex = strapi.connections.default; 

  //delete test database after all tests
  knex.raw( ' some sort of empty database query ' )

  done();
});

I appreciate any help that you can provide. Thanks.

2

Hi wondering if anyone can help with this - it is a pain to manually drop tables after running tests.

3

Hey @MCT,

You can do it like this in your afterAll function:

afterAll(async (done) => {
  await strapi.connections.default.raw(`DELETE FROM categories;`);
  done();
});

That’s how I prefer to do it. But you can also use the service for that:

await strapi.services['category'].delete({ id:category.id });

1 Like
4

I would like to know how did you setup Postgres as test db :slight_smile: ,that’s what brought me here!

1 Like
5

You might also setup your tests like this:

./tests/helpers/close-database.js

const closeDatabase = async () => {
  const { filename } = strapi.config.get(
    'database.connections.default.settings'
  );
  if (filename) {
    const tmpDbFile = path.join(__dirname, '..', '..', filename);
    await strapi.db.destroy();
    if (fs.existsSync(tmpDbFile)) {
      fs.unlinkSync(tmpDbFile);
    }
  }
};

./tests/helpers/strapi-setup.js

const Strapi = require('strapi');
const http = require('http');

let instance;
async function setupStrapi() {
  if (!instance) {
    /** the following code in copied from `./node_modules/strapi/lib/Strapi.js` */
    await Strapi().load();
    instance = strapi; // strapi is global now
    await instance.app
      .use(instance.router.routes()) // populate KOA routes
      .use(instance.router.allowedMethods()); // populate KOA methods

    instance.server = http.createServer(instance.app.callback());
  }
  return instance;
}

./tests/app.spec.js

const { setupStrapi, closeDatabase } = require('./helpers'); // you might also add jest.setTimeout(newTimeout) if needed in this file.

// 1. unit under test
describe('Global Strapi', () => {
  /** this code is called once before any test is called */
  beforeAll(async () => {
    await setupStrapi(); // singleton so it can be called many times
  });

  /** this code is called once before all the tested are finished */
  afterAll(async () => {
    await closeDatabase();
  });
  // 2. scenario and 3. expectation
  test('When setting up properly strapi should be defined', () => {
    expect(strapi).toBeDefined();
  });
});

This allows you to use sqlite for jest testing with windows. Problem was, strapi does not close the connections by default, so you have to close the strapi db connection before you unlink the .tmp/test.db file.

Hope it helps.

6

This is not for a postgres db. You need to read the question.