server/initializers/migrations/0690-live-latency-mode.ts

   1 import { LiveVideoLatencyMode } from '@shared/models'
   2 import * as Sequelize from 'sequelize'
   3
   4 async function up (utils: {
   5   transaction: Sequelize.Transaction
   6   queryInterface: Sequelize.QueryInterface
   7   sequelize: Sequelize.Sequelize
   8   db: any
   9 }): Promise<void> {
  10   await utils.queryInterface.addColumn('videoLive', 'latencyMode', {
  11     type: Sequelize.INTEGER,
  12     defaultValue: null,
  13     allowNull: true
  14   }, { transaction: utils.transaction })
  15
  16   {
  17     const query = `UPDATE "videoLive" SET "latencyMode" = ${LiveVideoLatencyMode.DEFAULT}`
  18     await utils.sequelize.query(query, { type: Sequelize.QueryTypes.UPDATE, transaction: utils.transaction })
  19   }
  20
  21   await utils.queryInterface.changeColumn('videoLive', 'latencyMode', {
  22     type: Sequelize.INTEGER,
  23     defaultValue: null,
  24     allowNull: false
  25   }, { transaction: utils.transaction })
  26 }
  27
  28 function down () {
  29   throw new Error('Not implemented.')
  30 }
  31
  32 export {
  33   up,
  34   down
  35 }