aboutsummaryrefslogtreecommitdiffhomepage
path: root/server/initializers/migrations/0565-actor-follow-local-url.ts
diff options
context:
space:
mode:
Diffstat (limited to 'server/initializers/migrations/0565-actor-follow-local-url.ts')
-rw-r--r--server/initializers/migrations/0565-actor-follow-local-url.ts27
1 files changed, 27 insertions, 0 deletions
diff --git a/server/initializers/migrations/0565-actor-follow-local-url.ts b/server/initializers/migrations/0565-actor-follow-local-url.ts
new file mode 100644
index 000000000..779a59475
--- /dev/null
+++ b/server/initializers/migrations/0565-actor-follow-local-url.ts
@@ -0,0 +1,27 @@
1import * as Sequelize from 'sequelize'
2
3async 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
20function down (options) {
21 throw new Error('Not implemented.')
22}
23
24export {
25 up,
26 down
27}