server/initializers/migrations/0565-actor-follow-local-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 query = `
  11     UPDATE "actorFollow" SET url = follower.url || '/follows/' || following.id
  12     FROM actor follower, actor following
  13     WHERE follower."serverId" IS NULL AND follower.id = "actorFollow"."actorId" AND following.id = "actorFollow"."targetActorId"
  14     `
  15
  16     await utils.sequelize.query(query)
  17   }
  18 }
  19
  20 function down (options) {
  21   throw new Error('Not implemented.')
  22 }
  23
  24 export {
  25   up,
  26   down
  27 }