async query(query, values) { const conn = await this.getConnectionFromPool(); try { const res = await conn.execute(query, values || {}); return res && res.rows; } catch (e) { throw (e); } }
return result.rows }) .catch(function(err) {
} else console.log("Outside for -"+JSON.stringify(result.rows)); for (var i=0; i<result.rows.length;i++) console.log("Inside For -"+result.rows[i].ENAME_ENC); if((result.rows[i].ENAME_ENC)!=null) CiphertextBlob: Buffer(result.rows[i].ENAME_ENC, 'base64') }; kms.decrypt(encdata,function (err, data) result.rows[i].ENAME_ENC=DEC_ENAME_ENC; console.log(DEC_ENAME_ENC +" ---"+result.rows[i].ENAME_ENC); res.send(JSON.stringify(result.rows));
if (err || result.rows.length < 1) if((result.rows[0].ENAME_ENC)!=null) CiphertextBlob: Buffer(result.rows[0].ENAME_ENC, 'base64') }; kms.decrypt(encdata,function (err, data) { result.rows[0].ENAME_ENC=DEC_ENAME_ENC; res.contentType('application/json').status(200).send(JSON.stringify(result.rows)); res.contentType('application/json').status(200).send(JSON.stringify(result.rows));
type: "success", msg: "Conexão Efetuada com sucesso!!! :)", data: result.rows[0].DATA, title: "Status da Conexão" });