database

//Database connection
"use strict";

var getConnection =  function () {
    var mysql = require('mysql');

    var connection = mysql.createConnection({
        host: 'localhost',
        port: 8889,
        user: 'howest',
        password: 'howest',
        database: 'noteapp'
    });

    connection.connect(function(err) {
        if (err) throw err;
    });

    return connection;
};

var db = {
    getUser: function(email){
        getConnection().query('SELECT password, iduser FROM user WHERE email = ?', email).on('result', function (row) {
            console.log(row);
            return row;
        })
    },

    getTodolistId: function (title) {
        getConnection().query('SELECT idtodolist FROM todolist WHERE title= ?', [title]).on('result', function (row) {
            return row.idtodolist;
        });
    },

    createTodolist: function(title, userId){
        getConnection().query('INSERT INTO todolist (title, idUser) VALUES (?, ?)', [title, userId], function (err, results) {
            if (err) throw err;
            return results.insertId;
        });
    },

    insertTodo: function (listid) {
        getConnection().query('INSERT INTO todoitem (idtodolist, text, date, complete) VALUES (?, ?, ?, ?)', [listid, req.body.new_note, req.body.date, false]).on('result', function () {
            return listid;
        })
    },

    getTodos: function(listid){
        getConnection().query('SELECT text, date, complete FROM todolist JOIN todoitem ON todolist.idtodolist = todoitem.idtodolist WHERE todolist.idtodolist = ?', [listid], function (err, results) {
            if (err) throw err;
            return results;
        });
    }
};

module.exports = db;