NodeJS + PostgreSQL integration testing

Question

I would like to include Postgres interaction into my integration tests, i.e. not mock the database part, and I need help on figuring out the best way to do the test cleanup.

My setup is NodeJS, Postgres, Sequelize, Karma+Mocha. Currently, before running the tests a new database is created and migrated, after each test I run a raw query that truncates all the tables, and after all tests cases are finished the test database is dropped. As you probably guessed it, the execution time for running tests like this is pretty slow.

I was wondering if there is a way to speed the process up. Is there an in-memory psql database that I could use for my test cases (I've search for one for a while but couldn't find it), or something like that.

To be more precise, I'm looking for a way to clear the database after a test wrote something to it, in a way that does not require truncating all the tables after every test case.

It is taking too long for them to run (at least on my computer), and I only have a few of them for now. I'm worried that it will take forever for them to run once I've covered a decent amount of use cases and was wondering if there might be a better way. — Vedran
– Vedran, Commented Jul 1, 2019 at 19:50
Truncating even many tables shouldn't take more then a few milliseconds. At most "seconds" - maybe the truncate statement was waiting for locks — user330315
– user330315, Commented Jul 1, 2019 at 20:20

Vedran · Accepted Answer · 2019-07-02 11:16:13Z

3

Incorporated https://stackoverflow.com/a/12082038/2018521 into my cleanup:

afterEach(async () => {
  await db.sequelize.query(`
    DO
    $func$
    BEGIN
      EXECUTE
      (SELECT 'TRUNCATE TABLE ' || string_agg(oid::regclass::text, ', ') || ' RESTART IDENTITY CASCADE'
        FROM   pg_class
        WHERE  relkind = 'r'  -- only tables
        AND    relnamespace = 'public'::regnamespace
      );
    END
    $func$;
  `);
});

Truncate now runs almost instantly.

answered Jul 2, 2019 at 11:16

Vedran

1,1601 gold badge20 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

NodeJS + PostgreSQL integration testing

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related