]> git.immae.eu Git - github/Chocobozzz/PeerTube.git/blob - client/src/app/shared/video-playlist/video-playlist.service.ts
Optimize list my playlists SQL query
[github/Chocobozzz/PeerTube.git] / client / src / app / shared / video-playlist / video-playlist.service.ts
1 import { bufferTime, catchError, filter, map, share, switchMap, tap } from 'rxjs/operators'
2 import { Injectable } from '@angular/core'
3 import { merge, Observable, of, ReplaySubject, Subject } from 'rxjs'
4 import { RestExtractor } from '../rest/rest-extractor.service'
5 import { HttpClient, HttpParams } from '@angular/common/http'
6 import { ResultList, VideoPlaylistElementCreate, VideoPlaylistElementUpdate } from '../../../../../shared'
7 import { environment } from '../../../environments/environment'
8 import { VideoPlaylist as VideoPlaylistServerModel } from '@shared/models/videos/playlist/video-playlist.model'
9 import { VideoChannelService } from '@app/shared/video-channel/video-channel.service'
10 import { VideoChannel } from '@app/shared/video-channel/video-channel.model'
11 import { VideoPlaylistCreate } from '@shared/models/videos/playlist/video-playlist-create.model'
12 import { VideoPlaylistUpdate } from '@shared/models/videos/playlist/video-playlist-update.model'
13 import { objectToFormData } from '@app/shared/misc/utils'
14 import { AuthUser, ServerService } from '@app/core'
15 import { VideoPlaylist } from '@app/shared/video-playlist/video-playlist.model'
16 import { AccountService } from '@app/shared/account/account.service'
17 import { Account } from '@app/shared/account/account.model'
18 import { RestService } from '@app/shared/rest'
19 import { VideoExistInPlaylist, VideosExistInPlaylists } from '@shared/models/videos/playlist/video-exist-in-playlist.model'
20 import { VideoPlaylistReorder } from '@shared/models/videos/playlist/video-playlist-reorder.model'
21 import { ComponentPaginationLight } from '@app/shared/rest/component-pagination.model'
22 import { VideoPlaylistElement as ServerVideoPlaylistElement } from '@shared/models/videos/playlist/video-playlist-element.model'
23 import { VideoPlaylistElement } from '@app/shared/video-playlist/video-playlist-element.model'
24 import { uniq } from 'lodash-es'
25 import * as debug from 'debug'
26
27 const logger = debug('peertube:playlists:VideoPlaylistService')
28
29 export type CachedPlaylist = VideoPlaylist | { id: number, displayName: string }
30
31 @Injectable()
32 export class VideoPlaylistService {
33 static BASE_VIDEO_PLAYLIST_URL = environment.apiUrl + '/api/v1/video-playlists/'
34 static MY_VIDEO_PLAYLIST_URL = environment.apiUrl + '/api/v1/users/me/video-playlists/'
35
36 // Use a replay subject because we "next" a value before subscribing
37 private videoExistsInPlaylistNotifier = new ReplaySubject<number>(1)
38 private videoExistsInPlaylistCacheSubject = new Subject<VideosExistInPlaylists>()
39 private readonly videoExistsInPlaylistObservable: Observable<VideosExistInPlaylists>
40
41 private videoExistsObservableCache: { [ id: number ]: Observable<VideoExistInPlaylist[]> } = {}
42 private videoExistsCache: { [ id: number ]: VideoExistInPlaylist[] } = {}
43
44 private myAccountPlaylistCache: ResultList<CachedPlaylist> = undefined
45 private myAccountPlaylistCacheRunning = false
46 private myAccountPlaylistCacheSubject = new Subject<ResultList<CachedPlaylist>>()
47
48 constructor (
49 private authHttp: HttpClient,
50 private serverService: ServerService,
51 private restExtractor: RestExtractor,
52 private restService: RestService
53 ) {
54 this.videoExistsInPlaylistObservable = merge(
55 this.videoExistsInPlaylistNotifier.pipe(
56 bufferTime(500),
57 filter(videoIds => videoIds.length !== 0),
58 map(videoIds => uniq(videoIds)),
59 switchMap(videoIds => this.doVideosExistInPlaylist(videoIds)),
60 share()
61 ),
62
63 this.videoExistsInPlaylistCacheSubject
64 )
65 }
66
67 listChannelPlaylists (videoChannel: VideoChannel, componentPagination: ComponentPaginationLight): Observable<ResultList<VideoPlaylist>> {
68 const url = VideoChannelService.BASE_VIDEO_CHANNEL_URL + videoChannel.nameWithHost + '/video-playlists'
69 const pagination = this.restService.componentPaginationToRestPagination(componentPagination)
70
71 let params = new HttpParams()
72 params = this.restService.addRestGetParams(params, pagination)
73
74 return this.authHttp.get<ResultList<VideoPlaylist>>(url, { params })
75 .pipe(
76 switchMap(res => this.extractPlaylists(res)),
77 catchError(err => this.restExtractor.handleError(err))
78 )
79 }
80
81 listMyPlaylistWithCache (user: AuthUser, search?: string) {
82 if (!search) {
83 if (this.myAccountPlaylistCacheRunning) return
84 if (this.myAccountPlaylistCache) return of(this.myAccountPlaylistCache)
85 }
86
87 this.myAccountPlaylistCacheRunning = true
88
89 return this.listAccountPlaylists(user.account, undefined, '-updatedAt', search)
90 .pipe(
91 tap(result => {
92 if (!search) {
93 this.myAccountPlaylistCacheRunning = false
94 this.myAccountPlaylistCache = result
95 }
96 })
97 )
98 }
99
100 listAccountPlaylists (
101 account: Account,
102 componentPagination: ComponentPaginationLight,
103 sort: string,
104 search?: string
105 ): Observable<ResultList<VideoPlaylist>> {
106 const url = AccountService.BASE_ACCOUNT_URL + account.nameWithHost + '/video-playlists'
107 const pagination = componentPagination
108 ? this.restService.componentPaginationToRestPagination(componentPagination)
109 : undefined
110
111 let params = new HttpParams()
112 params = this.restService.addRestGetParams(params, pagination, sort)
113 if (search) params = this.restService.addObjectParams(params, { search })
114
115 return this.authHttp.get<ResultList<VideoPlaylist>>(url, { params })
116 .pipe(
117 switchMap(res => this.extractPlaylists(res)),
118 catchError(err => this.restExtractor.handleError(err))
119 )
120 }
121
122 getVideoPlaylist (id: string | number) {
123 const url = VideoPlaylistService.BASE_VIDEO_PLAYLIST_URL + id
124
125 return this.authHttp.get<VideoPlaylist>(url)
126 .pipe(
127 switchMap(res => this.extractPlaylist(res)),
128 catchError(err => this.restExtractor.handleError(err))
129 )
130 }
131
132 createVideoPlaylist (body: VideoPlaylistCreate) {
133 const data = objectToFormData(body)
134
135 return this.authHttp.post<{ videoPlaylist: { id: number } }>(VideoPlaylistService.BASE_VIDEO_PLAYLIST_URL, data)
136 .pipe(
137 tap(res => {
138 this.myAccountPlaylistCache.total++
139
140 this.myAccountPlaylistCache.data.push({
141 id: res.videoPlaylist.id,
142 displayName: body.displayName
143 })
144
145 this.myAccountPlaylistCacheSubject.next(this.myAccountPlaylistCache)
146 }),
147 catchError(err => this.restExtractor.handleError(err))
148 )
149 }
150
151 updateVideoPlaylist (videoPlaylist: VideoPlaylist, body: VideoPlaylistUpdate) {
152 const data = objectToFormData(body)
153
154 return this.authHttp.put(VideoPlaylistService.BASE_VIDEO_PLAYLIST_URL + videoPlaylist.id, data)
155 .pipe(
156 map(this.restExtractor.extractDataBool),
157 tap(() => {
158 const playlist = this.myAccountPlaylistCache.data.find(p => p.id === videoPlaylist.id)
159 playlist.displayName = body.displayName
160
161 this.myAccountPlaylistCacheSubject.next(this.myAccountPlaylistCache)
162 }),
163 catchError(err => this.restExtractor.handleError(err))
164 )
165 }
166
167 removeVideoPlaylist (videoPlaylist: VideoPlaylist) {
168 return this.authHttp.delete(VideoPlaylistService.BASE_VIDEO_PLAYLIST_URL + videoPlaylist.id)
169 .pipe(
170 map(this.restExtractor.extractDataBool),
171 tap(() => {
172 this.myAccountPlaylistCache.total--
173 this.myAccountPlaylistCache.data = this.myAccountPlaylistCache.data
174 .filter(p => p.id !== videoPlaylist.id)
175
176 this.myAccountPlaylistCacheSubject.next(this.myAccountPlaylistCache)
177 }),
178 catchError(err => this.restExtractor.handleError(err))
179 )
180 }
181
182 addVideoInPlaylist (playlistId: number, body: VideoPlaylistElementCreate) {
183 const url = VideoPlaylistService.BASE_VIDEO_PLAYLIST_URL + playlistId + '/videos'
184
185 return this.authHttp.post<{ videoPlaylistElement: { id: number } }>(url, body)
186 .pipe(
187 tap(res => {
188 const existsResult = this.videoExistsCache[body.videoId]
189 existsResult.push({
190 playlistId,
191 playlistElementId: res.videoPlaylistElement.id,
192 startTimestamp: body.startTimestamp,
193 stopTimestamp: body.stopTimestamp
194 })
195
196 this.runPlaylistCheck(body.videoId)
197 }),
198 catchError(err => this.restExtractor.handleError(err))
199 )
200 }
201
202 updateVideoOfPlaylist (playlistId: number, playlistElementId: number, body: VideoPlaylistElementUpdate, videoId: number) {
203 return this.authHttp.put(VideoPlaylistService.BASE_VIDEO_PLAYLIST_URL + playlistId + '/videos/' + playlistElementId, body)
204 .pipe(
205 map(this.restExtractor.extractDataBool),
206 tap(() => {
207 const existsResult = this.videoExistsCache[videoId]
208 const elem = existsResult.find(e => e.playlistElementId === playlistElementId)
209
210 elem.startTimestamp = body.startTimestamp
211 elem.stopTimestamp = body.stopTimestamp
212
213 this.runPlaylistCheck(videoId)
214 }),
215 catchError(err => this.restExtractor.handleError(err))
216 )
217 }
218
219 removeVideoFromPlaylist (playlistId: number, playlistElementId: number, videoId?: number) {
220 return this.authHttp.delete(VideoPlaylistService.BASE_VIDEO_PLAYLIST_URL + playlistId + '/videos/' + playlistElementId)
221 .pipe(
222 map(this.restExtractor.extractDataBool),
223 tap(() => {
224 if (!videoId) return
225
226 this.videoExistsCache[videoId] = this.videoExistsCache[videoId].filter(e => e.playlistElementId !== playlistElementId)
227 this.runPlaylistCheck(videoId)
228 }),
229 catchError(err => this.restExtractor.handleError(err))
230 )
231 }
232
233 reorderPlaylist (playlistId: number, oldPosition: number, newPosition: number) {
234 const body: VideoPlaylistReorder = {
235 startPosition: oldPosition,
236 insertAfterPosition: newPosition
237 }
238
239 return this.authHttp.post(VideoPlaylistService.BASE_VIDEO_PLAYLIST_URL + playlistId + '/videos/reorder', body)
240 .pipe(
241 map(this.restExtractor.extractDataBool),
242 catchError(err => this.restExtractor.handleError(err))
243 )
244 }
245
246 getPlaylistVideos (
247 videoPlaylistId: number | string,
248 componentPagination: ComponentPaginationLight
249 ): Observable<ResultList<VideoPlaylistElement>> {
250 const path = VideoPlaylistService.BASE_VIDEO_PLAYLIST_URL + videoPlaylistId + '/videos'
251 const pagination = this.restService.componentPaginationToRestPagination(componentPagination)
252
253 let params = new HttpParams()
254 params = this.restService.addRestGetParams(params, pagination)
255
256 return this.authHttp
257 .get<ResultList<ServerVideoPlaylistElement>>(path, { params })
258 .pipe(
259 switchMap(res => this.extractVideoPlaylistElements(res)),
260 catchError(err => this.restExtractor.handleError(err))
261 )
262 }
263
264 listenToMyAccountPlaylistsChange () {
265 return this.myAccountPlaylistCacheSubject.asObservable()
266 }
267
268 listenToVideoPlaylistChange (videoId: number) {
269 if (this.videoExistsObservableCache[ videoId ]) {
270 return this.videoExistsObservableCache[ videoId ]
271 }
272
273 const obs = this.videoExistsInPlaylistObservable
274 .pipe(
275 map(existsResult => existsResult[ videoId ]),
276 filter(r => !!r),
277 tap(result => this.videoExistsCache[ videoId ] = result)
278 )
279
280 this.videoExistsObservableCache[ videoId ] = obs
281 return obs
282 }
283
284 runPlaylistCheck (videoId: number) {
285 logger('Running playlist check.')
286
287 if (this.videoExistsCache[videoId]) {
288 logger('Found cache for %d.', videoId)
289
290 return this.videoExistsInPlaylistCacheSubject.next({ [videoId]: this.videoExistsCache[videoId] })
291 }
292
293 logger('Fetching from network for %d.', videoId)
294 return this.videoExistsInPlaylistNotifier.next(videoId)
295 }
296
297 extractPlaylists (result: ResultList<VideoPlaylistServerModel>) {
298 return this.serverService.getServerLocale()
299 .pipe(
300 map(translations => {
301 const playlistsJSON = result.data
302 const total = result.total
303 const playlists: VideoPlaylist[] = []
304
305 for (const playlistJSON of playlistsJSON) {
306 playlists.push(new VideoPlaylist(playlistJSON, translations))
307 }
308
309 return { data: playlists, total }
310 })
311 )
312 }
313
314 extractPlaylist (playlist: VideoPlaylistServerModel) {
315 return this.serverService.getServerLocale()
316 .pipe(map(translations => new VideoPlaylist(playlist, translations)))
317 }
318
319 extractVideoPlaylistElements (result: ResultList<ServerVideoPlaylistElement>) {
320 return this.serverService.getServerLocale()
321 .pipe(
322 map(translations => {
323 const elementsJson = result.data
324 const total = result.total
325 const elements: VideoPlaylistElement[] = []
326
327 for (const elementJson of elementsJson) {
328 elements.push(new VideoPlaylistElement(elementJson, translations))
329 }
330
331 return { total, data: elements }
332 })
333 )
334 }
335
336 private doVideosExistInPlaylist (videoIds: number[]): Observable<VideosExistInPlaylists> {
337 const url = VideoPlaylistService.MY_VIDEO_PLAYLIST_URL + 'videos-exist'
338
339 let params = new HttpParams()
340 params = this.restService.addObjectParams(params, { videoIds })
341
342 return this.authHttp.get<VideoExistInPlaylist>(url, { params, headers: { ignoreLoadingBar: '' } })
343 .pipe(catchError(err => this.restExtractor.handleError(err)))
344 }
345 }