1 import * as express from 'express'
2 import * as Promise from 'bluebird'
3 import * as multer from 'multer'
4 import { extname, join } from 'path'
6 import { database as db } from '../../../initializers/database'
9 REQUEST_VIDEO_QADU_TYPES,
10 REQUEST_VIDEO_EVENT_TYPES,
14 } from '../../../initializers'
16 addEventToRemoteVideo,
17 quickAndDirtyUpdateVideoToFriends,
29 videosUpdateValidator,
30 videosSearchValidator,
34 } from '../../../middlewares'
37 retryTransactionWrapper,
42 } from '../../../helpers'
43 import { TagInstance, VideoInstance } from '../../../models'
44 import { VideoCreate, VideoUpdate } from '../../../../shared'
46 import { abuseVideoRouter } from './abuse'
47 import { blacklistRouter } from './blacklist'
48 import { rateVideoRouter } from './rate'
49 import { videoChannelRouter } from './channel'
51 const videosRouter = express.Router()
53 // multer configuration
54 const storage = multer.diskStorage({
55 destination: (req, file, cb) => {
56 cb(null, CONFIG.STORAGE.VIDEOS_DIR)
59 filename: (req, file, cb) => {
61 if (file.mimetype === 'video/webm') extension = 'webm'
62 else if (file.mimetype === 'video/mp4') extension = 'mp4'
63 else if (file.mimetype === 'video/ogg') extension = 'ogv'
64 generateRandomString(16)
65 .then(randomString => {
66 cb(null, randomString + '.' + extension)
69 logger.error('Cannot generate random string for file name.', err)
75 const reqFiles = multer({ storage: storage }).fields([{ name: 'videofile', maxCount: 1 }])
77 videosRouter.use('/', abuseVideoRouter)
78 videosRouter.use('/', blacklistRouter)
79 videosRouter.use('/', rateVideoRouter)
80 videosRouter.use('/', videoChannelRouter)
82 videosRouter.get('/categories', listVideoCategories)
83 videosRouter.get('/licences', listVideoLicences)
84 videosRouter.get('/languages', listVideoLanguages)
93 videosRouter.put('/:id',
95 videosUpdateValidator,
96 updateVideoRetryWrapper
98 videosRouter.post('/upload',
104 videosRouter.get('/:id',
109 videosRouter.delete('/:id',
111 videosRemoveValidator,
112 removeVideoRetryWrapper
115 videosRouter.get('/search/:value',
116 videosSearchValidator,
125 // ---------------------------------------------------------------------------
131 // ---------------------------------------------------------------------------
133 function listVideoCategories (req: express.Request, res: express.Response) {
134 res.json(VIDEO_CATEGORIES)
137 function listVideoLicences (req: express.Request, res: express.Response) {
138 res.json(VIDEO_LICENCES)
141 function listVideoLanguages (req: express.Request, res: express.Response) {
142 res.json(VIDEO_LANGUAGES)
145 // Wrapper to video add that retry the function if there is a database error
146 // We need this because we run the transaction in SERIALIZABLE isolation that can fail
147 function addVideoRetryWrapper (req: express.Request, res: express.Response, next: express.NextFunction) {
149 arguments: [ req, res, req.files['videofile'][0] ],
150 errorMessage: 'Cannot insert the video with many retries.'
153 retryTransactionWrapper(addVideo, options)
155 // TODO : include Location of the new video -> 201
156 res.type('json').status(204).end()
158 .catch(err => next(err))
161 function addVideo (req: express.Request, res: express.Response, videoPhysicalFile: Express.Multer.File) {
162 const videoInfo: VideoCreate = req.body
165 return db.sequelize.transaction(t => {
166 let p: Promise<TagInstance[]>
168 if (!videoInfo.tags) p = Promise.resolve(undefined)
169 else p = db.Tag.findOrCreateTags(videoInfo.tags, t)
172 .then(tagInstances => {
174 name: videoInfo.name,
176 extname: extname(videoPhysicalFile.filename),
177 category: videoInfo.category,
178 licence: videoInfo.licence,
179 language: videoInfo.language,
180 nsfw: videoInfo.nsfw,
181 description: videoInfo.description,
182 duration: videoPhysicalFile['duration'], // duration was added by a previous middleware
183 channelId: res.locals.videoChannel.id
186 const video = db.Video.build(videoData)
187 return { tagInstances, video }
189 .then(({ tagInstances, video }) => {
190 const videoFilePath = join(CONFIG.STORAGE.VIDEOS_DIR, videoPhysicalFile.filename)
191 return getVideoFileHeight(videoFilePath)
192 .then(height => ({ tagInstances, video, videoFileHeight: height }))
194 .then(({ tagInstances, video, videoFileHeight }) => {
195 const videoFileData = {
196 extname: extname(videoPhysicalFile.filename),
197 resolution: videoFileHeight,
198 size: videoPhysicalFile.size
201 const videoFile = db.VideoFile.build(videoFileData)
202 return { tagInstances, video, videoFile }
204 .then(({ tagInstances, video, videoFile }) => {
205 const videoDir = CONFIG.STORAGE.VIDEOS_DIR
206 const source = join(videoDir, videoPhysicalFile.filename)
207 const destination = join(videoDir, video.getVideoFilename(videoFile))
209 return renamePromise(source, destination)
211 // This is important in case if there is another attempt in the retry process
212 videoPhysicalFile.filename = video.getVideoFilename(videoFile)
213 return { tagInstances, video, videoFile }
216 .then(({ tagInstances, video, videoFile }) => {
220 video.createTorrentAndSetInfoHash(videoFile),
221 video.createThumbnail(videoFile),
222 video.createPreview(videoFile)
225 if (CONFIG.TRANSCODING.ENABLED === true) {
226 // Put uuid because we don't have id auto incremented for now
228 videoUUID: video.uuid
232 JobScheduler.Instance.createJob(t, 'videoFileOptimizer', dataInput)
236 return Promise.all(tasks).then(() => ({ tagInstances, video, videoFile }))
238 .then(({ tagInstances, video, videoFile }) => {
239 const options = { transaction: t }
241 return video.save(options)
242 .then(videoCreated => {
243 // Do not forget to add video channel information to the created video
244 videoCreated.VideoChannel = res.locals.videoChannel
245 videoUUID = videoCreated.uuid
247 return { tagInstances, video: videoCreated, videoFile }
250 .then(({ tagInstances, video, videoFile }) => {
251 const options = { transaction: t }
252 videoFile.videoId = video.id
254 return videoFile.save(options)
255 .then(() => video.VideoFiles = [ videoFile ])
256 .then(() => ({ tagInstances, video }))
258 .then(({ tagInstances, video }) => {
259 if (!tagInstances) return video
261 const options = { transaction: t }
262 return video.setTags(tagInstances, options)
264 video.Tags = tagInstances
269 // Let transcoding job send the video to friends because the video file extension might change
270 if (CONFIG.TRANSCODING.ENABLED === true) return undefined
272 return video.toAddRemoteJSON()
273 .then(remoteVideo => {
274 // Now we'll add the video's meta data to our friends
275 return addVideoToFriends(remoteVideo, t)
279 .then(() => logger.info('Video with name %s and uuid %s created.', videoInfo.name, videoUUID))
280 .catch((err: Error) => {
281 logger.debug('Cannot insert the video.', err)
286 function updateVideoRetryWrapper (req: express.Request, res: express.Response, next: express.NextFunction) {
288 arguments: [ req, res ],
289 errorMessage: 'Cannot update the video with many retries.'
292 retryTransactionWrapper(updateVideo, options)
294 return res.type('json').status(204).end()
296 .catch(err => next(err))
299 function updateVideo (req: express.Request, res: express.Response) {
300 const videoInstance = res.locals.video
301 const videoFieldsSave = videoInstance.toJSON()
302 const videoInfoToUpdate: VideoUpdate = req.body
304 return db.sequelize.transaction(t => {
305 let tagsPromise: Promise<TagInstance[]>
306 if (!videoInfoToUpdate.tags) {
307 tagsPromise = Promise.resolve(null)
309 tagsPromise = db.Tag.findOrCreateTags(videoInfoToUpdate.tags, t)
313 .then(tagInstances => {
318 if (videoInfoToUpdate.name !== undefined) videoInstance.set('name', videoInfoToUpdate.name)
319 if (videoInfoToUpdate.category !== undefined) videoInstance.set('category', videoInfoToUpdate.category)
320 if (videoInfoToUpdate.licence !== undefined) videoInstance.set('licence', videoInfoToUpdate.licence)
321 if (videoInfoToUpdate.language !== undefined) videoInstance.set('language', videoInfoToUpdate.language)
322 if (videoInfoToUpdate.nsfw !== undefined) videoInstance.set('nsfw', videoInfoToUpdate.nsfw)
323 if (videoInfoToUpdate.description !== undefined) videoInstance.set('description', videoInfoToUpdate.description)
325 return videoInstance.save(options).then(() => tagInstances)
327 .then(tagInstances => {
328 if (!tagInstances) return
330 const options = { transaction: t }
331 return videoInstance.setTags(tagInstances, options)
333 videoInstance.Tags = tagInstances
339 const json = videoInstance.toUpdateRemoteJSON()
341 // Now we'll update the video's meta data to our friends
342 return updateVideoToFriends(json, t)
346 logger.info('Video with name %s and uuid %s updated.', videoInstance.name, videoInstance.uuid)
349 logger.debug('Cannot update the video.', err)
351 // Force fields we want to update
352 // If the transaction is retried, sequelize will think the object has not changed
353 // So it will skip the SQL request, even if the last one was ROLLBACKed!
354 Object.keys(videoFieldsSave).forEach(key => {
355 const value = videoFieldsSave[key]
356 videoInstance.set(key, value)
363 function getVideo (req: express.Request, res: express.Response) {
364 const videoInstance = res.locals.video
366 if (videoInstance.isOwned()) {
367 // The increment is done directly in the database, not using the instance value
368 videoInstance.increment('views')
370 // FIXME: make a real view system
371 // For example, only add a view when a user watch a video during 30s etc
373 videoId: videoInstance.id,
374 type: REQUEST_VIDEO_QADU_TYPES.VIEWS
376 return quickAndDirtyUpdateVideoToFriends(qaduParams)
378 .catch(err => logger.error('Cannot add view to video %d.', videoInstance.id, err))
380 // Just send the event to our friends
381 const eventParams = {
382 videoId: videoInstance.id,
383 type: REQUEST_VIDEO_EVENT_TYPES.VIEWS
385 addEventToRemoteVideo(eventParams)
388 // Do not wait the view system
389 res.json(videoInstance.toFormattedDetailsJSON())
392 function listVideos (req: express.Request, res: express.Response, next: express.NextFunction) {
393 db.Video.listForApi(req.query.start, req.query.count, req.query.sort)
394 .then(result => res.json(getFormattedObjects(result.data, result.total)))
395 .catch(err => next(err))
398 function removeVideoRetryWrapper (req: express.Request, res: express.Response, next: express.NextFunction) {
400 arguments: [ req, res ],
401 errorMessage: 'Cannot remove the video with many retries.'
404 retryTransactionWrapper(removeVideo, options)
406 return res.type('json').status(204).end()
408 .catch(err => next(err))
411 function removeVideo (req: express.Request, res: express.Response) {
412 const videoInstance: VideoInstance = res.locals.video
414 return db.sequelize.transaction(t => {
415 return videoInstance.destroy({ transaction: t })
418 logger.info('Video with name %s and uuid %s deleted.', videoInstance.name, videoInstance.uuid)
421 logger.error('Errors when removed the video.', err)
426 function searchVideos (req: express.Request, res: express.Response, next: express.NextFunction) {
427 db.Video.searchAndPopulateAuthorAndPodAndTags(req.params.value, req.query.field, req.query.start, req.query.count, req.query.sort)
428 .then(result => res.json(getFormattedObjects(result.data, result.total)))
429 .catch(err => next(err))