47 lines
1.3 KiB
JavaScript
47 lines
1.3 KiB
JavaScript
const connection = require('../conf/connection.js');
|
|
const express = require('express');
|
|
const nodemailer = require("nodemailer");
|
|
var app = express()
|
|
|
|
|
|
function query(consulta) {
|
|
return new Promise(function(resolve, reject) {
|
|
connection.query(`${consulta}`, (error, results, files) => {
|
|
if (error){
|
|
reject(error);
|
|
}
|
|
resolve(results);
|
|
});
|
|
})
|
|
}
|
|
|
|
|
|
app.get('/getPersona', async(req, res) => {
|
|
|
|
try{
|
|
console.log(`Entro a registtro`);
|
|
|
|
let sqlString = `SELECT eq.*, eq.nombre as nombreEquipo, per.* FROM Equipo as eq INNER JOIN Persona as per Where eq.idEquipo=per.idEquipo ORDER BY nombreEquipo asc`;
|
|
let sqlAnswer = await query(sqlString);
|
|
console.log(sqlAnswer);
|
|
for(let row in sqlAnswer)
|
|
console.log(`aaa ${sqlAnswer[row].fechaRegistro}`);
|
|
|
|
res.status(200).json({error: false, mjs: 'Exito', data: sqlAnswer});
|
|
return;
|
|
}
|
|
catch(error){
|
|
|
|
let men = `Errror al traer los datos de la base ${error}`;
|
|
console.log(men);
|
|
res.status(400).json({ error: true, msj: men, desc: error });
|
|
return;
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
});
|
|
|
|
module.exports = app |