sequelize.js - SequelizeDatabaseError : ER_BAD_FIELD_ERROR: Unknown column 'models.[object Object]' in 'where clause'

Question

想要计算 updatedAt 列，然后将其与 where 子句中的当前日期进行比较

const query = {
        where: {
            [sequalize.fn('ADDDATE', sequalize.col('updatedAt'), 5)]:
            {
                $lt: sequalize.fn('NOW'),
            },
        },
        force: true,
    };

错误: SequelizeDatabaseError: ER_BAD_FIELD_ERROR: Unknown column 'models.[object Object]' in 'where clause'

Answer 1

首先将 sequalize 更改为 sequelize :)

其次，您的 where 查询应如下所示:

where: sequelize.where(
        sequelize.fn('ADDDATE', sequelize.col('updatedAt'), 5),
        {
            $lt: sequelize.fn('NOW')
        }
    )