Question

我正致力于一个明确项目,我利用管理办公室的后遗症,使我用Mysql 8.0的图表数据得以持续。我试图进行简单的DELETE查询,其中我对“指标_Name”和“日期”这两个领域提出疑问。

const deleteRecordsBetweenDates = async () =>{
    let startDate = new Date("2020-05-25").toJSON().slice(0, 10);
    let finalDate = new Date("2022-12-19").toJSON().slice(0, 10);
    const deleteRecords = await indcds_scheme.destroy({
        where: {
            [Op.and]: [
                {"Nombre_indicador": "Covid 19"}, 
                {[Op.between] : [
                    {Fecha_de_inicio: "2020-05-25"}, 
                    {Fecha_de_inicio: "2022-12-19"}
                ]}
            ]
        } 
    });
    return deleteRecords;
}

   router.delete("/delete", async (req, res) => {
    deleteRecordsBetweenDates()
      .then((result) => {
        console.log(result)
        return res.sendStatus(200)
      })
      .catch((error) => {
        console.log(error)
        return res.sendStatus(500)
      });
  });

计划:

const indcds_scheme = connection.define(
  "indicador_categoría",
  {
    Id: {
      type: Sequelize.INTEGER,
      primaryKey: true,
      autoIncrement: true,
    },
    Nombre_indicador: Sequelize.DataTypes.STRING,
    Descripción_indicador: Sequelize.DataTypes.INTEGER,
    Valor_de_variable: Sequelize.INTEGER,
    Última_actualización: Sequelize.DATE,
    Fecha_de_inicio: Sequelize.DATEONLY,
    Población_rural: Sequelize.INTEGER,
    Población_urbana: Sequelize.INTEGER,
 },
 {
   freezeTableName: true,
 }
);

接下来是:

将日期改为有效日表,但仍然存在同样的问题:

 let startDate = new Date("2020-05-25").toJSON().slice(0, 10);

Answer 1

The issue could be with the way you are using Sequelize s query options for date ranges or the JSON conversion.
I think the use of Op.and to combine conditions is unnecessary in this case. Because sequelize implicitly treats multiple keys within the where object as an AND operation anyway. So you can directly use an array of conditions without explicitly using Op.and. Also the usage of Op.between could be adjusted to include the correct date range. Instead of specifying an array of two objects inside [Op.between], you could provide an array of two dates representing the start and end dates. Something like this,

const startDate = new Date("2020-05-25")
const finalDate = new Date("2022-12-19")

const deleteRecords = await indcds_scheme.destroy({
  where: {
    Nombre_indicador: "Covid 19",
    Fecha_de_inicio: {
      [Op.between]: [startDate, finalDate],
    }
  }
})

此外,你不需要将日期改为初等干事。如果我不错,那么,我顺便处理日期物体。如果做不到这一点,你可以尝试使用奥特特特和奥特莱。

where: {
     Nombre_indicador: "Covid 19",
     Fecha_de_inicio: {
       [Op.gte]: startDate,
       [Op.lte]: finalDate,
     },
   }

友情链接