Merge branch 'release/2.1.0' into develop

[oweals/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..08e2e3989b87688764271cab3707db2faa3f9a8a 100644 (file)
--- a/server/initializers/migrations/0450-streaming-playlist-files.ts
+++ b/server/initializers/migrations/0450-streaming-playlist-files.ts
@@ -1,9 +1,9 @@
 import * as Sequelize from 'sequelize'
 
 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<void> {
   {
@@ -28,6 +28,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) {