var getAllMeasureInfoByCod = function (measureCod, language) {
return sql.getPlainContext()
// Step 1 get Measure Info Description and Measure Unit
.step('measure', {query: sql.fromFile('./sql/getMeasureByCod'),
params: {
measureCod: {
type: sql.INT,
val: parseInt(measureCod)
},
language: {
type: sql.INT,
val: language
}
}
})
// Setp 2 - Get the Multiplier from another table
.step('multiplier', function (execute, data) {
execute({
query: sql.fromFile('./sql/getMultiplierByCod'),
params: {
measureCod: {
type: sql.INT,
val: parseInt(measureCod)
}
}
})
})
} // return a promise .then()
it( "should return the correct results", function( done ) {
var expectedResults = { name: "Neo", alias: "The One" };
sql.addFileMock( "./spec/userById", function( stepName, stepArg ) {
return expectedResults;
} );
sql.getPlainContext()
.step( "user", {
preparedSql: sql.fromFile( "./userById" ),
params: {
boardId: {
val: 1,
type: sql.INT
},
laneId: {
val: 2,
type: sql.INT
}
}
}
)
.end( function( sets ) {
expect( sets.user ).to.eql( expectedResults );
done();
} );
} );