var fs = require('fs'),
  express = require('express');

var app = module.exports = express.createServer();


app.configure(function() {
  app.use(express.bodyParser())
     .use(express.cookieParser())
     .use(app.router)
     .use(express.errorHandler({showStack: true, formatUrl: 'txmt'}));
});

dom = require('express-jsdom')(app)
  .use({css: './assets/default.styl'});

dom.get('/mysql', 'jquery', function($) {
    var mysql = require('mysql');
    var client = new mysql.Client();

    client.host = '172.16.1.57';
    client.user = 'user';
    client.database = 'db';
    client.password = 'password';

    //client.connect();

    var htmlString = '';

    client.query('select user_sid, nick_name from mob_user_info limit ?, ?', [2, 2], this.res.defer(function(err, results, fields){
        if(err) throw err;
        //console.log(results);
        //console.log(err);
        //console.log(fields);

        for(var i in results) {
            var data = JSON.stringify(results);
            htmlString += 'user_sid:' + results[i].user_sid + ', nick_name:' + results[i].nick_name + '<br/>';
        }
        //client.end();
        console.log(htmlString);
        $('body').append('<h1>' + htmlString + '</h1>');
    }));
});

if (!module.parent) {
  app.listen(8081);
}