NodeJS and Knex

// Writen by Tory on 9-8-2015

var mysql = require('mysql2');
var knex = require('knex')({
  client: 'mysql2',
  connection: {
    host     : '127.0.0.1',
    user     : 'root',
    //password : 'your_database_password', // CodeAnywhere doesn’t require a password for root
    database : 'nodejstest'
  }
});

knex('Persons').insert({
    PersonID: Math.floor((Math.random() * 100000) + 1),
    Lastname: 'Doe',
    Firstname: 'John',
    Address: '555 Test Ave',
    City: 'Test Ville'
})
.then(function(){
    return knex.select().from('Persons');
})
.then(function(data){
    console.log(data);
})
.catch(function(err){
    Console.log(err);
});