Express Database Function

database.js

var mysqlPackage = require("mysql");
var mysql = mysqlPackage.createConnection({
    host: "localhost",
    user: "root",
    password: "",
    database: "test"
});
mysql.connect(function (err) {
    err ? console.log(err) : false;
});

// Properties
mysql.lastId = mysql.query("SELECT LAST_INSERT_ID()");

// Methods
mysql.filter = function (data) {
    var obj = {fields: [], values: []}; // {fields: ["f1","f2","f3"], values: ["v1"."v2","v3"]}
    for (var i in data) {
        //data[i] = mysql.escape(data[i]);
        obj.fields.push(i);
        obj.values.push(data[i]);
    }
    return obj;
}

mysql.insert = function (tableName, data) {
    var q = "INSERT INTO ? (??) VALUES (??)";
    data = mysql.filter(data);
    //console.log(data);
    mysql.query(q, [tableName, data.fields, data.values], function(err){
        console.log(err);
    });
}


module.exports = mysql;