can someone help me that where my code wrong, i tried to do soft delete by following (https://sequelize.org/master/manual/paranoid.html)
but instead, it deleted my whole row, my deletedAt doesn't work.
here is my migration:
module.exports = {
up: async (queryInterface, Sequelize) => {
return queryInterface.createTable('pets', {
///i've remove some column that doesn't do anything here in my question
deletedAt:
{
type: Sequelize.DATE,
allowNull: true,
}
})
},
down: async (queryInterface, Sequelize) => {
return queryInterface.dropTable('pets');
}
};
and here is my model
module.exports = (sequelize, DataTypes) => {
class pet extends Model {
static associate(models) {
}
};
pet.init({
name: {
type: Sequelize.STRING,
allowNull: false,
},
},
{
paranoid: true,
sequelize,
modelName: 'pet',
timestamps: false,
});
pet.associate = function (model) {
pet.hasOne(model.order, { foreignKey: "petId", targetKey: "petId" });
pet.hasOne(model.category, { as: 'category', foreignKey: 'petId' });
pet.belongsToMany(model.tag, {
as: 'tag',
through: 'pet_tag',
foreignKey: 'petId',
otherKey: 'tagId',
timestamps: false
})
}
return pet;
};
I'm not sure how to check if I'm doing it correctly.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…