-import * as Sequelize from 'sequelize'
+import { OrderItem, Transaction } from 'sequelize'
import {
AllowNull,
BeforeDestroy,
BelongsTo,
Column,
CreatedAt,
+ DataType,
ForeignKey,
Is,
Model,
Table,
UpdatedAt
} from 'sequelize-typescript'
-import { throwIfNotValid } from '../utils'
+import { buildWhereIdOrUUID, throwIfNotValid } from '../utils'
import { VideoModel } from './video'
import { isVideoCaptionLanguageValid } from '../../helpers/custom-validators/video-captions'
import { VideoCaption } from '../../../shared/models/videos/caption/video-caption.model'
-import { STATIC_PATHS, VIDEO_LANGUAGES } from '../../initializers/constants'
+import { CONSTRAINTS_FIELDS, LAZY_STATIC_PATHS, VIDEO_LANGUAGES, WEBSERVER } from '../../initializers/constants'
import { join } from 'path'
import { logger } from '../../helpers/logger'
import { remove } from 'fs-extra'
import { CONFIG } from '../../initializers/config'
+import * as Bluebird from 'bluebird'
+import { MVideoAccountLight, MVideoCaptionFormattable, MVideoCaptionVideo } from '@server/types/models'
+import { buildRemoteVideoBaseUrl } from '@server/helpers/activitypub'
export enum ScopeNames {
WITH_VIDEO_UUID_AND_REMOTE = 'WITH_VIDEO_UUID_AND_REMOTE'
}
-@Scopes({
+@Scopes(() => ({
[ScopeNames.WITH_VIDEO_UUID_AND_REMOTE]: {
include: [
{
- attributes: [ 'uuid', 'remote' ],
- model: () => VideoModel.unscoped(),
+ attributes: [ 'id', 'uuid', 'remote' ],
+ model: VideoModel.unscoped(),
required: true
}
]
}
-})
+}))
@Table({
tableName: 'videoCaption',
@Column
language: string
+ @AllowNull(true)
+ @Column(DataType.STRING(CONSTRAINTS_FIELDS.COMMONS.URL.max))
+ fileUrl: string
+
@ForeignKey(() => VideoModel)
@Column
videoId: number
@BeforeDestroy
static async removeFiles (instance: VideoCaptionModel) {
if (!instance.Video) {
- instance.Video = await instance.$get('Video') as VideoModel
+ instance.Video = await instance.$get('Video')
}
if (instance.isOwned()) {
return undefined
}
- static loadByVideoIdAndLanguage (videoId: string | number, language: string) {
+ static loadByVideoIdAndLanguage (videoId: string | number, language: string): Bluebird<MVideoCaptionVideo> {
const videoInclude = {
model: VideoModel.unscoped(),
attributes: [ 'id', 'remote', 'uuid' ],
- where: { }
+ where: buildWhereIdOrUUID(videoId)
}
- if (typeof videoId === 'string') videoInclude.where['uuid'] = videoId
- else videoInclude.where['id'] = videoId
-
const query = {
where: {
language
return VideoCaptionModel.findOne(query)
}
- static insertOrReplaceLanguage (videoId: number, language: string, transaction: Sequelize.Transaction) {
+ static insertOrReplaceLanguage (videoId: number, language: string, fileUrl: string, transaction: Transaction) {
const values = {
videoId,
- language
+ language,
+ fileUrl
}
- return VideoCaptionModel.upsert<VideoCaptionModel>(values, { transaction, returning: true })
+ return VideoCaptionModel.upsert(values, { transaction, returning: true })
.then(([ caption ]) => caption)
}
- static listVideoCaptions (videoId: number) {
+ static listVideoCaptions (videoId: number): Bluebird<MVideoCaptionVideo[]> {
const query = {
- order: [ [ 'language', 'ASC' ] ],
+ order: [ [ 'language', 'ASC' ] ] as OrderItem[],
where: {
videoId
}
return VIDEO_LANGUAGES[language] || 'Unknown'
}
- static deleteAllCaptionsOfRemoteVideo (videoId: number, transaction: Sequelize.Transaction) {
+ static deleteAllCaptionsOfRemoteVideo (videoId: number, transaction: Transaction) {
const query = {
where: {
videoId
return this.Video.remote === false
}
- toFormattedJSON (): VideoCaption {
+ toFormattedJSON (this: MVideoCaptionFormattable): VideoCaption {
return {
language: {
id: this.language,
}
}
- getCaptionStaticPath () {
- return join(STATIC_PATHS.VIDEO_CAPTIONS, this.getCaptionName())
+ getCaptionStaticPath (this: MVideoCaptionFormattable) {
+ return join(LAZY_STATIC_PATHS.VIDEO_CAPTIONS, this.getCaptionName())
}
- getCaptionName () {
+ getCaptionName (this: MVideoCaptionFormattable) {
return `${this.Video.uuid}-${this.language}.vtt`
}
- removeCaptionFile () {
+ removeCaptionFile (this: MVideoCaptionFormattable) {
return remove(CONFIG.STORAGE.CAPTIONS_DIR + this.getCaptionName())
}
+
+ getFileUrl (video: MVideoAccountLight) {
+ if (!this.Video) this.Video = video as VideoModel
+
+ if (video.isOwned()) return WEBSERVER.URL + this.getCaptionStaticPath()
+ if (this.fileUrl) return this.fileUrl
+
+ // Fallback if we don't have a file URL
+ return buildRemoteVideoBaseUrl(video, this.getCaptionStaticPath())
+ }
}