+async function getOrCreateVideo (videoObject: VideoTorrentObject, channelActor: ActorModel) {
+ logger.debug('Adding remote video %s.', videoObject.id)
+
+ return sequelizeTypescript.transaction(async t => {
+ const sequelizeOptions = {
+ transaction: t
+ }
+ const videoFromDatabase = await VideoModel.loadByUUIDOrURLAndPopulateAccount(videoObject.uuid, videoObject.id, t)
+ if (videoFromDatabase) return videoFromDatabase
+
+ const videoData = await videoActivityObjectToDBAttributes(channelActor.VideoChannel, videoObject, videoObject.to, videoObject.cc)
+ const video = VideoModel.build(videoData)
+
+ // Don't block on request
+ generateThumbnailFromUrl(video, videoObject.icon)
+ .catch(err => logger.warn('Cannot generate thumbnail of %s.', videoObject.id, err))
+
+ const videoCreated = await video.save(sequelizeOptions)
+
+ const videoFileAttributes = videoFileActivityUrlToDBAttributes(videoCreated, videoObject)
+ if (videoFileAttributes.length === 0) {
+ throw new Error('Cannot find valid files for video %s ' + videoObject.url)
+ }
+
+ const tasks = videoFileAttributes.map(f => VideoFileModel.create(f, { transaction: t }))
+ await Promise.all(tasks)
+
+ const tags = videoObject.tag.map(t => t.name)
+ const tagInstances = await TagModel.findOrCreateTags(tags, t)
+ await videoCreated.$set('Tags', tagInstances, sequelizeOptions)
+
+ logger.info('Remote video with uuid %s inserted.', videoObject.uuid)
+
+ videoCreated.VideoChannel = channelActor.VideoChannel
+ return videoCreated
+ })
+}
+
+async function getOrCreateAccountAndVideoAndChannel (videoObject: VideoTorrentObject | string, actor?: ActorModel) {
+ if (typeof videoObject === 'string') {
+ const videoFromDatabase = await VideoModel.loadByUrlAndPopulateAccount(videoObject)
+ if (videoFromDatabase) {
+ return {
+ video: videoFromDatabase,
+ actor: videoFromDatabase.VideoChannel.Account.Actor,
+ channelActor: videoFromDatabase.VideoChannel.Actor
+ }
+ }
+
+ videoObject = await fetchRemoteVideo(videoObject)
+ if (!videoObject) throw new Error('Cannot fetch remote video')
+ }
+
+ if (!actor) {
+ const actorObj = videoObject.attributedTo.find(a => a.type === 'Person')
+ if (!actorObj) throw new Error('Cannot find associated actor to video ' + videoObject.url)
+
+ actor = await getOrCreateActorAndServerAndModel(actorObj.id)
+ }
+
+ const channel = videoObject.attributedTo.find(a => a.type === 'Group')
+ if (!channel) throw new Error('Cannot find associated video channel to video ' + videoObject.url)
+
+ const channelActor = await getOrCreateActorAndServerAndModel(channel.id)
+
+ const options = {
+ arguments: [ videoObject, channelActor ],
+ errorMessage: 'Cannot insert the remote video with many retries.'
+ }
+
+ const video = await retryTransactionWrapper(getOrCreateVideo, options)
+
+ // Process outside the transaction because we could fetch remote data
+ if (videoObject.likes && Array.isArray(videoObject.likes.orderedItems)) {
+ logger.info('Adding likes of video %s.', video.uuid)
+ await createRates(videoObject.likes.orderedItems, video, 'like')
+ }
+
+ if (videoObject.dislikes && Array.isArray(videoObject.dislikes.orderedItems)) {
+ logger.info('Adding dislikes of video %s.', video.uuid)
+ await createRates(videoObject.dislikes.orderedItems, video, 'dislike')
+ }
+
+ if (videoObject.shares && Array.isArray(videoObject.shares.orderedItems)) {
+ logger.info('Adding shares of video %s.', video.uuid)
+ await addVideoShares(video, videoObject.shares.orderedItems)
+ }
+
+ if (videoObject.comments && Array.isArray(videoObject.comments.orderedItems)) {
+ logger.info('Adding comments of video %s.', video.uuid)
+ await addVideoComments(video, videoObject.comments.orderedItems)
+ }
+
+ return { actor, channelActor, video }
+}
+
+async function createRates (actorUrls: string[], video: VideoModel, rate: VideoRateType) {
+ let rateCounts = 0
+ const tasks: Bluebird<number>[] = []
+
+ for (const actorUrl of actorUrls) {
+ const actor = await getOrCreateActorAndServerAndModel(actorUrl)
+ const p = AccountVideoRateModel
+ .create({
+ videoId: video.id,
+ accountId: actor.Account.id,
+ type: rate
+ })
+ .then(() => rateCounts += 1)
+
+ tasks.push(p)
+ }
+
+ await Promise.all(tasks)
+
+ logger.info('Adding %d %s to video %s.', rateCounts, rate, video.uuid)
+
+ // This is "likes" and "dislikes"
+ await video.increment(rate + 's', { by: rateCounts })
+
+ return
+}
+
+async function addVideoShares (instance: VideoModel, shareUrls: string[]) {
+ for (const shareUrl of shareUrls) {
+ // Fetch url
+ const { body } = await doRequest({
+ uri: shareUrl,
+ json: true,
+ activityPub: true
+ })
+ const actorUrl = body.actor
+ if (!actorUrl) continue
+
+ const actor = await getOrCreateActorAndServerAndModel(actorUrl)
+
+ const entry = {
+ actorId: actor.id,
+ videoId: instance.id,
+ url: shareUrl
+ }
+
+ await VideoShareModel.findOrCreate({
+ where: {
+ url: shareUrl
+ },
+ defaults: entry
+ })
+ }