javascript - Sequelize : Use query results as table for selectQuery

Question

是否可以将查询结果用作sequelize 查询生成器中另一个选择的表？这是我试图生成的 SQL:

UPDATE target 
SET fk1_id = '1' 
WHERE id NOT IN
    (SELECT id
    FROM (
        SELECT id
        FROM target
        WHERE fk1_id = 1 AND fk2_id = 2
         ) AS inner_target )
    AND fk1_id IS NULL AND fk2_id = '2' LIMIT 1

我正在尝试通过以下方式实现这一目标:

const innerSelect = 
sequelize.dialect.QueryGenerator.selectQuery('target', {
            attributes: ['fk1_id'],
            where: {
                fk1_id: fk1_id,
                fk2_id: fk2_id,
            },
        }).slice(0, -1);

const selectAs = sequelize.dialect.QueryGenerator.selectQuery(
    sequelize.literal(`${innerSelect}`), {
            attributes: ['id'],
        }).slice(0, -1);

但是，我收到一条错误消息:

"message": "Table 'db.undefined' doesn't exist"
"name": "SequelizeDatabaseError"
"code": "ER_NO_SUCH_TABLE"

并且内部选择试图从未定义

中进行选择

如有任何建议，我们将不胜感激!

Answer 1

根据该错误，您尚未创建正在查询的表。