sequelize/sequelize-typescript

Why is using soft deletion ineffective

AgileZM opened this issue · 0 comments

Issue

If Paranoid: true is configured, data will still be deleted

Versions

  • sequelize: ^6.37.1
  • sequelize-typescript: ^2.1.6
  • typescript: 4.8.4

Issue type

  • bug report
  • feature request

Actual behavior

Expected behavior

Steps to reproduce

Related code

sequelize: {
    dataSource: {
      default: {
        database: process.env["DATABASE_DATABASE"],
        username: process.env["DATABASE_USERNAME"],
        password: process.env["DATABASE_PASSWORD"],
        host: process.env["DATABASE_HOST"],
        port: process.env["DATABASE_PORT"],
        encrypt: false,
        dialect: "mysql",
        define: {
          charset: "utf8",
          timestamps: true,
          paranoid: true,
          underscored: true,
          freezeTableName: true,
          engine: "innodb",
        },
        entities: [
          "**/entity/*{.ts,.js}"
        ]
      }
    }
  }

 @Column({ field: 'created_at', allowNull: true, type: DataType.DATE })
  createdAt?: Date;

 @Column({ field: 'updated_at', allowNull: true, type: DataType.DATE })
  updatedAt?: Date;

  @Column({ field: 'deleted_at', allowNull: true, type: DataType.DATE })
  deletedAt?: Date;