1 import { Sequelize } from 'sequelize'
2 import { AbstractVideosModelQueryBuilder } from './shared/abstract-videos-model-query-builder'
3 import { VideoModelBuilder } from './shared/video-model-builder'
4 import { BuildVideosListQueryOptions, VideosIdListQueryBuilder } from './videos-id-list-query-builder'
8 * Build videos list SQL query and create video models
12 export class VideosModelListQueryBuilder extends AbstractVideosModelQueryBuilder {
13 protected attributes: { [key: string]: string }
14 protected joins: string[] = []
16 private innerQuery: string
17 private innerSort: string
19 private readonly videoModelBuilder: VideoModelBuilder
21 constructor (protected readonly sequelize: Sequelize) {
24 this.videoModelBuilder = new VideoModelBuilder(this.mode, this.videoAttributes)
27 queryVideos (options: BuildVideosListQueryOptions) {
28 this.buildInnerQuery(options)
29 this.buildListQueryFromIdsQuery(options)
31 return this.runQuery(undefined, true).then(rows => this.videoModelBuilder.buildVideosFromRows(rows))
34 private buildInnerQuery (options: BuildVideosListQueryOptions) {
35 const idsQueryBuilder = new VideosIdListQueryBuilder(this.sequelize)
36 const { query, sort, replacements } = idsQueryBuilder.getIdsListQueryAndSort(options)
38 this.replacements = replacements
39 this.innerQuery = query
43 private buildListQueryFromIdsQuery (options: BuildVideosListQueryOptions) {
48 this.joins = [ 'INNER JOIN "video" ON "tmp"."id" = "video"."id"' ]
50 this.includeChannels()
51 this.includeAccounts()
52 this.includeThumbnails()
54 if (options.withFiles) {
55 this.includeWebtorrentFiles(false)
56 this.includeStreamingPlaylistFiles(false)
60 this.includeUserHistory(options.user.id)
63 if (options.videoPlaylistId) {
64 this.includePlaylist(options.videoPlaylistId)
67 const select = this.buildSelect()
69 this.query = `${select} FROM (${this.innerQuery}) AS "tmp" ${this.joins.join(' ')} ${this.innerSort}`