server.js

const express = require('express');
const morgan = require('morgan');
const path = require('path');
const app = express();
const bodyParser = require('body-parser');
const multer  = require('multer')
const upload = multer();

// leggere il file .env
require('dotenv').config()


const knex = require('knex')({
  client: 'mysql',
  connection: {
    host : process.env.DB_HOST,
    user : process.env.DB_USER,
    password : process.env.DB_PASS,
    database : process.env.DB_NAME
  }
});

const port = process.env.PORT || 5000;

// Setup logger
app.use(morgan(':remote-addr - :remote-user [:date[clf]] ":method :url HTTP/:http-version" :status :res[content-length] :response-time ms'));

// Parse "body" param in request
app.use(bodyParser.urlencoded({
  extended: true
}));
app.use(bodyParser.json());

// Serve static assets
app.use(express.static(path.resolve(__dirname, '..', 'build')));

// Always return the main index.html, so react-router render the route in the client
// app.get('*', (req, res) => {
//   res.sendFile(path.resolve(__dirname, '..', 'build', 'index.html'));
// });

app.get('/api/hello', (req, res) => {
  res.send({ express: 'Hello From Express' });
});

app.post('/api/login', upload.fields([]), (req, res) => {
  knex('users').select('id', 'name').where({
    email: req.body.email,
    password: req.body.password
  }).then(dati => {
    res.json(dati);
  })
});

app.post('/api/add-list', upload.fields([]), (req, res) => {
  knex('lists').insert(req.body).returning('id').then(result => {
    knex('lists').where('id', result[0])
    .then(list => res.json(list));
  });
});

app.post('/api/update-list', upload.fields([]), (req, res) => {
  console.log('req.', req.body);
  knex('lists').where({ id: req.body.id }).update({ name: req.body.name }, 'id').then(result => {
    knex('lists').where('id', req.body.id)
    .then(list => res.json(list));
  });
});

app.get('/api/lists', (req, res) => {
  knex('lists').where('userId', req.query.userId)
  .then(result => {res.json(result)})
})

app.delete('/api/deleteList', (req, res) => {
  knex('lists').where({
    userId: req.query.userId, 
    id: req.query.listId
  }).del().then( result => {
    res.send('success');
  })
});

app.post('/api/add-todo', upload.fields([]), (req, res) => {
  knex('item').insert(req.body).returning('id').then(result => {
    console.log('RESULT', result);
    knex('item').where('id', result[0])
    .then(todo => res.json(todo));
  });
});

app.get('/api/todos', (req, res) => {
  knex('item').where('listId', req.query.listId)
  .then(result => {res.json(result)})
})

app.delete('/api/deleteTodo', (req, res) => {
  knex('item').where({
    listId: req.query.listId, 
    id: req.query.todoId
  }).del().then( result => {
    res.send('success');
  })
});

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