'use strict'
-const each = require('async/each')
const express = require('express')
const fs = require('fs')
const multer = require('multer')
const logger = require('../../helpers/logger')
const friends = require('../../lib/friends')
const middlewares = require('../../middlewares')
+const admin = middlewares.admin
const oAuth = middlewares.oauth
const pagination = middlewares.pagination
const validators = middlewares.validators
const reqFiles = multer({ storage: storage }).fields([{ name: 'videofile', maxCount: 1 }])
+router.get('/abuse',
+ oAuth.authenticate,
+ admin.ensureIsAdmin,
+ validatorsPagination.pagination,
+ validatorsSort.videoAbusesSort,
+ sort.setVideoAbusesSort,
+ pagination.setPagination,
+ listVideoAbuses
+)
+router.post('/:id/abuse',
+ oAuth.authenticate,
+ validatorsVideos.videoAbuseReport,
+ reportVideoAbuseRetryWrapper
+)
+
router.get('/',
validatorsPagination.pagination,
validatorsSort.videosSort,
pagination.setPagination,
listVideos
)
+router.put('/:id',
+ oAuth.authenticate,
+ reqFiles,
+ validatorsVideos.videosUpdate,
+ updateVideoRetryWrapper
+)
router.post('/',
oAuth.authenticate,
reqFiles,
validatorsVideos.videosAdd,
- addVideo
+ addVideoRetryWrapper
)
router.get('/:id',
validatorsVideos.videosGet,
// ---------------------------------------------------------------------------
-function addVideo (req, res, next) {
- const videoFile = req.files.videofile[0]
+// Wrapper to video add that retry the function if there is a database error
+// We need this because we run the transaction in SERIALIZABLE isolation that can fail
+function addVideoRetryWrapper (req, res, next) {
+ const options = {
+ arguments: [ req, res, req.files.videofile[0] ],
+ errorMessage: 'Cannot insert the video with many retries.'
+ }
+
+ utils.retryWrapper(addVideo, options, function (err) {
+ if (err) return next(err)
+
+ // TODO : include Location of the new video -> 201
+ return res.type('json').status(204).end()
+ })
+}
+
+function addVideo (req, res, videoFile, callback) {
const videoInfos = req.body
waterfall([
- function startTransaction (callback) {
- db.sequelize.transaction().asCallback(function (err, t) {
- return callback(err, t)
+ function startTransaction (callbackWaterfall) {
+ db.sequelize.transaction({ isolationLevel: 'SERIALIZABLE' }).asCallback(function (err, t) {
+ return callbackWaterfall(err, t)
})
},
- function findOrCreateAuthor (t, callback) {
+ function findOrCreateAuthor (t, callbackWaterfall) {
const user = res.locals.oauth.token.User
- const query = {
- where: {
- name: user.username,
- podId: null,
- userId: user.id
- },
- defaults: {
- name: user.username,
- podId: null, // null because it is OUR pod
- userId: user.id
- },
- transaction: t
- }
-
- db.Author.findOrCreate(query).asCallback(function (err, result) {
- const authorInstance = result[0]
+ const name = user.username
+ // null because it is OUR pod
+ const podId = null
+ const userId = user.id
- return callback(err, t, authorInstance)
+ db.Author.findOrCreateAuthor(name, podId, userId, t, function (err, authorInstance) {
+ return callbackWaterfall(err, t, authorInstance)
})
},
- function findOrCreateTags (t, author, callback) {
+ function findOrCreateTags (t, author, callbackWaterfall) {
const tags = videoInfos.tags
- const tagInstances = []
-
- each(tags, function (tag, callbackEach) {
- const query = {
- where: {
- name: tag
- },
- defaults: {
- name: tag
- },
- transaction: t
- }
-
- db.Tag.findOrCreate(query).asCallback(function (err, res) {
- if (err) return callbackEach(err)
- // res = [ tag, isCreated ]
- const tag = res[0]
- tagInstances.push(tag)
- return callbackEach()
- })
- }, function (err) {
- return callback(err, t, author, tagInstances)
+ db.Tag.findOrCreateTags(tags, t, function (err, tagInstances) {
+ return callbackWaterfall(err, t, author, tagInstances)
})
},
- function createVideoObject (t, author, tagInstances, callback) {
+ function createVideoObject (t, author, tagInstances, callbackWaterfall) {
const videoData = {
name: videoInfos.name,
remoteId: null,
const video = db.Video.build(videoData)
- return callback(null, t, author, tagInstances, video)
+ return callbackWaterfall(null, t, author, tagInstances, video)
},
// Set the videoname the same as the id
- function renameVideoFile (t, author, tagInstances, video, callback) {
+ function renameVideoFile (t, author, tagInstances, video, callbackWaterfall) {
const videoDir = constants.CONFIG.STORAGE.VIDEOS_DIR
const source = path.join(videoDir, videoFile.filename)
const destination = path.join(videoDir, video.getVideoFilename())
fs.rename(source, destination, function (err) {
- return callback(err, t, author, tagInstances, video)
+ if (err) return callbackWaterfall(err)
+
+ // This is important in case if there is another attempt
+ videoFile.filename = video.getVideoFilename()
+ return callbackWaterfall(null, t, author, tagInstances, video)
})
},
- function insertVideoIntoDB (t, author, tagInstances, video, callback) {
+ function insertVideoIntoDB (t, author, tagInstances, video, callbackWaterfall) {
const options = { transaction: t }
// Add tags association
video.save(options).asCallback(function (err, videoCreated) {
- if (err) return callback(err)
+ if (err) return callbackWaterfall(err)
// Do not forget to add Author informations to the created video
videoCreated.Author = author
- return callback(err, t, tagInstances, videoCreated)
+ return callbackWaterfall(err, t, tagInstances, videoCreated)
})
},
- function associateTagsToVideo (t, tagInstances, video, callback) {
+ function associateTagsToVideo (t, tagInstances, video, callbackWaterfall) {
const options = { transaction: t }
video.setTags(tagInstances, options).asCallback(function (err) {
video.Tags = tagInstances
- return callback(err, t, video)
+ return callbackWaterfall(err, t, video)
})
},
- function sendToFriends (t, video, callback) {
- video.toRemoteJSON(function (err, remoteVideo) {
- if (err) return callback(err)
+ function sendToFriends (t, video, callbackWaterfall) {
+ video.toAddRemoteJSON(function (err, remoteVideo) {
+ if (err) return callbackWaterfall(err)
// Now we'll add the video's meta data to our friends
- friends.addVideoToFriends(remoteVideo)
-
- return callback(null, t)
+ friends.addVideoToFriends(remoteVideo, t, function (err) {
+ return callbackWaterfall(err, t)
+ })
})
}
], function andFinally (err, t) {
if (err) {
- logger.error('Cannot insert the video.')
+ // This is just a debug because we will retry the insert
+ logger.debug('Cannot insert the video.', { error: err })
// Abort transaction?
if (t) t.rollback()
- return next(err)
+ return callback(err)
}
// Commit transaction
- t.commit()
+ t.commit().asCallback(function (err) {
+ if (err) return callback(err)
- // TODO : include Location of the new video -> 201
- return res.type('json').status(204).end()
+ logger.info('Video with name %s created.', videoInfos.name)
+ return callback(null)
+ })
})
}
-function getVideo (req, res, next) {
- db.Video.loadAndPopulateAuthorAndPodAndTags(req.params.id, function (err, video) {
- if (err) return next(err)
-
- if (!video) {
- return res.type('json').status(204).end()
- }
-
- res.json(video.toFormatedJSON())
- })
-}
+function updateVideoRetryWrapper (req, res, next) {
+ const options = {
+ arguments: [ req, res ],
+ errorMessage: 'Cannot update the video with many retries.'
+ }
-function listVideos (req, res, next) {
- db.Video.listForApi(req.query.start, req.query.count, req.query.sort, function (err, videosList, videosTotal) {
+ utils.retryWrapper(updateVideo, options, function (err) {
if (err) return next(err)
- res.json(getFormatedVideos(videosList, videosTotal))
+ // TODO : include Location of the new video -> 201
+ return res.type('json').status(204).end()
})
}
-function removeVideo (req, res, next) {
- const videoId = req.params.id
+function updateVideo (req, res, finalCallback) {
+ const videoInstance = res.locals.video
+ const videoFieldsSave = videoInstance.toJSON()
+ const videoInfosToUpdate = req.body
waterfall([
- function getVideo (callback) {
- db.Video.load(videoId, callback)
+
+ function startTransaction (callback) {
+ db.sequelize.transaction({ isolationLevel: 'SERIALIZABLE' }).asCallback(function (err, t) {
+ return callback(err, t)
+ })
},
- function removeFromDB (video, callback) {
- video.destroy().asCallback(function (err) {
- if (err) return callback(err)
+ function findOrCreateTags (t, callback) {
+ if (videoInfosToUpdate.tags) {
+ db.Tag.findOrCreateTags(videoInfosToUpdate.tags, t, function (err, tagInstances) {
+ return callback(err, t, tagInstances)
+ })
+ } else {
+ return callback(null, t, null)
+ }
+ },
- return callback(null, video)
+ function updateVideoIntoDB (t, tagInstances, callback) {
+ const options = {
+ transaction: t
+ }
+
+ if (videoInfosToUpdate.name) videoInstance.set('name', videoInfosToUpdate.name)
+ if (videoInfosToUpdate.description) videoInstance.set('description', videoInfosToUpdate.description)
+
+ videoInstance.save(options).asCallback(function (err) {
+ return callback(err, t, tagInstances)
})
},
- function sendInformationToFriends (video, callback) {
- const params = {
- name: video.name,
- remoteId: video.id
+ function associateTagsToVideo (t, tagInstances, callback) {
+ if (tagInstances) {
+ const options = { transaction: t }
+
+ videoInstance.setTags(tagInstances, options).asCallback(function (err) {
+ videoInstance.Tags = tagInstances
+
+ return callback(err, t)
+ })
+ } else {
+ return callback(null, t)
}
+ },
- friends.removeVideoToFriends(params)
+ function sendToFriends (t, callback) {
+ const json = videoInstance.toUpdateRemoteJSON()
- return callback(null)
+ // Now we'll update the video's meta data to our friends
+ friends.updateVideoToFriends(json, t, function (err) {
+ return callback(err, t)
+ })
}
- ], function andFinally (err) {
+
+ ], function andFinally (err, t) {
+ if (err) {
+ logger.debug('Cannot update the video.', { error: err })
+
+ // Abort transaction?
+ if (t) t.rollback()
+
+ // Force fields we want to update
+ // If the transaction is retried, sequelize will think the object has not changed
+ // So it will skip the SQL request, even if the last one was ROLLBACKed!
+ Object.keys(videoFieldsSave).forEach(function (key) {
+ const value = videoFieldsSave[key]
+ videoInstance.set(key, value)
+ })
+
+ return finalCallback(err)
+ }
+
+ // Commit transaction
+ t.commit().asCallback(function (err) {
+ if (err) return finalCallback(err)
+
+ logger.info('Video with name %s updated.', videoInfosToUpdate.name)
+ return finalCallback(null)
+ })
+ })
+}
+
+function getVideo (req, res, next) {
+ const videoInstance = res.locals.video
+ res.json(videoInstance.toFormatedJSON())
+}
+
+function listVideos (req, res, next) {
+ db.Video.listForApi(req.query.start, req.query.count, req.query.sort, function (err, videosList, videosTotal) {
+ if (err) return next(err)
+
+ res.json(utils.getFormatedObjects(videosList, videosTotal))
+ })
+}
+
+function removeVideo (req, res, next) {
+ const videoInstance = res.locals.video
+
+ videoInstance.destroy().asCallback(function (err) {
if (err) {
logger.error('Errors when removed the video.', { error: err })
return next(err)
function (err, videosList, videosTotal) {
if (err) return next(err)
- res.json(getFormatedVideos(videosList, videosTotal))
+ res.json(utils.getFormatedObjects(videosList, videosTotal))
}
)
}
-// ---------------------------------------------------------------------------
-
-function getFormatedVideos (videos, videosTotal) {
- const formatedVideos = []
+function listVideoAbuses (req, res, next) {
+ db.VideoAbuse.listForApi(req.query.start, req.query.count, req.query.sort, function (err, abusesList, abusesTotal) {
+ if (err) return next(err)
- videos.forEach(function (video) {
- formatedVideos.push(video.toFormatedJSON())
+ res.json(utils.getFormatedObjects(abusesList, abusesTotal))
})
+}
- return {
- total: videosTotal,
- data: formatedVideos
+function reportVideoAbuseRetryWrapper (req, res, next) {
+ utils.transactionRetryer(
+ function (callback) {
+ return reportVideoAbuse(req, res, callback)
+ },
+ function (err) {
+ if (err) {
+ logger.error('Cannot report abuse to the video with many retries.', { error: err })
+ return next(err)
+ }
+
+ return res.type('json').status(204).end()
+ }
+ )
+}
+
+function reportVideoAbuse (req, res, finalCallback) {
+ const videoInstance = res.locals.video
+ const reporterUsername = res.locals.oauth.token.User.username
+
+ const abuse = {
+ reporterUsername,
+ reason: req.body.reason,
+ videoId: videoInstance.id,
+ reporterPodId: null // This is our pod that reported this abuse
}
+
+ waterfall([
+
+ function startTransaction (callback) {
+ db.sequelize.transaction().asCallback(function (err, t) {
+ return callback(err, t)
+ })
+ },
+
+ function createAbuse (t, callback) {
+ db.VideoAbuse.create(abuse).asCallback(function (err, abuse) {
+ return callback(err, t, abuse)
+ })
+ },
+
+ function sendToFriendsIfNeeded (t, abuse, callback) {
+ // We send the information to the destination pod
+ if (videoInstance.isOwned() === false) {
+ const reportData = {
+ reporterUsername,
+ reportReason: abuse.reason,
+ videoRemoteId: videoInstance.remoteId
+ }
+
+ friends.reportAbuseVideoToFriend(reportData, videoInstance)
+ }
+
+ return callback(null, t)
+ }
+
+ ], function andFinally (err, t) {
+ if (err) {
+ logger.debug('Cannot update the video.', { error: err })
+
+ // Abort transaction?
+ if (t) t.rollback()
+
+ return finalCallback(err)
+ }
+
+ // Commit transaction
+ t.commit().asCallback(function (err) {
+ if (err) return finalCallback(err)
+
+ logger.info('Abuse report for video %s created.', videoInstance.name)
+ return finalCallback(null)
+ })
+ })
}
+