server.js

const express = require('express');
const server = express();
const PORT = 3000;

const cookie = require('js-cookie');
const sha256 = require('js-sha256');
const sql = require('mysql');


const pug = require("pug");
const path = require('path');
//set-up
server.set('view engine', 'pug');
server.use(express.json()); // JSON

//SQL

var con = sql.createConnection({
    host: 'localhost',
    user: 'root',
    password: '',
    database: 'mysql'
});

con.connect((err) => {
    if(err) throw err;
    console.log('sql->success');
});



// GETS
// index
server.get('/', (req, res) => {
    res.render('index');                    // INDEX
});

// events
server.get('/events', (req, res) => {
    res.render('construction.pug');         // CLOSED
});

// cake-type
server.get('/cake-type', (req, res) => {
    res.render('construction.pug');         // CLOSED
});

// shopping
server.get('/shopping', (req, res) => {
    res.render('construction.pug');         // CLOSED
});

// login
server.get('/login', (req, res) => {
    res.render('login.pug');                // OPEN
});

// register
server.get('/register', (req, res) => {
    res.render('register.pug');             // OPEN
});

// cart
server.get('/cart', (req, res) => {
    res.render('construction.pug');         // CLOSED
});

// settings
server.get('/settings', (req, res) => {
    res.render('settings.pug');         // OPEN
});


// API
const r = '/api';

// login
server.post(r + '/login', (req, res) => {
    const obj = req.body;

    const email = obj.email;
    const password = sha256(obj.password);

    console.log(email);
    console.log(password);
    console.log();

    res.send('success');
});

// register
server.post(r + '/register', (req, res) => {
    const obj = req.body;

    const email = obj.email;
    const password = sha256(obj.password);

    // <sql>
    const payload = `VALUES ("${email}", "${password}")`;
    
    const json = {
        success: "",
        email: "",
        password: "",
        exists: ""
    };
    
    let exists = false
    const sCheck = `SELECT email FROM user_logins WHERE email = "${email}"`;
    con.query(sCheck, (err, result) => {
        if(result.length === 0){
            exists = false;

            if (exists === false) {
                const sql = 'INSERT INTO user_logins (email, password)' + payload;
                con.query(sql, (err, result) => {
                    if(err){ 
                        json.success = 'false';
                        res.json(json);
                    } else {
                        json.success = 'true';
                        res.json(json);
                    }
                   
                });
            }

        } else {
            exists = true;
        }

        json.success = exists ? 'false' : 'true';
        json.email = email;
        json.password = password;
        json.exists = exists ? 'true' : 'false';
        
        res.json(json);

    });

    // </sql>
    
});





// Run server
// 404 - NEEDS TO BE LAST ROUTE
server.get('*', (req, res) => {
    res.render('404.pug');
});

server.listen(PORT, () => {
    console.log(`server running on http://localhost:${PORT}/`);
});