const express = require('express');
const app = express();
const port = 3002;
const mysql = require('mysql');
const bodyParser = require('body-parser');
const cors = require('cors');

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

const connection = mysql.createConnection({
    host: "localhost",
    user :  'root',
    password :  '<My password>',
    database :  'sqlquests',
});

connection.connect();

app.get('/api/movies',  (req, res) => {
    connection.query('SELECT * FROM movie;', (err, rows, fields) => {
      if (err) throw err;
      res.status(200).send(rows)
    })
  })

app.get('/api/movies/names',  (req, res) => {
    connection.query('SELECT name FROM movie;', (err, rows, fields) => {
      if (err) throw err;
      res.status(200).send(rows)
    })
  })


app.listen(port, err => {
  if (err) throw err;
  console.log(`Server is listening on ${port}`);
});