app.js

const express = require('express');
const { db } = require('./config/db-config');
const { dbService } = require('./config/db-config');
const dotenv = require('dotenv');
const app = express();
const cookie = require('cookie-parser');
const cors = require('cors');
// const { name } = require('ejs');
const PORT = process.env.PORT || 5000;
app.use('/js', express.static(__dirname + '/public/js'));
app.use('/css', express.static(__dirname + '/public/css'));
app.use(cookie());
app.use(cors());
app.use(express.urlencoded({ extended: false }));
app.use(express.json());
app.use('/', require('./controllers/pages'));
app.use('/api', require('./controllers/auth'));
app.use(require('./controllers/servers'));
app.set('view engine', 'ejs');
app.set('views', './views');
db.connect((err) => {
    if (err) throw err;
    console.log('Database connected');
});
app.listen(process.env.PORT, () => console.log(`Listening on port ${PORT}`));

// create
app.post('/insert', (request, response) => {
    console.log(request.body);
    const { name } = request.body;
    const dbS = dbService.getDbServiceInstance();

    const result = dbS.insertNewName(name);

    result
        .then(data => response.json({ data: data }))
        .catch(err => console.log(err));

});

// Create Read Function
app.get('/getAll', (request, response) => {
    console.log('Get');

    const dbS = dbService.getDbServiceInstance();
    const result = dbS.getAllData();

    result
        .then(data => response.json({ data: data }))
        .catch(err => console.log(err));

    //   response.json({ success: true  });
});

// update
app.patch('/update', (request, response) => { // :id ????
    // console.log(request.body);
    // console.log(request.headers);
    // console.log(`METHOD:${request.method}`);
    // console.log(`ID:${request.body.id}`);
    // console.log(`NAME:${request.body.name}`);
    const { id, name } = request.body;
    const dbS = dbService.getDbServiceInstance();

    const result = dbS.updateNameById(id, name);

    result
        .then(data => response.json({ success: data }))
        .catch(err => console.log(err));
});

// delete

app.delete('/delete/:id', (request, response) => {
    const { id } = request.params;
    const dbS = dbService.getDbServiceInstance();

    const result = dbS.deleteRowById(id);

    result
        .then(data => response.json({ success: data }))
        .catch(err => console.log(err));

    console.log(request.params);
});