findAllConsumers.js
1.08 KB
var findAllConsumers = function(callback, err) {
var qrySql =
"select COD_DAE, COD_DAE + 9000000 as novo_cod_dae, NOME from cadastro";
poolMsql.request().query(qrySql, function(err, recordsets) {
var pre_query = new Date().getTime();
if (err || recordsets.recordset.length === 0) {
console.log("Não realizou a querie: \n" + err);
return callback(null, err);
} else {
var post_query = new Date().getTime();
var duration = (post_query - pre_query) / 1000;
console.log("Tempo para executar a querie: " + duration);
var allConsumers = [];
recordsets.recordset.forEach(element => {
var valueToPush = {};
valueToPush.label = element.NOME + " - " + element.novo_cod_dae;
valueToPush.value = "" + element.novo_cod_dae;
allConsumers.push(valueToPush);
});
post_query = new Date().getTime();
duration = (post_query - pre_query) / 1000;
console.log("Tempo total para querie e criar vetor: " + duration);
return callback(allConsumers, undefined);
}
});
};
module.exports = findAllConsumers;