在Sequelize with Dates中使用Op.between时发生TypeScript错误

Question

我想在MySql表中查找在特定日期范围内创建的所有记录。

所以我写道：

import { Sequelize, Model, DataTypes, Op } from 'sequelize';
const sequelize = new Sequelize({
// some db connection config
dialect: 'mysql'
})
class Patient extends Model {
public guid!: number;
public name!: string;
public recordState: number = 0;
public createdAt?: Date;
public updatedAt?: Date
}
Patient.init({
guid: {
type: DataTypes.STRING,
primaryKey: true,
allowNull: false
},
name: { type: DataTypes.STRING, allowNull: false },
recordState: {
type: DataTypes.INTEGER,
allowNull: false,
defaultValue: 0
},
createdAt: DataTypes.DATE,
updatedAt: DataTypes.DATE
}, {
sequelize,
modelName: 'Patient',
timestamps: false
})
Patient.findAll({
where: {
createdAt: {
[Op.between]: [new Date('2020-02-02'), new Date()]
}
}
})

但是，当我尝试用tsc编译它时，它报告的错误如下：

sequelize.ts:50:5 - error TS2322: Type '{ [between]: Date[]; }' is not assignable to type 'string | number | boolean | WhereAttributeHash | AndOperator | OrOperator | Literal | Where | Fn | Col | WhereOperators | Buffer | WhereGeometryOptions | (string | ... 2 more ... | Buffer)[]'.
Types of property '[Op.between]' are incompatible.
Type 'Date[]' is not assignable to type 'string | number | boolean | [number, number] | WhereAttributeHash | AndOperator | OrOperator | Literal | Where | ... 5 more ... | (string | ... 2 more ... | Buffer)[]'.
Type 'Date[]' is not assignable to type '(string | number | WhereAttributeHash | Buffer)[]'.
Type 'Date' is not assignable to type 'string | number | WhereAttributeHash | Buffer'.
Type 'Date' is not assignable to type 'WhereAttributeHash'.
Index signature is missing in type 'Date'.
50     createdAt: {
~~~~~~~~~

Found 1 error.

似乎我不能将Op.between与日期范围一起使用？但当我在JS中编写类似的代码时，这是可以的。

所以我想知道我的TS代码中是否真的有问题，或者只是类型定义中缺少，或者不建议使用带日期的Op.between？

Answer 1

您传递的是日期对象，而不是字符串。这样做：

Patient.findAll({
where: {
createdAt: {
[Op.between]: [new Date('2020-02-02').toISOString(), new Date().toISOString()]
}
}
})

Answer 2

在我的情况下，我有：

createdAt: {
[Op.between]: [
new Date(startDate).toISOString(),
new Date(`${endDate} 23:59:59`).toISOString()
]
}

并工作更改为：

createdAt: {
[Op.and]: [
{
[Op.lt]: new Date(`${endDate} 23:59:59`),
[Op.gt]: new Date(startDate)
}
]
}