68 lines
2.3 KiB
JavaScript
68 lines
2.3 KiB
JavaScript
|
|
const connection = require('../conf/connection.js');;
|
|
const express = require('express');
|
|
const fileUpload = require('express-fileupload');
|
|
var path = require('path');
|
|
const nodemailer = require("nodemailer");
|
|
const fs = require("fs");
|
|
const { commit } = require('../conf/connection.js');
|
|
var app = express()
|
|
app.use(fileUpload());
|
|
|
|
|
|
function query(consulta) {
|
|
return new Promise(function(resolve, reject) {
|
|
connection.query(`${consulta}`, (error, results, files) => {
|
|
if (error) reject(error);
|
|
resolve(results);
|
|
});
|
|
})
|
|
|
|
}
|
|
|
|
app.post('/eliminarLibro', async(req, res) => {
|
|
|
|
let data = req.body;
|
|
|
|
try{
|
|
let sqlSelectImage = `SELECT ruta from Imagen where idLibro = ${data.idLibro};`;
|
|
let imageName = await query(sqlSelectImage);
|
|
let sqlSelectVizualizacion= `SELECT ruta from Visualizacion where idLibro = ${data.idLibro};`;
|
|
let vizualizacionName = await query(sqlSelectVizualizacion);
|
|
|
|
let sqlDeleteStrign = `DELETE FROM PdfLibro where idLibro=${data.idLibro};`;
|
|
await query(sqlDeleteStrign);
|
|
sqlDeleteStrign = `DELETE FROM Imagen where idLibro=${data.idLibro};`;
|
|
await query(sqlDeleteStrign);
|
|
sqlDeleteStrign = `DELETE FROM Visualizacion where idLibro=${data.idLibro};`;
|
|
await query(sqlDeleteStrign);
|
|
sqlDeleteStrign = `DELETE FROM Libro where idLibro=${data.idLibro};`;
|
|
await query(sqlDeleteStrign);
|
|
let rutaVizualizavcion = path.join('.', `/routes/pdf/${vizualizacionName}`);
|
|
try{
|
|
vizualizacionName = vizualizacionName[0].ruta;
|
|
fs.unlinkSync(rutaVizualizavcion);
|
|
}
|
|
catch(error){
|
|
console.log(error);
|
|
}
|
|
let rutaImage = path.join('.', `/routes/imagenLibro/${imageName}`);
|
|
try{
|
|
imageName = imageName[0].ruta;
|
|
fs.unlinkSync(rutaImage);
|
|
}
|
|
catch(error){
|
|
console.log(error);
|
|
}
|
|
res.status(200).json({error: false, msj: 'Imagen Eliminada con exito'});
|
|
return;
|
|
}
|
|
catch(error){
|
|
console.log(`Este es el error : ${error}`);
|
|
res.status(400).json({error: true, msj: 'No se pudo eliminar la libro', desc: error});
|
|
return;
|
|
}
|
|
|
|
});
|
|
module.exports = app
|