aboutsummaryrefslogtreecommitdiffhomepage
path: root/server/initializers/migrations/0005-email-pod.ts
blob: a9200c47f3b14cc30e602099e1989a625a2f7595 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
import { waterfall } from 'async'

// utils = { transaction, queryInterface, sequelize, Sequelize }
function up (utils, finalCallback) {
  const q = utils.queryInterface
  const Sequelize = utils.Sequelize

  const data = {
    type: Sequelize.STRING(400),
    allowNull: false,
    defaultValue: ''
  }

  waterfall([

    function addEmailColumn (callback) {
      q.addColumn('Pods', 'email', data, { transaction: utils.transaction }).asCallback(function (err) {
        return callback(err)
      })
    },

    function updateWithFakeEmails (callback) {
      const query = 'UPDATE "Pods" SET "email" = \'dummy@example.com\''
      utils.sequelize.query(query, { transaction: utils.transaction }).asCallback(function (err) {
        return callback(err)
      })
    },

    function nullOnDefault (callback) {
      data.defaultValue = null

      q.changeColumn('Pods', 'email', data, { transaction: utils.transaction }).asCallback(callback)
    }
  ], finalCallback)
}

function down (options, callback) {
  throw new Error('Not implemented.')
}

export {
  up,
  down
}