// user.js
var bookshelf = require('./db');
var bcrypt = require('bcrypt-nodejs');

var user = bookshelf.Model.extend({
    tableName: 'users'
});

var validatePassword = function (username, password) {
    user.where('username', username).fetch().then(function (_user) {
        return bcrypt.compareSync(password, _user.get('password'));
    });
};

// exports
module.exports = {user: user};
module.exports.validatePassword = validatePassword;

///////////////////////////////////////////////////////////////////////////////////

// test.js
var user = require('./app/models/user');

console.log(user.validatePassword('newUserTest', 'passWord')); // returns undefined instead of true/false