]>
Commit | Line | Data |
---|---|---|
2af337c8 C |
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 | const query = ` | |
9 | WITH t AS ( | |
10 | SELECT actor.id FROM actor | |
11 | LEFT JOIN "videoChannel" ON "videoChannel"."actorId" = actor.id | |
12 | LEFT JOIN account ON account."actorId" = "actor"."id" | |
13 | WHERE "videoChannel".id IS NULL and "account".id IS NULL | |
14 | ) DELETE FROM "actorFollow" WHERE "actorId" IN (SELECT t.id FROM t) OR "targetActorId" in (SELECT t.id FROM t) | |
15 | ` | |
16 | ||
17 | await utils.sequelize.query(query) | |
18 | } | |
19 | ||
20 | function down (options) { | |
21 | throw new Error('Not implemented.') | |
22 | } | |
23 | ||
24 | export { | |
25 | up, | |
26 | down | |
27 | } |