diff options
Diffstat (limited to 'server/models/video/video.ts')
-rw-r--r-- | server/models/video/video.ts | 165 |
1 files changed, 82 insertions, 83 deletions
diff --git a/server/models/video/video.ts b/server/models/video/video.ts index 1a924e6c9..1ec8d717e 100644 --- a/server/models/video/video.ts +++ b/server/models/video/video.ts | |||
@@ -187,7 +187,7 @@ export type AvailableForListIDsOptions = { | |||
187 | } | 187 | } |
188 | 188 | ||
189 | @Scopes(() => ({ | 189 | @Scopes(() => ({ |
190 | [ ScopeNames.FOR_API ]: (options: ForAPIOptions) => { | 190 | [ScopeNames.FOR_API]: (options: ForAPIOptions) => { |
191 | const query: FindOptions = { | 191 | const query: FindOptions = { |
192 | include: [ | 192 | include: [ |
193 | { | 193 | { |
@@ -212,7 +212,7 @@ export type AvailableForListIDsOptions = { | |||
212 | if (options.ids) { | 212 | if (options.ids) { |
213 | query.where = { | 213 | query.where = { |
214 | id: { | 214 | id: { |
215 | [ Op.in ]: options.ids | 215 | [Op.in]: options.ids |
216 | } | 216 | } |
217 | } | 217 | } |
218 | } | 218 | } |
@@ -236,7 +236,7 @@ export type AvailableForListIDsOptions = { | |||
236 | 236 | ||
237 | return query | 237 | return query |
238 | }, | 238 | }, |
239 | [ ScopeNames.AVAILABLE_FOR_LIST_IDS ]: (options: AvailableForListIDsOptions) => { | 239 | [ScopeNames.AVAILABLE_FOR_LIST_IDS]: (options: AvailableForListIDsOptions) => { |
240 | const whereAnd = options.baseWhere ? [].concat(options.baseWhere) : [] | 240 | const whereAnd = options.baseWhere ? [].concat(options.baseWhere) : [] |
241 | 241 | ||
242 | const query: FindOptions = { | 242 | const query: FindOptions = { |
@@ -247,11 +247,11 @@ export type AvailableForListIDsOptions = { | |||
247 | const attributesType = options.attributesType || 'id' | 247 | const attributesType = options.attributesType || 'id' |
248 | 248 | ||
249 | if (attributesType === 'id') query.attributes = [ 'id' ] | 249 | if (attributesType === 'id') query.attributes = [ 'id' ] |
250 | else if (attributesType === 'none') query.attributes = [ ] | 250 | else if (attributesType === 'none') query.attributes = [] |
251 | 251 | ||
252 | whereAnd.push({ | 252 | whereAnd.push({ |
253 | id: { | 253 | id: { |
254 | [ Op.notIn ]: Sequelize.literal( | 254 | [Op.notIn]: Sequelize.literal( |
255 | '(SELECT "videoBlacklist"."videoId" FROM "videoBlacklist")' | 255 | '(SELECT "videoBlacklist"."videoId" FROM "videoBlacklist")' |
256 | ) | 256 | ) |
257 | } | 257 | } |
@@ -260,7 +260,7 @@ export type AvailableForListIDsOptions = { | |||
260 | if (options.serverAccountId) { | 260 | if (options.serverAccountId) { |
261 | whereAnd.push({ | 261 | whereAnd.push({ |
262 | channelId: { | 262 | channelId: { |
263 | [ Op.notIn ]: Sequelize.literal( | 263 | [Op.notIn]: Sequelize.literal( |
264 | '(' + | 264 | '(' + |
265 | 'SELECT id FROM "videoChannel" WHERE "accountId" IN (' + | 265 | 'SELECT id FROM "videoChannel" WHERE "accountId" IN (' + |
266 | buildBlockedAccountSQL(options.serverAccountId, options.user ? options.user.Account.id : undefined) + | 266 | buildBlockedAccountSQL(options.serverAccountId, options.user ? options.user.Account.id : undefined) + |
@@ -273,15 +273,14 @@ export type AvailableForListIDsOptions = { | |||
273 | 273 | ||
274 | // Only list public/published videos | 274 | // Only list public/published videos |
275 | if (!options.filter || options.filter !== 'all-local') { | 275 | if (!options.filter || options.filter !== 'all-local') { |
276 | |||
277 | const publishWhere = { | 276 | const publishWhere = { |
278 | // Always list published videos, or videos that are being transcoded but on which we don't want to wait for transcoding | 277 | // Always list published videos, or videos that are being transcoded but on which we don't want to wait for transcoding |
279 | [ Op.or ]: [ | 278 | [Op.or]: [ |
280 | { | 279 | { |
281 | state: VideoState.PUBLISHED | 280 | state: VideoState.PUBLISHED |
282 | }, | 281 | }, |
283 | { | 282 | { |
284 | [ Op.and ]: { | 283 | [Op.and]: { |
285 | state: VideoState.TO_TRANSCODE, | 284 | state: VideoState.TO_TRANSCODE, |
286 | waitTranscoding: false | 285 | waitTranscoding: false |
287 | } | 286 | } |
@@ -368,7 +367,7 @@ export type AvailableForListIDsOptions = { | |||
368 | [Op.or]: [ | 367 | [Op.or]: [ |
369 | { | 368 | { |
370 | id: { | 369 | id: { |
371 | [ Op.in ]: Sequelize.literal( | 370 | [Op.in]: Sequelize.literal( |
372 | '(' + | 371 | '(' + |
373 | 'SELECT "videoShare"."videoId" AS "id" FROM "videoShare" ' + | 372 | 'SELECT "videoShare"."videoId" AS "id" FROM "videoShare" ' + |
374 | 'INNER JOIN "actorFollow" ON "actorFollow"."targetActorId" = "videoShare"."actorId" ' + | 373 | 'INNER JOIN "actorFollow" ON "actorFollow"."targetActorId" = "videoShare"."actorId" ' + |
@@ -379,7 +378,7 @@ export type AvailableForListIDsOptions = { | |||
379 | }, | 378 | }, |
380 | { | 379 | { |
381 | id: { | 380 | id: { |
382 | [ Op.in ]: Sequelize.literal( | 381 | [Op.in]: Sequelize.literal( |
383 | '(' + | 382 | '(' + |
384 | 'SELECT "video"."id" AS "id" FROM "video" ' + | 383 | 'SELECT "video"."id" AS "id" FROM "video" ' + |
385 | 'INNER JOIN "videoChannel" ON "videoChannel"."id" = "video"."channelId" ' + | 384 | 'INNER JOIN "videoChannel" ON "videoChannel"."id" = "video"."channelId" ' + |
@@ -399,7 +398,7 @@ export type AvailableForListIDsOptions = { | |||
399 | if (options.withFiles === true) { | 398 | if (options.withFiles === true) { |
400 | whereAnd.push({ | 399 | whereAnd.push({ |
401 | id: { | 400 | id: { |
402 | [ Op.in ]: Sequelize.literal( | 401 | [Op.in]: Sequelize.literal( |
403 | '(SELECT "videoId" FROM "videoFile")' | 402 | '(SELECT "videoId" FROM "videoFile")' |
404 | ) | 403 | ) |
405 | } | 404 | } |
@@ -413,7 +412,7 @@ export type AvailableForListIDsOptions = { | |||
413 | 412 | ||
414 | whereAnd.push({ | 413 | whereAnd.push({ |
415 | id: { | 414 | id: { |
416 | [ Op.in ]: Sequelize.literal( | 415 | [Op.in]: Sequelize.literal( |
417 | '(' + | 416 | '(' + |
418 | 'SELECT "videoId" FROM "videoTag" ' + | 417 | 'SELECT "videoId" FROM "videoTag" ' + |
419 | 'INNER JOIN "tag" ON "tag"."id" = "videoTag"."tagId" ' + | 418 | 'INNER JOIN "tag" ON "tag"."id" = "videoTag"."tagId" ' + |
@@ -429,7 +428,7 @@ export type AvailableForListIDsOptions = { | |||
429 | 428 | ||
430 | whereAnd.push({ | 429 | whereAnd.push({ |
431 | id: { | 430 | id: { |
432 | [ Op.in ]: Sequelize.literal( | 431 | [Op.in]: Sequelize.literal( |
433 | '(' + | 432 | '(' + |
434 | 'SELECT "videoId" FROM "videoTag" ' + | 433 | 'SELECT "videoId" FROM "videoTag" ' + |
435 | 'INNER JOIN "tag" ON "tag"."id" = "videoTag"."tagId" ' + | 434 | 'INNER JOIN "tag" ON "tag"."id" = "videoTag"."tagId" ' + |
@@ -449,7 +448,7 @@ export type AvailableForListIDsOptions = { | |||
449 | if (options.categoryOneOf) { | 448 | if (options.categoryOneOf) { |
450 | whereAnd.push({ | 449 | whereAnd.push({ |
451 | category: { | 450 | category: { |
452 | [ Op.or ]: options.categoryOneOf | 451 | [Op.or]: options.categoryOneOf |
453 | } | 452 | } |
454 | }) | 453 | }) |
455 | } | 454 | } |
@@ -457,7 +456,7 @@ export type AvailableForListIDsOptions = { | |||
457 | if (options.licenceOneOf) { | 456 | if (options.licenceOneOf) { |
458 | whereAnd.push({ | 457 | whereAnd.push({ |
459 | licence: { | 458 | licence: { |
460 | [ Op.or ]: options.licenceOneOf | 459 | [Op.or]: options.licenceOneOf |
461 | } | 460 | } |
462 | }) | 461 | }) |
463 | } | 462 | } |
@@ -472,12 +471,12 @@ export type AvailableForListIDsOptions = { | |||
472 | [Op.or]: [ | 471 | [Op.or]: [ |
473 | { | 472 | { |
474 | language: { | 473 | language: { |
475 | [ Op.or ]: videoLanguages | 474 | [Op.or]: videoLanguages |
476 | } | 475 | } |
477 | }, | 476 | }, |
478 | { | 477 | { |
479 | id: { | 478 | id: { |
480 | [ Op.in ]: Sequelize.literal( | 479 | [Op.in]: Sequelize.literal( |
481 | '(' + | 480 | '(' + |
482 | 'SELECT "videoId" FROM "videoCaption" ' + | 481 | 'SELECT "videoId" FROM "videoCaption" ' + |
483 | 'WHERE "language" IN (' + createSafeIn(VideoModel, options.languageOneOf) + ') ' + | 482 | 'WHERE "language" IN (' + createSafeIn(VideoModel, options.languageOneOf) + ') ' + |
@@ -511,12 +510,12 @@ export type AvailableForListIDsOptions = { | |||
511 | } | 510 | } |
512 | 511 | ||
513 | query.where = { | 512 | query.where = { |
514 | [ Op.and ]: whereAnd | 513 | [Op.and]: whereAnd |
515 | } | 514 | } |
516 | 515 | ||
517 | return query | 516 | return query |
518 | }, | 517 | }, |
519 | [ ScopeNames.WITH_THUMBNAILS ]: { | 518 | [ScopeNames.WITH_THUMBNAILS]: { |
520 | include: [ | 519 | include: [ |
521 | { | 520 | { |
522 | model: ThumbnailModel, | 521 | model: ThumbnailModel, |
@@ -524,7 +523,7 @@ export type AvailableForListIDsOptions = { | |||
524 | } | 523 | } |
525 | ] | 524 | ] |
526 | }, | 525 | }, |
527 | [ ScopeNames.WITH_USER_ID ]: { | 526 | [ScopeNames.WITH_USER_ID]: { |
528 | include: [ | 527 | include: [ |
529 | { | 528 | { |
530 | attributes: [ 'accountId' ], | 529 | attributes: [ 'accountId' ], |
@@ -540,7 +539,7 @@ export type AvailableForListIDsOptions = { | |||
540 | } | 539 | } |
541 | ] | 540 | ] |
542 | }, | 541 | }, |
543 | [ ScopeNames.WITH_ACCOUNT_DETAILS ]: { | 542 | [ScopeNames.WITH_ACCOUNT_DETAILS]: { |
544 | include: [ | 543 | include: [ |
545 | { | 544 | { |
546 | model: VideoChannelModel.unscoped(), | 545 | model: VideoChannelModel.unscoped(), |
@@ -592,10 +591,10 @@ export type AvailableForListIDsOptions = { | |||
592 | } | 591 | } |
593 | ] | 592 | ] |
594 | }, | 593 | }, |
595 | [ ScopeNames.WITH_TAGS ]: { | 594 | [ScopeNames.WITH_TAGS]: { |
596 | include: [ TagModel ] | 595 | include: [ TagModel ] |
597 | }, | 596 | }, |
598 | [ ScopeNames.WITH_BLACKLISTED ]: { | 597 | [ScopeNames.WITH_BLACKLISTED]: { |
599 | include: [ | 598 | include: [ |
600 | { | 599 | { |
601 | attributes: [ 'id', 'reason', 'unfederated' ], | 600 | attributes: [ 'id', 'reason', 'unfederated' ], |
@@ -604,7 +603,7 @@ export type AvailableForListIDsOptions = { | |||
604 | } | 603 | } |
605 | ] | 604 | ] |
606 | }, | 605 | }, |
607 | [ ScopeNames.WITH_WEBTORRENT_FILES ]: (withRedundancies = false) => { | 606 | [ScopeNames.WITH_WEBTORRENT_FILES]: (withRedundancies = false) => { |
608 | let subInclude: any[] = [] | 607 | let subInclude: any[] = [] |
609 | 608 | ||
610 | if (withRedundancies === true) { | 609 | if (withRedundancies === true) { |
@@ -628,7 +627,7 @@ export type AvailableForListIDsOptions = { | |||
628 | ] | 627 | ] |
629 | } | 628 | } |
630 | }, | 629 | }, |
631 | [ ScopeNames.WITH_STREAMING_PLAYLISTS ]: (withRedundancies = false) => { | 630 | [ScopeNames.WITH_STREAMING_PLAYLISTS]: (withRedundancies = false) => { |
632 | const subInclude: IncludeOptions[] = [ | 631 | const subInclude: IncludeOptions[] = [ |
633 | { | 632 | { |
634 | model: VideoFileModel.unscoped(), | 633 | model: VideoFileModel.unscoped(), |
@@ -655,7 +654,7 @@ export type AvailableForListIDsOptions = { | |||
655 | ] | 654 | ] |
656 | } | 655 | } |
657 | }, | 656 | }, |
658 | [ ScopeNames.WITH_SCHEDULED_UPDATE ]: { | 657 | [ScopeNames.WITH_SCHEDULED_UPDATE]: { |
659 | include: [ | 658 | include: [ |
660 | { | 659 | { |
661 | model: ScheduleVideoUpdateModel.unscoped(), | 660 | model: ScheduleVideoUpdateModel.unscoped(), |
@@ -663,7 +662,7 @@ export type AvailableForListIDsOptions = { | |||
663 | } | 662 | } |
664 | ] | 663 | ] |
665 | }, | 664 | }, |
666 | [ ScopeNames.WITH_USER_HISTORY ]: (userId: number) => { | 665 | [ScopeNames.WITH_USER_HISTORY]: (userId: number) => { |
667 | return { | 666 | return { |
668 | include: [ | 667 | include: [ |
669 | { | 668 | { |
@@ -1016,7 +1015,7 @@ export class VideoModel extends Model<VideoModel> { | |||
1016 | }, | 1015 | }, |
1017 | onDelete: 'cascade', | 1016 | onDelete: 'cascade', |
1018 | hooks: true, | 1017 | hooks: true, |
1019 | [ 'separate' as any ]: true | 1018 | ['separate' as any]: true |
1020 | }) | 1019 | }) |
1021 | VideoCaptions: VideoCaptionModel[] | 1020 | VideoCaptions: VideoCaptionModel[] |
1022 | 1021 | ||
@@ -1112,9 +1111,9 @@ export class VideoModel extends Model<VideoModel> { | |||
1112 | order: getVideoSort('createdAt', [ 'Tags', 'name', 'ASC' ] as any), // FIXME: sequelize typings | 1111 | order: getVideoSort('createdAt', [ 'Tags', 'name', 'ASC' ] as any), // FIXME: sequelize typings |
1113 | where: { | 1112 | where: { |
1114 | id: { | 1113 | id: { |
1115 | [ Op.in ]: Sequelize.literal('(' + rawQuery + ')') | 1114 | [Op.in]: Sequelize.literal('(' + rawQuery + ')') |
1116 | }, | 1115 | }, |
1117 | [ Op.or ]: [ | 1116 | [Op.or]: [ |
1118 | { privacy: VideoPrivacy.PUBLIC }, | 1117 | { privacy: VideoPrivacy.PUBLIC }, |
1119 | { privacy: VideoPrivacy.UNLISTED } | 1118 | { privacy: VideoPrivacy.UNLISTED } |
1120 | ] | 1119 | ] |
@@ -1131,10 +1130,10 @@ export class VideoModel extends Model<VideoModel> { | |||
1131 | required: false, | 1130 | required: false, |
1132 | // We only want videos shared by this actor | 1131 | // We only want videos shared by this actor |
1133 | where: { | 1132 | where: { |
1134 | [ Op.and ]: [ | 1133 | [Op.and]: [ |
1135 | { | 1134 | { |
1136 | id: { | 1135 | id: { |
1137 | [ Op.not ]: null | 1136 | [Op.not]: null |
1138 | } | 1137 | } |
1139 | }, | 1138 | }, |
1140 | { | 1139 | { |
@@ -1184,8 +1183,8 @@ export class VideoModel extends Model<VideoModel> { | |||
1184 | // totals: totalVideos + totalVideoShares | 1183 | // totals: totalVideos + totalVideoShares |
1185 | let totalVideos = 0 | 1184 | let totalVideos = 0 |
1186 | let totalVideoShares = 0 | 1185 | let totalVideoShares = 0 |
1187 | if (totals[ 0 ]) totalVideos = parseInt(totals[ 0 ].total, 10) | 1186 | if (totals[0]) totalVideos = parseInt(totals[0].total, 10) |
1188 | if (totals[ 1 ]) totalVideoShares = parseInt(totals[ 1 ].total, 10) | 1187 | if (totals[1]) totalVideoShares = parseInt(totals[1].total, 10) |
1189 | 1188 | ||
1190 | const total = totalVideos + totalVideoShares | 1189 | const total = totalVideos + totalVideoShares |
1191 | return { | 1190 | return { |
@@ -1228,7 +1227,7 @@ export class VideoModel extends Model<VideoModel> { | |||
1228 | baseQuery = Object.assign(baseQuery, { | 1227 | baseQuery = Object.assign(baseQuery, { |
1229 | where: { | 1228 | where: { |
1230 | name: { | 1229 | name: { |
1231 | [ Op.iLike ]: '%' + search + '%' | 1230 | [Op.iLike]: '%' + search + '%' |
1232 | } | 1231 | } |
1233 | } | 1232 | } |
1234 | }) | 1233 | }) |
@@ -1258,25 +1257,25 @@ export class VideoModel extends Model<VideoModel> { | |||
1258 | } | 1257 | } |
1259 | 1258 | ||
1260 | static async listForApi (options: { | 1259 | static async listForApi (options: { |
1261 | start: number, | 1260 | start: number |
1262 | count: number, | 1261 | count: number |
1263 | sort: string, | 1262 | sort: string |
1264 | nsfw: boolean, | 1263 | nsfw: boolean |
1265 | includeLocalVideos: boolean, | 1264 | includeLocalVideos: boolean |
1266 | withFiles: boolean, | 1265 | withFiles: boolean |
1267 | categoryOneOf?: number[], | 1266 | categoryOneOf?: number[] |
1268 | licenceOneOf?: number[], | 1267 | licenceOneOf?: number[] |
1269 | languageOneOf?: string[], | 1268 | languageOneOf?: string[] |
1270 | tagsOneOf?: string[], | 1269 | tagsOneOf?: string[] |
1271 | tagsAllOf?: string[], | 1270 | tagsAllOf?: string[] |
1272 | filter?: VideoFilter, | 1271 | filter?: VideoFilter |
1273 | accountId?: number, | 1272 | accountId?: number |
1274 | videoChannelId?: number, | 1273 | videoChannelId?: number |
1275 | followerActorId?: number | 1274 | followerActorId?: number |
1276 | videoPlaylistId?: number, | 1275 | videoPlaylistId?: number |
1277 | trendingDays?: number, | 1276 | trendingDays?: number |
1278 | user?: MUserAccountId, | 1277 | user?: MUserAccountId |
1279 | historyOfUser?: MUserId, | 1278 | historyOfUser?: MUserId |
1280 | countVideos?: boolean | 1279 | countVideos?: boolean |
1281 | }) { | 1280 | }) { |
1282 | if (options.filter && options.filter === 'all-local' && !options.user.hasRight(UserRight.SEE_ALL_VIDEOS)) { | 1281 | if (options.filter && options.filter === 'all-local' && !options.user.hasRight(UserRight.SEE_ALL_VIDEOS)) { |
@@ -1342,7 +1341,7 @@ export class VideoModel extends Model<VideoModel> { | |||
1342 | tagsAllOf?: string[] | 1341 | tagsAllOf?: string[] |
1343 | durationMin?: number // seconds | 1342 | durationMin?: number // seconds |
1344 | durationMax?: number // seconds | 1343 | durationMax?: number // seconds |
1345 | user?: MUserAccountId, | 1344 | user?: MUserAccountId |
1346 | filter?: VideoFilter | 1345 | filter?: VideoFilter |
1347 | }) { | 1346 | }) { |
1348 | const whereAnd = [] | 1347 | const whereAnd = [] |
@@ -1350,8 +1349,8 @@ export class VideoModel extends Model<VideoModel> { | |||
1350 | if (options.startDate || options.endDate) { | 1349 | if (options.startDate || options.endDate) { |
1351 | const publishedAtRange = {} | 1350 | const publishedAtRange = {} |
1352 | 1351 | ||
1353 | if (options.startDate) publishedAtRange[ Op.gte ] = options.startDate | 1352 | if (options.startDate) publishedAtRange[Op.gte] = options.startDate |
1354 | if (options.endDate) publishedAtRange[ Op.lte ] = options.endDate | 1353 | if (options.endDate) publishedAtRange[Op.lte] = options.endDate |
1355 | 1354 | ||
1356 | whereAnd.push({ publishedAt: publishedAtRange }) | 1355 | whereAnd.push({ publishedAt: publishedAtRange }) |
1357 | } | 1356 | } |
@@ -1359,8 +1358,8 @@ export class VideoModel extends Model<VideoModel> { | |||
1359 | if (options.originallyPublishedStartDate || options.originallyPublishedEndDate) { | 1358 | if (options.originallyPublishedStartDate || options.originallyPublishedEndDate) { |
1360 | const originallyPublishedAtRange = {} | 1359 | const originallyPublishedAtRange = {} |
1361 | 1360 | ||
1362 | if (options.originallyPublishedStartDate) originallyPublishedAtRange[ Op.gte ] = options.originallyPublishedStartDate | 1361 | if (options.originallyPublishedStartDate) originallyPublishedAtRange[Op.gte] = options.originallyPublishedStartDate |
1363 | if (options.originallyPublishedEndDate) originallyPublishedAtRange[ Op.lte ] = options.originallyPublishedEndDate | 1362 | if (options.originallyPublishedEndDate) originallyPublishedAtRange[Op.lte] = options.originallyPublishedEndDate |
1364 | 1363 | ||
1365 | whereAnd.push({ originallyPublishedAt: originallyPublishedAtRange }) | 1364 | whereAnd.push({ originallyPublishedAt: originallyPublishedAtRange }) |
1366 | } | 1365 | } |
@@ -1368,8 +1367,8 @@ export class VideoModel extends Model<VideoModel> { | |||
1368 | if (options.durationMin || options.durationMax) { | 1367 | if (options.durationMin || options.durationMax) { |
1369 | const durationRange = {} | 1368 | const durationRange = {} |
1370 | 1369 | ||
1371 | if (options.durationMin) durationRange[ Op.gte ] = options.durationMin | 1370 | if (options.durationMin) durationRange[Op.gte] = options.durationMin |
1372 | if (options.durationMax) durationRange[ Op.lte ] = options.durationMax | 1371 | if (options.durationMax) durationRange[Op.lte] = options.durationMax |
1373 | 1372 | ||
1374 | whereAnd.push({ duration: durationRange }) | 1373 | whereAnd.push({ duration: durationRange }) |
1375 | } | 1374 | } |
@@ -1380,7 +1379,7 @@ export class VideoModel extends Model<VideoModel> { | |||
1380 | if (options.search) { | 1379 | if (options.search) { |
1381 | const trigramSearch = { | 1380 | const trigramSearch = { |
1382 | id: { | 1381 | id: { |
1383 | [ Op.in ]: Sequelize.literal( | 1382 | [Op.in]: Sequelize.literal( |
1384 | '(' + | 1383 | '(' + |
1385 | 'SELECT "video"."id" FROM "video" ' + | 1384 | 'SELECT "video"."id" FROM "video" ' + |
1386 | 'WHERE ' + | 1385 | 'WHERE ' + |
@@ -1578,8 +1577,8 @@ export class VideoModel extends Model<VideoModel> { | |||
1578 | } | 1577 | } |
1579 | 1578 | ||
1580 | static loadForGetAPI (parameters: { | 1579 | static loadForGetAPI (parameters: { |
1581 | id: number | string, | 1580 | id: number | string |
1582 | t?: Transaction, | 1581 | t?: Transaction |
1583 | userId?: number | 1582 | userId?: number |
1584 | }): Bluebird<MVideoDetails> { | 1583 | }): Bluebird<MVideoDetails> { |
1585 | const { id, t, userId } = parameters | 1584 | const { id, t, userId } = parameters |
@@ -1645,9 +1644,9 @@ export class VideoModel extends Model<VideoModel> { | |||
1645 | static checkVideoHasInstanceFollow (videoId: number, followerActorId: number) { | 1644 | static checkVideoHasInstanceFollow (videoId: number, followerActorId: number) { |
1646 | // Instances only share videos | 1645 | // Instances only share videos |
1647 | const query = 'SELECT 1 FROM "videoShare" ' + | 1646 | const query = 'SELECT 1 FROM "videoShare" ' + |
1648 | 'INNER JOIN "actorFollow" ON "actorFollow"."targetActorId" = "videoShare"."actorId" ' + | 1647 | 'INNER JOIN "actorFollow" ON "actorFollow"."targetActorId" = "videoShare"."actorId" ' + |
1649 | 'WHERE "actorFollow"."actorId" = $followerActorId AND "videoShare"."videoId" = $videoId ' + | 1648 | 'WHERE "actorFollow"."actorId" = $followerActorId AND "videoShare"."videoId" = $videoId ' + |
1650 | 'LIMIT 1' | 1649 | 'LIMIT 1' |
1651 | 1650 | ||
1652 | const options = { | 1651 | const options = { |
1653 | type: QueryTypes.SELECT as QueryTypes.SELECT, | 1652 | type: QueryTypes.SELECT as QueryTypes.SELECT, |
@@ -1679,7 +1678,7 @@ export class VideoModel extends Model<VideoModel> { | |||
1679 | } | 1678 | } |
1680 | 1679 | ||
1681 | return VideoModel.findAll(query) | 1680 | return VideoModel.findAll(query) |
1682 | .then(videos => videos.map(v => v.id)) | 1681 | .then(videos => videos.map(v => v.id)) |
1683 | } | 1682 | } |
1684 | 1683 | ||
1685 | // threshold corresponds to how many video the field should have to be returned | 1684 | // threshold corresponds to how many video the field should have to be returned |
@@ -1699,14 +1698,14 @@ export class VideoModel extends Model<VideoModel> { | |||
1699 | limit: count, | 1698 | limit: count, |
1700 | group: field, | 1699 | group: field, |
1701 | having: Sequelize.where( | 1700 | having: Sequelize.where( |
1702 | Sequelize.fn('COUNT', Sequelize.col(field)), { [ Op.gte ]: threshold } | 1701 | Sequelize.fn('COUNT', Sequelize.col(field)), { [Op.gte]: threshold } |
1703 | ), | 1702 | ), |
1704 | order: [ (this.sequelize as any).random() ] | 1703 | order: [ (this.sequelize as any).random() ] |
1705 | } | 1704 | } |
1706 | 1705 | ||
1707 | return VideoModel.scope({ method: [ ScopeNames.AVAILABLE_FOR_LIST_IDS, scopeOptions ] }) | 1706 | return VideoModel.scope({ method: [ ScopeNames.AVAILABLE_FOR_LIST_IDS, scopeOptions ] }) |
1708 | .findAll(query) | 1707 | .findAll(query) |
1709 | .then(rows => rows.map(r => r[ field ])) | 1708 | .then(rows => rows.map(r => r[field])) |
1710 | } | 1709 | } |
1711 | 1710 | ||
1712 | static buildTrendingQuery (trendingDays: number) { | 1711 | static buildTrendingQuery (trendingDays: number) { |
@@ -1717,7 +1716,7 @@ export class VideoModel extends Model<VideoModel> { | |||
1717 | required: false, | 1716 | required: false, |
1718 | where: { | 1717 | where: { |
1719 | startDate: { | 1718 | startDate: { |
1720 | [ Op.gte ]: new Date(new Date().getTime() - (24 * 3600 * 1000) * trendingDays) | 1719 | [Op.gte]: new Date(new Date().getTime() - (24 * 3600 * 1000) * trendingDays) |
1721 | } | 1720 | } |
1722 | } | 1721 | } |
1723 | } | 1722 | } |
@@ -1800,23 +1799,23 @@ export class VideoModel extends Model<VideoModel> { | |||
1800 | } | 1799 | } |
1801 | 1800 | ||
1802 | static getCategoryLabel (id: number) { | 1801 | static getCategoryLabel (id: number) { |
1803 | return VIDEO_CATEGORIES[ id ] || 'Misc' | 1802 | return VIDEO_CATEGORIES[id] || 'Misc' |
1804 | } | 1803 | } |
1805 | 1804 | ||
1806 | static getLicenceLabel (id: number) { | 1805 | static getLicenceLabel (id: number) { |
1807 | return VIDEO_LICENCES[ id ] || 'Unknown' | 1806 | return VIDEO_LICENCES[id] || 'Unknown' |
1808 | } | 1807 | } |
1809 | 1808 | ||
1810 | static getLanguageLabel (id: string) { | 1809 | static getLanguageLabel (id: string) { |
1811 | return VIDEO_LANGUAGES[ id ] || 'Unknown' | 1810 | return VIDEO_LANGUAGES[id] || 'Unknown' |
1812 | } | 1811 | } |
1813 | 1812 | ||
1814 | static getPrivacyLabel (id: number) { | 1813 | static getPrivacyLabel (id: number) { |
1815 | return VIDEO_PRIVACIES[ id ] || 'Unknown' | 1814 | return VIDEO_PRIVACIES[id] || 'Unknown' |
1816 | } | 1815 | } |
1817 | 1816 | ||
1818 | static getStateLabel (id: number) { | 1817 | static getStateLabel (id: number) { |
1819 | return VIDEO_STATES[ id ] || 'Unknown' | 1818 | return VIDEO_STATES[id] || 'Unknown' |
1820 | } | 1819 | } |
1821 | 1820 | ||
1822 | isBlacklisted () { | 1821 | isBlacklisted () { |
@@ -1828,7 +1827,7 @@ export class VideoModel extends Model<VideoModel> { | |||
1828 | this.VideoChannel.Account.isBlocked() | 1827 | this.VideoChannel.Account.isBlocked() |
1829 | } | 1828 | } |
1830 | 1829 | ||
1831 | getQualityFileBy <T extends MVideoWithFile> (this: T, fun: (files: MVideoFile[], it: (file: MVideoFile) => number) => MVideoFile) { | 1830 | getQualityFileBy<T extends MVideoWithFile> (this: T, fun: (files: MVideoFile[], it: (file: MVideoFile) => number) => MVideoFile) { |
1832 | if (Array.isArray(this.VideoFiles) && this.VideoFiles.length !== 0) { | 1831 | if (Array.isArray(this.VideoFiles) && this.VideoFiles.length !== 0) { |
1833 | const file = fun(this.VideoFiles, file => file.resolution) | 1832 | const file = fun(this.VideoFiles, file => file.resolution) |
1834 | 1833 | ||
@@ -1846,15 +1845,15 @@ export class VideoModel extends Model<VideoModel> { | |||
1846 | return undefined | 1845 | return undefined |
1847 | } | 1846 | } |
1848 | 1847 | ||
1849 | getMaxQualityFile <T extends MVideoWithFile> (this: T): MVideoFileVideo | MVideoFileStreamingPlaylistVideo { | 1848 | getMaxQualityFile<T extends MVideoWithFile> (this: T): MVideoFileVideo | MVideoFileStreamingPlaylistVideo { |
1850 | return this.getQualityFileBy(maxBy) | 1849 | return this.getQualityFileBy(maxBy) |
1851 | } | 1850 | } |
1852 | 1851 | ||
1853 | getMinQualityFile <T extends MVideoWithFile> (this: T): MVideoFileVideo | MVideoFileStreamingPlaylistVideo { | 1852 | getMinQualityFile<T extends MVideoWithFile> (this: T): MVideoFileVideo | MVideoFileStreamingPlaylistVideo { |
1854 | return this.getQualityFileBy(minBy) | 1853 | return this.getQualityFileBy(minBy) |
1855 | } | 1854 | } |
1856 | 1855 | ||
1857 | getWebTorrentFile <T extends MVideoWithFile> (this: T, resolution: number): MVideoFileVideo { | 1856 | getWebTorrentFile<T extends MVideoWithFile> (this: T, resolution: number): MVideoFileVideo { |
1858 | if (Array.isArray(this.VideoFiles) === false) return undefined | 1857 | if (Array.isArray(this.VideoFiles) === false) return undefined |
1859 | 1858 | ||
1860 | const file = this.VideoFiles.find(f => f.resolution === resolution) | 1859 | const file = this.VideoFiles.find(f => f.resolution === resolution) |
@@ -1977,8 +1976,8 @@ export class VideoModel extends Model<VideoModel> { | |||
1977 | } | 1976 | } |
1978 | 1977 | ||
1979 | this.VideoStreamingPlaylists = this.VideoStreamingPlaylists | 1978 | this.VideoStreamingPlaylists = this.VideoStreamingPlaylists |
1980 | .filter(s => s.type !== VideoStreamingPlaylistType.HLS) | 1979 | .filter(s => s.type !== VideoStreamingPlaylistType.HLS) |
1981 | .concat(toAdd) | 1980 | .concat(toAdd) |
1982 | } | 1981 | } |
1983 | 1982 | ||
1984 | removeFile (videoFile: MVideoFile, isRedundancy = false) { | 1983 | removeFile (videoFile: MVideoFile, isRedundancy = false) { |
@@ -1999,7 +1998,7 @@ export class VideoModel extends Model<VideoModel> { | |||
1999 | await remove(directoryPath) | 1998 | await remove(directoryPath) |
2000 | 1999 | ||
2001 | if (isRedundancy !== true) { | 2000 | if (isRedundancy !== true) { |
2002 | let streamingPlaylistWithFiles = streamingPlaylist as MStreamingPlaylistFilesVideo | 2001 | const streamingPlaylistWithFiles = streamingPlaylist as MStreamingPlaylistFilesVideo |
2003 | streamingPlaylistWithFiles.Video = this | 2002 | streamingPlaylistWithFiles.Video = this |
2004 | 2003 | ||
2005 | if (!Array.isArray(streamingPlaylistWithFiles.VideoFiles)) { | 2004 | if (!Array.isArray(streamingPlaylistWithFiles.VideoFiles)) { |