]> git.immae.eu Git - github/Chocobozzz/PeerTube.git/blame - server/models/video/video.ts
Add messages about privacy concerns (P2P)
[github/Chocobozzz/PeerTube.git] / server / models / video / video.ts
CommitLineData
39445ead 1import * as Bluebird from 'bluebird'
53abc4c2 2import { map, maxBy, truncate } from 'lodash'
571389d4 3import * as magnetUtil from 'magnet-uri'
4d4e5cd4 4import * as parseTorrent from 'parse-torrent'
65fcc311 5import { join } from 'path'
e02643f3 6import * as Sequelize from 'sequelize'
3fd3ab2d 7import {
4ba3b8ea
C
8 AfterDestroy,
9 AllowNull,
10 BeforeDestroy,
11 BelongsTo,
12 BelongsToMany,
13 Column,
14 CreatedAt,
15 DataType,
16 Default,
17 ForeignKey,
18 HasMany,
19 IFindOptions,
20 Is,
21 IsInt,
22 IsUUID,
23 Min,
24 Model,
25 Scopes,
26 Table,
27 UpdatedAt
3fd3ab2d 28} from 'sequelize-typescript'
571389d4 29import { VideoPrivacy, VideoResolution } from '../../../shared'
3fd3ab2d 30import { VideoTorrentObject } from '../../../shared/models/activitypub/objects'
d48ff09d 31import { Video, VideoDetails } from '../../../shared/models/videos'
da854ddd
C
32import { activityPubCollection } from '../../helpers/activitypub'
33import { createTorrentPromise, renamePromise, statPromise, unlinkPromise, writeFilePromise } from '../../helpers/core-utils'
34import { isActivityPubUrlValid } from '../../helpers/custom-validators/activitypub/misc'
47564bbe 35import { isBooleanValid } from '../../helpers/custom-validators/misc'
3fd3ab2d 36import {
4ba3b8ea
C
37 isVideoCategoryValid,
38 isVideoDescriptionValid,
39 isVideoDurationValid,
40 isVideoLanguageValid,
41 isVideoLicenceValid,
42 isVideoNameValid,
2422c46b 43 isVideoPrivacyValid, isVideoSupportValid
3fd3ab2d 44} from '../../helpers/custom-validators/videos'
056aa7f2 45import { generateImageFromVideoFile, getVideoFileResolution, transcode } from '../../helpers/ffmpeg-utils'
da854ddd 46import { logger } from '../../helpers/logger'
f05a1c30 47import { getServerActor } from '../../helpers/utils'
65fcc311 48import {
4ba3b8ea
C
49 API_VERSION,
50 CONFIG,
51 CONSTRAINTS_FIELDS,
52 PREVIEWS_SIZE,
53 REMOTE_SCHEME,
54 STATIC_PATHS,
55 THUMBNAILS_SIZE,
56 VIDEO_CATEGORIES,
57 VIDEO_LANGUAGES,
58 VIDEO_LICENCES,
59 VIDEO_PRIVACIES
3fd3ab2d 60} from '../../initializers'
46531a0a
C
61import {
62 getVideoCommentsActivityPubUrl,
63 getVideoDislikesActivityPubUrl,
64 getVideoLikesActivityPubUrl,
65 getVideoSharesActivityPubUrl
66} from '../../lib/activitypub'
50d6de9c 67import { sendDeleteVideo } from '../../lib/activitypub/send'
3fd3ab2d
C
68import { AccountModel } from '../account/account'
69import { AccountVideoRateModel } from '../account/account-video-rate'
50d6de9c 70import { ActorModel } from '../activitypub/actor'
b6a4fd6b 71import { AvatarModel } from '../avatar/avatar'
3fd3ab2d
C
72import { ServerModel } from '../server/server'
73import { getSort, throwIfNotValid } from '../utils'
74import { TagModel } from './tag'
75import { VideoAbuseModel } from './video-abuse'
76import { VideoChannelModel } from './video-channel'
da854ddd 77import { VideoCommentModel } from './video-comment'
3fd3ab2d
C
78import { VideoFileModel } from './video-file'
79import { VideoShareModel } from './video-share'
80import { VideoTagModel } from './video-tag'
81
d48ff09d 82enum ScopeNames {
50d6de9c 83 AVAILABLE_FOR_LIST = 'AVAILABLE_FOR_LIST',
4cb6d457 84 WITH_ACCOUNT_DETAILS = 'WITH_ACCOUNT_DETAILS',
d48ff09d
C
85 WITH_TAGS = 'WITH_TAGS',
86 WITH_FILES = 'WITH_FILES',
87 WITH_SHARES = 'WITH_SHARES',
da854ddd
C
88 WITH_RATES = 'WITH_RATES',
89 WITH_COMMENTS = 'WITH_COMMENTS'
d48ff09d
C
90}
91
92@Scopes({
f05a1c30 93 [ScopeNames.AVAILABLE_FOR_LIST]: (actorId: number) => ({
d48ff09d
C
94 where: {
95 id: {
96 [Sequelize.Op.notIn]: Sequelize.literal(
97 '(SELECT "videoBlacklist"."videoId" FROM "videoBlacklist")'
2d9ab590
C
98 ),
99 [ Sequelize.Op.in ]: Sequelize.literal(
100 '(' +
101 'SELECT "videoShare"."videoId" AS "id" FROM "videoShare" ' +
102 'INNER JOIN "actorFollow" ON "actorFollow"."targetActorId" = "videoShare"."actorId" ' +
103 'WHERE "actorFollow"."actorId" = ' + parseInt(actorId.toString(), 10) +
104 ' UNION ' +
105 'SELECT "video"."id" AS "id" FROM "video" ' +
106 'INNER JOIN "videoChannel" ON "videoChannel"."id" = "video"."channelId" ' +
107 'INNER JOIN "account" ON "account"."id" = "videoChannel"."accountId" ' +
108 'INNER JOIN "actor" ON "account"."actorId" = "actor"."id" ' +
109 'LEFT JOIN "actorFollow" ON "actorFollow"."targetActorId" = "actor"."id" ' +
110 'WHERE "actor"."serverId" IS NULL OR "actorFollow"."actorId" = ' + parseInt(actorId.toString(), 10) +
111 ')'
d48ff09d 112 )
50d6de9c 113 },
2d9ab590 114 privacy: VideoPrivacy.PUBLIC
f05a1c30 115 },
4cb6d457
C
116 include: [
117 {
f05a1c30
C
118 attributes: [ 'name', 'description' ],
119 model: VideoChannelModel.unscoped(),
4cb6d457
C
120 required: true,
121 include: [
122 {
123 attributes: [ 'name' ],
f05a1c30 124 model: AccountModel.unscoped(),
4cb6d457
C
125 required: true,
126 include: [
127 {
128 attributes: [ 'serverId' ],
f05a1c30 129 model: ActorModel.unscoped(),
4cb6d457
C
130 required: true,
131 include: [
132 {
f05a1c30 133 attributes: [ 'host' ],
2d9ab590 134 model: ServerModel.unscoped()
4cb6d457
C
135 }
136 ]
137 }
138 ]
139 }
140 ]
141 }
142 ]
f05a1c30 143 }),
4cb6d457 144 [ScopeNames.WITH_ACCOUNT_DETAILS]: {
d48ff09d
C
145 include: [
146 {
6120941f 147 model: () => VideoChannelModel.unscoped(),
d48ff09d
C
148 required: true,
149 include: [
6120941f
C
150 {
151 attributes: {
152 exclude: [ 'privateKey', 'publicKey' ]
153 },
3e500247
C
154 model: () => ActorModel.unscoped(),
155 required: true,
156 include: [
157 {
158 attributes: [ 'host' ],
159 model: () => ServerModel.unscoped(),
160 required: false
161 }
162 ]
6120941f 163 },
d48ff09d 164 {
3e500247 165 model: () => AccountModel.unscoped(),
d48ff09d
C
166 required: true,
167 include: [
168 {
3e500247 169 model: () => ActorModel.unscoped(),
6120941f
C
170 attributes: {
171 exclude: [ 'privateKey', 'publicKey' ]
172 },
50d6de9c
C
173 required: true,
174 include: [
175 {
3e500247
C
176 attributes: [ 'host' ],
177 model: () => ServerModel.unscoped(),
50d6de9c 178 required: false
b6a4fd6b
C
179 },
180 {
181 model: () => AvatarModel.unscoped(),
182 required: false
50d6de9c
C
183 }
184 ]
d48ff09d
C
185 }
186 ]
187 }
188 ]
189 }
190 ]
191 },
192 [ScopeNames.WITH_TAGS]: {
193 include: [ () => TagModel ]
194 },
195 [ScopeNames.WITH_FILES]: {
196 include: [
197 {
198 model: () => VideoFileModel,
199 required: true
200 }
201 ]
202 },
203 [ScopeNames.WITH_SHARES]: {
204 include: [
205 {
206 model: () => VideoShareModel,
50d6de9c 207 include: [ () => ActorModel ]
d48ff09d
C
208 }
209 ]
210 },
211 [ScopeNames.WITH_RATES]: {
212 include: [
213 {
214 model: () => AccountVideoRateModel,
215 include: [ () => AccountModel ]
216 }
217 ]
da854ddd
C
218 },
219 [ScopeNames.WITH_COMMENTS]: {
220 include: [
221 {
222 model: () => VideoCommentModel
223 }
224 ]
d48ff09d
C
225 }
226})
3fd3ab2d
C
227@Table({
228 tableName: 'video',
229 indexes: [
feb4bdfd 230 {
3fd3ab2d 231 fields: [ 'name' ]
feb4bdfd
C
232 },
233 {
3fd3ab2d
C
234 fields: [ 'createdAt' ]
235 },
236 {
237 fields: [ 'duration' ]
238 },
239 {
240 fields: [ 'views' ]
241 },
242 {
243 fields: [ 'likes' ]
244 },
245 {
246 fields: [ 'uuid' ]
247 },
248 {
249 fields: [ 'channelId' ]
4cb6d457
C
250 },
251 {
252 fields: [ 'id', 'privacy' ]
2ccaeeb3
C
253 },
254 {
255 fields: [ 'url'],
256 unique: true
feb4bdfd 257 }
e02643f3 258 ]
3fd3ab2d
C
259})
260export class VideoModel extends Model<VideoModel> {
261
262 @AllowNull(false)
263 @Default(DataType.UUIDV4)
264 @IsUUID(4)
265 @Column(DataType.UUID)
266 uuid: string
267
268 @AllowNull(false)
269 @Is('VideoName', value => throwIfNotValid(value, isVideoNameValid, 'name'))
270 @Column
271 name: string
272
273 @AllowNull(true)
274 @Default(null)
275 @Is('VideoCategory', value => throwIfNotValid(value, isVideoCategoryValid, 'category'))
276 @Column
277 category: number
278
279 @AllowNull(true)
280 @Default(null)
281 @Is('VideoLicence', value => throwIfNotValid(value, isVideoLicenceValid, 'licence'))
282 @Column
283 licence: number
284
285 @AllowNull(true)
286 @Default(null)
287 @Is('VideoLanguage', value => throwIfNotValid(value, isVideoLanguageValid, 'language'))
288 @Column
289 language: number
290
291 @AllowNull(false)
292 @Is('VideoPrivacy', value => throwIfNotValid(value, isVideoPrivacyValid, 'privacy'))
293 @Column
294 privacy: number
295
296 @AllowNull(false)
47564bbe 297 @Is('VideoNSFW', value => throwIfNotValid(value, isBooleanValid, 'NSFW boolean'))
3fd3ab2d
C
298 @Column
299 nsfw: boolean
300
301 @AllowNull(true)
302 @Default(null)
303 @Is('VideoDescription', value => throwIfNotValid(value, isVideoDescriptionValid, 'description'))
304 @Column(DataType.STRING(CONSTRAINTS_FIELDS.VIDEOS.DESCRIPTION.max))
305 description: string
306
2422c46b
C
307 @AllowNull(true)
308 @Default(null)
309 @Is('VideoSupport', value => throwIfNotValid(value, isVideoSupportValid, 'support'))
310 @Column(DataType.STRING(CONSTRAINTS_FIELDS.VIDEOS.SUPPORT.max))
311 support: string
312
3fd3ab2d
C
313 @AllowNull(false)
314 @Is('VideoDuration', value => throwIfNotValid(value, isVideoDurationValid, 'duration'))
315 @Column
316 duration: number
317
318 @AllowNull(false)
319 @Default(0)
320 @IsInt
321 @Min(0)
322 @Column
323 views: number
324
325 @AllowNull(false)
326 @Default(0)
327 @IsInt
328 @Min(0)
329 @Column
330 likes: number
331
332 @AllowNull(false)
333 @Default(0)
334 @IsInt
335 @Min(0)
336 @Column
337 dislikes: number
338
339 @AllowNull(false)
340 @Column
341 remote: boolean
342
343 @AllowNull(false)
344 @Is('VideoUrl', value => throwIfNotValid(value, isActivityPubUrlValid, 'url'))
345 @Column(DataType.STRING(CONSTRAINTS_FIELDS.VIDEOS.URL.max))
346 url: string
347
47564bbe
C
348 @AllowNull(false)
349 @Column
350 commentsEnabled: boolean
351
3fd3ab2d
C
352 @CreatedAt
353 createdAt: Date
354
355 @UpdatedAt
356 updatedAt: Date
357
358 @ForeignKey(() => VideoChannelModel)
359 @Column
360 channelId: number
361
362 @BelongsTo(() => VideoChannelModel, {
feb4bdfd 363 foreignKey: {
50d6de9c 364 allowNull: true
feb4bdfd
C
365 },
366 onDelete: 'cascade'
367 })
3fd3ab2d 368 VideoChannel: VideoChannelModel
7920c273 369
3fd3ab2d 370 @BelongsToMany(() => TagModel, {
7920c273 371 foreignKey: 'videoId',
3fd3ab2d
C
372 through: () => VideoTagModel,
373 onDelete: 'CASCADE'
7920c273 374 })
3fd3ab2d 375 Tags: TagModel[]
55fa55a9 376
3fd3ab2d 377 @HasMany(() => VideoAbuseModel, {
55fa55a9
C
378 foreignKey: {
379 name: 'videoId',
380 allowNull: false
381 },
382 onDelete: 'cascade'
383 })
3fd3ab2d 384 VideoAbuses: VideoAbuseModel[]
93e1258c 385
3fd3ab2d 386 @HasMany(() => VideoFileModel, {
93e1258c
C
387 foreignKey: {
388 name: 'videoId',
389 allowNull: false
390 },
391 onDelete: 'cascade'
392 })
3fd3ab2d 393 VideoFiles: VideoFileModel[]
e71bcc0f 394
3fd3ab2d 395 @HasMany(() => VideoShareModel, {
e71bcc0f
C
396 foreignKey: {
397 name: 'videoId',
398 allowNull: false
399 },
400 onDelete: 'cascade'
401 })
3fd3ab2d 402 VideoShares: VideoShareModel[]
16b90975 403
3fd3ab2d 404 @HasMany(() => AccountVideoRateModel, {
16b90975
C
405 foreignKey: {
406 name: 'videoId',
407 allowNull: false
408 },
409 onDelete: 'cascade'
410 })
3fd3ab2d 411 AccountVideoRates: AccountVideoRateModel[]
f285faa0 412
da854ddd
C
413 @HasMany(() => VideoCommentModel, {
414 foreignKey: {
415 name: 'videoId',
416 allowNull: false
417 },
f05a1c30
C
418 onDelete: 'cascade',
419 hooks: true
da854ddd
C
420 })
421 VideoComments: VideoCommentModel[]
422
f05a1c30
C
423 @BeforeDestroy
424 static async sendDelete (instance: VideoModel, options) {
425 if (instance.isOwned()) {
426 if (!instance.VideoChannel) {
427 instance.VideoChannel = await instance.$get('VideoChannel', {
428 include: [
429 {
430 model: AccountModel,
431 include: [ ActorModel ]
432 }
433 ],
434 transaction: options.transaction
435 }) as VideoChannelModel
436 }
437
438 logger.debug('Sending delete of video %s.', instance.url)
439
440 return sendDeleteVideo(instance, options.transaction)
441 }
442
443 return undefined
444 }
445
3fd3ab2d 446 @AfterDestroy
f05a1c30
C
447 static async removeFilesAndSendDelete (instance: VideoModel) {
448 const tasks: Promise<any>[] = []
f285faa0 449
f05a1c30 450 tasks.push(instance.removeThumbnail())
93e1258c 451
3fd3ab2d 452 if (instance.isOwned()) {
f05a1c30
C
453 if (!Array.isArray(instance.VideoFiles)) {
454 instance.VideoFiles = await instance.$get('VideoFiles') as VideoFileModel[]
455 }
456
457 tasks.push(instance.removePreview())
40298b02 458
3fd3ab2d
C
459 // Remove physical files and torrents
460 instance.VideoFiles.forEach(file => {
461 tasks.push(instance.removeFile(file))
462 tasks.push(instance.removeTorrent(file))
463 })
464 }
40298b02 465
3fd3ab2d
C
466 return Promise.all(tasks)
467 .catch(err => {
468 logger.error('Some errors when removing files of video %s in after destroy hook.', instance.uuid, err)
469 })
470 }
f285faa0 471
3fd3ab2d 472 static list () {
d48ff09d 473 return VideoModel.scope(ScopeNames.WITH_FILES).findAll()
3fd3ab2d 474 }
f285faa0 475
50d6de9c 476 static listAllAndSharedByActorForOutbox (actorId: number, start: number, count: number) {
3fd3ab2d
C
477 function getRawQuery (select: string) {
478 const queryVideo = 'SELECT ' + select + ' FROM "video" AS "Video" ' +
479 'INNER JOIN "videoChannel" AS "VideoChannel" ON "VideoChannel"."id" = "Video"."channelId" ' +
50d6de9c
C
480 'INNER JOIN "account" AS "Account" ON "Account"."id" = "VideoChannel"."accountId" ' +
481 'WHERE "Account"."actorId" = ' + actorId
3fd3ab2d
C
482 const queryVideoShare = 'SELECT ' + select + ' FROM "videoShare" AS "VideoShare" ' +
483 'INNER JOIN "video" AS "Video" ON "Video"."id" = "VideoShare"."videoId" ' +
50d6de9c 484 'WHERE "VideoShare"."actorId" = ' + actorId
558d7c23 485
3fd3ab2d
C
486 return `(${queryVideo}) UNION (${queryVideoShare})`
487 }
aaf61f38 488
3fd3ab2d
C
489 const rawQuery = getRawQuery('"Video"."id"')
490 const rawCountQuery = getRawQuery('COUNT("Video"."id") as "total"')
491
492 const query = {
493 distinct: true,
494 offset: start,
495 limit: count,
3bb6c526 496 order: getSort('createdAt', [ 'Tags', 'name', 'ASC' ]),
3fd3ab2d
C
497 where: {
498 id: {
499 [Sequelize.Op.in]: Sequelize.literal('(' + rawQuery + ')')
3c75ce12
C
500 },
501 [Sequelize.Op.or]: [
502 { privacy: VideoPrivacy.PUBLIC },
503 { privacy: VideoPrivacy.UNLISTED }
504 ]
3fd3ab2d
C
505 },
506 include: [
507 {
1d230c44 508 attributes: [ 'id', 'url' ],
2c897999 509 model: VideoShareModel.unscoped(),
3fd3ab2d
C
510 required: false,
511 where: {
512 [Sequelize.Op.and]: [
513 {
514 id: {
515 [Sequelize.Op.not]: null
516 }
517 },
518 {
50d6de9c 519 actorId
3fd3ab2d
C
520 }
521 ]
522 },
50d6de9c
C
523 include: [
524 {
2c897999
C
525 attributes: [ 'id', 'url' ],
526 model: ActorModel.unscoped()
50d6de9c
C
527 }
528 ]
3fd3ab2d
C
529 },
530 {
2c897999 531 model: VideoChannelModel.unscoped(),
3fd3ab2d
C
532 required: true,
533 include: [
534 {
2c897999
C
535 attributes: [ 'name' ],
536 model: AccountModel.unscoped(),
537 required: true,
538 include: [
539 {
540 attributes: [ 'id', 'url' ],
541 model: ActorModel.unscoped(),
542 required: true
543 }
544 ]
545 },
546 {
547 attributes: [ 'id', 'url' ],
548 model: ActorModel.unscoped(),
3fd3ab2d
C
549 required: true
550 }
551 ]
552 },
553 {
2c897999 554 attributes: [ 'type' ],
3fd3ab2d 555 model: AccountVideoRateModel,
2c897999
C
556 required: false,
557 include: [
558 {
559 attributes: [ 'id' ],
560 model: AccountModel.unscoped(),
561 include: [
562 {
563 attributes: [ 'url' ],
564 model: ActorModel.unscoped(),
565 include: [
566 {
567 attributes: [ 'host' ],
568 model: ServerModel,
569 required: false
570 }
571 ]
572 }
573 ]
574 }
575 ]
576 },
577 {
578 attributes: [ 'url' ],
579 model: VideoCommentModel,
580 required: false
3fd3ab2d
C
581 },
582 VideoFileModel,
2c897999 583 TagModel
3fd3ab2d
C
584 ]
585 }
164174a6 586
3fd3ab2d
C
587 return Bluebird.all([
588 // FIXME: typing issue
589 VideoModel.findAll(query as any),
590 VideoModel.sequelize.query(rawCountQuery, { type: Sequelize.QueryTypes.SELECT })
591 ]).then(([ rows, totals ]) => {
592 // totals: totalVideos + totalVideoShares
593 let totalVideos = 0
594 let totalVideoShares = 0
595 if (totals[0]) totalVideos = parseInt(totals[0].total, 10)
596 if (totals[1]) totalVideoShares = parseInt(totals[1].total, 10)
597
598 const total = totalVideos + totalVideoShares
599 return {
600 data: rows,
601 total: total
602 }
603 })
604 }
93e1258c 605
3fd3ab2d
C
606 static listUserVideosForApi (userId: number, start: number, count: number, sort: string) {
607 const query = {
3fd3ab2d
C
608 offset: start,
609 limit: count,
3bb6c526 610 order: getSort(sort),
3fd3ab2d
C
611 include: [
612 {
613 model: VideoChannelModel,
614 required: true,
615 include: [
616 {
617 model: AccountModel,
618 where: {
619 userId
620 },
621 required: true
622 }
623 ]
d48ff09d 624 }
3fd3ab2d
C
625 ]
626 }
d8755eed 627
3fd3ab2d
C
628 return VideoModel.findAndCountAll(query).then(({ rows, count }) => {
629 return {
630 data: rows,
631 total: count
632 }
633 })
634 }
93e1258c 635
f05a1c30 636 static async listForApi (start: number, count: number, sort: string) {
3fd3ab2d 637 const query = {
3fd3ab2d
C
638 offset: start,
639 limit: count,
6ff9c676 640 order: getSort(sort)
3fd3ab2d 641 }
93e1258c 642
f05a1c30
C
643 const serverActor = await getServerActor()
644
645 return VideoModel.scope({ method: [ ScopeNames.AVAILABLE_FOR_LIST, serverActor.id ] })
d48ff09d
C
646 .findAndCountAll(query)
647 .then(({ rows, count }) => {
648 return {
649 data: rows,
650 total: count
651 }
652 })
93e1258c
C
653 }
654
f05a1c30
C
655 static async searchAndPopulateAccountAndServerAndTags (value: string, start: number, count: number, sort: string) {
656 const query: IFindOptions<VideoModel> = {
657 offset: start,
658 limit: count,
3bb6c526 659 order: getSort(sort),
f05a1c30
C
660 where: {
661 name: {
662 [Sequelize.Op.iLike]: '%' + value + '%'
663 }
664 }
665 }
666
667 const serverActor = await getServerActor()
668
669 return VideoModel.scope({ method: [ ScopeNames.AVAILABLE_FOR_LIST, serverActor.id ] })
670 .findAndCountAll(query).then(({ rows, count }) => {
671 return {
672 data: rows,
673 total: count
674 }
675 })
676 }
677
3fd3ab2d
C
678 static load (id: number) {
679 return VideoModel.findById(id)
680 }
fdbda9e3 681
3fd3ab2d
C
682 static loadByUrlAndPopulateAccount (url: string, t?: Sequelize.Transaction) {
683 const query: IFindOptions<VideoModel> = {
684 where: {
685 url
d48ff09d 686 }
3fd3ab2d 687 }
d8755eed 688
3fd3ab2d 689 if (t !== undefined) query.transaction = t
d8755eed 690
4cb6d457 691 return VideoModel.scope([ ScopeNames.WITH_ACCOUNT_DETAILS, ScopeNames.WITH_FILES ]).findOne(query)
3fd3ab2d 692 }
d8755eed 693
2ccaeeb3 694 static loadByUUIDOrURLAndPopulateAccount (uuid: string, url: string, t?: Sequelize.Transaction) {
3fd3ab2d
C
695 const query: IFindOptions<VideoModel> = {
696 where: {
697 [Sequelize.Op.or]: [
698 { uuid },
699 { url }
700 ]
d48ff09d 701 }
3fd3ab2d 702 }
feb4bdfd 703
3fd3ab2d 704 if (t !== undefined) query.transaction = t
feb4bdfd 705
2ccaeeb3 706 return VideoModel.scope([ ScopeNames.WITH_ACCOUNT_DETAILS, ScopeNames.WITH_FILES ]).findOne(query)
72c7248b
C
707 }
708
3fd3ab2d
C
709 static loadAndPopulateAccountAndServerAndTags (id: number) {
710 const options = {
d48ff09d 711 order: [ [ 'Tags', 'name', 'ASC' ] ]
3fd3ab2d 712 }
72c7248b 713
d48ff09d 714 return VideoModel
4cb6d457 715 .scope([ ScopeNames.WITH_TAGS, ScopeNames.WITH_FILES, ScopeNames.WITH_ACCOUNT_DETAILS ])
d48ff09d 716 .findById(id, options)
3fd3ab2d 717 }
72c7248b 718
8fa5653a
C
719 static loadByUUID (uuid: string) {
720 const options = {
721 where: {
722 uuid
723 }
724 }
725
726 return VideoModel
727 .scope([ ScopeNames.WITH_FILES ])
728 .findOne(options)
729 }
730
3fd3ab2d
C
731 static loadByUUIDAndPopulateAccountAndServerAndTags (uuid: string) {
732 const options = {
733 order: [ [ 'Tags', 'name', 'ASC' ] ],
734 where: {
735 uuid
d48ff09d 736 }
3fd3ab2d 737 }
fd45e8f4 738
d48ff09d 739 return VideoModel
4cb6d457 740 .scope([ ScopeNames.WITH_TAGS, ScopeNames.WITH_FILES, ScopeNames.WITH_ACCOUNT_DETAILS ])
da854ddd
C
741 .findOne(options)
742 }
743
744 static loadAndPopulateAll (id: number) {
745 const options = {
746 order: [ [ 'Tags', 'name', 'ASC' ] ],
747 where: {
748 id
749 }
750 }
751
752 return VideoModel
753 .scope([
754 ScopeNames.WITH_RATES,
755 ScopeNames.WITH_SHARES,
756 ScopeNames.WITH_TAGS,
757 ScopeNames.WITH_FILES,
4cb6d457 758 ScopeNames.WITH_ACCOUNT_DETAILS,
da854ddd
C
759 ScopeNames.WITH_COMMENTS
760 ])
d48ff09d 761 .findOne(options)
aaf61f38
C
762 }
763
3fd3ab2d
C
764 getOriginalFile () {
765 if (Array.isArray(this.VideoFiles) === false) return undefined
aaf61f38 766
3fd3ab2d
C
767 // The original file is the file that have the higher resolution
768 return maxBy(this.VideoFiles, file => file.resolution)
e4f97bab 769 }
aaf61f38 770
3fd3ab2d
C
771 getVideoFilename (videoFile: VideoFileModel) {
772 return this.uuid + '-' + videoFile.resolution + videoFile.extname
773 }
165cdc75 774
3fd3ab2d
C
775 getThumbnailName () {
776 // We always have a copy of the thumbnail
777 const extension = '.jpg'
778 return this.uuid + extension
7b1f49de
C
779 }
780
3fd3ab2d
C
781 getPreviewName () {
782 const extension = '.jpg'
783 return this.uuid + extension
784 }
7b1f49de 785
3fd3ab2d
C
786 getTorrentFileName (videoFile: VideoFileModel) {
787 const extension = '.torrent'
788 return this.uuid + '-' + videoFile.resolution + extension
789 }
8e7f08b5 790
3fd3ab2d
C
791 isOwned () {
792 return this.remote === false
9567011b
C
793 }
794
3fd3ab2d 795 createPreview (videoFile: VideoFileModel) {
3fd3ab2d
C
796 return generateImageFromVideoFile(
797 this.getVideoFilePath(videoFile),
798 CONFIG.STORAGE.PREVIEWS_DIR,
799 this.getPreviewName(),
26670720 800 PREVIEWS_SIZE
3fd3ab2d
C
801 )
802 }
9567011b 803
3fd3ab2d 804 createThumbnail (videoFile: VideoFileModel) {
3fd3ab2d
C
805 return generateImageFromVideoFile(
806 this.getVideoFilePath(videoFile),
807 CONFIG.STORAGE.THUMBNAILS_DIR,
808 this.getThumbnailName(),
26670720 809 THUMBNAILS_SIZE
3fd3ab2d 810 )
14d3270f
C
811 }
812
3fd3ab2d
C
813 getVideoFilePath (videoFile: VideoFileModel) {
814 return join(CONFIG.STORAGE.VIDEOS_DIR, this.getVideoFilename(videoFile))
815 }
14d3270f 816
3fd3ab2d
C
817 createTorrentAndSetInfoHash = async function (videoFile: VideoFileModel) {
818 const options = {
819 announceList: [
0edf0581
C
820 [ CONFIG.WEBSERVER.WS + '://' + CONFIG.WEBSERVER.HOSTNAME + ':' + CONFIG.WEBSERVER.PORT + '/tracker/socket' ],
821 [ CONFIG.WEBSERVER.URL + '/tracker/announce' ]
3fd3ab2d
C
822 ],
823 urlList: [
824 CONFIG.WEBSERVER.URL + STATIC_PATHS.WEBSEED + this.getVideoFilename(videoFile)
825 ]
826 }
14d3270f 827
3fd3ab2d 828 const torrent = await createTorrentPromise(this.getVideoFilePath(videoFile), options)
e4f97bab 829
3fd3ab2d
C
830 const filePath = join(CONFIG.STORAGE.TORRENTS_DIR, this.getTorrentFileName(videoFile))
831 logger.info('Creating torrent %s.', filePath)
e4f97bab 832
3fd3ab2d 833 await writeFilePromise(filePath, torrent)
e4f97bab 834
3fd3ab2d
C
835 const parsedTorrent = parseTorrent(torrent)
836 videoFile.infoHash = parsedTorrent.infoHash
837 }
e4f97bab 838
3fd3ab2d
C
839 getEmbedPath () {
840 return '/videos/embed/' + this.uuid
841 }
e4f97bab 842
3fd3ab2d
C
843 getThumbnailPath () {
844 return join(STATIC_PATHS.THUMBNAILS, this.getThumbnailName())
e4f97bab 845 }
227d02fe 846
3fd3ab2d
C
847 getPreviewPath () {
848 return join(STATIC_PATHS.PREVIEWS, this.getPreviewName())
849 }
40298b02 850
2422c46b 851 toFormattedJSON (): Video {
3fd3ab2d 852 let serverHost
40298b02 853
50d6de9c
C
854 if (this.VideoChannel.Account.Actor.Server) {
855 serverHost = this.VideoChannel.Account.Actor.Server.host
3fd3ab2d
C
856 } else {
857 // It means it's our video
858 serverHost = CONFIG.WEBSERVER.HOST
859 }
14d3270f 860
3fd3ab2d
C
861 return {
862 id: this.id,
863 uuid: this.uuid,
864 name: this.name,
865 category: this.category,
866 categoryLabel: this.getCategoryLabel(),
867 licence: this.licence,
868 licenceLabel: this.getLicenceLabel(),
869 language: this.language,
870 languageLabel: this.getLanguageLabel(),
871 nsfw: this.nsfw,
872 description: this.getTruncatedDescription(),
873 serverHost,
874 isLocal: this.isOwned(),
875 accountName: this.VideoChannel.Account.name,
876 duration: this.duration,
877 views: this.views,
878 likes: this.likes,
879 dislikes: this.dislikes,
3fd3ab2d
C
880 thumbnailPath: this.getThumbnailPath(),
881 previewPath: this.getPreviewPath(),
882 embedPath: this.getEmbedPath(),
883 createdAt: this.createdAt,
884 updatedAt: this.updatedAt
2422c46b 885 }
14d3270f 886 }
14d3270f 887
2422c46b 888 toFormattedDetailsJSON (): VideoDetails {
3fd3ab2d 889 const formattedJson = this.toFormattedJSON()
e4f97bab 890
3fd3ab2d
C
891 // Maybe our server is not up to date and there are new privacy settings since our version
892 let privacyLabel = VIDEO_PRIVACIES[this.privacy]
893 if (!privacyLabel) privacyLabel = 'Unknown'
e4f97bab 894
3fd3ab2d
C
895 const detailsJson = {
896 privacyLabel,
897 privacy: this.privacy,
2422c46b 898 support: this.support,
3fd3ab2d
C
899 descriptionPath: this.getDescriptionPath(),
900 channel: this.VideoChannel.toFormattedJSON(),
901 account: this.VideoChannel.Account.toFormattedJSON(),
d48ff09d 902 tags: map<TagModel, string>(this.Tags, 'name'),
47564bbe 903 commentsEnabled: this.commentsEnabled,
3fd3ab2d
C
904 files: []
905 }
e4f97bab 906
3fd3ab2d
C
907 // Format and sort video files
908 const { baseUrlHttp, baseUrlWs } = this.getBaseUrls()
909 detailsJson.files = this.VideoFiles
910 .map(videoFile => {
911 let resolutionLabel = videoFile.resolution + 'p'
912
913 return {
914 resolution: videoFile.resolution,
915 resolutionLabel,
916 magnetUri: this.generateMagnetUri(videoFile, baseUrlHttp, baseUrlWs),
917 size: videoFile.size,
918 torrentUrl: this.getTorrentUrl(videoFile, baseUrlHttp),
919 fileUrl: this.getVideoFileUrl(videoFile, baseUrlHttp)
920 }
921 })
922 .sort((a, b) => {
923 if (a.resolution < b.resolution) return 1
924 if (a.resolution === b.resolution) return 0
925 return -1
926 })
927
2422c46b 928 return Object.assign(formattedJson, detailsJson)
3fd3ab2d 929 }
e4f97bab 930
3fd3ab2d
C
931 toActivityPubObject (): VideoTorrentObject {
932 const { baseUrlHttp, baseUrlWs } = this.getBaseUrls()
933 if (!this.Tags) this.Tags = []
e4f97bab 934
3fd3ab2d
C
935 const tag = this.Tags.map(t => ({
936 type: 'Hashtag' as 'Hashtag',
937 name: t.name
938 }))
40298b02 939
3fd3ab2d
C
940 let language
941 if (this.language) {
942 language = {
943 identifier: this.language + '',
944 name: this.getLanguageLabel()
945 }
946 }
40298b02 947
3fd3ab2d
C
948 let category
949 if (this.category) {
950 category = {
951 identifier: this.category + '',
952 name: this.getCategoryLabel()
953 }
954 }
40298b02 955
3fd3ab2d
C
956 let licence
957 if (this.licence) {
958 licence = {
959 identifier: this.licence + '',
960 name: this.getLicenceLabel()
961 }
962 }
9567011b 963
3fd3ab2d
C
964 let likesObject
965 let dislikesObject
e4f97bab 966
3fd3ab2d 967 if (Array.isArray(this.AccountVideoRates)) {
46531a0a
C
968 const res = this.toRatesActivityPubObjects()
969 likesObject = res.likesObject
970 dislikesObject = res.dislikesObject
3fd3ab2d 971 }
e4f97bab 972
3fd3ab2d
C
973 let sharesObject
974 if (Array.isArray(this.VideoShares)) {
46531a0a 975 sharesObject = this.toAnnouncesActivityPubObject()
3fd3ab2d 976 }
93e1258c 977
da854ddd
C
978 let commentsObject
979 if (Array.isArray(this.VideoComments)) {
46531a0a 980 commentsObject = this.toCommentsActivityPubObject()
da854ddd
C
981 }
982
3fd3ab2d
C
983 const url = []
984 for (const file of this.VideoFiles) {
985 url.push({
986 type: 'Link',
987 mimeType: 'video/' + file.extname.replace('.', ''),
9fb3abfd 988 href: this.getVideoFileUrl(file, baseUrlHttp),
3fd3ab2d
C
989 width: file.resolution,
990 size: file.size
991 })
992
993 url.push({
994 type: 'Link',
995 mimeType: 'application/x-bittorrent',
9fb3abfd 996 href: this.getTorrentUrl(file, baseUrlHttp),
3fd3ab2d
C
997 width: file.resolution
998 })
999
1000 url.push({
1001 type: 'Link',
1002 mimeType: 'application/x-bittorrent;x-scheme-handler/magnet',
9fb3abfd 1003 href: this.generateMagnetUri(file, baseUrlHttp, baseUrlWs),
3fd3ab2d
C
1004 width: file.resolution
1005 })
1006 }
93e1258c 1007
3fd3ab2d
C
1008 // Add video url too
1009 url.push({
1010 type: 'Link',
1011 mimeType: 'text/html',
9fb3abfd 1012 href: CONFIG.WEBSERVER.URL + '/videos/watch/' + this.uuid
3fd3ab2d 1013 })
93e1258c 1014
3fd3ab2d
C
1015 return {
1016 type: 'Video' as 'Video',
1017 id: this.url,
1018 name: this.name,
093237cf 1019 duration: this.getActivityStreamDuration(),
3fd3ab2d
C
1020 uuid: this.uuid,
1021 tag,
1022 category,
1023 licence,
1024 language,
1025 views: this.views,
0a67e28b 1026 sensitive: this.nsfw,
47564bbe 1027 commentsEnabled: this.commentsEnabled,
3fd3ab2d
C
1028 published: this.createdAt.toISOString(),
1029 updated: this.updatedAt.toISOString(),
1030 mediaType: 'text/markdown',
1031 content: this.getTruncatedDescription(),
2422c46b 1032 support: this.support,
3fd3ab2d
C
1033 icon: {
1034 type: 'Image',
1035 url: this.getThumbnailUrl(baseUrlHttp),
1036 mediaType: 'image/jpeg',
1037 width: THUMBNAILS_SIZE.width,
1038 height: THUMBNAILS_SIZE.height
1039 },
1040 url,
1041 likes: likesObject,
1042 dislikes: dislikesObject,
50d6de9c 1043 shares: sharesObject,
da854ddd 1044 comments: commentsObject,
50d6de9c
C
1045 attributedTo: [
1046 {
1047 type: 'Group',
1048 id: this.VideoChannel.Actor.url
2ccaeeb3
C
1049 },
1050 {
1051 type: 'Person',
1052 id: this.VideoChannel.Account.Actor.url
50d6de9c
C
1053 }
1054 ]
3fd3ab2d
C
1055 }
1056 }
1057
46531a0a
C
1058 toAnnouncesActivityPubObject () {
1059 const shares: string[] = []
1060
1061 for (const videoShare of this.VideoShares) {
1062 shares.push(videoShare.url)
1063 }
1064
1065 return activityPubCollection(getVideoSharesActivityPubUrl(this), shares)
1066 }
1067
1068 toCommentsActivityPubObject () {
1069 const comments: string[] = []
1070
1071 for (const videoComment of this.VideoComments) {
1072 comments.push(videoComment.url)
1073 }
1074
1075 return activityPubCollection(getVideoCommentsActivityPubUrl(this), comments)
1076 }
1077
1078 toRatesActivityPubObjects () {
1079 const likes: string[] = []
1080 const dislikes: string[] = []
1081
1082 for (const rate of this.AccountVideoRates) {
1083 if (rate.type === 'like') {
1084 likes.push(rate.Account.Actor.url)
1085 } else if (rate.type === 'dislike') {
1086 dislikes.push(rate.Account.Actor.url)
1087 }
1088 }
1089
1090 const likesObject = activityPubCollection(getVideoLikesActivityPubUrl(this), likes)
1091 const dislikesObject = activityPubCollection(getVideoDislikesActivityPubUrl(this), dislikes)
1092
1093 return { likesObject, dislikesObject }
1094 }
1095
3fd3ab2d
C
1096 getTruncatedDescription () {
1097 if (!this.description) return null
93e1258c 1098
3fd3ab2d
C
1099 const options = {
1100 length: CONSTRAINTS_FIELDS.VIDEOS.TRUNCATED_DESCRIPTION.max
1101 }
aaf61f38 1102
3fd3ab2d 1103 return truncate(this.description, options)
93e1258c
C
1104 }
1105
3fd3ab2d
C
1106 optimizeOriginalVideofile = async function () {
1107 const videosDirectory = CONFIG.STORAGE.VIDEOS_DIR
1108 const newExtname = '.mp4'
1109 const inputVideoFile = this.getOriginalFile()
1110 const videoInputPath = join(videosDirectory, this.getVideoFilename(inputVideoFile))
1111 const videoOutputPath = join(videosDirectory, this.id + '-transcoded' + newExtname)
b769007f 1112
3fd3ab2d
C
1113 const transcodeOptions = {
1114 inputPath: videoInputPath,
1115 outputPath: videoOutputPath
1116 }
c46edbc2 1117
3fd3ab2d
C
1118 try {
1119 // Could be very long!
1120 await transcode(transcodeOptions)
c46edbc2 1121
3fd3ab2d 1122 await unlinkPromise(videoInputPath)
c46edbc2 1123
3fd3ab2d
C
1124 // Important to do this before getVideoFilename() to take in account the new file extension
1125 inputVideoFile.set('extname', newExtname)
e71bcc0f 1126
3fd3ab2d
C
1127 await renamePromise(videoOutputPath, this.getVideoFilePath(inputVideoFile))
1128 const stats = await statPromise(this.getVideoFilePath(inputVideoFile))
e71bcc0f 1129
3fd3ab2d 1130 inputVideoFile.set('size', stats.size)
e71bcc0f 1131
3fd3ab2d
C
1132 await this.createTorrentAndSetInfoHash(inputVideoFile)
1133 await inputVideoFile.save()
fd45e8f4 1134
3fd3ab2d
C
1135 } catch (err) {
1136 // Auto destruction...
1137 this.destroy().catch(err => logger.error('Cannot destruct video after transcoding failure.', err))
fd45e8f4 1138
3fd3ab2d
C
1139 throw err
1140 }
feb4bdfd
C
1141 }
1142
056aa7f2 1143 transcodeOriginalVideofile = async function (resolution: VideoResolution, isPortraitMode: boolean) {
3fd3ab2d
C
1144 const videosDirectory = CONFIG.STORAGE.VIDEOS_DIR
1145 const extname = '.mp4'
aaf61f38 1146
3fd3ab2d
C
1147 // We are sure it's x264 in mp4 because optimizeOriginalVideofile was already executed
1148 const videoInputPath = join(videosDirectory, this.getVideoFilename(this.getOriginalFile()))
feb4bdfd 1149
3fd3ab2d
C
1150 const newVideoFile = new VideoFileModel({
1151 resolution,
1152 extname,
1153 size: 0,
1154 videoId: this.id
1155 })
1156 const videoOutputPath = join(videosDirectory, this.getVideoFilename(newVideoFile))
a041b171 1157
3fd3ab2d
C
1158 const transcodeOptions = {
1159 inputPath: videoInputPath,
1160 outputPath: videoOutputPath,
056aa7f2
C
1161 resolution,
1162 isPortraitMode
3fd3ab2d 1163 }
a041b171 1164
3fd3ab2d 1165 await transcode(transcodeOptions)
a041b171 1166
3fd3ab2d 1167 const stats = await statPromise(videoOutputPath)
d7d5611c 1168
3fd3ab2d 1169 newVideoFile.set('size', stats.size)
d7d5611c 1170
3fd3ab2d 1171 await this.createTorrentAndSetInfoHash(newVideoFile)
d7d5611c 1172
3fd3ab2d
C
1173 await newVideoFile.save()
1174
1175 this.VideoFiles.push(newVideoFile)
0d0e8dd0
C
1176 }
1177
056aa7f2 1178 getOriginalFileResolution () {
3fd3ab2d 1179 const originalFilePath = this.getVideoFilePath(this.getOriginalFile())
0d0e8dd0 1180
056aa7f2 1181 return getVideoFileResolution(originalFilePath)
3fd3ab2d 1182 }
0d0e8dd0 1183
3fd3ab2d
C
1184 getDescriptionPath () {
1185 return `/api/${API_VERSION}/videos/${this.uuid}/description`
feb4bdfd
C
1186 }
1187
3fd3ab2d
C
1188 getCategoryLabel () {
1189 let categoryLabel = VIDEO_CATEGORIES[this.category]
1190 if (!categoryLabel) categoryLabel = 'Misc'
aaf61f38 1191
3fd3ab2d 1192 return categoryLabel
0a6658fd
C
1193 }
1194
3fd3ab2d
C
1195 getLicenceLabel () {
1196 let licenceLabel = VIDEO_LICENCES[this.licence]
1197 if (!licenceLabel) licenceLabel = 'Unknown'
0a6658fd 1198
3fd3ab2d 1199 return licenceLabel
feb4bdfd 1200 }
7920c273 1201
3fd3ab2d
C
1202 getLanguageLabel () {
1203 let languageLabel = VIDEO_LANGUAGES[this.language]
1204 if (!languageLabel) languageLabel = 'Unknown'
1205
1206 return languageLabel
72c7248b
C
1207 }
1208
3fd3ab2d
C
1209 removeThumbnail () {
1210 const thumbnailPath = join(CONFIG.STORAGE.THUMBNAILS_DIR, this.getThumbnailName())
1211 return unlinkPromise(thumbnailPath)
feb4bdfd
C
1212 }
1213
3fd3ab2d
C
1214 removePreview () {
1215 // Same name than video thumbnail
1216 return unlinkPromise(CONFIG.STORAGE.PREVIEWS_DIR + this.getPreviewName())
7920c273
C
1217 }
1218
3fd3ab2d
C
1219 removeFile (videoFile: VideoFileModel) {
1220 const filePath = join(CONFIG.STORAGE.VIDEOS_DIR, this.getVideoFilename(videoFile))
1221 return unlinkPromise(filePath)
feb4bdfd
C
1222 }
1223
3fd3ab2d
C
1224 removeTorrent (videoFile: VideoFileModel) {
1225 const torrentPath = join(CONFIG.STORAGE.TORRENTS_DIR, this.getTorrentFileName(videoFile))
1226 return unlinkPromise(torrentPath)
aaf61f38
C
1227 }
1228
093237cf
C
1229 getActivityStreamDuration () {
1230 // https://www.w3.org/TR/activitystreams-vocabulary/#dfn-duration
1231 return 'PT' + this.duration + 'S'
1232 }
1233
3fd3ab2d
C
1234 private getBaseUrls () {
1235 let baseUrlHttp
1236 let baseUrlWs
7920c273 1237
3fd3ab2d
C
1238 if (this.isOwned()) {
1239 baseUrlHttp = CONFIG.WEBSERVER.URL
1240 baseUrlWs = CONFIG.WEBSERVER.WS + '://' + CONFIG.WEBSERVER.HOSTNAME + ':' + CONFIG.WEBSERVER.PORT
1241 } else {
50d6de9c
C
1242 baseUrlHttp = REMOTE_SCHEME.HTTP + '://' + this.VideoChannel.Account.Actor.Server.host
1243 baseUrlWs = REMOTE_SCHEME.WS + '://' + this.VideoChannel.Account.Actor.Server.host
6fcd19ba 1244 }
aaf61f38 1245
3fd3ab2d 1246 return { baseUrlHttp, baseUrlWs }
15d4ee04 1247 }
a96aed15 1248
3fd3ab2d
C
1249 private getThumbnailUrl (baseUrlHttp: string) {
1250 return baseUrlHttp + STATIC_PATHS.THUMBNAILS + this.getThumbnailName()
a96aed15
C
1251 }
1252
3fd3ab2d
C
1253 private getTorrentUrl (videoFile: VideoFileModel, baseUrlHttp: string) {
1254 return baseUrlHttp + STATIC_PATHS.TORRENTS + this.getTorrentFileName(videoFile)
1255 }
e4f97bab 1256
3fd3ab2d
C
1257 private getVideoFileUrl (videoFile: VideoFileModel, baseUrlHttp: string) {
1258 return baseUrlHttp + STATIC_PATHS.WEBSEED + this.getVideoFilename(videoFile)
1259 }
a96aed15 1260
3fd3ab2d
C
1261 private generateMagnetUri (videoFile: VideoFileModel, baseUrlHttp: string, baseUrlWs: string) {
1262 const xs = this.getTorrentUrl(videoFile, baseUrlHttp)
1263 const announce = [ baseUrlWs + '/tracker/socket', baseUrlHttp + '/tracker/announce' ]
1264 const urlList = [ this.getVideoFileUrl(videoFile, baseUrlHttp) ]
1265
1266 const magnetHash = {
1267 xs,
1268 announce,
1269 urlList,
1270 infoHash: videoFile.infoHash,
1271 name: this.name
1272 }
a96aed15 1273
3fd3ab2d 1274 return magnetUtil.encode(magnetHash)
a96aed15 1275 }
a96aed15 1276}