---

const express = require('express')
const mysql = require('mysql2')
const app = express()
app.use(express.json())

const db = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: '',
  database: 'carsdb'
})

db.connect()

// CREATE
app.post('/cars', (req, res) => {
  const { model_name, brand, manufacture_year, mileage } = req.body
  db.query(
    'INSERT INTO car_listings (model_name, brand, manufacture_year, mileage) VALUES (?, ?, ?, ?)',
    [model_name, brand, manufacture_year, mileage],
    (err, result) => {
      res.json({ id: result.insertId })
    }
  )
})

// READ
app.get('/cars', (req, res) => {
  db.query('SELECT * FROM car_listings', (err, rows) => {
    res.json(rows)
  })
})

// UPDATE
app.put('/cars/:id', (req, res) => {
  const { model_name, brand, manufacture_year, mileage } = req.body
  db.query(
    'UPDATE car_listings SET model_name=?, brand=?, manufacture_year=?, mileage=? WHERE id=?',
    [model_name, brand, manufacture_year, mileage, req.params.id],
    () => res.json({ message: 'Updated' })
  )
})

// DELETE
app.delete('/cars/:id', (req, res) => {
  db.query(
    'DELETE FROM car_listings WHERE id=?',
    [req.params.id],
    () => res.json({ message: 'Deleted' })
  )
})

app.listen(3000, () => console.log('Running on port 3000'))