.then(function (result) {
			if (result.rows.length === 0) return Promise.reject('User Not Found');

			var promise = new Promise(function (resolve, reject) {
				var hash = result.rows[0].password_hash; 	
		      	bcrypt.compare(password, hash, function(err, res) {
		      		if (res) resolve(result.rows[0].id);
		      		else reject('Invalid password');
				});
		    });
			return promise
		}, function (err) {

users.create = function (username : string, email : string, password :string) {
	if (!validate(username, email, password)) return Promise.reject('invalid');
    
	
	return users.usernameExists(username).then(function (exists) {
        if (exists) throw new ex.UserException('That username is already taken!');
    }).then(function () {
        return users.emailExists(email)
    }).then(function (exists) {
        console.log(exists)
        if (exists) throw new ex.UserException('That email is already in use!');
    }).then(function () {
        return hashPassword(password)
    }).then(function (hash){
		return database.runFunction(
			'createuser', 
			[username, hash, email]
		);
	});
};

		.then(function (result) {
			if (result.rows.length === 0) return Promise.reject('User Not Found');
			else return result;
		});