var uuid = require('uuid');
var mysql = require('mysql');
var Chance = require('chance');
var chance = new Chance();


var mysqlConnection = mysql.createConnection({
        host:'localhost',
        user:'mifadir',
        password:'',
        database:'test'
});

var query_enc = 'select aes_encrypt(?, ?) as res;';

mysqlConnection.query(query_enc, ["محمد", 123], function(err, rows, fields){
    if(!err){
        console.dir(rows[0].res.toString());
        var query_dec = 'select aes_decrypt(?, ?) as res;';
        mysqlConnection.query(query_dec, [rows[0].res, 123], function(err, rows1, fields1){
            if(!err){
                console.dir(rows1[0].res.toString());
            }
        });
    }
});