andela/team-odd-bn-backend

View on GitHub
src/database/migrations/20191203155339-modify-ratings.js

Summary

Maintainability
A
50 mins
Test Coverage
'use strict';

module.exports = {
  up: (queryInterface, Sequelize) => {

    return Promise.all([
      queryInterface.removeColumn('ratings', 'userId'),
      queryInterface.addColumn(
      'ratings',
      'userId',
      {
      type: Sequelize.INTEGER,
      onDelete: 'CASCADE',
      onUpdate: 'CASCADE',
      references: {
      model: 'users',
      key: 'id',
      as: 'userId',}
    }
    )
      ]);
  },

  down: (queryInterface, Sequelize) => {
    return Promise.all([
      queryInterface.removeColumn('ratings', 'userId'),
      queryInterface.addColumn('ratings', 'userId', Sequelize.INTEGER),
    ]);
    
  }
};