connection.on('connect', function(err) {
if(err) {
console.log(err);
return;
}
var result = [];
var request = new Request(sql, function(err, rowCount) {
if (err) {
console.log(err);
}
callback(null, result[0].count);
});
request.on('row', function(columns) {
var obj = {};
columns.forEach(function(column) {
var key = column.metadata.colName;
obj[key] = column.value ? column.value : '';
});
result.push(obj);
});
connection.execSql(request);
}
return new Promise((resolve, reject) => {
var request = new Request('select * from dbo.ManageMent_ProductInfo', function(err, rowCount) {
if(err)
{
console.log(err);
return false;
}
//dbConn.idle = true;
console.log("ManageMent_ProductInfo: "+rowCount+" rows");
resolve();
});
request.on("row", function(columns){
//console.log(columns[0].metadata.colName+"="+columns[0].value);
//console.log(columns[1].metadata.colName+"="+columns[1].value);
//console.log(columns[2].metadata.colName+"="+columns[2].value);
//PI_Status
var PI_Status = parseInt(columns[6].value);
if(PI_Status == 1)
{
var product = new ProductInfo(columns[0].value, columns[1].value, columns[2].value);
ProductInfoList.push(product);
}
});
//dbConn.idle = false;
dbConn.connection.execSql(request);
});
return connect(function(err, connection){
if (err) return logError(err, connection, cb);
var request = new tedious.Request(sproc, function(err, rowCount, rows) {
if (err) return logError(err, connection, cb);
});
for (var i=0; i<params.length; i++) {
var param = params[i];
request.addParameter(param.name, param.type, param.value);
}
var currSetIndex = -1;
var currSet;
request.on('columnMetadata', function (columns) {
currSetIndex++;
currSet = sets[currSetIndex];
});
request.on('row', function (columns) {
var rowObj = {};
for(var i=0; i<columns.length; i++) {
rowObj[columns[i].metadata.colName] = columns[i].value;
}
return rowHandler(currSet, rowObj);
});
request.on('doneProc', function (rowCount, more, returnStatus, rows) {
getCloseConnectionCb(connection, cb)();
});
return connection.callProcedure(request);
});
function getListAccounts(Connection, successCall, failureCall){
var doc = [];
var sqlreq = new sqlReq("sp_TempAccount_GetAccounts", function(err, rowCount){
if(err) {
console.log("Retrieve All Data Error: " + err);
failureCall();
}
});
try {
Connection.callProcedure(sqlreq);
sqlreq.on('row', function(columns) {
var row = {};
columns.forEach(function(column) {
row[column.metadata.colName.toLowerCase()] = column.value;
});
doc.push(row);
});
sqlreq.on('doneProc', function(rowCount, more, returnStatus, rows) {
console.log("Row Count: " + rowCount);
console.log(more);
console.log("Return Status " + returnStatus);
console.log("Rows: " );
console.log(rows)
console.log(doc)
successCall(doc)
});
}
catch (err) {
failureCall()
}
}
return new Promise((resolve, reject) => {
var product = null;
//console.log("addProductRegionInfo:"+model+"_"+hw);
var sql = "select * from dbo.ManageMent_ProductInfo where PI_ModelName='"+model+"' AND PI_HWVersion='"+hw+"' AND PI_Status=1;";
var productRequest = new Request(sql, function(err, rowCount) {
if(err)
{
console.log(err);
return false;
}
//dbConn.idle = true;
//console.log("ManageMent_ProductInfo: "+rowCount+" rows");
resolve(product);
});
productRequest.on("row", function(columns){
//console.log(columns[0].metadata.colName+"="+columns[0].value);
product = new ProductInfo(columns[0].value, model, hw);
ProductInfoList.push(product);
});
//dbConn.idle = false;
dbConn.connection.execSql(productRequest);
});
self.pool.requestConnection(function(err, db) {
if (err)
return fn(err);
initConnection(db);
var r = new tedious.Request(
'SELECT s.' + self.sessColumnName + ' FROM ' + self.tableName + ' s WHERE s.' + self.sidColumnName + '=@sid AND s.' + self.expiresColumnName + '>=SYSUTCDATETIME()',
function(err, rowCount) {
debug.sql("Executed SELECT");
db.close();
if (err)
return fn(err);
if (!rowCount || rowCount!==1)
return fn();
}
);
r.on('row', function(columns) {
if (!columns || columns.length!==1)
return fn();
var v=columns[0].value;
debug.sql("Returning "+v);
return fn(null, JSON.parse(v));
});
r.addParameter('sid', tedious.TYPES.VarChar, sid);
debugSql(r);
db.execSql(r);
});
connection.on('connect', function(err) {
if(err) {
console.log(err)
} else {
statement = statement.toString()
request = new Request(statement, function(err, rowCount) {
if (err) {
console.log(err)
} else {
if(self.colToRow) {
next(rowsToObject(rows))
} else {
next(rowsToObjectLiteral(rows))
}
}
connection.close()
})
if(parameters && parameters.length) {
parameters.forEach(function(parameter){
request.addParameter(parameter.name, self.type_dict[parameter.type], parameter.value);
})
}
var rows = []
request.on('row', function(columns) {
rows.push(columns)
})
connection.execSql(request)
}
})
sumario: function (siape, mes, ano, callback) {
var str_mes = (mes < 10) ? '0' + mes : mes.toString();
var workingDays = 0;
var days = new Date(ano, mes, 0).getUTCDate();
for (var i = 1; i <= days; i++) {
var wd = new Date(ano, mes-1, i).getUTCDay();
//console.log('dia', i, wd);
if (wd != 0 && wd != 6)
workingDays++;
}
var sumario_sql = "select siape, nome, '01/" + str_mes + "/" + ano + " a " + days + "/" + str_mes + "/" + ano + "' as periodo, " + mssql_min_to_time('SUM(saldo_minutos)') + " as saldo, " + mssql_min_to_time2('SUM(minutos_trabalhados)') + " as horas_trabalhadas, " + mssql_min_to_time2("SUM(CASE WHEN " + mssql_weekday_from_str('bdata') + " > 1 AND " + mssql_weekday_from_str('bdata') + " < 7 THEN carga_horaria_minutos ELSE 0 END)") + " as carga_horaria from consulta_batidas where siape = '" + siape + "' and bdata like '%/" + str_mes + "/" + ano.toString() + "' group by siape, nome";
//console.log(sumario_sql);
var rows = [];
req = new tedious.Request(sumario_sql, function (err, count) {
if (err) return callback(err);
//console.log('req finish');
callback(null, rows[0]);
});
req.on('row', function (cols) {
var row = {};
for (var i = 0; i < cols.length; i++) {
row[cols[i].metadata.colName] = cols[i].value;
}
rows.push(row);
});
conn.execSql(req);
},
pontos: function (siape, mes, ano, callback) {
var rows = [];
var str_mes = (mes < 10) ? '0' + mes : mes.toString();
var sql = "select *, " + mssql_min_to_time('minutos_trabalhados') + " as horas_trabalhadas, " + mssql_min_to_time('saldo_minutos') + " as saldo from consulta_batidas where siape = '" + siape + "' and bdata like '%/" + str_mes + "/" + ano.toString() + "'";
//console.log(sql);
req = new tedious.Request(sql,
function (err, count) {
if (err) return callback(err);
//console.log('req finish');
callback(null, rows);
});
req.on('row', function (cols) {
var row = {};
for (var i = 0; i < cols.length; i++) {
row[cols[i].metadata.colName] = cols[i].value;
}
rows.push(row);
});
conn.execSql(req);
},
function executeStatement() {
request = new Request(queryString, function(err, rowCount, rows) {
node.log(rowCount + " rows returned");
if (err) {
setStatus(statusEnum.error);
node.error('Error: ' +JSON.stringify(err));
node.log('Error: ' +JSON.stringify(err));
}
});
var result = [];
var columnDetails= {};
request.on('row', function(columns) {
columns.forEach(function(column) {
if (column.value === null) {
node.log('NULL');
} else {
let columnName = column.metadata.colName;
columnDetails[columnName] = column.value;
}
});
result.push(columnDetails);
node.send(result);
setStatus(statusEnum.sent);
});
request.on('done', function(rowCount, more) {
node.log(rowCount + ' rows returned');
});
client.execSql(request);
}
departamento: function (dep, mes, ano, callback) {
var rows = [];
var str_mes = (mes < 10) ? '0' + mes : mes.toString();
var days = new Date(ano, mes, 0).getUTCDate();
var funcs_dep_filtro = "select f.n_folha from funcionarios f join departamentos d on f.departamento_id = d.id where upper(d.descricao) = upper('" + dep + "')";
var sumario_funcs_dep = "select siape, nome, '01/" + str_mes + "/" + ano + " a " + days + "/" + str_mes + "/" + ano + "' as periodo, " + mssql_min_to_time('SUM(saldo_minutos)') + " as saldo, " + mssql_min_to_time2('SUM(minutos_trabalhados)') + " as horas_trabalhadas, " + mssql_min_to_time2("SUM(CASE WHEN " + mssql_weekday_from_str('bdata') + " > 1 AND " + mssql_weekday_from_str('bdata') + " < 7 THEN carga_horaria_minutos ELSE 0 END)") + " as carga_horaria from consulta_batidas where siape in (" + funcs_dep_filtro + ") and bdata like '%/" + str_mes + "/" + ano.toString() + "' group by siape, nome";
var sql = sumario_funcs_dep;
req = new tedious.Request(sql, function (err, count) {
if (err) return callback(err);
//console.log('req finish');
callback(null, rows[0]);
});
req.on('row', function (cols) {
var row = {};
for (var i = 0; i < cols.length; i++) {
row[cols[i].metadata.colName] = cols[i].value;
}
rows.push(row);
});
conn.execSql(req);
},
function executeSetSessionStatement() {
// Specify the name of the predictive stored procedure
storedProcedureName = "sp_set_session_context";
request = new Request(storedProcedureName, function(err, rowCount) {
if (err) {
console.log(err);
} else {
// Invoke the query in the session context
executeQuery();
}
});
// The input values to the prediction are provided here:
request.addParameter('@key', TYPES.VarChar, 'LoginID');
request.addParameter('@value', TYPES.VarChar, config.loginID);
request.addParameter('@readonly', TYPES.Int, '1');
// Iterate over any received rows in the result
request.on('row', function(columns) {
console.log("Session login set")
columns.forEach(function(column) {
console.log(column.metadata.colName + " = " + column.value);
});
});
connection.callProcedure(request);
}
function executeSql(){
var request = new Request(p.sql,function(err,rowCount){
cnn.close();
if (!err){
res.json({status:true,result:{cols:cols,data:table}});
}else{
res.json({status:false,message:err});
}
});
var table =[];
var cols = []
request.on("columnMetadata",function(columns){
cols = columns;
})
request.on('row',function(columns){
var row ={};
columns.forEach(function(column){
//console.log(column);
row[column.metadata.colName] = column.value;
});
table.push(row);
});
request.on("done",function(rowCount,more,rows){
console.log(rowCount);
})
cnn.execSql(request);
}
async.eachSeries(queries, function(query, callback) {
var queryResult = {
columns: [],
rows: []
};
request = new Request(query, function(err){
if(err)
result.push(new Error(err));
else
result.push(queryResult);
return callback();
});
request.on('columnMetadata', function (columns) {
queryResult.columns = Object.keys(columns);
});
request.on('row', function (columns) {
var row = [];
for(var column in columns) row.push(columns[column].value);
queryResult.rows.push(row);
});
connection.execSql(request);
}, function() {
dbConnect.GetDbConnection(function (err, connection) {
if (err) {
return cb(err, null);
}
var sql = 'select max(ID) from cf_Operators where Id < 9999';
var request = new Request(sql, function (err, sqlResults) {
if (err) {
connection.close();
sql = null;
console.log(err);
return cb(err, null);
}
connection.close();
sql = null;
request = null;
return cb(null, data);
});
request.on('row', function (columns) {
var id = parseInt(columns[0].value,10);
id++;
var opCode = uuid.create().toString();
opCode = opCode.substring(0,10);
data = {
OperatorId: id.toString(),
SecCode: opCode.toUpperCase()
};
});
connection.execSql(request);
});
legendas: function (siape, mes, ano, callback) {
var rows = [];
var str_mes = (mes < 10) ? '0' + mes : mes.toString();
var pontos = []
pontos.push("select distinct substring(bentrada1, 2, LEN(bentrada1)) from consulta_batidas where siape = '" + siape + "' and bdata like '%/" + str_mes + "/" + ano.toString() + "'");
pontos.push("select distinct substring(bsaida1, 2, len(bsaida1)) from consulta_batidas where siape = '" + siape + "' and bdata like '%/" + str_mes + "/" + ano.toString() + "'");
pontos.push("select distinct substring(bentrada2, 2, LEN(bentrada2)) from consulta_batidas where siape = '" + siape + "' and bdata like '%/" + str_mes + "/" + ano.toString() + "'");
pontos.push("select distinct substring(bsaida2, 2, len(bsaida2)) from consulta_batidas where siape = '" + siape + "' and bdata like '%/" + str_mes + "/" + ano.toString() + "'");
var sql = "select substring(nome, 2, LEN(nome)) as nome, descricao from justificativas where substring(nome, 2, LEN(nome)) in (" + pontos.join(' UNION ') + ")";
//console.log(servidor);
req = new tedious.Request(sql,
function (err, count) {
if (err) return callback(err);
console.log('req finish');
callback(null, rows);
});
req.on('row', function (cols) {
var row = {};
for (var i = 0; i < cols.length; i++) {
row[cols[i].metadata.colName] = cols[i].value;
}
rows.push(row);
});
conn.execSql(req);
},
function Read(callback) {
console.log('Reading rows from the Table...');
// Read all rows from table
request = new Request(
'SELECT Id, Name, Location FROM TestSchema.Employees;',
function(err, rowCount, rows) {
if (err) {
callback(err);
} else {
console.log(rowCount + ' row(s) returned');
callback(null);
}
});
// Print the rows read
var result = ""; request.on('row', function(columns) {
columns.forEach(function(column) {
if (column.value === null) {
console.log('NULL');
} else {
result += column.value + " ";
}
});
console.log(result);
result = "";
});
// Execute SQL statement
connection.execSql(request);
}
connection.on('connect', function (err) {
var request = new tedious.Request(sql.GetBookDetails, function (err, rc, rows) {
if (err) {
console.log(err);
res.status(500).send("database error");
connection.close();
return;
}
if (!rc) {
res.status(404).send("book not found");
connection.close();
return;
}
var book = {
id: rows[0].ID.value,
title: rows[0].Title.value,
author: rows[0].Author.value,
authorId: rows[0].AuthorID.value,
nominations: []
};
book.nominations = rows.slice(1).map(function (row) {
return {
awardId: row.AwardID.value,
yearNominated: row.YearNominated.value,
isWinner: !!row.IsWinner.value
};
});
res.json(book);
connection.close();
});
request.addParameter("bookId", tedious.TYPES.Int, bookId);
connection.execSql(request);
});
self.pool.requestConnection(function(err, db) {
if (err)
return fn(err);
initConnection(db);
var r = new tedious.Request(
'SELECT @count=COUNT(*) FROM ' + self.tableName,
function(err, rowCount) {
debug.sql("Executed SELECT");
db.close();
if (err)
return fn(err);
if (!rowCount || rowCount!==1)
return fn();
}
);
r.on('returnValue', function(parameterName, value, metadata) {
if (!value)
return fn();
return fn(null, value);
});
request.addOutputParameter('count', tedious.TYPES.Int);
debugSql(r);
db.execSql(r);
});
connection.on('connect', function (err) {
var request = new tedious.Request(sql.GetAuthorDetails, function (err, rc, rows) {
if (err) {
console.log(err);
res.status(500).send("database error");
connection.close();
return;
}
if (!rc) {
res.status(404).send("author not found");
connection.close();
return;
}
var author = {
id: rows[0].ID.value,
name: rows[0].Name.value,
books: []
};
author.books = rows.slice(1).map(function (row) {
return {
id: row.ID.value,
title: row.Title.value
};
});
res.json(author);
connection.close();
});
request.addParameter("authorId", tedious.TYPES.Int, authorId);
connection.execSql(request);
});
function getData(Connection, id, successCall, failureCall){
var sqlreq = new sqlReq("sp_TempAccount_GetSingle", function(err, rowCount){
if(err) {
console.log("Retrieve Data Error: " + err);
failureCall();
}
});
try {
sqlreq.addParameter('account_ID', sqlType.VarChar, id);
Connection.callProcedure(sqlreq);
sqlreq.on('row', function(columns) {
var row = {};
columns.forEach(function(column) {
row[column.metadata.colName.toLowerCase()] = column.value;
});
console.log("Row : ");
console.log(row);
successCall(row)
});
}
catch (err) {
failureCall()
}
}
function selectMessagesFromDatabase(){
request = new Request(
"select * from webtext",
function(err, rowCount, rows) {
console.log(rows);
}
);
request.on('row', function(columns) {
columns.forEach(function(column) {
console.log(column.value);
sqlData = sqlData + " " + column.value ;
});
sqlData = sqlData + "\n";
});
request.on('done', function(rowCount, more) {
console.log(rowCount + ' rows returned');
self._response.end(sqlData);
sqlData = "";
});
connection.execSqlBatch(request);
}
pool.acquire(function (err, connection) {
assert(!err);
var command = 'DECLARE @jobName VARCHAR(68) = \'pool\' + CONVERT(VARCHAR(64),NEWID()), @jobId UNIQUEIDENTIFIER;' +
'EXECUTE msdb..sp_add_job @jobName, @owner_login_name=\'' + connectionConfig.userName + '\', @job_id=@jobId OUTPUT;' +
'EXECUTE msdb..sp_add_jobserver @job_id=@jobId;' +
'DECLARE @cmd VARCHAR(50);' +
'SELECT @cmd = \'kill \' + CONVERT(VARCHAR(10), @@SPID);' +
'EXECUTE msdb..sp_add_jobstep @job_id=@jobId, @step_name=\'Step1\', @command = @cmd, @database_name = \'' + connectionConfig.options.database + '\', @on_success_action = 3;' +
'DECLARE @deleteCommand VARCHAR(200);' +
'SET @deleteCommand = \'execute msdb..sp_delete_job @job_name=\'\'\'+@jobName+\'\'\'\';' +
'EXECUTE msdb..sp_add_jobstep @job_id=@jobId, @step_name=\'Step2\', @command = @deletecommand;' +
'EXECUTE msdb..sp_start_job @job_id=@jobId;' +
'WAITFOR DELAY \'01:00:00\';' +
'SELECT 42';
var request = new Request(command, function (err, rowCount) {
assert(err);
pool.drain(done);
});
request.on('row', function (columns) {
assert(false);
});
connection.execSql(request);
});
connection.on('connect', function (err) {
//if error return
if (err) {
result.error = err;
callback(result);
}
//setup the sql request
var request = new Request(sqlText, function (err, rowCount, rows) {
if (err) {
result.error = err;
}
else {
result.rowCount = rowCount;
result.data = rowsToJsonObjects(rows);
}
callback(result);
});
//add paramters
obj.parameters.forEach(function (parameter) {
request.addParameter(parameter.name, parameter.type, parameter.value);
});
request.on('done', function (rowCount, more, rows) {
if (err) {
result.error = err;
}
});
connection.execSql(request);
});
return new Promise((resolve, reject) => {
var regionList = [];
var PR_ID = "";
//console.log("addRegionInfo:"+region);
var sql = "select PR_ID from dbo.ManageMent_ProductRegion where PR_PI_ID='"+productObj.PI_ID+"' AND PR_Region='"+region+"' AND PR_Status=1;";
var regionRequest = new Request(sql, function(err, rowCount) {
if(err)
{
console.log(err);
return false;
}
//dbConn.idle = true;
//console.log("ManageMent_ProductRegion: "+rowCount+" rows");
var modelStr = productObj.PI_ModelName + "_" + productObj.PI_HWVersion;
queryList[modelStr] = productObj.PR;
resolve(PR_ID);
});
regionRequest.on("row", function(columns){
//console.log(columns[0].metadata.colName+"="+columns[0].value);
PR_ID = columns[0].value;
var regionObj = new RegionInfo(PR_ID, productObj.PI_ID, region);
productObj.PR.push(regionObj);
});
//dbConn.idle = false;
dbConn.connection.execSql(regionRequest);
});
function AddSlStyle(connection, operatorId, cb) {
var sql = 'insert into sl_style( operatorId, style_id, style_desc, cabinet, width, depth, height, readitonly, defaultrec,' +
'status, updated) values(@oper, \'1\', \'UNDEFINED\', \'UNDEFINED\', 1,1,1,1,1,\'A\',getdate()) ' +
'insert into sl_style( operatorId, style_id, style_desc, cabinet, width, depth, height, readitonly, defaultrec,' +
'status, updated) values(@oper, \'Sitdown\', \'Sitdown\', \'Sitdown\', 0,0,0,0,0,\'A\',getdate()) ' +
'insert into sl_style( operatorId, style_id, style_desc, cabinet, width, depth, height, readitonly, defaultrec,' +
'status, updated) values(@oper, \'Slanttop\', \'Slanttop\', \'Slanttop\', 0,0,0,0,0,\'A\',getdate()) ' +
'insert into sl_style( operatorId, style_id, style_desc, cabinet, width, depth, height, readitonly, defaultrec,' +
'status, updated) values(@oper, \'Upright\', \'Upright\', \'upright\', 1,1,1,1,1,\'A\',getdate())';
var request = new Request(sql, function (err, sqlResults) {
if (err) {
request = null;
sql = null;
return cb(err, null);
}
request = null;
sql = null;
return cb();
});
request.addParameter('oper', TYPES.Int, operatorId);
connection.execSql(request);
}
return new Promise((resolve, reject) => {
var RegionInfoList = [];
var request = new Request('select * from dbo.ManageMent_ProductRegion', function(err, rowCount) {
if(err)
{
console.log(err);
return false;
}
console.log("ManageMent_ProductRegion: "+rowCount+" rows");
resolve(RegionInfoList);
});
request.on("row", function(columns){
var rowData = "";
//console.log(columns[0].metadata.colName+"="+columns[0].value);
//console.log(columns[1].metadata.colName+"="+columns[1].value);
//console.log(columns[2].metadata.colName+"="+columns[2].value);
//PI_Status
var PR_Status = parseInt(columns[3].value);
if(PR_Status == 1)
{
var region = new RegionInfo(columns[0].value, columns[1].value, columns[2].value);
RegionInfoList.push(region);
}
});
dbConn.connection.execSql(request);
});
function AddCfTransTypes(connection, operatorId, cb) {
var sql = 'insert into cf_transtypes values (@operatorID,0,\'Bill Break\',10000,1) ' +
'insert into cf_transtypes values (@operatorID,1,\'Voucher Redemption\',50000,1) ' +
'insert into cf_transtypes values (@operatorID,2,\'ATM Withdrawl\',0,1) ' +
'insert into cf_transtypes values (@operatorID,3,\'RT Fill\',0,1) ' +
'insert into cf_transtypes values (@operatorID,4,\'RT Drop\',0,1) ' +
'insert into cf_transtypes values (@operatorID,5,\'Voucher Batch\',90000,1) ' +
'insert into cf_transtypes values (@operatorID,6,\'Cash Retrived\',0,1) ' +
'insert into cf_transtypes values (@operatorID,7,\'Test Cash Dispense\',0,1) ' +
'insert into cf_transtypes values (@operatorID,8,\'Test Coin Dispense\',0,1) ' +
'insert into cf_transtypes values (@operatorID,9,\'Change Drawer Draw\',0,1) ' +
'insert into cf_transtypes values (@operatorID,10,\'Manual Ticket Redemption\',0,1) ';
var request = new Request(sql, function (err, sqlResults) {
if (err) {
request = null;
sql = null;
return cb(err, null);
}
request = null;
sql = null;
return cb();
});
request.addParameter('operatorID', TYPES.Int, operatorId);
connection.execSql(request);
}
function executeStatement() {
request = new Request(queryString, function(err) {
if (err) {
setStatus(statusEnum.error);
node.error('Error: ' +JSON.stringify(err));
node.log('Error: ' +JSON.stringify(err));
}
});
var result = "";
request.on('row', function(columns) {
columns.forEach(function(column) {
if (column.value === null) {
node.log('NULL');
} else {
result += column.value + " | ";
}
});
node.log(result);
node.send(result);
setStatus(statusEnum.sent);
result ="";
});
request.on('done', function(rowCount, more) {
node.log(rowCount + ' rows returned');
});
client.execSql(request);
}
connection.on('connect', function(err) {
if(err) {
console.log(err);
return;
}
var result = [];
var request = new Request(sql, function(err, rowCount) {
if (err) {
console.log(err);
}
callback(null, result);
});
request.on('row', function(columns) {
var obj = {};
columns.forEach(function(column) {
var key = column.metadata.colName.toLowerCase();
var value = column.value;
if(value && underscore._.isDate(value)) {
obj[key] = util.utilDate.format(value, 'yyyy-MM-dd hh:mm:ss');
} else {
obj[key] = value ? value : '';
}
});
result.push(obj);
});
connection.execSql(request);
}