var DBShowUsers = function(OrderBy, CallBack) {
    var mysql = require('mysql'), util = require('mysql-utilities');
    var con = mysql.createConnection({host: "localhost", user: "mti", password: "***", database: "db_mti"});

    con.connect();
    util.upgrade(con);
    util.introspection(con);

    con.select('users', '*', {}, OrderBy, CallBack);
    con.end();
};

try{
    var argv = process.argv, argc = argv.length, trim = require('trim'), com = "";

    for (var i=2; i<argc; i++) {
        argv[i] = trim(argv[i]);
        com += argv[i] + " ";
    }
    console.log(">> " + com);

    if (argc <= 2) { throw new Error("Пустой запрос"); }
    if (argv[2].toLowerCase() != "show") { throw new Error("Неверный запрос"); }

    var sort_field = argc >= 4 ? argv[3] : "", sort_dir = argc == 5 ? argv[4] : "", OrderBy = [], dir = "";

    if (sort_field.length > 0) {
        if (sort_field == "id" || sort_field == "name") {
            if (sort_dir.length > 0) {
                if (sort_dir == "asc" || sort_dir == "desc") {
                    dir = sort_dir;
                } else {
                    throw new Error("Неверное направление сортировки");
                }
            }

            OrderBy[sort_field] = dir;
        } else {
            throw new Error("Неверный параметр сортировки");
        }
    }

    DBShowUsers(OrderBy, function (err, rows) {
        if (err) { throw new Error(err); } else { console.log(rows); }
    });
} catch (err) {
    console.error(err);
}