fisu

var CensusQuery = require('dbgcensus').Query;
var query = new CensusQuery('character', 'ps2:v2', 'conchubair');
var mysql = require('mysql');
var j, i;
var connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: '',
    database: 'learning',
});
query.where('name.first_lower').equals('esdf');
query.hideFields(['currency', 'times', 'certs', 'daily_ribbon', 'profile_id', 'battlerank']);
//query.addResolve('profile');
query.get(function (error, data) {
    console.log(data);
    //console.log(data[0].character_id);
    //console.log(data[0].name.first);
    //console.log(data[0].name.first_lower);
    //console.log(data[0].faction_id);
    //console.log(data[0].head_id);
    //console.log(data[0].title_id);
    //console.log(data[0].battle_rank.percent_to_next);
    //console.log(data[0].battle_rank.value);
    connection.connect(function (err) {
        if (err) {
            console.error('error connecting: ' + err.stack);
            return;
        }

        console.log('connected as id ' + connection.threadId);
    });
    connection.query('INSERT INTO nacwrel (id, name_f, name_lower, faction_id, head_id, title_id, br_pc2next, br) VALUES (' + data[0].character_id + ', \'' + data[0].name.first + '\', \'' + data[0].name.first_lower + '\', ' + data[0].faction_id + ', ' + data[0].head_id + ', ' + data[0].title_id + ', ' + data[0].battle_rank.percent_to_next + ', ' + data[0].battle_rank.value + ')', function (err, result) {
        if (err) {
            return connection.rollback(function () {
                throw err;
            });
        }
        connection.commit(function (err) {
            if (err) {
                return connection.rollback(function () {
                    throw err;
                });
            }
            console.log('success!');
        });
    });
});