[sequelize] migration 정리

맨날 쓰고 

맨날 까먹는 

 

sequelize migration 정리 

 

command

sequelize migration:create --name 파일명

sequelize db:migrate
sequelize db:migrate:undo

 

 

addColumn

module.exports = {
    up: async (queryInterface, Sequelize) => {
        await queryInterface.addColumn('테이블명', '변수명', {
            type: Sequelize.타입[BOOLEAN, STRING(4, 8, 16), TEXT, INTEGER],
            comment: ""
            ...
        })
    }
}

 

removeColumn

module.exports = {
    up: async (queryInterface, Sequelize) => {
        await queryInterface.removeColumn('테이블명', '변수명')
    }
}

 

renameColumn

module.exports = {
    up: async (queryInterface, Sequelize) => {
        await queryInterface.renameColumn('테이블명', '변수명', '바꿀 변수 명')
    }
}

 

changeColumn

module.exports = {
    up: async (queryInterface, Sequelize) => {
        await queryInterface.changeColumn('테이블명','변수명',
            {
                type: Sequelize.타입[BOOLEAN, STRING(4, 8, 16), TEXT, INTEGER],
                comment: "",
                ...
            }
        )
    }
}

 

addConstraint (참조 테이블에 변수랑 테이블에 변수가 선언되어 있어야 한다)

module.exports = {
    up: async (queryInterface, Sequelize) => {
        await queryInterface.addConstraint('테이블명', {
            fields: ['변수명'],
            type: 'foreign key',
            name: '왜래키명',
            references: {
                table: '참조 테이블',
                field: '참조 변수명'
            }
        })
    }
}

 

removeConstraint

module.exports = {
    up: async (queryInterface, Sequelize) => {
        await queryInterface.removeConstraint('테이블명', '왜래키명')
    }
}