我在下面的代码中遇到了一些问题。有没有人能帮我看看,告诉我发生了什么事?
const name = ["a", "b", "c"]
let query1 = ('SELECT name FROM table WHERE name = ? AND status IN ("Pending","Active") limit 1')
if (name instanceof Array) {
async function getNames() {
try {
name.forEach(async (name) => {
let newName = []
let rows = await promisePool.query(query1, name);
if (rows[0].length > 0) {
if (rows[0])
newName.push(rows[0][0].uid_name)
console.log(newName)
}
return (rows);
})
}
catch (err) {
console.log('ERROR => ' + err);
return err;
}
}
await getNames();
console.log(newName) returns (if row is found)
['a']
['b']如何将任何返回值推送到数组?desired output ['a','b'],这样我就可以将其与原始数组进行比较。
先谢谢你,乌辛
我对代码做了一些修改,但老实说,我仍然不是专家。
const name = ["a","b","c"]
let query1 = ('SELECT name FROM table WHERE name = ? AND status IN ("Pending","Active") limit 1')
if (name instanceof Array) {
async function getNames() {
try {
for(names of name) {
let rows = await promisePool.query(query1,[uid,challenge_type,names]);
return (rows);
}
}
catch (err) {
console.log('ERROR => ' + err);
return err;
}
}
let newVar = await getNames();
console.log(newVar[0])newVar只返回1行,其中应该有2个名称。
name.forEach(async (element) => {
let rows = await promisePool.query(query1,[uid,challenge_type,element]);
if (rows[0].length > 0) {
if (rows[0])
/* newName.push(rows[0][0].uid_name) */
console.log(rows[0])
return (rows);如果我使用forEach...Of,我可以在作用域内返回它,但是console.log (console.log)是未定义的
发布于 2021-08-06 00:17:29
是否有特定的原因使您循环遍历名称并按名称执行查询?如果您想要做的只是查看数组中的哪些名称已经存在于您的数据库中,那么您可以在一个查询中完成所有这些操作。类似于:
const names = ["a","b","c"];
const query = 'SELECT name FROM table WHERE name IN (?) AND status IN ("Pending","Active")';
const result = await promisePool.query(query, [names]);
console.log(result);https://stackoverflow.com/questions/68669316
复制相似问题