1 import { AllowNull, BelongsTo, Column, CreatedAt, ForeignKey, Model, Table } from 'sequelize-typescript'
2 import { VideoModel } from './video'
3 import * as Sequelize from 'sequelize'
6 tableName: 'videoView',
13 fields: [ 'startDate' ]
17 export class VideoViewModel extends Model<VideoViewModel> {
22 @Column(Sequelize.DATE)
26 @Column(Sequelize.DATE)
33 @ForeignKey(() => VideoModel)
37 @BelongsTo(() => VideoModel, {
45 static removeOldRemoteViewsHistory (beforeDate: string) {
49 [Sequelize.Op.lt]: beforeDate
52 [Sequelize.Op.in]: Sequelize.literal('(SELECT "id" FROM "video" WHERE "remote" IS TRUE)')
57 return VideoViewModel.destroy(query)