Best way to write unit test for Node Rest api while working with Postgres, chai and mocha?

Question

I am working on node js rest api in which database is Postgres and we are not using any ORM. How I am writing is as below which is hitting database for create and update

it('it should create customer', (done) => {
  const payload = {
    customerId: "test",
    customerName: "test",
    customerAddress: "Some place, NWZ"
  }
  chai
    .request(server)
    .post('/customer')
    .send(payload)
    .end((err, res) => {
      res.should.have.status(200);
      res.body.success.should.equal(true);
      done();
    });
});

Now I want to know that what is best way to write unit test cases ? Like

Should I write unit test cases by mocking api response excluding database query ?
Or should I write unit test case which will hit database ?

Or in any way we can mock database ? What is best way to do it ?

chygo · Accepted Answer · 2022-08-09 07:02:00Z

1

There is some debate regarding whether unit tests should hit database. But in general, I would say hitting a real database in testing should be categories as integration test, not unit test.

So for your question 2: I would say: no, you should not write unit test case that hit database.

Then for your question 1: yes, you should mocking api response, the library you could choose, e.g. sinon.

---- Updated ----

There is an article regarding the topic, if you are interested, please refer to the following: Hitting Real Database? Unit Test and Integration Test for RESTful API in Nodejs Environment

edited Aug 9, 2022 at 7:02

answered Aug 1, 2022 at 10:47

chygo

4762 gold badges7 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Best way to write unit test for Node Rest api while working with Postgres, chai and mocha?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related