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