pool.getConnection((connErr, connection) => {
if (connErr) {
reject(connErr);
} else {
connection.query({
sql: 'SELECT user_id,expired_at FROM `user_token` WHERE `token` = ?',
values: [hashToken(token)],
}, (err, results) => {
connection.release();
if (err) {
return reject(err);
}
if (results.length === 0) {
return resolve(null);
}
return resolve(results[0]);
});
}
});
pool.getConnection((connErr, connection) => {
if (connErr) {
reject(connErr);
} else {
const token = createToken({
id,
});
const expiredAt = getTokenTimestamp();
connection.query({
sql: `INSERT INTO user_token ${userTokenField} VALUES (?,?,FROM_UNIXTIME(?))`,
values: [hashToken(token), id, expiredAt],
}, (err) => {
connection.release();
if (err) {
return reject(err);
}
return resolve(token);
});
}
});