Teacher.js

var app = require('./app');
var connection = require('./DBconnection');
var mysql = require('mysql');
//var dateformat = require('dateformat');
// ""
module.exports = {
    addEvent: function(email, name, description, start_day, start_month, start_year, end_day, end_month, end_year, course)
    {
        return new Promise(function (resolve, reject) {
            var event_values = [[email, name, description, start_day, start_month, start_year, end_day, end_month, end_year, course]];
            connection.query('INSERT INTO events(teacher_email, name, description, start_day, start_month, start_year, end_day, end_month, end_year, course) VALUES ?', [event_values], function (err, result, field) {
                if (err) {
                    if (err.code == 'ER_DUP_ENTRY') {
                        reject(1);
                    }
                    else
                        throw err;
                }
                resolve(-1);
            });
        });
    }
};