var express  = require('express');
var app = express();
var port = process.env.PORT || 8080;
var Firebird = require('node-firebird');

var _Db = function(){
    //métodos privados
    var connect = function () {
        var options = {
            host: '127.0.0.1',
            port: 3050,
            database: 'C:\\Setydeias\\Setyware\\ADM77777\\ADM77777.gdb',
            user: 'SYSDBA',
            password: 'masterkey'
        };
        return options;
    };
    //métodos públicos
    return {
        execute: function(query) {
            Firebird.attach(connect(), function(err, db) {
                if (err) throw err;

                db.query(query, function(err, result) {
                    db.detach();
                    return result;
                });
            });
        }
    };
};

app.get('/get', function(req, res){
    console.log(_Db());
    var consulta = _Db().execute('SELECT * FROM SACADOS');
    console.log(consulta);
    res.sendStatus(200);
});


app.listen(port, function(){
    console.log("Running at port " + port);
});