Why is using soft deletion ineffective
AgileZM opened this issue · 0 comments
AgileZM commented
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;