const express = require('express');
const mysql = require('mysql');
const app = express()

const connection = mysql.createConnection({
	host: 'localhost',
	user: process.env.DBUSER,
	password: process.env.DBPASSWORD,
	database: 'new_trello'
});
connection.connect();

app.use(express.urlencoded({extended:false}));

const showItems = (req, res)=>{
	connection.query(`SELECT * FROM items`, (errors, results, fields)=>{
		res.render('show.ejs',{
			items:results
		})
	})
}

app.get('/', showItems);
app.post('/', (req, res)=>{
	connection.query(`INSERT INTO items (title, description) VALUES ('${req.body.title}', '${req.body.description}')`, (errors, results, fields)=>{
		res.redirect('/');
	})
})

app.listen(3003, ()=>{
	console.log('listening');
})