stubing Database provider

[mortenko]

Once again !.

Im trying to write unit test for API endpoint rc/radars . I would like to stub db statement Database.raw() to not hit my DB. I read also documentation and found ioc.fake() but its not working for database provider.

I'm getting different errors based on what I'm actually trying... for example when I try to stub Database object with raw method I get raw is not defined on database object.

Is there any way how to stub/fake database provider to not hit database ? except wrapping sql execution into standalone method ?

const Database = use('Database');  // sinon.stub(Database, 'raw'); also do not work 
const sinon = require('sinon');

before(() => {
   sinon.stub(Database);
});

after(() => {
.....
});


test('should get list of all radars', async ({ assert, client }) => {
  try {

    const response = await client
      .get('rc/radars')
      .header('accept', 'application/json')
      .end();

    response.assertStatus(200);
  } catch (error) {
    console.log('error', error);
  }
});

 async getRadars({ request, response }) {
    try {
      const enterpriseId = request.enterpriseId;
      const radars = await this.getClientRadars(enterpriseId);
      console.log('radars', radars);
      if (radars.length !== 0) {
        const clientRadarsPromise = radars.map(
          async ({ radarId, radarName, visualization, radarDescription }) => {
            const { rows } = await Database.raw(SQL Statement);    // I NEED STUB THIS

            return {
               rows
            };
          }
        );
        const clientRadars = await Promise.all(clientRadarsPromise);
        return response.ok(clientRadars);
      }
      return response.ok([]);
    } catch (error) {
      Logger.error(
        'The following error occcured during retrieving radars data from DB:  %s',
        error.message
      );
      throw new DatabaseException(
        'Cant retrieve radars data for given client from DB'
      );
    }
  }

[thetutlage]

Stubbing Db is not something we promote. If you stub the DB, all you are testing is that your code invokes the right method and not the behavior.

Database is completely in your control, there are no side-effects of running the real query and hence stubbing is over engineering with negative benefits