X-Git-Url: https://git.immae.eu/?a=blobdiff_plain;f=server%2Fmodels%2Fvideo%2Fsql%2Fvideo-model-get-query-builder.ts;h=8926390764a7c8a5445f71f115b58e39ed9551ca;hb=17bb45388ec319d288a1b8387c6c199fe2f6b64f;hp=1a921d80218244de6c1e8b2ace23fc16c3661369;hpb=ca4b4b2e5590c1b37cff1fe1be7f797b93351229;p=github%2FChocobozzz%2FPeerTube.git diff --git a/server/models/video/sql/video-model-get-query-builder.ts b/server/models/video/sql/video-model-get-query-builder.ts index 1a921d802..892639076 100644 --- a/server/models/video/sql/video-model-get-query-builder.ts +++ b/server/models/video/sql/video-model-get-query-builder.ts @@ -1,8 +1,8 @@ import { Sequelize, Transaction } from 'sequelize' import { AbstractVideosModelQueryBuilder } from './shared/abstract-videos-model-query-builder' -import { VideoAttributes } from './shared/video-attributes' import { VideoFileQueryBuilder } from './shared/video-file-query-builder' import { VideoModelBuilder } from './shared/video-model-builder' +import { VideoTables } from './shared/video-tables' /** * @@ -29,7 +29,7 @@ export class VideosModelGetQueryBuilder { this.webtorrentFilesQueryBuilder = new VideoFileQueryBuilder(sequelize) this.streamingPlaylistFilesQueryBuilder = new VideoFileQueryBuilder(sequelize) - this.videoModelBuilder = new VideoModelBuilder('get', new VideoAttributes('get')) + this.videoModelBuilder = new VideoModelBuilder('get', new VideoTables('get')) } async queryVideos (options: BuildVideoGetQueryOptions) { @@ -64,7 +64,7 @@ export class VideosModelGetQuerySubBuilder extends AbstractVideosModelQueryBuild queryVideos (options: BuildVideoGetQueryOptions) { this.buildMainGetQuery(options) - return this.runQuery(options.transaction, true) + return this.runQuery(options.transaction) } private buildMainGetQuery (options: BuildVideoGetQueryOptions) { @@ -102,6 +102,6 @@ export class VideosModelGetQuerySubBuilder extends AbstractVideosModelQueryBuild const order = 'ORDER BY "Tags"."name" ASC' const from = `SELECT * FROM "video" ${this.where} LIMIT 1` - return `${this.buildSelect()} FROM (${from}) AS "video" ${this.joins.join(' ')} ${this.where} ${order}` + return `${this.buildSelect()} FROM (${from}) AS "video" ${this.joins.join(' ')} ${order}` } }