Breaking News: Grepper is joining You.com. Read the official announcement!

Add a mirgation in sequelize

Helpless Hamerkop answered on January 24, 2022 Popularity 1/10 Helpfulness 1/10

answer Add a mirgation in sequelize

Add a mirgation in sequelize

Comment

//Create a migration in main directory:
npx sequelize-cli migration:generate --name add-title-post-table
//or
npx sequelize-cli migration:create --name add-title-post-table

//Inside migration:
module.exports = {
    up: (queryInterface, Sequelize) => {
        return queryInterface.sequelize.transaction((t) => {
            return Promise.all([
                queryInterface.addColumn('table_name', 'field_one_name', {
                    type: Sequelize.STRING
                }, { transaction: t }),
                queryInterface.addColumn('table_name', 'field_two_name', {
                    type: Sequelize.STRING,
                }, { transaction: t })
            ])
        })
    },

    down: (queryInterface, Sequelize) => {
        return queryInterface.sequelize.transaction((t) => {
            return Promise.all([
                queryInterface.removeColumn('table_name', 'field_one_name', { transaction: t }),
                queryInterface.removeColumn('table_name', 'field_two_name', { transaction: t })
            ])
        })
    }
};

//Export migration to sequelize: 
npx sequelize-cli db:migrate

Popularity 1/10 Helpfulness 1/10 Language javascript

Source: www.codegrepper.com

Tags: add javascript

Link to this answer
Share Copy Link

Contributed on Jan 24 2022

Helpless Hamerkop

0 Answers Avg Quality 2/10

Add a mirgation in sequelize

Contents

More Related Answers

Add a mirgation in sequelize

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.