diff options
| author | Rigel Kent <sendmemail@rigelk.eu> | 2020-04-20 15:28:16 +0200 |
|---|---|---|
| committer | Rigel Kent <par@rigelk.eu> | 2020-05-01 16:41:02 +0200 |
| commit | 197876ea87494f9c8f5262fa371b0f70e3c56fb5 (patch) | |
| tree | f16db617292c63a7d7385c40d4983d30c6542033 /server/models/video/video-abuse.ts | |
| parent | efa012edad6b9b4c38a21a5c7d06ce0f7089d22c (diff) | |
| download | PeerTube-197876ea87494f9c8f5262fa371b0f70e3c56fb5.tar.gz PeerTube-197876ea87494f9c8f5262fa371b0f70e3c56fb5.tar.zst PeerTube-197876ea87494f9c8f5262fa371b0f70e3c56fb5.zip | |
Add tests for video-abuse persistence after video deletion
Diffstat (limited to 'server/models/video/video-abuse.ts')
| -rw-r--r-- | server/models/video/video-abuse.ts | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/server/models/video/video-abuse.ts b/server/models/video/video-abuse.ts index 285fb1fbc..628f1caa6 100644 --- a/server/models/video/video-abuse.ts +++ b/server/models/video/video-abuse.ts | |||
| @@ -143,7 +143,8 @@ export enum ScopeNames { | |||
| 143 | 'SELECT count(DISTINCT "videoAbuse"."id") ' + | 143 | 'SELECT count(DISTINCT "videoAbuse"."id") ' + |
| 144 | 'FROM "videoAbuse" ' + | 144 | 'FROM "videoAbuse" ' + |
| 145 | `WHERE CAST("deletedVideo"->'channel'->'ownerAccount'->>'id' AS INTEGER) = "Video->VideoChannel"."accountId" ` + | 145 | `WHERE CAST("deletedVideo"->'channel'->'ownerAccount'->>'id' AS INTEGER) = "Video->VideoChannel"."accountId" ` + |
| 146 | `OR CAST("deletedVideo"->'channel'->'ownerAccount'->>'id' AS INTEGER) = CAST("VideoAbuseModel"."deletedVideo"->'channel'->'ownerAccount'->>'id' AS INTEGER) ` + | 146 | `OR CAST("deletedVideo"->'channel'->'ownerAccount'->>'id' AS INTEGER) = ` + |
| 147 | `CAST("VideoAbuseModel"."deletedVideo"->'channel'->'ownerAccount'->>'id' AS INTEGER) ` + | ||
| 147 | ')' | 148 | ')' |
| 148 | ), | 149 | ), |
| 149 | 'countReportsForReportee__deletedVideo' | 150 | 'countReportsForReportee__deletedVideo' |