在 typescript 中获取 exists 查询的结果
我正在尝试使用打字稿获取现有查询的结果,但我无法获取查询返回的对象的“1”或“0”。
code.ts
const rslt1 = query(`SELECT EXISTS(SELECT * FROM patients WHERE cc=?)`, [paramsInput]);
const rslt2 = query(`SELECT EXISTS(SELECT * FROM doctors WHERE specialty=?)`, [params.specialtyInput]);
(async () => {
const frslt1:object = await rslt1
console.log(frslt1, Object.values(frslt1))
console.log(await rslt2)
})()
在控制台中我得到这个:
[{ "EXISTS(SELECT * FROM patients WHERE cc='6465465465')": 0 } ] [ { "EXISTS(SELECT * FROM patients WHERE cc='6465465465')": 0 } ]
[{ "EXISTS(SELECT * FROM doctors WHERE specialty='Medicina general')": 1 } ]
我需要查询的结果来做 if later
回答如下:我认为您应该尝试将
query
调用直接放入您的异步函数中。
试试
(async () => {
const rslt1 = await query(`SELECT EXISTS(SELECT * FROM patients WHERE cc=?)`, [paramsInput]);
const rslt2 = await query(`SELECT EXISTS(SELECT * FROM doctors WHERE specialty=?)`, [params.specialtyInput]);
const frslt1: object = rslt1
console.log(frslt1, Object.values(frslt1))
console.log(rslt2)
})()