server.js

const express = require('express');
const bodyParser = require('body-parser');
const app = express();
const port = process.env.PORT || 4800;
const fs = require('fs');


app.use(bodyParser.json());
app.use(bodyParser.urlencoded({extended:true}));

const data = fs.readFileSync('./database.json');
const conf = JSON.parse(data);
const mysql = require('mysql');

const connection = mysql.createConnection({
    host: conf.host,
    user: conf.user,
    password: conf.password,
    port: conf.port,
    database: conf.database
});

connection.connect();

const multer = require('multer');
const upload = multer({dest: './upload'})


app.get('/api/movies',(req, res) =>{
    connection.query(
        "SELECT * FROM MOVIE WHERE isDeleted =0",
        (err,rows,fields) => {
            res.send(rows);
        }
    );
});

app.use('/image',express.static('./upload'));
app.post('/api/movies', upload.single('image'),(req, res) => {
    let sql = 'INSERT INTO MOVIE VALUES(null, ?, ?, ?, ?, ?, now(), 0,"","")';
    let image = '/image/' + req.file.filename;
    let name = req.body.name;
    let day = req.body.day;
    let genre = req.body.genre;
    let age = req.body.age;
    let keyWord = req.body.keyWord;
    let keyWord2 = req.body.keyWord2;
    let params = [image, name, day, genre, age,keyWord,keyWord2]
    connection.query(sql,params,
        (err, rows, fields) => {
            res.send(rows)
        }
        );

});

app.delete('/api/movies/:id', (req,res)=>{
    let sql = 'UPDATE MOVIE SET isDeleted =1 WHERE id = ?';
    let params = [req.params.id];
    connection.query(sql,params,
        (err, rows, fields) => {
            res.send(rows)
        }
    )
});

app.listen(port, () => console.log(`Listening on port ${port}`));