server/controllers/api/video-playlist.ts

   1 import * as express from 'express'
   2 import { getFormattedObjects, getServerActor } from '../../helpers/utils'
   3 import {
   4   asyncMiddleware,
   5   asyncRetryTransactionMiddleware,
   6   authenticate,
   7   commonVideosFiltersValidator,
   8   optionalAuthenticate,
   9   paginationValidator,
  10   setDefaultPagination,
  11   setDefaultSort
  12 } from '../../middlewares'
  13 import { videoPlaylistsSortValidator } from '../../middlewares/validators'
  14 import { buildNSFWFilter, createReqFiles, isUserAbleToSearchRemoteURI } from '../../helpers/express-utils'
  15 import { MIMETYPES, VIDEO_PLAYLIST_PRIVACIES } from '../../initializers/constants'
  16 import { logger } from '../../helpers/logger'
  17 import { resetSequelizeInstance } from '../../helpers/database-utils'
  18 import { VideoPlaylistModel } from '../../models/video/video-playlist'
  19 import {
  20   commonVideoPlaylistFiltersValidator,
  21   videoPlaylistsAddValidator,
  22   videoPlaylistsAddVideoValidator,
  23   videoPlaylistsDeleteValidator,
  24   videoPlaylistsGetValidator,
  25   videoPlaylistsReorderVideosValidator,
  26   videoPlaylistsUpdateOrRemoveVideoValidator,
  27   videoPlaylistsUpdateValidator
  28 } from '../../middlewares/validators/videos/video-playlists'
  29 import { VideoPlaylistCreate } from '../../../shared/models/videos/playlist/video-playlist-create.model'
  30 import { VideoPlaylistPrivacy } from '../../../shared/models/videos/playlist/video-playlist-privacy.model'
  31 import { join } from 'path'
  32 import { sendCreateVideoPlaylist, sendDeleteVideoPlaylist, sendUpdateVideoPlaylist } from '../../lib/activitypub/send'
  33 import { getVideoPlaylistActivityPubUrl, getVideoPlaylistElementActivityPubUrl } from '../../lib/activitypub/url'
  34 import { VideoPlaylistUpdate } from '../../../shared/models/videos/playlist/video-playlist-update.model'
  35 import { VideoModel } from '../../models/video/video'
  36 import { VideoPlaylistElementModel } from '../../models/video/video-playlist-element'
  37 import { VideoPlaylistElementCreate } from '../../../shared/models/videos/playlist/video-playlist-element-create.model'
  38 import { VideoPlaylistElementUpdate } from '../../../shared/models/videos/playlist/video-playlist-element-update.model'
  39 import { AccountModel } from '../../models/account/account'
  40 import { VideoPlaylistReorder } from '../../../shared/models/videos/playlist/video-playlist-reorder.model'
  41 import { JobQueue } from '../../lib/job-queue'
  42 import { CONFIG } from '../../initializers/config'
  43 import { sequelizeTypescript } from '../../initializers/database'
  44 import { createPlaylistMiniatureFromExisting } from '../../lib/thumbnail'
  45
  46 const reqThumbnailFile = createReqFiles([ 'thumbnailfile' ], MIMETYPES.IMAGE.MIMETYPE_EXT, { thumbnailfile: CONFIG.STORAGE.TMP_DIR })
  47
  48 const videoPlaylistRouter = express.Router()
  49
  50 videoPlaylistRouter.get('/privacies', listVideoPlaylistPrivacies)
  51
  52 videoPlaylistRouter.get('/',
  53   paginationValidator,
  54   videoPlaylistsSortValidator,
  55   setDefaultSort,
  56   setDefaultPagination,
  57   commonVideoPlaylistFiltersValidator,
  58   asyncMiddleware(listVideoPlaylists)
  59 )
  60
  61 videoPlaylistRouter.get('/:playlistId',
  62   asyncMiddleware(videoPlaylistsGetValidator),
  63   getVideoPlaylist
  64 )
  65
  66 videoPlaylistRouter.post('/',
  67   authenticate,
  68   reqThumbnailFile,
  69   asyncMiddleware(videoPlaylistsAddValidator),
  70   asyncRetryTransactionMiddleware(addVideoPlaylist)
  71 )
  72
  73 videoPlaylistRouter.put('/:playlistId',
  74   authenticate,
  75   reqThumbnailFile,
  76   asyncMiddleware(videoPlaylistsUpdateValidator),
  77   asyncRetryTransactionMiddleware(updateVideoPlaylist)
  78 )
  79
  80 videoPlaylistRouter.delete('/:playlistId',
  81   authenticate,
  82   asyncMiddleware(videoPlaylistsDeleteValidator),
  83   asyncRetryTransactionMiddleware(removeVideoPlaylist)
  84 )
  85
  86 videoPlaylistRouter.get('/:playlistId/videos',
  87   asyncMiddleware(videoPlaylistsGetValidator),
  88   paginationValidator,
  89   setDefaultPagination,
  90   optionalAuthenticate,
  91   commonVideosFiltersValidator,
  92   asyncMiddleware(getVideoPlaylistVideos)
  93 )
  94
  95 videoPlaylistRouter.post('/:playlistId/videos',
  96   authenticate,
  97   asyncMiddleware(videoPlaylistsAddVideoValidator),
  98   asyncRetryTransactionMiddleware(addVideoInPlaylist)
  99 )
 100
 101 videoPlaylistRouter.post('/:playlistId/videos/reorder',
 102   authenticate,
 103   asyncMiddleware(videoPlaylistsReorderVideosValidator),
 104   asyncRetryTransactionMiddleware(reorderVideosPlaylist)
 105 )
 106
 107 videoPlaylistRouter.put('/:playlistId/videos/:videoId',
 108   authenticate,
 109   asyncMiddleware(videoPlaylistsUpdateOrRemoveVideoValidator),
 110   asyncRetryTransactionMiddleware(updateVideoPlaylistElement)
 111 )
 112
 113 videoPlaylistRouter.delete('/:playlistId/videos/:videoId',
 114   authenticate,
 115   asyncMiddleware(videoPlaylistsUpdateOrRemoveVideoValidator),
 116   asyncRetryTransactionMiddleware(removeVideoFromPlaylist)
 117 )
 118
 119 // ---------------------------------------------------------------------------
 120
 121 export {
 122   videoPlaylistRouter
 123 }
 124
 125 // ---------------------------------------------------------------------------
 126
 127 function listVideoPlaylistPrivacies (req: express.Request, res: express.Response) {
 128   res.json(VIDEO_PLAYLIST_PRIVACIES)
 129 }
 130
 131 async function listVideoPlaylists (req: express.Request, res: express.Response) {
 132   const serverActor = await getServerActor()
 133   const resultList = await VideoPlaylistModel.listForApi({
 134     followerActorId: serverActor.id,
 135     start: req.query.start,
 136     count: req.query.count,
 137     sort: req.query.sort,
 138     type: req.query.type
 139   })
 140
 141   return res.json(getFormattedObjects(resultList.data, resultList.total))
 142 }
 143
 144 function getVideoPlaylist (req: express.Request, res: express.Response) {
 145   const videoPlaylist = res.locals.videoPlaylist
 146
 147   if (videoPlaylist.isOutdated()) {
 148     JobQueue.Instance.createJob({ type: 'activitypub-refresher', payload: { type: 'video-playlist', url: videoPlaylist.url } })
 149             .catch(err => logger.error('Cannot create AP refresher job for playlist %s.', videoPlaylist.url, { err }))
 150   }
 151
 152   return res.json(videoPlaylist.toFormattedJSON())
 153 }
 154
 155 async function addVideoPlaylist (req: express.Request, res: express.Response) {
 156   const videoPlaylistInfo: VideoPlaylistCreate = req.body
 157   const user = res.locals.oauth.token.User
 158
 159   const videoPlaylist = new VideoPlaylistModel({
 160     name: videoPlaylistInfo.displayName,
 161     description: videoPlaylistInfo.description,
 162     privacy: videoPlaylistInfo.privacy || VideoPlaylistPrivacy.PRIVATE,
 163     ownerAccountId: user.Account.id
 164   })
 165
 166   videoPlaylist.url = getVideoPlaylistActivityPubUrl(videoPlaylist) // We use the UUID, so set the URL after building the object
 167
 168   if (videoPlaylistInfo.videoChannelId) {
 169     const videoChannel = res.locals.videoChannel
 170
 171     videoPlaylist.videoChannelId = videoChannel.id
 172     videoPlaylist.VideoChannel = videoChannel
 173   }
 174
 175   const thumbnailField = req.files['thumbnailfile']
 176   const thumbnailModel = thumbnailField
 177     ? await createPlaylistMiniatureFromExisting(thumbnailField[0].path, videoPlaylist)
 178     : undefined
 179
 180   const videoPlaylistCreated: VideoPlaylistModel = await sequelizeTypescript.transaction(async t => {
 181     const videoPlaylistCreated = await videoPlaylist.save({ transaction: t })
 182
 183     if (thumbnailModel) await videoPlaylistCreated.setAndSaveThumbnail(thumbnailModel, t)
 184
 185     // We need more attributes for the federation
 186     videoPlaylistCreated.OwnerAccount = await AccountModel.load(user.Account.id, t)
 187     await sendCreateVideoPlaylist(videoPlaylistCreated, t)
 188
 189     return videoPlaylistCreated
 190   })
 191
 192   logger.info('Video playlist with uuid %s created.', videoPlaylist.uuid)
 193
 194   return res.json({
 195     videoPlaylist: {
 196       id: videoPlaylistCreated.id,
 197       uuid: videoPlaylistCreated.uuid
 198     }
 199   }).end()
 200 }
 201
 202 async function updateVideoPlaylist (req: express.Request, res: express.Response) {
 203   const videoPlaylistInstance = res.locals.videoPlaylist
 204   const videoPlaylistFieldsSave = videoPlaylistInstance.toJSON()
 205   const videoPlaylistInfoToUpdate = req.body as VideoPlaylistUpdate
 206
 207   const wasPrivatePlaylist = videoPlaylistInstance.privacy === VideoPlaylistPrivacy.PRIVATE
 208   const wasNotPrivatePlaylist = videoPlaylistInstance.privacy !== VideoPlaylistPrivacy.PRIVATE
 209
 210   const thumbnailField = req.files['thumbnailfile']
 211   const thumbnailModel = thumbnailField
 212     ? await createPlaylistMiniatureFromExisting(thumbnailField[0].path, videoPlaylistInstance)
 213     : undefined
 214
 215   try {
 216     await sequelizeTypescript.transaction(async t => {
 217       const sequelizeOptions = {
 218         transaction: t
 219       }
 220
 221       if (videoPlaylistInfoToUpdate.videoChannelId !== undefined) {
 222         if (videoPlaylistInfoToUpdate.videoChannelId === null) {
 223           videoPlaylistInstance.videoChannelId = null
 224         } else {
 225           const videoChannel = res.locals.videoChannel
 226
 227           videoPlaylistInstance.videoChannelId = videoChannel.id
 228           videoPlaylistInstance.VideoChannel = videoChannel
 229         }
 230       }
 231
 232       if (videoPlaylistInfoToUpdate.displayName !== undefined) videoPlaylistInstance.name = videoPlaylistInfoToUpdate.displayName
 233       if (videoPlaylistInfoToUpdate.description !== undefined) videoPlaylistInstance.description = videoPlaylistInfoToUpdate.description
 234
 235       if (videoPlaylistInfoToUpdate.privacy !== undefined) {
 236         videoPlaylistInstance.privacy = parseInt(videoPlaylistInfoToUpdate.privacy.toString(), 10)
 237
 238         if (wasNotPrivatePlaylist === true && videoPlaylistInstance.privacy === VideoPlaylistPrivacy.PRIVATE) {
 239           await sendDeleteVideoPlaylist(videoPlaylistInstance, t)
 240         }
 241       }
 242
 243       const playlistUpdated = await videoPlaylistInstance.save(sequelizeOptions)
 244
 245       if (thumbnailModel) await playlistUpdated.setAndSaveThumbnail(thumbnailModel, t)
 246
 247       const isNewPlaylist = wasPrivatePlaylist && playlistUpdated.privacy !== VideoPlaylistPrivacy.PRIVATE
 248
 249       if (isNewPlaylist) {
 250         await sendCreateVideoPlaylist(playlistUpdated, t)
 251       } else {
 252         await sendUpdateVideoPlaylist(playlistUpdated, t)
 253       }
 254
 255       logger.info('Video playlist %s updated.', videoPlaylistInstance.uuid)
 256
 257       return playlistUpdated
 258     })
 259   } catch (err) {
 260     logger.debug('Cannot update the video playlist.', { err })
 261
 262     // Force fields we want to update
 263     // If the transaction is retried, sequelize will think the object has not changed
 264     // So it will skip the SQL request, even if the last one was ROLLBACKed!
 265     resetSequelizeInstance(videoPlaylistInstance, videoPlaylistFieldsSave)
 266
 267     throw err
 268   }
 269
 270   return res.type('json').status(204).end()
 271 }
 272
 273 async function removeVideoPlaylist (req: express.Request, res: express.Response) {
 274   const videoPlaylistInstance = res.locals.videoPlaylist
 275
 276   await sequelizeTypescript.transaction(async t => {
 277     await videoPlaylistInstance.destroy({ transaction: t })
 278
 279     await sendDeleteVideoPlaylist(videoPlaylistInstance, t)
 280
 281     logger.info('Video playlist %s deleted.', videoPlaylistInstance.uuid)
 282   })
 283
 284   return res.type('json').status(204).end()
 285 }
 286
 287 async function addVideoInPlaylist (req: express.Request, res: express.Response) {
 288   const body: VideoPlaylistElementCreate = req.body
 289   const videoPlaylist = res.locals.videoPlaylist
 290   const video = res.locals.video
 291
 292   const playlistElement: VideoPlaylistElementModel = await sequelizeTypescript.transaction(async t => {
 293     const position = await VideoPlaylistElementModel.getNextPositionOf(videoPlaylist.id, t)
 294
 295     const playlistElement = await VideoPlaylistElementModel.create({
 296       url: getVideoPlaylistElementActivityPubUrl(videoPlaylist, video),
 297       position,
 298       startTimestamp: body.startTimestamp || null,
 299       stopTimestamp: body.stopTimestamp || null,
 300       videoPlaylistId: videoPlaylist.id,
 301       videoId: video.id
 302     }, { transaction: t })
 303
 304     videoPlaylist.changed('updatedAt', true)
 305     await videoPlaylist.save({ transaction: t })
 306
 307     await sendUpdateVideoPlaylist(videoPlaylist, t)
 308
 309     return playlistElement
 310   })
 311
 312   // If the user did not set a thumbnail, automatically take the video thumbnail
 313   if (videoPlaylist.hasThumbnail() === false) {
 314     logger.info('Generating default thumbnail to playlist %s.', videoPlaylist.url)
 315
 316     const inputPath = join(CONFIG.STORAGE.THUMBNAILS_DIR, video.getMiniature().filename)
 317     const thumbnailModel = await createPlaylistMiniatureFromExisting(inputPath, videoPlaylist, true)
 318
 319     thumbnailModel.videoPlaylistId = videoPlaylist.id
 320
 321     await thumbnailModel.save()
 322   }
 323
 324   logger.info('Video added in playlist %s at position %d.', videoPlaylist.uuid, playlistElement.position)
 325
 326   return res.json({
 327     videoPlaylistElement: {
 328       id: playlistElement.id
 329     }
 330   }).end()
 331 }
 332
 333 async function updateVideoPlaylistElement (req: express.Request, res: express.Response) {
 334   const body: VideoPlaylistElementUpdate = req.body
 335   const videoPlaylist = res.locals.videoPlaylist
 336   const videoPlaylistElement = res.locals.videoPlaylistElement
 337
 338   const playlistElement: VideoPlaylistElementModel = await sequelizeTypescript.transaction(async t => {
 339     if (body.startTimestamp !== undefined) videoPlaylistElement.startTimestamp = body.startTimestamp
 340     if (body.stopTimestamp !== undefined) videoPlaylistElement.stopTimestamp = body.stopTimestamp
 341
 342     const element = await videoPlaylistElement.save({ transaction: t })
 343
 344     videoPlaylist.changed('updatedAt', true)
 345     await videoPlaylist.save({ transaction: t })
 346
 347     await sendUpdateVideoPlaylist(videoPlaylist, t)
 348
 349     return element
 350   })
 351
 352   logger.info('Element of position %d of playlist %s updated.', playlistElement.position, videoPlaylist.uuid)
 353
 354   return res.type('json').status(204).end()
 355 }
 356
 357 async function removeVideoFromPlaylist (req: express.Request, res: express.Response) {
 358   const videoPlaylistElement = res.locals.videoPlaylistElement
 359   const videoPlaylist = res.locals.videoPlaylist
 360   const positionToDelete = videoPlaylistElement.position
 361
 362   await sequelizeTypescript.transaction(async t => {
 363     await videoPlaylistElement.destroy({ transaction: t })
 364
 365     // Decrease position of the next elements
 366     await VideoPlaylistElementModel.increasePositionOf(videoPlaylist.id, positionToDelete, null, -1, t)
 367
 368     videoPlaylist.changed('updatedAt', true)
 369     await videoPlaylist.save({ transaction: t })
 370
 371     await sendUpdateVideoPlaylist(videoPlaylist, t)
 372
 373     logger.info('Video playlist element %d of playlist %s deleted.', videoPlaylistElement.position, videoPlaylist.uuid)
 374   })
 375
 376   return res.type('json').status(204).end()
 377 }
 378
 379 async function reorderVideosPlaylist (req: express.Request, res: express.Response) {
 380   const videoPlaylist = res.locals.videoPlaylist
 381   const body: VideoPlaylistReorder = req.body
 382
 383   const start: number = body.startPosition
 384   const insertAfter: number = body.insertAfterPosition
 385   const reorderLength: number = body.reorderLength || 1
 386
 387   if (start === insertAfter) {
 388     return res.status(204).end()
 389   }
 390
 391   // Example: if we reorder position 2 and insert after position 5 (so at position 6): # 1 2 3 4 5 6 7 8 9
 392   //  * increase position when position > 5 # 1 2 3 4 5 7 8 9 10
 393   //  * update position 2 -> position 6 # 1 3 4 5 6 7 8 9 10
 394   //  * decrease position when position position > 2 # 1 2 3 4 5 6 7 8 9
 395   await sequelizeTypescript.transaction(async t => {
 396     const newPosition = insertAfter + 1
 397
 398     // Add space after the position when we want to insert our reordered elements (increase)
 399     await VideoPlaylistElementModel.increasePositionOf(videoPlaylist.id, newPosition, null, reorderLength, t)
 400
 401     let oldPosition = start
 402
 403     // We incremented the position of the elements we want to reorder
 404     if (start >= newPosition) oldPosition += reorderLength
 405
 406     const endOldPosition = oldPosition + reorderLength - 1
 407     // Insert our reordered elements in their place (update)
 408     await VideoPlaylistElementModel.reassignPositionOf(videoPlaylist.id, oldPosition, endOldPosition, newPosition, t)
 409
 410     // Decrease positions of elements after the old position of our ordered elements (decrease)
 411     await VideoPlaylistElementModel.increasePositionOf(videoPlaylist.id, oldPosition, null, -reorderLength, t)
 412
 413     videoPlaylist.changed('updatedAt', true)
 414     await videoPlaylist.save({ transaction: t })
 415
 416     await sendUpdateVideoPlaylist(videoPlaylist, t)
 417   })
 418
 419   logger.info(
 420     'Reordered playlist %s (inserted after %d elements %d - %d).',
 421     videoPlaylist.uuid, insertAfter, start, start + reorderLength - 1
 422   )
 423
 424   return res.type('json').status(204).end()
 425 }
 426
 427 async function getVideoPlaylistVideos (req: express.Request, res: express.Response) {
 428   const videoPlaylistInstance = res.locals.videoPlaylist
 429   const followerActorId = isUserAbleToSearchRemoteURI(res) ? null : undefined
 430
 431   const resultList = await VideoModel.listForApi({
 432     followerActorId,
 433     start: req.query.start,
 434     count: req.query.count,
 435     sort: 'VideoPlaylistElements.position',
 436     includeLocalVideos: true,
 437     categoryOneOf: req.query.categoryOneOf,
 438     licenceOneOf: req.query.licenceOneOf,
 439     languageOneOf: req.query.languageOneOf,
 440     tagsOneOf: req.query.tagsOneOf,
 441     tagsAllOf: req.query.tagsAllOf,
 442     filter: req.query.filter,
 443     nsfw: buildNSFWFilter(res, req.query.nsfw),
 444     withFiles: false,
 445     videoPlaylistId: videoPlaylistInstance.id,
 446     user: res.locals.oauth ? res.locals.oauth.token.User : undefined
 447   })
 448
 449   const additionalAttributes = { playlistInfo: true }
 450   return res.json(getFormattedObjects(resultList.data, resultList.total, { additionalAttributes }))
 451 }