node.js & postgreSQL 初体验[二]

sunsir

局部代码：模拟一个小登录的测试！
刚开始的时候忘记这NODE.JS异步问题了，怎么测都不行！
后来一顿回调啊~ OK了~！  这种方法代码的可读性很差，嵌套太多了。等等吧
等过几天再研究一下 ，解决这异步的问题！~
index.js

var um = require('./modules/user-manager');
exports.index = function(req, res){
res.render('index', { title: 'Test Login DEMO' });
um.findUserByEmail('tom@gmail.com', function(user) {
if (user == null) {
console.log('no user');
} else {
console.log(user.email);
um.getMd5Password('x', function(password) {
console.log('userpassword', user.password);
console.log('input password', password);
if (user.password != password) {
console.log('password error');
} else {
console.log('OK');
}
});
}
});
};


./modules/user-manager

var pg = require('pg');
var conString = "postgres://postgres:password@localhost/test";  
var client = new pg.Client(conString);  
client.connect();

var userManager = {};
userManager.findUserByEmail = function(email, callback) {
var query = client.query('SELECT * FROM person WHERE email = $1', [email]);
query.on('row', function(row, result) {
result.addRow(row);
});
query.on('end', function(result) {
if (result.rowCount == 0) {
callback(null);
} else {
callback(result.rows[0]);
}
});
}

userManager.getMd5Password = function(password, callback) {
var query = client.query('SELECT md5($1) as p', [password]);
query.on('row', function(row, result) {
callback(row.p);
});
}
module.exports = userManager;