import { AllowNull, BelongsTo, Column, CreatedAt, ForeignKey, Model, Scopes, Table, UpdatedAt } from 'sequelize-typescript'
-import { AccountModel } from '../account/account'
-import { VideoModel } from './video'
+import { MVideoChangeOwnershipFormattable, MVideoChangeOwnershipFull } from '@server/types/models/video/video-change-ownership'
+import { AttributesOnly } from '@shared/typescript-utils'
import { VideoChangeOwnership, VideoChangeOwnershipStatus } from '../../../shared/models/videos'
+import { AccountModel } from '../account/account'
import { getSort } from '../utils'
-import { VideoFileModel } from './video-file'
+import { ScopeNames as VideoScopeNames, VideoModel } from './video'
enum ScopeNames {
- FULL = 'FULL'
+ WITH_ACCOUNTS = 'WITH_ACCOUNTS',
+ WITH_VIDEO = 'WITH_VIDEO'
}
@Table({
tableName: 'videoChangeOwnership',
indexes: [
{
- fields: ['videoId']
+ fields: [ 'videoId' ]
},
{
- fields: ['initiatorAccountId']
+ fields: [ 'initiatorAccountId' ]
},
{
- fields: ['nextOwnerAccountId']
+ fields: [ 'nextOwnerAccountId' ]
}
]
})
-@Scopes({
- [ScopeNames.FULL]: {
+@Scopes(() => ({
+ [ScopeNames.WITH_ACCOUNTS]: {
include: [
{
- model: () => AccountModel,
+ model: AccountModel,
as: 'Initiator',
required: true
},
{
- model: () => AccountModel,
+ model: AccountModel,
as: 'NextOwner',
required: true
- },
+ }
+ ]
+ },
+ [ScopeNames.WITH_VIDEO]: {
+ include: [
{
- model: () => VideoModel,
- required: true,
- include: [{ model: () => VideoFileModel }]
+ model: VideoModel.scope([
+ VideoScopeNames.WITH_THUMBNAILS,
+ VideoScopeNames.WITH_WEBTORRENT_FILES,
+ VideoScopeNames.WITH_STREAMING_PLAYLISTS,
+ VideoScopeNames.WITH_ACCOUNT_DETAILS
+ ]),
+ required: true
}
]
}
-})
-export class VideoChangeOwnershipModel extends Model<VideoChangeOwnershipModel> {
+}))
+export class VideoChangeOwnershipModel extends Model<Partial<AttributesOnly<VideoChangeOwnershipModel>>> {
@CreatedAt
createdAt: Date
Video: VideoModel
static listForApi (nextOwnerId: number, start: number, count: number, sort: string) {
- return VideoChangeOwnershipModel.scope(ScopeNames.FULL).findAndCountAll({
+ const query = {
offset: start,
limit: count,
order: getSort(sort),
where: {
nextOwnerAccountId: nextOwnerId
}
- })
- .then(({ rows, count }) => ({ total: count, data: rows }))
+ }
+
+ return Promise.all([
+ VideoChangeOwnershipModel.scope(ScopeNames.WITH_ACCOUNTS).count(query),
+ VideoChangeOwnershipModel.scope([ ScopeNames.WITH_ACCOUNTS, ScopeNames.WITH_VIDEO ]).findAll<MVideoChangeOwnershipFull>(query)
+ ]).then(([ count, rows ]) => ({ total: count, data: rows }))
}
- static load (id: number) {
- return VideoChangeOwnershipModel.scope(ScopeNames.FULL).findById(id)
+ static load (id: number): Promise<MVideoChangeOwnershipFull> {
+ return VideoChangeOwnershipModel.scope([ ScopeNames.WITH_ACCOUNTS, ScopeNames.WITH_VIDEO ])
+ .findByPk(id)
}
- toFormattedJSON (): VideoChangeOwnership {
+ toFormattedJSON (this: MVideoChangeOwnershipFormattable): VideoChangeOwnership {
return {
id: this.id,
status: this.status,
initiatorAccount: this.Initiator.toFormattedJSON(),
nextOwnerAccount: this.NextOwner.toFormattedJSON(),
- video: {
- id: this.Video.id,
- uuid: this.Video.uuid,
- url: this.Video.url,
- name: this.Video.name
- },
+ video: this.Video.toFormattedJSON(),
createdAt: this.createdAt
}
}