server/initializers/migrations/0340-add-originally-published-at.ts

   1 import * as Sequelize from 'sequelize'
   2
   3 async function up (utils: {
   4   transaction: Sequelize.Transaction,
   5   queryInterface: Sequelize.QueryInterface,
   6   sequelize: Sequelize.Sequelize
   7 }): Promise<void> {
   8
   9   {
  10     const data = {
  11       type: Sequelize.DATE,
  12       allowNull: true,
  13       defaultValue: Sequelize.NOW
  14     }
  15     await utils.queryInterface.addColumn('video', 'originallyPublishedAt', data)
  16   }
  17
  18   {
  19     const query = 'UPDATE video SET "originallyPublishedAt" = video."publishedAt"'
  20     await utils.sequelize.query(query)
  21   }
  22 }
  23
  24 function down (options) {
  25   throw new Error('Not implemented.')
  26 }
  27
  28 export {
  29   up,
  30   down
  31 }