Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
4.1k views
in Technique[技术] by (71.8m points)

sequelize.js - SequelizeJS soft deletion doesn't work when i run migration

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. 

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)
等待大神解答

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...