server/initializers/migrations/0290-account-video-rate-url.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   db: any
   8 }): Promise<void> {
   9   {
  10     const data = {
  11       type: Sequelize.STRING(2000),
  12       allowNull: true
  13     }
  14
  15     await utils.queryInterface.addColumn('accountVideoRate', 'url', data)
  16   }
  17
  18   {
  19     const builtUrlQuery = `SELECT "actor"."url" || '/' ||  "accountVideoRate"."type" || 's/' || "videoId" ` +
  20       'FROM "accountVideoRate" ' +
  21       'INNER JOIN account ON account.id = "accountVideoRate"."accountId" ' +
  22       'INNER JOIN actor ON actor.id = account."actorId" ' +
  23       'WHERE "base".id = "accountVideoRate".id'
  24
  25     const query = 'UPDATE "accountVideoRate" base SET "url" = (' + builtUrlQuery + ') WHERE "url" IS NULL'
  26     await utils.sequelize.query(query)
  27   }
  28
  29   {
  30     const data = {
  31       type: Sequelize.STRING(2000),
  32       allowNull: false,
  33       defaultValue: null
  34     }
  35     await utils.queryInterface.changeColumn('accountVideoRate', 'url', data)
  36   }
  37 }
  38
  39 function down (options) {
  40   throw new Error('Not implemented.')
  41 }
  42
  43 export {
  44   up,
  45   down
  46 }