1 import { AllowNull, BelongsTo, Column, CreatedAt, DataType, ForeignKey, HasMany, Is, Model, Table, UpdatedAt } from 'sequelize-typescript'
2 import { isVideoFileInfoHashValid } from '../../helpers/custom-validators/videos'
3 import { throwIfNotValid } from '../utils'
4 import { VideoModel } from './video'
5 import * as Sequelize from 'sequelize'
6 import { VideoRedundancyModel } from '../redundancy/video-redundancy'
7 import { VideoStreamingPlaylistType } from '../../../shared/models/videos/video-streaming-playlist.type'
8 import { isActivityPubUrlValid } from '../../helpers/custom-validators/activitypub/misc'
9 import { CONSTRAINTS_FIELDS, STATIC_PATHS, P2P_MEDIA_LOADER_PEER_VERSION } from '../../initializers'
10 import { VideoFileModel } from './video-file'
11 import { join } from 'path'
12 import { sha1 } from '../../helpers/core-utils'
13 import { isArrayOf } from '../../helpers/custom-validators/misc'
16 tableName: 'videoStreamingPlaylist',
22 fields: [ 'videoId', 'type' ],
26 fields: [ 'p2pMediaLoaderInfohashes' ],
31 export class VideoStreamingPlaylistModel extends Model<VideoStreamingPlaylistModel> {
40 type: VideoStreamingPlaylistType
43 @Is('PlaylistUrl', value => throwIfNotValid(value, isActivityPubUrlValid, 'playlist url'))
44 @Column(DataType.STRING(CONSTRAINTS_FIELDS.VIDEOS.URL.max))
48 @Is('VideoStreamingPlaylistInfoHashes', value => throwIfNotValid(value, v => isArrayOf(v, isVideoFileInfoHashValid), 'info hashes'))
49 @Column(DataType.ARRAY(DataType.STRING))
50 p2pMediaLoaderInfohashes: string[]
54 p2pMediaLoaderPeerVersion: number
57 @Is('VideoStreamingSegmentsSha256Url', value => throwIfNotValid(value, isActivityPubUrlValid, 'segments sha256 url'))
59 segmentsSha256Url: string
61 @ForeignKey(() => VideoModel)
65 @BelongsTo(() => VideoModel, {
73 @HasMany(() => VideoRedundancyModel, {
80 RedundancyVideos: VideoRedundancyModel[]
82 static doesInfohashExist (infoHash: string) {
83 const query = 'SELECT 1 FROM "videoStreamingPlaylist" WHERE $infoHash = ANY("p2pMediaLoaderInfohashes") LIMIT 1'
85 type: Sequelize.QueryTypes.SELECT,
90 return VideoModel.sequelize.query(query, options)
92 return results.length === 1
96 static buildP2PMediaLoaderInfoHashes (playlistUrl: string, videoFiles: VideoFileModel[]) {
97 const hashes: string[] = []
99 // https://github.com/Novage/p2p-media-loader/blob/master/p2p-media-loader-core/lib/p2p-media-manager.ts#L115
100 for (let i = 0; i < videoFiles.length; i++) {
101 hashes.push(sha1(`${P2P_MEDIA_LOADER_PEER_VERSION}${playlistUrl}+V${i}`))
107 static listByIncorrectPeerVersion () {
110 p2pMediaLoaderPeerVersion: {
111 [Sequelize.Op.ne]: P2P_MEDIA_LOADER_PEER_VERSION
116 return VideoStreamingPlaylistModel.findAll(query)
119 static loadWithVideo (id: number) {
123 model: VideoModel.unscoped(),
129 return VideoStreamingPlaylistModel.findByPk(id, options)
132 static getHlsPlaylistFilename (resolution: number) {
133 return resolution + '.m3u8'
136 static getMasterHlsPlaylistFilename () {
140 static getHlsSha256SegmentsFilename () {
141 return 'segments-sha256.json'
144 static getHlsVideoName (uuid: string, resolution: number) {
145 return `${uuid}-${resolution}-fragmented.mp4`
148 static getHlsMasterPlaylistStaticPath (videoUUID: string) {
149 return join(STATIC_PATHS.STREAMING_PLAYLISTS.HLS, videoUUID, VideoStreamingPlaylistModel.getMasterHlsPlaylistFilename())
152 static getHlsPlaylistStaticPath (videoUUID: string, resolution: number) {
153 return join(STATIC_PATHS.STREAMING_PLAYLISTS.HLS, videoUUID, VideoStreamingPlaylistModel.getHlsPlaylistFilename(resolution))
156 static getHlsSha256SegmentsStaticPath (videoUUID: string) {
157 return join(STATIC_PATHS.STREAMING_PLAYLISTS.HLS, videoUUID, VideoStreamingPlaylistModel.getHlsSha256SegmentsFilename())
161 if (this.type === VideoStreamingPlaylistType.HLS) return 'hls'
166 getVideoRedundancyUrl (baseUrlHttp: string) {
167 return baseUrlHttp + STATIC_PATHS.REDUNDANCY + this.getStringType() + '/' + this.Video.uuid
170 hasSameUniqueKeysThan (other: VideoStreamingPlaylistModel) {
171 return this.type === other.type &&
172 this.videoId === other.videoId