X-Git-Url: https://git.immae.eu/?a=blobdiff_plain;f=server%2Fmodels%2Fvideo%2Fvideo-playlist-element.ts;h=eeb3d6bbd5ec10059be86a45e5cf4b9e881b0cd4;hb=1735c825726edaa0af5035cb6cbb0cc0db502c6d;hp=3396b11367902557073a87ef4f36698388836fbf;hpb=e8bafea35bc930cb8ac5b2d521a188642a1adffe;p=github%2FChocobozzz%2FPeerTube.git diff --git a/server/models/video/video-playlist-element.ts b/server/models/video/video-playlist-element.ts index 3396b1136..eeb3d6bbd 100644 --- a/server/models/video/video-playlist-element.ts +++ b/server/models/video/video-playlist-element.ts @@ -15,12 +15,12 @@ import { } from 'sequelize-typescript' import { VideoModel } from './video' import { VideoPlaylistModel } from './video-playlist' -import * as Sequelize from 'sequelize' import { getSort, throwIfNotValid } from '../utils' import { isActivityPubUrlValid } from '../../helpers/custom-validators/activitypub/misc' import { CONSTRAINTS_FIELDS } from '../../initializers/constants' import { PlaylistElementObject } from '../../../shared/models/activitypub/objects/playlist-element-object' import * as validator from 'validator' +import { AggregateOptions, Op, Sequelize, Transaction } from 'sequelize' @Table({ tableName: 'videoPlaylistElement', @@ -96,7 +96,7 @@ export class VideoPlaylistElementModel extends Model }) Video: VideoModel - static deleteAllOf (videoPlaylistId: number, transaction?: Sequelize.Transaction) { + static deleteAllOf (videoPlaylistId: number, transaction?: Transaction) { const query = { where: { videoPlaylistId @@ -140,7 +140,7 @@ export class VideoPlaylistElementModel extends Model return VideoPlaylistElementModel.findOne(query) } - static listUrlsOfForAP (videoPlaylistId: number, start: number, count: number, t?: Sequelize.Transaction) { + static listUrlsOfForAP (videoPlaylistId: number, start: number, count: number, t?: Transaction) { const query = { attributes: [ 'url' ], offset: start, @@ -159,8 +159,8 @@ export class VideoPlaylistElementModel extends Model }) } - static getNextPositionOf (videoPlaylistId: number, transaction?: Sequelize.Transaction) { - const query = { + static getNextPositionOf (videoPlaylistId: number, transaction?: Transaction) { + const query: AggregateOptions = { where: { videoPlaylistId }, @@ -176,14 +176,14 @@ export class VideoPlaylistElementModel extends Model firstPosition: number, endPosition: number, newPosition: number, - transaction?: Sequelize.Transaction + transaction?: Transaction ) { const query = { where: { videoPlaylistId, position: { - [Sequelize.Op.gte]: firstPosition, - [Sequelize.Op.lte]: endPosition + [Op.gte]: firstPosition, + [Op.lte]: endPosition } }, transaction, @@ -198,13 +198,13 @@ export class VideoPlaylistElementModel extends Model fromPosition: number, toPosition?: number, by = 1, - transaction?: Sequelize.Transaction + transaction?: Transaction ) { const query = { where: { videoPlaylistId, position: { - [Sequelize.Op.gte]: fromPosition + [Op.gte]: fromPosition } }, transaction