Sequelize 如何查找具有多个 where 子句和时间戳的行 >现在() [英] Sequelize how to find rows with multiple where clauses and timestamp > NOW()

问题描述

如何使用 Sequelize 执行此操作?

How do I do this with Sequelize?

SELECT FROM sessions WHERE user_id = ? AND token = ? AND expires > NOW()

这是我想要做的(假设 Session 是一个 Sequelize 模型):

Here's what I'm trying to do (assume Session is a Sequelize model):

Session.find({
    where: {
        user_id: someNumber,
        token: someString,
        //expires > NOW() (how do I do this?)
    }
}).on('success', function (s) { /* things and stuff */ });

谢谢！

推荐答案

您是否尝试在 sequelize 中使用 finder 的数组表示法?

did you try to use the array notation of finders in sequelize?

Session.find({
  where: ['user_id=? and token=? and expires > NOW()', someNumber, someString]
}).on('success', function (s) { /* things and stuff */ });

您可以查看此页面:http://sequelizejs.com/?active=find-objects#find-对象

希望这有效.否则它是一个错误:D

Hope this works. Otherwise it's a bug :D

这篇关于Sequelize 如何查找具有多个 where 子句和时间戳的行 >现在()的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！