stub

gistfile1.js

        it('should execute MySQL SELECT with orderBy clause', function() {
            var JobManager = require('../../../app/managers/job').JobManager,
                tableName = 'dbName',
                criteria = { name: 'test' };

            var jobManager = new JobManager(mySQLMock, tableName);

            jobManager.find(criteria);

            expect(mySQLMock.select.calledOnce).to.equal(true);
            expect(mySQLMock.select.calledTwice).to.equal(false);
            expect(mySQLMock.select.calledWith('*')).to.equal(true);
            expect(mySQLMock.select.calledWith('no with this')).to.equal(false);

            expect(mySQLMock.from.calledOnce).to.equal(true);
            expect(mySQLMock.from.calledWith(tableName)).to.equal(true);

            expect(mySQLMock.where.calledOnce).to.equal(true);
            expect(mySQLMock.where.calledWith(criteria)).to.equal(true);

            expect(mySQLMock.orderBy.calledOnce).to.equal(false);
            expect(mySQLMock.limit.calledOnce).to.equal(false);
            expect(mySQLMock.offset.calledOnce).to.equal(false);
        });

mysql.js

'use strict';

var sinon = require('sinon');

/**
 * mySQLMock object for testing purpose only
 */
var mySQLMock = {};

mySQLMock.select = sinon.stub().returnsThis();
mySQLMock.from = sinon.stub().returnsThis();
mySQLMock.where = sinon.stub().returnsThis();
mySQLMock.orderBy = sinon.stub().returnsThis();
mySQLMock.limit = sinon.stub().returnsThis();
mySQLMock.offset = sinon.stub().returnsThis();
mySQLMock.update = sinon.stub().returnsThis();
mySQLMock.insert = sinon.stub().returnsThis();

module.exports = mySQLMock;