aboutsummaryrefslogtreecommitdiffhomepage
path: root/server/initializers/migrations/0565-actor-follow-local-url.ts
diff options
context:
space:
mode:
authorChocobozzz <me@florianbigard.com>2020-12-01 10:25:11 +0100
committerChocobozzz <me@florianbigard.com>2020-12-01 15:04:38 +0100
commitd9550daf0560656c756f07492126186aeb7c3a6f (patch)
treed4bc66d1708877f5c18c0007d2838db80a2db349 /server/initializers/migrations/0565-actor-follow-local-url.ts
parent9e3e4adc6503742c30645cf01729a34c921c4060 (diff)
downloadPeerTube-d9550daf0560656c756f07492126186aeb7c3a6f.tar.gz
PeerTube-d9550daf0560656c756f07492126186aeb7c3a6f.tar.zst
PeerTube-d9550daf0560656c756f07492126186aeb7c3a6f.zip
Add local actor follow url migration
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}