server/lib/activitypub/videos.ts

   1 import * as Bluebird from 'bluebird'
   2 import { maxBy, minBy } from 'lodash'
   3 import * as magnetUtil from 'magnet-uri'
   4 import { join } from 'path'
   5 import * as request from 'request'
   6 import * as sequelize from 'sequelize'
   7 import {
   8   ActivityHashTagObject,
   9   ActivityMagnetUrlObject,
  10   ActivityPlaylistSegmentHashesObject,
  11   ActivityPlaylistUrlObject,
  12   ActivitypubHttpFetcherPayload,
  13   ActivityTagObject,
  14   ActivityUrlObject,
  15   ActivityVideoUrlObject,
  16   VideoState
  17 } from '../../../shared/index'
  18 import { VideoTorrentObject } from '../../../shared/models/activitypub/objects'
  19 import { VideoPrivacy } from '../../../shared/models/videos'
  20 import { ThumbnailType } from '../../../shared/models/videos/thumbnail.type'
  21 import { VideoStreamingPlaylistType } from '../../../shared/models/videos/video-streaming-playlist.type'
  22 import { buildRemoteVideoBaseUrl, checkUrlsSameHost, getAPId } from '../../helpers/activitypub'
  23 import { isAPVideoFileMetadataObject, sanitizeAndCheckVideoTorrentObject } from '../../helpers/custom-validators/activitypub/videos'
  24 import { isArray } from '../../helpers/custom-validators/misc'
  25 import { isVideoFileInfoHashValid } from '../../helpers/custom-validators/videos'
  26 import { deleteNonExistingModels, resetSequelizeInstance, retryTransactionWrapper } from '../../helpers/database-utils'
  27 import { logger } from '../../helpers/logger'
  28 import { doRequest } from '../../helpers/requests'
  29 import { fetchVideoByUrl, getExtFromMimetype, VideoFetchByUrlType } from '../../helpers/video'
  30 import {
  31   ACTIVITY_PUB,
  32   MIMETYPES,
  33   P2P_MEDIA_LOADER_PEER_VERSION,
  34   PREVIEWS_SIZE,
  35   REMOTE_SCHEME,
  36   STATIC_PATHS,
  37   THUMBNAILS_SIZE
  38 } from '../../initializers/constants'
  39 import { sequelizeTypescript } from '../../initializers/database'
  40 import { AccountVideoRateModel } from '../../models/account/account-video-rate'
  41 import { TagModel } from '../../models/video/tag'
  42 import { VideoModel } from '../../models/video/video'
  43 import { VideoCaptionModel } from '../../models/video/video-caption'
  44 import { VideoCommentModel } from '../../models/video/video-comment'
  45 import { VideoFileModel } from '../../models/video/video-file'
  46 import { VideoShareModel } from '../../models/video/video-share'
  47 import { VideoStreamingPlaylistModel } from '../../models/video/video-streaming-playlist'
  48 import {
  49   MAccountIdActor,
  50   MChannelAccountLight,
  51   MChannelDefault,
  52   MChannelId,
  53   MStreamingPlaylist,
  54   MVideo,
  55   MVideoAccountLight,
  56   MVideoAccountLightBlacklistAllFiles,
  57   MVideoAP,
  58   MVideoAPWithoutCaption,
  59   MVideoFile,
  60   MVideoFullLight,
  61   MVideoId,
  62   MVideoImmutable,
  63   MVideoThumbnail
  64 } from '../../types/models'
  65 import { MThumbnail } from '../../types/models/video/thumbnail'
  66 import { FilteredModelAttributes } from '../../types/sequelize'
  67 import { ActorFollowScoreCache } from '../files-cache'
  68 import { JobQueue } from '../job-queue'
  69 import { Notifier } from '../notifier'
  70 import { createPlaceholderThumbnail, createVideoMiniatureFromUrl } from '../thumbnail'
  71 import { autoBlacklistVideoIfNeeded } from '../video-blacklist'
  72 import { getOrCreateActorAndServerAndModel } from './actor'
  73 import { crawlCollectionPage } from './crawl'
  74 import { sendCreateVideo, sendUpdateVideo } from './send'
  75 import { addVideoShares, shareVideoByServerAndChannel } from './share'
  76 import { addVideoComments } from './video-comments'
  77 import { createRates } from './video-rates'
  78
  79 async function federateVideoIfNeeded (videoArg: MVideoAPWithoutCaption, isNewVideo: boolean, transaction?: sequelize.Transaction) {
  80   const video = videoArg as MVideoAP
  81
  82   if (
  83     // Check this is not a blacklisted video, or unfederated blacklisted video
  84     (video.isBlacklisted() === false || (isNewVideo === false && video.VideoBlacklist.unfederated === false)) &&
  85     // Check the video is public/unlisted and published
  86     video.hasPrivacyForFederation() && video.state === VideoState.PUBLISHED
  87   ) {
  88     // Fetch more attributes that we will need to serialize in AP object
  89     if (isArray(video.VideoCaptions) === false) {
  90       video.VideoCaptions = await video.$get('VideoCaptions', {
  91         attributes: [ 'language' ],
  92         transaction
  93       })
  94     }
  95
  96     if (isNewVideo) {
  97       // Now we'll add the video's meta data to our followers
  98       await sendCreateVideo(video, transaction)
  99       await shareVideoByServerAndChannel(video, transaction)
 100     } else {
 101       await sendUpdateVideo(video, transaction)
 102     }
 103   }
 104 }
 105
 106 async function fetchRemoteVideo (videoUrl: string): Promise<{ response: request.RequestResponse, videoObject: VideoTorrentObject }> {
 107   const options = {
 108     uri: videoUrl,
 109     method: 'GET',
 110     json: true,
 111     activityPub: true
 112   }
 113
 114   logger.info('Fetching remote video %s.', videoUrl)
 115
 116   const { response, body } = await doRequest<any>(options)
 117
 118   if (sanitizeAndCheckVideoTorrentObject(body) === false || checkUrlsSameHost(body.id, videoUrl) !== true) {
 119     logger.debug('Remote video JSON is not valid.', { body })
 120     return { response, videoObject: undefined }
 121   }
 122
 123   return { response, videoObject: body }
 124 }
 125
 126 async function fetchRemoteVideoDescription (video: MVideoAccountLight) {
 127   const host = video.VideoChannel.Account.Actor.Server.host
 128   const path = video.getDescriptionAPIPath()
 129   const options = {
 130     uri: REMOTE_SCHEME.HTTP + '://' + host + path,
 131     json: true
 132   }
 133
 134   const { body } = await doRequest<any>(options)
 135   return body.description ? body.description : ''
 136 }
 137
 138 function getOrCreateVideoChannelFromVideoObject (videoObject: VideoTorrentObject) {
 139   const channel = videoObject.attributedTo.find(a => a.type === 'Group')
 140   if (!channel) throw new Error('Cannot find associated video channel to video ' + videoObject.url)
 141
 142   if (checkUrlsSameHost(channel.id, videoObject.id) !== true) {
 143     throw new Error(`Video channel url ${channel.id} does not have the same host than video object id ${videoObject.id}`)
 144   }
 145
 146   return getOrCreateActorAndServerAndModel(channel.id, 'all')
 147 }
 148
 149 type SyncParam = {
 150   likes: boolean
 151   dislikes: boolean
 152   shares: boolean
 153   comments: boolean
 154   thumbnail: boolean
 155   refreshVideo?: boolean
 156 }
 157 async function syncVideoExternalAttributes (video: MVideo, fetchedVideo: VideoTorrentObject, syncParam: SyncParam) {
 158   logger.info('Adding likes/dislikes/shares/comments of video %s.', video.uuid)
 159
 160   const jobPayloads: ActivitypubHttpFetcherPayload[] = []
 161
 162   if (syncParam.likes === true) {
 163     const handler = items => createRates(items, video, 'like')
 164     const cleaner = crawlStartDate => AccountVideoRateModel.cleanOldRatesOf(video.id, 'like' as 'like', crawlStartDate)
 165
 166     await crawlCollectionPage<string>(fetchedVideo.likes, handler, cleaner)
 167       .catch(err => logger.error('Cannot add likes of video %s.', video.uuid, { err, rootUrl: fetchedVideo.likes }))
 168   } else {
 169     jobPayloads.push({ uri: fetchedVideo.likes, videoId: video.id, type: 'video-likes' as 'video-likes' })
 170   }
 171
 172   if (syncParam.dislikes === true) {
 173     const handler = items => createRates(items, video, 'dislike')
 174     const cleaner = crawlStartDate => AccountVideoRateModel.cleanOldRatesOf(video.id, 'dislike' as 'dislike', crawlStartDate)
 175
 176     await crawlCollectionPage<string>(fetchedVideo.dislikes, handler, cleaner)
 177       .catch(err => logger.error('Cannot add dislikes of video %s.', video.uuid, { err, rootUrl: fetchedVideo.dislikes }))
 178   } else {
 179     jobPayloads.push({ uri: fetchedVideo.dislikes, videoId: video.id, type: 'video-dislikes' as 'video-dislikes' })
 180   }
 181
 182   if (syncParam.shares === true) {
 183     const handler = items => addVideoShares(items, video)
 184     const cleaner = crawlStartDate => VideoShareModel.cleanOldSharesOf(video.id, crawlStartDate)
 185
 186     await crawlCollectionPage<string>(fetchedVideo.shares, handler, cleaner)
 187       .catch(err => logger.error('Cannot add shares of video %s.', video.uuid, { err, rootUrl: fetchedVideo.shares }))
 188   } else {
 189     jobPayloads.push({ uri: fetchedVideo.shares, videoId: video.id, type: 'video-shares' as 'video-shares' })
 190   }
 191
 192   if (syncParam.comments === true) {
 193     const handler = items => addVideoComments(items)
 194     const cleaner = crawlStartDate => VideoCommentModel.cleanOldCommentsOf(video.id, crawlStartDate)
 195
 196     await crawlCollectionPage<string>(fetchedVideo.comments, handler, cleaner)
 197       .catch(err => logger.error('Cannot add comments of video %s.', video.uuid, { err, rootUrl: fetchedVideo.comments }))
 198   } else {
 199     jobPayloads.push({ uri: fetchedVideo.comments, videoId: video.id, type: 'video-comments' as 'video-comments' })
 200   }
 201
 202   await Bluebird.map(jobPayloads, payload => JobQueue.Instance.createJobWithPromise({ type: 'activitypub-http-fetcher', payload }))
 203 }
 204
 205 type GetVideoResult <T> = Promise<{
 206   video: T
 207   created: boolean
 208   autoBlacklisted?: boolean
 209 }>
 210
 211 type GetVideoParamAll = {
 212   videoObject: { id: string } | string
 213   syncParam?: SyncParam
 214   fetchType?: 'all'
 215   allowRefresh?: boolean
 216 }
 217
 218 type GetVideoParamImmutable = {
 219   videoObject: { id: string } | string
 220   syncParam?: SyncParam
 221   fetchType: 'only-immutable-attributes'
 222   allowRefresh: false
 223 }
 224
 225 type GetVideoParamOther = {
 226   videoObject: { id: string } | string
 227   syncParam?: SyncParam
 228   fetchType?: 'all' | 'only-video'
 229   allowRefresh?: boolean
 230 }
 231
 232 function getOrCreateVideoAndAccountAndChannel (options: GetVideoParamAll): GetVideoResult<MVideoAccountLightBlacklistAllFiles>
 233 function getOrCreateVideoAndAccountAndChannel (options: GetVideoParamImmutable): GetVideoResult<MVideoImmutable>
 234 function getOrCreateVideoAndAccountAndChannel (
 235   options: GetVideoParamOther
 236 ): GetVideoResult<MVideoAccountLightBlacklistAllFiles | MVideoThumbnail>
 237 async function getOrCreateVideoAndAccountAndChannel (
 238   options: GetVideoParamAll | GetVideoParamImmutable | GetVideoParamOther
 239 ): GetVideoResult<MVideoAccountLightBlacklistAllFiles | MVideoThumbnail | MVideoImmutable> {
 240   // Default params
 241   const syncParam = options.syncParam || { likes: true, dislikes: true, shares: true, comments: true, thumbnail: true, refreshVideo: false }
 242   const fetchType = options.fetchType || 'all'
 243   const allowRefresh = options.allowRefresh !== false
 244
 245   // Get video url
 246   const videoUrl = getAPId(options.videoObject)
 247   let videoFromDatabase = await fetchVideoByUrl(videoUrl, fetchType)
 248
 249   if (videoFromDatabase) {
 250     // If allowRefresh is true, we could not call this function using 'only-immutable-attributes' fetch type
 251     if (allowRefresh === true && (videoFromDatabase as MVideoThumbnail).isOutdated()) {
 252       const refreshOptions = {
 253         video: videoFromDatabase as MVideoThumbnail,
 254         fetchedType: fetchType,
 255         syncParam
 256       }
 257
 258       if (syncParam.refreshVideo === true) {
 259         videoFromDatabase = await refreshVideoIfNeeded(refreshOptions)
 260       } else {
 261         await JobQueue.Instance.createJobWithPromise({
 262           type: 'activitypub-refresher',
 263           payload: { type: 'video', url: videoFromDatabase.url }
 264         })
 265       }
 266     }
 267
 268     return { video: videoFromDatabase, created: false }
 269   }
 270
 271   const { videoObject: fetchedVideo } = await fetchRemoteVideo(videoUrl)
 272   if (!fetchedVideo) throw new Error('Cannot fetch remote video with url: ' + videoUrl)
 273
 274   const actor = await getOrCreateVideoChannelFromVideoObject(fetchedVideo)
 275   const videoChannel = actor.VideoChannel
 276
 277   try {
 278     const { autoBlacklisted, videoCreated } = await retryTransactionWrapper(createVideo, fetchedVideo, videoChannel, syncParam.thumbnail)
 279
 280     await syncVideoExternalAttributes(videoCreated, fetchedVideo, syncParam)
 281
 282     return { video: videoCreated, created: true, autoBlacklisted }
 283   } catch (err) {
 284     // Maybe a concurrent getOrCreateVideoAndAccountAndChannel call created this video
 285     if (err.name === 'SequelizeUniqueConstraintError') {
 286       const fallbackVideo = await fetchVideoByUrl(videoUrl, fetchType)
 287       if (fallbackVideo) return { video: fallbackVideo, created: false }
 288     }
 289
 290     throw err
 291   }
 292 }
 293
 294 async function updateVideoFromAP (options: {
 295   video: MVideoAccountLightBlacklistAllFiles
 296   videoObject: VideoTorrentObject
 297   account: MAccountIdActor
 298   channel: MChannelDefault
 299   overrideTo?: string[]
 300 }) {
 301   const { video, videoObject, account, channel, overrideTo } = options
 302
 303   logger.debug('Updating remote video "%s".', options.videoObject.uuid, { account, channel })
 304
 305   let videoFieldsSave: any
 306   const wasPrivateVideo = video.privacy === VideoPrivacy.PRIVATE
 307   const wasUnlistedVideo = video.privacy === VideoPrivacy.UNLISTED
 308
 309   try {
 310     let thumbnailModel: MThumbnail
 311
 312     try {
 313       thumbnailModel = await createVideoMiniatureFromUrl(getThumbnailFromIcons(videoObject).url, video, ThumbnailType.MINIATURE)
 314     } catch (err) {
 315       logger.warn('Cannot generate thumbnail of %s.', videoObject.id, { err })
 316     }
 317
 318     const videoUpdated = await sequelizeTypescript.transaction(async t => {
 319       const sequelizeOptions = { transaction: t }
 320
 321       videoFieldsSave = video.toJSON()
 322
 323       // Check actor has the right to update the video
 324       const videoChannel = video.VideoChannel
 325       if (videoChannel.Account.id !== account.id) {
 326         throw new Error('Account ' + account.Actor.url + ' does not own video channel ' + videoChannel.Actor.url)
 327       }
 328
 329       const to = overrideTo || videoObject.to
 330       const videoData = await videoActivityObjectToDBAttributes(channel, videoObject, to)
 331       video.name = videoData.name
 332       video.uuid = videoData.uuid
 333       video.url = videoData.url
 334       video.category = videoData.category
 335       video.licence = videoData.licence
 336       video.language = videoData.language
 337       video.description = videoData.description
 338       video.support = videoData.support
 339       video.nsfw = videoData.nsfw
 340       video.commentsEnabled = videoData.commentsEnabled
 341       video.downloadEnabled = videoData.downloadEnabled
 342       video.waitTranscoding = videoData.waitTranscoding
 343       video.state = videoData.state
 344       video.duration = videoData.duration
 345       video.createdAt = videoData.createdAt
 346       video.publishedAt = videoData.publishedAt
 347       video.originallyPublishedAt = videoData.originallyPublishedAt
 348       video.privacy = videoData.privacy
 349       video.channelId = videoData.channelId
 350       video.views = videoData.views
 351
 352       const videoUpdated = await video.save(sequelizeOptions) as MVideoFullLight
 353
 354       if (thumbnailModel) await videoUpdated.addAndSaveThumbnail(thumbnailModel, t)
 355
 356       if (videoUpdated.getPreview()) {
 357         const previewUrl = videoUpdated.getPreview().getFileUrl(videoUpdated)
 358         const previewModel = createPlaceholderThumbnail(previewUrl, video, ThumbnailType.PREVIEW, PREVIEWS_SIZE)
 359         await videoUpdated.addAndSaveThumbnail(previewModel, t)
 360       }
 361
 362       {
 363         const videoFileAttributes = videoFileActivityUrlToDBAttributes(videoUpdated, videoObject.url)
 364         const newVideoFiles = videoFileAttributes.map(a => new VideoFileModel(a))
 365
 366         // Remove video files that do not exist anymore
 367         const destroyTasks = deleteNonExistingModels(videoUpdated.VideoFiles, newVideoFiles, t)
 368         await Promise.all(destroyTasks)
 369
 370         // Update or add other one
 371         const upsertTasks = newVideoFiles.map(f => VideoFileModel.customUpsert(f, 'video', t))
 372         videoUpdated.VideoFiles = await Promise.all(upsertTasks)
 373       }
 374
 375       {
 376         const streamingPlaylistAttributes = streamingPlaylistActivityUrlToDBAttributes(videoUpdated, videoObject, videoUpdated.VideoFiles)
 377         const newStreamingPlaylists = streamingPlaylistAttributes.map(a => new VideoStreamingPlaylistModel(a))
 378
 379         // Remove video playlists that do not exist anymore
 380         const destroyTasks = deleteNonExistingModels(videoUpdated.VideoStreamingPlaylists, newStreamingPlaylists, t)
 381         await Promise.all(destroyTasks)
 382
 383         let oldStreamingPlaylistFiles: MVideoFile[] = []
 384         for (const videoStreamingPlaylist of videoUpdated.VideoStreamingPlaylists) {
 385           oldStreamingPlaylistFiles = oldStreamingPlaylistFiles.concat(videoStreamingPlaylist.VideoFiles)
 386         }
 387
 388         videoUpdated.VideoStreamingPlaylists = []
 389
 390         for (const playlistAttributes of streamingPlaylistAttributes) {
 391           const streamingPlaylistModel = await VideoStreamingPlaylistModel.upsert(playlistAttributes, { returning: true, transaction: t })
 392                                      .then(([ streamingPlaylist ]) => streamingPlaylist)
 393
 394           const newVideoFiles: MVideoFile[] = videoFileActivityUrlToDBAttributes(streamingPlaylistModel, playlistAttributes.tagAPObject)
 395             .map(a => new VideoFileModel(a))
 396           const destroyTasks = deleteNonExistingModels(oldStreamingPlaylistFiles, newVideoFiles, t)
 397           await Promise.all(destroyTasks)
 398
 399           // Update or add other one
 400           const upsertTasks = newVideoFiles.map(f => VideoFileModel.customUpsert(f, 'streaming-playlist', t))
 401           streamingPlaylistModel.VideoFiles = await Promise.all(upsertTasks)
 402
 403           videoUpdated.VideoStreamingPlaylists.push(streamingPlaylistModel)
 404         }
 405       }
 406
 407       {
 408         // Update Tags
 409         const tags = videoObject.tag
 410                                 .filter(isAPHashTagObject)
 411                                 .map(tag => tag.name)
 412         const tagInstances = await TagModel.findOrCreateTags(tags, t)
 413         await videoUpdated.$set('Tags', tagInstances, sequelizeOptions)
 414       }
 415
 416       {
 417         // Update captions
 418         await VideoCaptionModel.deleteAllCaptionsOfRemoteVideo(videoUpdated.id, t)
 419
 420         const videoCaptionsPromises = videoObject.subtitleLanguage.map(c => {
 421           return VideoCaptionModel.insertOrReplaceLanguage(videoUpdated.id, c.identifier, c.url, t)
 422         })
 423         await Promise.all(videoCaptionsPromises)
 424       }
 425
 426       return videoUpdated
 427     })
 428
 429     await autoBlacklistVideoIfNeeded({
 430       video: videoUpdated,
 431       user: undefined,
 432       isRemote: true,
 433       isNew: false,
 434       transaction: undefined
 435     })
 436
 437     if (wasPrivateVideo || wasUnlistedVideo) Notifier.Instance.notifyOnNewVideoIfNeeded(videoUpdated) // Notify our users?
 438
 439     logger.info('Remote video with uuid %s updated', videoObject.uuid)
 440
 441     return videoUpdated
 442   } catch (err) {
 443     if (video !== undefined && videoFieldsSave !== undefined) {
 444       resetSequelizeInstance(video, videoFieldsSave)
 445     }
 446
 447     // This is just a debug because we will retry the insert
 448     logger.debug('Cannot update the remote video.', { err })
 449     throw err
 450   }
 451 }
 452
 453 async function refreshVideoIfNeeded (options: {
 454   video: MVideoThumbnail
 455   fetchedType: VideoFetchByUrlType
 456   syncParam: SyncParam
 457 }): Promise<MVideoThumbnail> {
 458   if (!options.video.isOutdated()) return options.video
 459
 460   // We need more attributes if the argument video was fetched with not enough joints
 461   const video = options.fetchedType === 'all'
 462     ? options.video as MVideoAccountLightBlacklistAllFiles
 463     : await VideoModel.loadByUrlAndPopulateAccount(options.video.url)
 464
 465   try {
 466     const { response, videoObject } = await fetchRemoteVideo(video.url)
 467     if (response.statusCode === 404) {
 468       logger.info('Cannot refresh remote video %s: video does not exist anymore. Deleting it.', video.url)
 469
 470       // Video does not exist anymore
 471       await video.destroy()
 472       return undefined
 473     }
 474
 475     if (videoObject === undefined) {
 476       logger.warn('Cannot refresh remote video %s: invalid body.', video.url)
 477
 478       await video.setAsRefreshed()
 479       return video
 480     }
 481
 482     const channelActor = await getOrCreateVideoChannelFromVideoObject(videoObject)
 483
 484     const updateOptions = {
 485       video,
 486       videoObject,
 487       account: channelActor.VideoChannel.Account,
 488       channel: channelActor.VideoChannel
 489     }
 490     await retryTransactionWrapper(updateVideoFromAP, updateOptions)
 491     await syncVideoExternalAttributes(video, videoObject, options.syncParam)
 492
 493     ActorFollowScoreCache.Instance.addGoodServerId(video.VideoChannel.Actor.serverId)
 494
 495     return video
 496   } catch (err) {
 497     logger.warn('Cannot refresh video %s.', options.video.url, { err })
 498
 499     ActorFollowScoreCache.Instance.addBadServerId(video.VideoChannel.Actor.serverId)
 500
 501     // Don't refresh in loop
 502     await video.setAsRefreshed()
 503     return video
 504   }
 505 }
 506
 507 export {
 508   updateVideoFromAP,
 509   refreshVideoIfNeeded,
 510   federateVideoIfNeeded,
 511   fetchRemoteVideo,
 512   getOrCreateVideoAndAccountAndChannel,
 513   fetchRemoteVideoDescription,
 514   getOrCreateVideoChannelFromVideoObject
 515 }
 516
 517 // ---------------------------------------------------------------------------
 518
 519 function isAPVideoUrlObject (url: any): url is ActivityVideoUrlObject {
 520   const urlMediaType = url.mediaType
 521
 522   return MIMETYPES.VIDEO.MIMETYPE_EXT[urlMediaType] && urlMediaType.startsWith('video/')
 523 }
 524
 525 function isAPStreamingPlaylistUrlObject (url: ActivityUrlObject): url is ActivityPlaylistUrlObject {
 526   return url && url.mediaType === 'application/x-mpegURL'
 527 }
 528
 529 function isAPPlaylistSegmentHashesUrlObject (tag: any): tag is ActivityPlaylistSegmentHashesObject {
 530   return tag && tag.name === 'sha256' && tag.type === 'Link' && tag.mediaType === 'application/json'
 531 }
 532
 533 function isAPMagnetUrlObject (url: any): url is ActivityMagnetUrlObject {
 534   return url && url.mediaType === 'application/x-bittorrent;x-scheme-handler/magnet'
 535 }
 536
 537 function isAPHashTagObject (url: any): url is ActivityHashTagObject {
 538   return url && url.type === 'Hashtag'
 539 }
 540
 541 async function createVideo (videoObject: VideoTorrentObject, channel: MChannelAccountLight, waitThumbnail = false) {
 542   logger.debug('Adding remote video %s.', videoObject.id)
 543
 544   const videoData = await videoActivityObjectToDBAttributes(channel, videoObject, videoObject.to)
 545   const video = VideoModel.build(videoData) as MVideoThumbnail
 546
 547   const promiseThumbnail = createVideoMiniatureFromUrl(getThumbnailFromIcons(videoObject).url, video, ThumbnailType.MINIATURE)
 548     .catch(err => {
 549       logger.error('Cannot create miniature from url.', { err })
 550       return undefined
 551     })
 552
 553   let thumbnailModel: MThumbnail
 554   if (waitThumbnail === true) {
 555     thumbnailModel = await promiseThumbnail
 556   }
 557
 558   const { autoBlacklisted, videoCreated } = await sequelizeTypescript.transaction(async t => {
 559     const sequelizeOptions = { transaction: t }
 560
 561     const videoCreated = await video.save(sequelizeOptions) as MVideoFullLight
 562     videoCreated.VideoChannel = channel
 563
 564     if (thumbnailModel) await videoCreated.addAndSaveThumbnail(thumbnailModel, t)
 565
 566     const previewIcon = getPreviewFromIcons(videoObject)
 567     const previewUrl = previewIcon
 568       ? previewIcon.url
 569       : buildRemoteVideoBaseUrl(videoCreated, join(STATIC_PATHS.PREVIEWS, video.generatePreviewName()))
 570     const previewModel = createPlaceholderThumbnail(previewUrl, videoCreated, ThumbnailType.PREVIEW, PREVIEWS_SIZE)
 571
 572     if (thumbnailModel) await videoCreated.addAndSaveThumbnail(previewModel, t)
 573
 574     // Process files
 575     const videoFileAttributes = videoFileActivityUrlToDBAttributes(videoCreated, videoObject.url)
 576
 577     const videoFilePromises = videoFileAttributes.map(f => VideoFileModel.create(f, { transaction: t }))
 578     const videoFiles = await Promise.all(videoFilePromises)
 579
 580     const streamingPlaylistsAttributes = streamingPlaylistActivityUrlToDBAttributes(videoCreated, videoObject, videoFiles)
 581     videoCreated.VideoStreamingPlaylists = []
 582
 583     for (const playlistAttributes of streamingPlaylistsAttributes) {
 584       const playlistModel = await VideoStreamingPlaylistModel.create(playlistAttributes, { transaction: t })
 585
 586       const playlistFiles = videoFileActivityUrlToDBAttributes(playlistModel, playlistAttributes.tagAPObject)
 587       const videoFilePromises = playlistFiles.map(f => VideoFileModel.create(f, { transaction: t }))
 588       playlistModel.VideoFiles = await Promise.all(videoFilePromises)
 589
 590       videoCreated.VideoStreamingPlaylists.push(playlistModel)
 591     }
 592
 593     // Process tags
 594     const tags = videoObject.tag
 595                             .filter(isAPHashTagObject)
 596                             .map(t => t.name)
 597     const tagInstances = await TagModel.findOrCreateTags(tags, t)
 598     await videoCreated.$set('Tags', tagInstances, sequelizeOptions)
 599
 600     // Process captions
 601     const videoCaptionsPromises = videoObject.subtitleLanguage.map(c => {
 602       return VideoCaptionModel.insertOrReplaceLanguage(videoCreated.id, c.identifier, c.url, t)
 603     })
 604     await Promise.all(videoCaptionsPromises)
 605
 606     videoCreated.VideoFiles = videoFiles
 607     videoCreated.Tags = tagInstances
 608
 609     const autoBlacklisted = await autoBlacklistVideoIfNeeded({
 610       video: videoCreated,
 611       user: undefined,
 612       isRemote: true,
 613       isNew: true,
 614       transaction: t
 615     })
 616
 617     logger.info('Remote video with uuid %s inserted.', videoObject.uuid)
 618
 619     return { autoBlacklisted, videoCreated }
 620   })
 621
 622   if (waitThumbnail === false) {
 623     // Error is already caught above
 624     // eslint-disable-next-line @typescript-eslint/no-floating-promises
 625     promiseThumbnail.then(thumbnailModel => {
 626       if (!thumbnailModel) return
 627
 628       thumbnailModel = videoCreated.id
 629
 630       return thumbnailModel.save()
 631     })
 632   }
 633
 634   return { autoBlacklisted, videoCreated }
 635 }
 636
 637 function videoActivityObjectToDBAttributes (videoChannel: MChannelId, videoObject: VideoTorrentObject, to: string[] = []) {
 638   const privacy = to.includes(ACTIVITY_PUB.PUBLIC)
 639     ? VideoPrivacy.PUBLIC
 640     : VideoPrivacy.UNLISTED
 641
 642   const duration = videoObject.duration.replace(/[^\d]+/, '')
 643   const language = videoObject.language?.identifier
 644
 645   const category = videoObject.category
 646     ? parseInt(videoObject.category.identifier, 10)
 647     : undefined
 648
 649   const licence = videoObject.licence
 650     ? parseInt(videoObject.licence.identifier, 10)
 651     : undefined
 652
 653   const description = videoObject.content || null
 654   const support = videoObject.support || null
 655
 656   return {
 657     name: videoObject.name,
 658     uuid: videoObject.uuid,
 659     url: videoObject.id,
 660     category,
 661     licence,
 662     language,
 663     description,
 664     support,
 665     nsfw: videoObject.sensitive,
 666     commentsEnabled: videoObject.commentsEnabled,
 667     downloadEnabled: videoObject.downloadEnabled,
 668     waitTranscoding: videoObject.waitTranscoding,
 669     state: videoObject.state,
 670     channelId: videoChannel.id,
 671     duration: parseInt(duration, 10),
 672     createdAt: new Date(videoObject.published),
 673     publishedAt: new Date(videoObject.published),
 674
 675     originallyPublishedAt: videoObject.originallyPublishedAt
 676       ? new Date(videoObject.originallyPublishedAt)
 677       : null,
 678
 679     updatedAt: new Date(videoObject.updated),
 680     views: videoObject.views,
 681     likes: 0,
 682     dislikes: 0,
 683     remote: true,
 684     privacy
 685   }
 686 }
 687
 688 function videoFileActivityUrlToDBAttributes (
 689   videoOrPlaylist: MVideo | MStreamingPlaylist,
 690   urls: (ActivityTagObject | ActivityUrlObject)[]
 691 ) {
 692   const fileUrls = urls.filter(u => isAPVideoUrlObject(u)) as ActivityVideoUrlObject[]
 693
 694   if (fileUrls.length === 0) return []
 695
 696   const attributes: FilteredModelAttributes<VideoFileModel>[] = []
 697   for (const fileUrl of fileUrls) {
 698     // Fetch associated magnet uri
 699     const magnet = urls.filter(isAPMagnetUrlObject)
 700                        .find(u => u.height === fileUrl.height)
 701
 702     if (!magnet) throw new Error('Cannot find associated magnet uri for file ' + fileUrl.href)
 703
 704     const parsed = magnetUtil.decode(magnet.href)
 705     if (!parsed || isVideoFileInfoHashValid(parsed.infoHash) === false) {
 706       throw new Error('Cannot parse magnet URI ' + magnet.href)
 707     }
 708
 709     // Fetch associated metadata url, if any
 710     const metadata = urls.filter(isAPVideoFileMetadataObject)
 711                          .find(u => {
 712                            return u.height === fileUrl.height &&
 713                              u.fps === fileUrl.fps &&
 714                              u.rel.includes(fileUrl.mediaType)
 715                          })
 716
 717     const mediaType = fileUrl.mediaType
 718     const attribute = {
 719       extname: getExtFromMimetype(MIMETYPES.VIDEO.MIMETYPE_EXT, mediaType),
 720       infoHash: parsed.infoHash,
 721       resolution: fileUrl.height,
 722       size: fileUrl.size,
 723       fps: fileUrl.fps || -1,
 724       metadataUrl: metadata?.href,
 725
 726       // This is a video file owned by a video or by a streaming playlist
 727       videoId: (videoOrPlaylist as MStreamingPlaylist).playlistUrl ? null : videoOrPlaylist.id,
 728       videoStreamingPlaylistId: (videoOrPlaylist as MStreamingPlaylist).playlistUrl ? videoOrPlaylist.id : null
 729     }
 730
 731     attributes.push(attribute)
 732   }
 733
 734   return attributes
 735 }
 736
 737 function streamingPlaylistActivityUrlToDBAttributes (video: MVideoId, videoObject: VideoTorrentObject, videoFiles: MVideoFile[]) {
 738   const playlistUrls = videoObject.url.filter(u => isAPStreamingPlaylistUrlObject(u)) as ActivityPlaylistUrlObject[]
 739   if (playlistUrls.length === 0) return []
 740
 741   const attributes: (FilteredModelAttributes<VideoStreamingPlaylistModel> & { tagAPObject?: ActivityTagObject[] })[] = []
 742   for (const playlistUrlObject of playlistUrls) {
 743     const segmentsSha256UrlObject = playlistUrlObject.tag.find(isAPPlaylistSegmentHashesUrlObject)
 744
 745     let files: unknown[] = playlistUrlObject.tag.filter(u => isAPVideoUrlObject(u)) as ActivityVideoUrlObject[]
 746
 747     // FIXME: backward compatibility introduced in v2.1.0
 748     if (files.length === 0) files = videoFiles
 749
 750     if (!segmentsSha256UrlObject) {
 751       logger.warn('No segment sha256 URL found in AP playlist object.', { playlistUrl: playlistUrlObject })
 752       continue
 753     }
 754
 755     const attribute = {
 756       type: VideoStreamingPlaylistType.HLS,
 757       playlistUrl: playlistUrlObject.href,
 758       segmentsSha256Url: segmentsSha256UrlObject.href,
 759       p2pMediaLoaderInfohashes: VideoStreamingPlaylistModel.buildP2PMediaLoaderInfoHashes(playlistUrlObject.href, files),
 760       p2pMediaLoaderPeerVersion: P2P_MEDIA_LOADER_PEER_VERSION,
 761       videoId: video.id,
 762       tagAPObject: playlistUrlObject.tag
 763     }
 764
 765     attributes.push(attribute)
 766   }
 767
 768   return attributes
 769 }
 770
 771 function getThumbnailFromIcons (videoObject: VideoTorrentObject) {
 772   let validIcons = videoObject.icon.filter(i => i.width > THUMBNAILS_SIZE.minWidth)
 773   // Fallback if there are not valid icons
 774   if (validIcons.length === 0) validIcons = videoObject.icon
 775
 776   return minBy(validIcons, 'width')
 777 }
 778
 779 function getPreviewFromIcons (videoObject: VideoTorrentObject) {
 780   const validIcons = videoObject.icon.filter(i => i.width > PREVIEWS_SIZE.minWidth)
 781
 782   // FIXME: don't put a fallback here for compatibility with PeerTube <2.2
 783
 784   return maxBy(validIcons, 'width')
 785 }