X-Git-Url: https://git.immae.eu/?a=blobdiff_plain;f=server%2Finitializers%2Fmigrations%2F0450-streaming-playlist-files.ts;h=08e2e3989b87688764271cab3707db2faa3f9a8a;hb=ba4e1a059d42c765131ac66c1d8df963a66450b6;hp=460dac8be9f773cbfec13a61a7a75fa8bc3af31e;hpb=907b8f9347cca117c77a83cbea27140a10e3311e;p=github%2FChocobozzz%2FPeerTube.git diff --git a/server/initializers/migrations/0450-streaming-playlist-files.ts b/server/initializers/migrations/0450-streaming-playlist-files.ts index 460dac8be..08e2e3989 100644 --- a/server/initializers/migrations/0450-streaming-playlist-files.ts +++ b/server/initializers/migrations/0450-streaming-playlist-files.ts @@ -1,15 +1,9 @@ import * as Sequelize from 'sequelize' -import { join } from 'path' -import { HLS_STREAMING_PLAYLIST_DIRECTORY, WEBSERVER } from '@server/initializers/constants' -import { CONFIG } from '@server/initializers/config' -import { pathExists, stat, writeFile } from 'fs-extra' -import * as parseTorrent from 'parse-torrent' -import { createTorrentPromise } from '@server/helpers/webtorrent' async function up (utils: { - transaction: Sequelize.Transaction, - queryInterface: Sequelize.QueryInterface, - sequelize: Sequelize.Sequelize, + transaction: Sequelize.Transaction + queryInterface: Sequelize.QueryInterface + sequelize: Sequelize.Sequelize db: any }): Promise { { @@ -42,8 +36,8 @@ async function up (utils: { { const query = 'insert into "videoFile" ' + '(resolution, size, "infoHash", "videoId", "createdAt", "updatedAt", fps, extname, "videoStreamingPlaylistId")' + - '(SELECT "videoFile".resolution, "videoFile".size, \'fake\', NULL, "videoFile"."createdAt", "videoFile"."updatedAt", "videoFile"."fps", ' + - '"videoFile".extname, "videoStreamingPlaylist".id FROM "videoStreamingPlaylist" ' + + '(SELECT "videoFile".resolution, "videoFile".size, \'fake\', NULL, "videoFile"."createdAt", "videoFile"."updatedAt", ' + + '"videoFile"."fps", "videoFile".extname, "videoStreamingPlaylist".id FROM "videoStreamingPlaylist" ' + 'inner join video ON video.id = "videoStreamingPlaylist"."videoId" inner join "videoFile" ON "videoFile"."videoId" = video.id)' await utils.sequelize.query(query, { transaction: utils.transaction })