server/initializers/migrations/0005-email-pod.ts

   1 import { waterfall } from 'async'
   2
   3 // utils = { transaction, queryInterface, sequelize, Sequelize }
   4 function up (utils, finalCallback) {
   5   const q = utils.queryInterface
   6   const Sequelize = utils.Sequelize
   7
   8   const data = {
   9     type: Sequelize.STRING(400),
  10     allowNull: false,
  11     defaultValue: ''
  12   }
  13
  14   waterfall([
  15
  16     function addEmailColumn (callback) {
  17       q.addColumn('Pods', 'email', data, { transaction: utils.transaction }).asCallback(function (err) {
  18         return callback(err)
  19       })
  20     },
  21
  22     function updateWithFakeEmails (callback) {
  23       const query = 'UPDATE "Pods" SET "email" = \'dummy@example.com\''
  24       utils.sequelize.query(query, { transaction: utils.transaction }).asCallback(function (err) {
  25         return callback(err)
  26       })
  27     },
  28
  29     function nullOnDefault (callback) {
  30       data.defaultValue = null
  31
  32       q.changeColumn('Pods', 'email', data, { transaction: utils.transaction }).asCallback(callback)
  33     }
  34   ], finalCallback)
  35 }
  36
  37 function down (options, callback) {
  38   throw new Error('Not implemented.')
  39 }
  40
  41 export {
  42   up,
  43   down
  44 }