Mock Sql DB connection in Nodejs Unit test cases

Question

In My NodeJS Application, Connecting to Sql-DB using tedious, I want to unit test the microservices related to DB. During the unit test I don't want connect real database. But I am getting the error

Error: Unable to connect database: Error:'.connect cannot be called on a connection in SentLogin7WithStandardLogin state

Can you recommend any suggestions?

anangm182 · Accepted Answer · 2023-08-24 07:34:36Z

0

I recommend using sinon to mock/stub database connection. It works if you use ORM library or native databas library. I usually use stub method like this:

const sinon = require(‘sinon’);
const chai = require(‘chai’);

it(‘sentence for expected test’, () => {
   let stubDbConnection = sinon.stub(dbLib, ‘connectionMethod’);
   testedFunction();

   chai.expect(stubDbConnection.calledOnce).to.be.true;
});

Hope it helps you. Regards

answered Aug 24, 2023 at 7:34

anangm182

364 bronze badges

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

Collectives™ on Stack Overflow

Mock Sql DB connection in Nodejs Unit test cases

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