javascript - 加密解密后的节点mysql查询

Question

var crypto = require('crypto'); <-- standart
var mysql = require('mysql'); <-- standart

var decrypt = function (encryptedMessage) {
    var decryptor = crypto.createDecipheriv('aes-256-cbc','somepass', 'somevector');
    decryptor.setAutoPadding(false);
    return decryptor.update(encryptedMessage, 'hex', 'utf8') + decryptor.final('utf8');
};

var dec = decrypt(someencryptedmessage);
console.log(dec); <-- working as expected
connection.query("UPDATE table SET some_column = 1 WHERE id = '" + dec + "'");
//Query sent like this UPDATE table SET some_column = 1 WHERE id = ''

所以我认为异步竞争或其他方面的问题。我怎样才能解决这个问题 ？谢谢。

Answer 1

我发现了问题。字符串中有隐藏的特殊字符。我添加了这个，现在一切正常。

var dec = decrypt(someencryptedmessage).replace(/[^a-zA-Z0-9 ]/g, "");