在 typescript 中获取 exists 查询的结果

typescript 中获取 exists 查询的结果"/>

在 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)
})()