aboutsummaryrefslogtreecommitdiffhomepage
path: root/server
diff options
context:
space:
mode:
Diffstat (limited to 'server')
-rw-r--r--server/models/video/video-format-utils.ts6
-rw-r--r--server/models/video/video-query-builder.ts32
-rw-r--r--server/models/video/video.ts56
-rw-r--r--server/tests/feeds/feeds.ts36
4 files changed, 117 insertions, 13 deletions
diff --git a/server/models/video/video-format-utils.ts b/server/models/video/video-format-utils.ts
index 7a17c839f..ad512fc7f 100644
--- a/server/models/video/video-format-utils.ts
+++ b/server/models/video/video-format-utils.ts
@@ -59,7 +59,11 @@ function videoModelToFormattedJSON (video: MVideoFormattable, options?: VideoFor
59 label: VideoModel.getPrivacyLabel(video.privacy) 59 label: VideoModel.getPrivacyLabel(video.privacy)
60 }, 60 },
61 nsfw: video.nsfw, 61 nsfw: video.nsfw,
62 description: options && options.completeDescription === true ? video.description : video.getTruncatedDescription(), 62
63 description: options && options.completeDescription === true
64 ? video.description
65 : video.getTruncatedDescription(),
66
63 isLocal: video.isOwned(), 67 isLocal: video.isOwned(),
64 duration: video.duration, 68 duration: video.duration,
65 views: video.views, 69 views: video.views,
diff --git a/server/models/video/video-query-builder.ts b/server/models/video/video-query-builder.ts
index 466890364..b14bb16d6 100644
--- a/server/models/video/video-query-builder.ts
+++ b/server/models/video/video-query-builder.ts
@@ -156,7 +156,16 @@ function buildListQuery (model: typeof Model, options: BuildVideosQueryOptions)
156 } 156 }
157 157
158 if (options.withFiles === true) { 158 if (options.withFiles === true) {
159 and.push('EXISTS (SELECT 1 FROM "videoFile" WHERE "videoFile"."videoId" = "video"."id")') 159 and.push(
160 '(' +
161 ' EXISTS (SELECT 1 FROM "videoFile" WHERE "videoFile"."videoId" = "video"."id") ' +
162 ' OR EXISTS (' +
163 ' SELECT 1 FROM "videoStreamingPlaylist" ' +
164 ' INNER JOIN "videoFile" ON "videoFile"."videoStreamingPlaylistId" = "videoStreamingPlaylist"."id" ' +
165 ' WHERE "videoStreamingPlaylist"."videoId" = "video"."id"' +
166 ' )' +
167 ')'
168 )
160 } 169 }
161 170
162 if (options.tagsOneOf) { 171 if (options.tagsOneOf) {
@@ -443,7 +452,13 @@ function wrapForAPIResults (baseQuery: string, replacements: any, options: Build
443 ] 452 ]
444 453
445 if (options.withFiles) { 454 if (options.withFiles) {
446 joins.push('INNER JOIN "videoFile" AS "VideoFiles" ON "VideoFiles"."videoId" = "video"."id"') 455 joins.push('LEFT JOIN "videoFile" AS "VideoFiles" ON "VideoFiles"."videoId" = "video"."id"')
456
457 joins.push('LEFT JOIN "videoStreamingPlaylist" AS "VideoStreamingPlaylists" ON "VideoStreamingPlaylists"."videoId" = "video"."id"')
458 joins.push(
459 'LEFT JOIN "videoFile" AS "VideoStreamingPlaylists->VideoFiles" ' +
460 'ON "VideoStreamingPlaylists->VideoFiles"."videoStreamingPlaylistId" = "VideoStreamingPlaylists"."id"'
461 )
447 462
448 Object.assign(attributes, { 463 Object.assign(attributes, {
449 '"VideoFiles"."id"': '"VideoFiles.id"', 464 '"VideoFiles"."id"': '"VideoFiles.id"',
@@ -454,7 +469,18 @@ function wrapForAPIResults (baseQuery: string, replacements: any, options: Build
454 '"VideoFiles"."extname"': '"VideoFiles.extname"', 469 '"VideoFiles"."extname"': '"VideoFiles.extname"',
455 '"VideoFiles"."infoHash"': '"VideoFiles.infoHash"', 470 '"VideoFiles"."infoHash"': '"VideoFiles.infoHash"',
456 '"VideoFiles"."fps"': '"VideoFiles.fps"', 471 '"VideoFiles"."fps"': '"VideoFiles.fps"',
457 '"VideoFiles"."videoId"': '"VideoFiles.videoId"' 472 '"VideoFiles"."videoId"': '"VideoFiles.videoId"',
473
474 '"VideoStreamingPlaylists"."id"': '"VideoStreamingPlaylists.id"',
475 '"VideoStreamingPlaylists->VideoFiles"."id"': '"VideoStreamingPlaylists.VideoFiles.id"',
476 '"VideoStreamingPlaylists->VideoFiles"."createdAt"': '"VideoStreamingPlaylists.VideoFiles.createdAt"',
477 '"VideoStreamingPlaylists->VideoFiles"."updatedAt"': '"VideoStreamingPlaylists.VideoFiles.updatedAt"',
478 '"VideoStreamingPlaylists->VideoFiles"."resolution"': '"VideoStreamingPlaylists.VideoFiles.resolution"',
479 '"VideoStreamingPlaylists->VideoFiles"."size"': '"VideoStreamingPlaylists.VideoFiles.size"',
480 '"VideoStreamingPlaylists->VideoFiles"."extname"': '"VideoStreamingPlaylists.VideoFiles.extname"',
481 '"VideoStreamingPlaylists->VideoFiles"."infoHash"': '"VideoStreamingPlaylists.VideoFiles.infoHash"',
482 '"VideoStreamingPlaylists->VideoFiles"."fps"': '"VideoStreamingPlaylists.VideoFiles.fps"',
483 '"VideoStreamingPlaylists->VideoFiles"."videoId"': '"VideoStreamingPlaylists.VideoFiles.videoId"'
458 }) 484 })
459 } 485 }
460 486
diff --git a/server/models/video/video.ts b/server/models/video/video.ts
index 43609587c..1eded0d56 100644
--- a/server/models/video/video.ts
+++ b/server/models/video/video.ts
@@ -95,7 +95,7 @@ import {
95 MVideoWithRights 95 MVideoWithRights
96} from '../../types/models' 96} from '../../types/models'
97import { MThumbnail } from '../../types/models/video/thumbnail' 97import { MThumbnail } from '../../types/models/video/thumbnail'
98import { MVideoFile, MVideoFileStreamingPlaylistVideo } from '../../types/models/video/video-file' 98import { MVideoFile, MVideoFileStreamingPlaylistVideo, MVideoFileRedundanciesOpt } from '../../types/models/video/video-file'
99import { VideoAbuseModel } from '../abuse/video-abuse' 99import { VideoAbuseModel } from '../abuse/video-abuse'
100import { AccountModel } from '../account/account' 100import { AccountModel } from '../account/account'
101import { AccountVideoRateModel } from '../account/account-video-rate' 101import { AccountVideoRateModel } from '../account/account-video-rate'
@@ -127,6 +127,7 @@ import { VideoShareModel } from './video-share'
127import { VideoStreamingPlaylistModel } from './video-streaming-playlist' 127import { VideoStreamingPlaylistModel } from './video-streaming-playlist'
128import { VideoTagModel } from './video-tag' 128import { VideoTagModel } from './video-tag'
129import { VideoViewModel } from './video-view' 129import { VideoViewModel } from './video-view'
130import { stream } from 'winston'
130 131
131export enum ScopeNames { 132export enum ScopeNames {
132 AVAILABLE_FOR_LIST_IDS = 'AVAILABLE_FOR_LIST_IDS', 133 AVAILABLE_FOR_LIST_IDS = 'AVAILABLE_FOR_LIST_IDS',
@@ -1472,11 +1473,13 @@ export class VideoModel extends Model<VideoModel> {
1472 } 1473 }
1473 1474
1474 private static buildAPIResult (rows: any[]) { 1475 private static buildAPIResult (rows: any[]) {
1475 const memo: { [ id: number ]: VideoModel } = {} 1476 const videosMemo: { [ id: number ]: VideoModel } = {}
1477 const videoStreamingPlaylistMemo: { [ id: number ]: VideoStreamingPlaylistModel } = {}
1476 1478
1477 const thumbnailsDone = new Set<number>() 1479 const thumbnailsDone = new Set<number>()
1478 const historyDone = new Set<number>() 1480 const historyDone = new Set<number>()
1479 const videoFilesDone = new Set<number>() 1481 const videoFilesDone = new Set<number>()
1482 const videoStreamingPlaylistsDone = new Set<number>()
1480 1483
1481 const videos: VideoModel[] = [] 1484 const videos: VideoModel[] = []
1482 1485
@@ -1484,6 +1487,7 @@ export class VideoModel extends Model<VideoModel> {
1484 const actorKeys = [ 'id', 'preferredUsername', 'url', 'serverId', 'avatarId' ] 1487 const actorKeys = [ 'id', 'preferredUsername', 'url', 'serverId', 'avatarId' ]
1485 const serverKeys = [ 'id', 'host' ] 1488 const serverKeys = [ 'id', 'host' ]
1486 const videoFileKeys = [ 'id', 'createdAt', 'updatedAt', 'resolution', 'size', 'extname', 'infoHash', 'fps', 'videoId' ] 1489 const videoFileKeys = [ 'id', 'createdAt', 'updatedAt', 'resolution', 'size', 'extname', 'infoHash', 'fps', 'videoId' ]
1490 const videoStreamingPlaylistKeys = [ 'id' ]
1487 const videoKeys = [ 1491 const videoKeys = [
1488 'id', 1492 'id',
1489 'uuid', 1493 'uuid',
@@ -1529,7 +1533,7 @@ export class VideoModel extends Model<VideoModel> {
1529 } 1533 }
1530 1534
1531 for (const row of rows) { 1535 for (const row of rows) {
1532 if (!memo[row.id]) { 1536 if (!videosMemo[row.id]) {
1533 // Build Channel 1537 // Build Channel
1534 const channel = row.VideoChannel 1538 const channel = row.VideoChannel
1535 const channelModel = new VideoChannelModel(pick(channel, [ 'id', 'name', 'description', 'actorId' ])) 1539 const channelModel = new VideoChannelModel(pick(channel, [ 'id', 'name', 'description', 'actorId' ]))
@@ -1547,13 +1551,14 @@ export class VideoModel extends Model<VideoModel> {
1547 videoModel.UserVideoHistories = [] 1551 videoModel.UserVideoHistories = []
1548 videoModel.Thumbnails = [] 1552 videoModel.Thumbnails = []
1549 videoModel.VideoFiles = [] 1553 videoModel.VideoFiles = []
1554 videoModel.VideoStreamingPlaylists = []
1550 1555
1551 memo[row.id] = videoModel 1556 videosMemo[row.id] = videoModel
1552 // Don't take object value to have a sorted array 1557 // Don't take object value to have a sorted array
1553 videos.push(videoModel) 1558 videos.push(videoModel)
1554 } 1559 }
1555 1560
1556 const videoModel = memo[row.id] 1561 const videoModel = videosMemo[row.id]
1557 1562
1558 if (row.userVideoHistory?.id && !historyDone.has(row.userVideoHistory.id)) { 1563 if (row.userVideoHistory?.id && !historyDone.has(row.userVideoHistory.id)) {
1559 const historyModel = new UserVideoHistoryModel(pick(row.userVideoHistory, [ 'id', 'currentTime' ])) 1564 const historyModel = new UserVideoHistoryModel(pick(row.userVideoHistory, [ 'id', 'currentTime' ]))
@@ -1575,6 +1580,31 @@ export class VideoModel extends Model<VideoModel> {
1575 1580
1576 videoFilesDone.add(row.VideoFiles.id) 1581 videoFilesDone.add(row.VideoFiles.id)
1577 } 1582 }
1583
1584 if (row.VideoFiles?.id && !videoFilesDone.has(row.VideoFiles.id)) {
1585 const videoFileModel = new VideoFileModel(pick(row.VideoFiles, videoFileKeys))
1586 videoModel.VideoFiles.push(videoFileModel)
1587
1588 videoFilesDone.add(row.VideoFiles.id)
1589 }
1590
1591 if (row.VideoStreamingPlaylists?.id && !videoStreamingPlaylistMemo[row.VideoStreamingPlaylists.id]) {
1592 const streamingPlaylist = new VideoStreamingPlaylistModel(pick(row.VideoStreamingPlaylists, videoStreamingPlaylistKeys))
1593 streamingPlaylist.VideoFiles = []
1594
1595 videoModel.VideoStreamingPlaylists.push(streamingPlaylist)
1596
1597 videoStreamingPlaylistMemo[streamingPlaylist.id] = streamingPlaylist
1598 }
1599
1600 if (row.VideoStreamingPlaylists?.VideoFiles?.id && !videoFilesDone.has(row.VideoStreamingPlaylists.VideoFiles.id)) {
1601 const streamingPlaylist = videoStreamingPlaylistMemo[row.VideoStreamingPlaylists.id]
1602
1603 const videoFileModel = new VideoFileModel(pick(row.VideoStreamingPlaylists.VideoFiles, videoFileKeys))
1604 streamingPlaylist.VideoFiles.push(videoFileModel)
1605
1606 videoFilesDone.add(row.VideoStreamingPlaylists.VideoFiles.id)
1607 }
1578 } 1608 }
1579 1609
1580 return videos 1610 return videos
@@ -1717,7 +1747,21 @@ export class VideoModel extends Model<VideoModel> {
1717 1747
1718 getFormattedVideoFilesJSON (): VideoFile[] { 1748 getFormattedVideoFilesJSON (): VideoFile[] {
1719 const { baseUrlHttp, baseUrlWs } = this.getBaseUrls() 1749 const { baseUrlHttp, baseUrlWs } = this.getBaseUrls()
1720 return videoFilesModelToFormattedJSON(this, baseUrlHttp, baseUrlWs, this.VideoFiles) 1750 let files: MVideoFileRedundanciesOpt[] = []
1751
1752 logger.info('coucou', { files })
1753
1754 if (Array.isArray(this.VideoFiles)) {
1755 files = files.concat(this.VideoFiles)
1756 }
1757
1758 for (const p of (this.VideoStreamingPlaylists || [])) {
1759 files = files.concat(p.VideoFiles || [])
1760 }
1761
1762 logger.info('coucou', { files, video: this.VideoStreamingPlaylists })
1763
1764 return videoFilesModelToFormattedJSON(this, baseUrlHttp, baseUrlWs, files)
1721 } 1765 }
1722 1766
1723 toActivityPubObject (this: MVideoAP): VideoTorrentObject { 1767 toActivityPubObject (this: MVideoAP): VideoTorrentObject {
diff --git a/server/tests/feeds/feeds.ts b/server/tests/feeds/feeds.ts
index ba961cdba..0ff690f34 100644
--- a/server/tests/feeds/feeds.ts
+++ b/server/tests/feeds/feeds.ts
@@ -21,7 +21,8 @@ import {
21 setAccessTokensToServers, 21 setAccessTokensToServers,
22 uploadVideo, 22 uploadVideo,
23 uploadVideoAndGetId, 23 uploadVideoAndGetId,
24 userLogin 24 userLogin,
25 flushAndRunServer
25} from '../../../shared/extra-utils' 26} from '../../../shared/extra-utils'
26import { waitJobs } from '../../../shared/extra-utils/server/jobs' 27import { waitJobs } from '../../../shared/extra-utils/server/jobs'
27import { addVideoCommentThread } from '../../../shared/extra-utils/videos/video-comments' 28import { addVideoCommentThread } from '../../../shared/extra-utils/videos/video-comments'
@@ -34,6 +35,7 @@ const expect = chai.expect
34 35
35describe('Test syndication feeds', () => { 36describe('Test syndication feeds', () => {
36 let servers: ServerInfo[] = [] 37 let servers: ServerInfo[] = []
38 let serverHLSOnly: ServerInfo
37 let userAccessToken: string 39 let userAccessToken: string
38 let rootAccountId: number 40 let rootAccountId: number
39 let rootChannelId: number 41 let rootChannelId: number
@@ -45,8 +47,15 @@ describe('Test syndication feeds', () => {
45 47
46 // Run servers 48 // Run servers
47 servers = await flushAndRunMultipleServers(2) 49 servers = await flushAndRunMultipleServers(2)
50 serverHLSOnly = await flushAndRunServer(3, {
51 transcoding: {
52 enabled: true,
53 webtorrent: { enabled: false },
54 hls: { enabled: true }
55 }
56 })
48 57
49 await setAccessTokensToServers(servers) 58 await setAccessTokensToServers([ ...servers, serverHLSOnly ])
50 await doubleFollow(servers[0], servers[1]) 59 await doubleFollow(servers[0], servers[1])
51 60
52 { 61 {
@@ -116,6 +125,7 @@ describe('Test syndication feeds', () => {
116 }) 125 })
117 126
118 describe('Videos feed', function () { 127 describe('Videos feed', function () {
128
119 it('Should contain a valid enclosure (covers RSS 2.0 endpoint)', async function () { 129 it('Should contain a valid enclosure (covers RSS 2.0 endpoint)', async function () {
120 for (const server of servers) { 130 for (const server of servers) {
121 const rss = await getXMLfeed(server.url, 'videos') 131 const rss = await getXMLfeed(server.url, 'videos')
@@ -208,6 +218,26 @@ describe('Test syndication feeds', () => {
208 } 218 }
209 } 219 }
210 }) 220 })
221
222 it('Should correctly have videos feed with HLS only', async function () {
223 this.timeout(120000)
224
225 await uploadVideo(serverHLSOnly.url, serverHLSOnly.accessToken, { name: 'hls only video' })
226
227 await waitJobs([ serverHLSOnly ])
228
229 const json = await getJSONfeed(serverHLSOnly.url, 'videos')
230 const jsonObj = JSON.parse(json.text)
231 expect(jsonObj.items.length).to.be.equal(1)
232 expect(jsonObj.items[0].attachments).to.exist
233 expect(jsonObj.items[0].attachments.length).to.be.eq(4)
234
235 for (let i = 0; i < 4; i++) {
236 expect(jsonObj.items[0].attachments[i].mime_type).to.be.eq('application/x-bittorrent')
237 expect(jsonObj.items[0].attachments[i].size_in_bytes).to.be.greaterThan(0)
238 expect(jsonObj.items[0].attachments[i].url).to.exist
239 }
240 })
211 }) 241 })
212 242
213 describe('Video comments feed', function () { 243 describe('Video comments feed', function () {
@@ -260,6 +290,6 @@ describe('Test syndication feeds', () => {
260 }) 290 })
261 291
262 after(async function () { 292 after(async function () {
263 await cleanupTests(servers) 293 await cleanupTests([ ...servers, serverHLSOnly ])
264 }) 294 })
265}) 295})