const express = require('express');
const app = express();
const port = 5020;

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

app.get('/api/movies', (req, res) => {
  connection.query('SELECT * FROM movie', (error, results) => {
    if(error){
      return res.status(500).send(`Unexpected error: ${error.message}`);
    }
    res.json(results);
  });
});

app.get('/api/movies/names', (req, res) => {
  connection.query('SELECT name FROM movie', (error, results) => {
    if(error){
      return res.status(500).send(`Unexpected error: ${error.message}`);
    }
    res.json(results);
  });
});

app.listen(port);