node.js - NodeJs sequelize 获取数据之间的日期

Question

这个问题已经被问过了，但这并不能解决我的问题。

我有两个字段database是fromDate& toDate。我想在插入新数据时验证fromDate& 。toDate

我的意思是，我的. _ _database

现在我试图插入fromDateas2019-04-25和toDateas 2019-04-26。

在这种情况下，抛出错误，例如You have already this date's ...！

这是我的代码：

controller.js

const db = require('../../config/database');
const CubbersClosure = require('../../model/cubber/cubbersClosure.model')(db.sequelize, db.Sequelize);

exports.cubbersAddClosure = (req, res) =>{
   CubbersClosure.create({
        cubbersId:req.body.cubbersId,
        userId:req.body.userId,
        fromDate:req.body.fromDate,
        toDate:req.body.toDate,
        status:1,
        createdBy:req.body.createdBy,
        updatedBy:req.body.updatedBy
    }).then(closure=>{
        res.status(200).send({status: 'success', resCode:200, msg:'Shop closure date added successfully...!', data:closure});
    }).catch(function (error) {
        res.status(403).send({status: 'error', resCode:200, msg:'Internal Server Error...!', data:error});
    });
}

model.js

module.exports = (sequelize, Sequelize)=>{
    const cubbersAvailability = sequelize.define('cubbersclosure',{
        closureId:{
            type: Sequelize.INTEGER,
            primaryKey:true,
            autoIncrement:true
        },
        cubbersId:{type: Sequelize.INTEGER},
        userId:{type: Sequelize.INTEGER},
        fromDate:{type: Sequelize.STRING},
        toDate:{type: Sequelize.STRING},
        status:{type: Sequelize.INTEGER},
        createdAt:{type: Sequelize.DATE},
        createdBy:{type: Sequelize.INTEGER},
        updatedAt:{type: Sequelize.DATE},
        updatedBy:{type: Sequelize.INTEGER},
    },
    {
        freezeTableName: true
    });
    return cubbersAvailability;
}

数据库：

注意：在插入新日期之前，我想验证日期之间是否已经退出......！

标签： node.jsormsequelize.js