Add url field in caption and use it for thumbnails

[github/Chocobozzz/PeerTube.git] / server / initializers / migrations / 0450-streaming-playlist-files.ts

diff --git a/server/initializers/migrations/0450-streaming-playlist-files.ts b/server/initializers/migrations/0450-streaming-playlist-files.ts
index 536ef00f91e6f7d378ad2147a4ea41e3bd756c34..460dac8be9f773cbfec13a61a7a75fa8bc3af31e 100644 (file)
--- a/server/initializers/migrations/0450-streaming-playlist-files.ts
+++ b/server/initializers/migrations/0450-streaming-playlist-files.ts
@@ -1,4 +1,10 @@
 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,
@@ -28,6 +34,20 @@ async function up (utils: {
 
     await utils.queryInterface.changeColumn('videoFile', 'videoId', data)
   }
+
+  {
+    await utils.queryInterface.removeIndex('videoFile', 'video_file_video_id_resolution_fps')
+  }
+
+  {
+    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" ' +
+      'inner join video ON video.id = "videoStreamingPlaylist"."videoId" inner join "videoFile" ON "videoFile"."videoId" = video.id)'
+
+    await utils.sequelize.query(query, { transaction: utils.transaction })
+  }
 }
 
 function down (options) {