X-Git-Url: https://git.immae.eu/?a=blobdiff_plain;f=server%2Fmodels%2Fvideo%2Fschedule-video-update.ts;h=d462c20c763ca7df8917e8cd6a20b88759faec1e;hb=9c9a236b541a286e165d67341e4ddd6ea2fabdf1;hp=3cf5f6c99b06591fe81260f6479553d348d0eedc;hpb=bbe0f0645ca958d33a3f409b15166609733b663f;p=github%2FChocobozzz%2FPeerTube.git diff --git a/server/models/video/schedule-video-update.ts b/server/models/video/schedule-video-update.ts index 3cf5f6c99..d462c20c7 100644 --- a/server/models/video/schedule-video-update.ts +++ b/server/models/video/schedule-video-update.ts @@ -1,7 +1,9 @@ -import { AllowNull, BelongsTo, Column, CreatedAt, Default, ForeignKey, Model, Sequelize, Table, UpdatedAt } from 'sequelize-typescript' -import { ScopeNames as VideoScopeNames, VideoModel } from './video' +import { Op, Transaction } from 'sequelize' +import { AllowNull, BelongsTo, Column, CreatedAt, Default, ForeignKey, Model, Table, UpdatedAt } from 'sequelize-typescript' +import { MScheduleVideoUpdateFormattable, MScheduleVideoUpdate } from '@server/types/models' +import { AttributesOnly } from '@shared/core-utils' import { VideoPrivacy } from '../../../shared/models/videos' -import { Transaction } from 'sequelize' +import { VideoModel } from './video' @Table({ tableName: 'scheduleVideoUpdate', @@ -15,7 +17,7 @@ import { Transaction } from 'sequelize' } ] }) -export class ScheduleVideoUpdateModel extends Model { +export class ScheduleVideoUpdateModel extends Model>> { @AllowNull(false) @Default(null) @@ -25,7 +27,7 @@ export class ScheduleVideoUpdateModel extends Model { @AllowNull(true) @Default(null) @Column - privacy: VideoPrivacy.PUBLIC | VideoPrivacy.UNLISTED + privacy: VideoPrivacy.PUBLIC | VideoPrivacy.UNLISTED | VideoPrivacy.INTERNAL @CreatedAt createdAt: Date @@ -51,7 +53,7 @@ export class ScheduleVideoUpdateModel extends Model { attributes: [ 'id' ], where: { updateAt: { - [Sequelize.Op.lte]: new Date() + [Op.lte]: new Date() } } } @@ -60,30 +62,31 @@ export class ScheduleVideoUpdateModel extends Model { .then(res => !!res) } - static listVideosToUpdate (t: Transaction) { + static listVideosToUpdate (transaction?: Transaction) { const query = { where: { updateAt: { - [Sequelize.Op.lte]: new Date() + [Op.lte]: new Date() } }, - include: [ - { - model: VideoModel.scope( - [ - VideoScopeNames.WITH_FILES, - VideoScopeNames.WITH_ACCOUNT_DETAILS - ] - ) - } - ], + transaction + } + + return ScheduleVideoUpdateModel.findAll(query) + } + + static deleteByVideoId (videoId: number, t: Transaction) { + const query = { + where: { + videoId + }, transaction: t } - return ScheduleVideoUpdateModel.findAll(query) + return ScheduleVideoUpdateModel.destroy(query) } - toFormattedJSON () { + toFormattedJSON (this: MScheduleVideoUpdateFormattable) { return { updateAt: this.updateAt, privacy: this.privacy || undefined