server/initializers/migrations/0160-account-route.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     const toReplace = ':443'
  10     const by = ''
  11     const replacer = column => `replace("${column}", '${toReplace}', '${by}')`
  12
  13     const query = `
  14     UPDATE actor SET url = ${replacer('url')}, "inboxUrl" = ${replacer('inboxUrl')}, "outboxUrl" = ${replacer('outboxUrl')},
  15     "sharedInboxUrl" = ${replacer('sharedInboxUrl')}, "followersUrl" = ${replacer('followersUrl')},
  16     "followingUrl" = ${replacer('followingUrl')}
  17   `
  18     await utils.sequelize.query(query)
  19   }
  20
  21   {
  22     const toReplace = '/account/'
  23     const by = '/accounts/'
  24     const replacer = column => `replace("${column}", '${toReplace}', '${by}')`
  25
  26     const query = `
  27     UPDATE actor SET url = ${replacer('url')}, "inboxUrl" = ${replacer('inboxUrl')}, "outboxUrl" = ${replacer('outboxUrl')},
  28     "sharedInboxUrl" = ${replacer('sharedInboxUrl')}, "followersUrl" = ${replacer('followersUrl')},
  29     "followingUrl" = ${replacer('followingUrl')}
  30   `
  31     await utils.sequelize.query(query)
  32   }
  33 }
  34
  35 function down (options) {
  36   throw new Error('Not implemented.')
  37 }
  38
  39 export {
  40   up,
  41   down
  42 }