let router = require('express').Router();
let sql = require('mysql');

let connection = sql.createConnection({
    user: 'root',
    password: 'root',
    server: 'localhost',
    database: 'testdb'
});
connection.connect((err) => {
    if (err) throw err;
    console.log('Connected to database.')
})
router.get('/', (req, res) => {
    res.json({
        message: 'Welcome to the sshezi REST API'
    })
});
router.post('/savename', (req, res) => {
    let username = req.body.username;
    let email = req.body.email;
    connection.query("INSERT INTO `names` (id, username, email) (NULL, ?, ?)", username.toString(), email.toString(), (err, result) => {
        if (err) throw err;
        console.log('Entry added to Table names.');
    });
});
router.get('/getnames', (req, res) => {
    res.json(['Bob', 'Willy', 'Marcel', 'George', 'Brutus']);
    console.log('Sent usernames.');
});

module.exports = router;
/////////////////////////////
'use strict';
var express = require("express");
let apiRoutes = require('./api-routes');

var app = express();
app.use('/api', apiRoutes);
app.listen(4200, () => {
    console.log('Server running port 4200.');
});