From 3a4992633ee62d5edfbb484d9c6bcb3cf158489d Mon Sep 17 00:00:00 2001
From: Chocobozzz <me@florianbigard.com>
Date: Mon, 31 Jul 2023 14:34:36 +0200
Subject: Migrate server to ESM

Sorry for the very big commit that may lead to git log issues and merge
conflicts, but it's a major step forward:

 * Server can be faster at startup because imports() are async and we can
   easily lazy import big modules
 * Angular doesn't seem to support ES import (with .js extension), so we
   had to correctly organize peertube into a monorepo:
    * Use yarn workspace feature
    * Use typescript reference projects for dependencies
    * Shared projects have been moved into "packages", each one is now a
      node module (with a dedicated package.json/tsconfig.json)
    * server/tools have been moved into apps/ and is now a dedicated app
      bundled and published on NPM so users don't have to build peertube
      cli tools manually
    * server/tests have been moved into packages/ so we don't compile
      them every time we want to run the server
 * Use isolatedModule option:
   * Had to move from const enum to const
     (https://www.typescriptlang.org/docs/handbook/enums.html#objects-vs-enums)
   * Had to explictely specify "type" imports when used in decorators
 * Prefer tsx (that uses esbuild under the hood) instead of ts-node to
   load typescript files (tests with mocha or scripts):
     * To reduce test complexity as esbuild doesn't support decorator
       metadata, we only test server files that do not import server
       models
     * We still build tests files into js files for a faster CI
 * Remove unmaintained peertube CLI import script
 * Removed some barrels to speed up execution (less imports)
---
 .../migrations/0760-video-live-replay-setting.ts   | 125 ---------------------
 1 file changed, 125 deletions(-)
 delete mode 100644 server/initializers/migrations/0760-video-live-replay-setting.ts

(limited to 'server/initializers/migrations/0760-video-live-replay-setting.ts')

diff --git a/server/initializers/migrations/0760-video-live-replay-setting.ts b/server/initializers/migrations/0760-video-live-replay-setting.ts
deleted file mode 100644
index 7878df3f7..000000000
--- a/server/initializers/migrations/0760-video-live-replay-setting.ts
+++ /dev/null
@@ -1,125 +0,0 @@
-import * as Sequelize from 'sequelize'
-
-async function up (utils: {
-  transaction: Sequelize.Transaction
-  queryInterface: Sequelize.QueryInterface
-  sequelize: Sequelize.Sequelize
-}): Promise<void> {
-  {
-    const query = `
-    CREATE TABLE IF NOT EXISTS "videoLiveReplaySetting" (
-      "id"   SERIAL ,
-      "privacy" INTEGER NOT NULL,
-      "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL,
-      "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL,
-      PRIMARY KEY ("id")
-      );
-    `
-
-    await utils.sequelize.query(query, { transaction : utils.transaction })
-  }
-
-  {
-    await utils.queryInterface.addColumn('videoLive', 'replaySettingId', {
-      type: Sequelize.INTEGER,
-      defaultValue: null,
-      allowNull: true,
-      references: {
-        model: 'videoLiveReplaySetting',
-        key: 'id'
-      },
-      onDelete: 'SET NULL'
-    }, { transaction: utils.transaction })
-  }
-
-  {
-    await utils.queryInterface.addColumn('videoLiveSession', 'replaySettingId', {
-      type: Sequelize.INTEGER,
-      defaultValue: null,
-      allowNull: true,
-      references: {
-        model: 'videoLiveReplaySetting',
-        key: 'id'
-      },
-      onDelete: 'SET NULL'
-    }, { transaction: utils.transaction })
-  }
-
-  {
-    const query = `
-    SELECT live."id", v."privacy"
-    FROM "videoLive" live
-    INNER JOIN "video" v ON live."videoId" = v."id"
-    WHERE live."saveReplay" = true
-    `
-
-    const videoLives = await utils.sequelize.query<{ id: number, privacy: number }>(
-      query,
-      { type: Sequelize.QueryTypes.SELECT, transaction: utils.transaction }
-    )
-
-    for (const videoLive of videoLives) {
-      const query = `
-      WITH new_replay_setting AS (
-        INSERT INTO "videoLiveReplaySetting" ("privacy", "createdAt", "updatedAt")
-        VALUES (:privacy, NOW(), NOW())
-        RETURNING id
-        )
-      UPDATE "videoLive" SET "replaySettingId" = (SELECT id FROM new_replay_setting)
-      WHERE "id" = :id
-      `
-
-      const options = {
-        replacements: { privacy: videoLive.privacy, id: videoLive.id },
-        type: Sequelize.QueryTypes.UPDATE,
-        transaction: utils.transaction
-      }
-
-      await utils.sequelize.query(query, options)
-    }
-  }
-
-  {
-    const query = `
-    SELECT session."id", v."privacy"
-    FROM "videoLiveSession" session
-    INNER JOIN "video" v ON session."liveVideoId" = v."id"
-    WHERE session."saveReplay" = true
-      AND session."liveVideoId" IS NOT NULL;
-    `
-
-    const videoLiveSessions = await utils.sequelize.query<{ id: number, privacy: number }>(
-      query,
-      { type: Sequelize.QueryTypes.SELECT, transaction: utils.transaction }
-    )
-
-    for (const videoLive of videoLiveSessions) {
-      const query = `
-      WITH new_replay_setting AS (
-        INSERT INTO "videoLiveReplaySetting" ("privacy", "createdAt", "updatedAt")
-        VALUES (:privacy, NOW(), NOW())
-        RETURNING id
-        )
-      UPDATE "videoLiveSession" SET "replaySettingId" = (SELECT id FROM new_replay_setting)
-      WHERE "id" = :id
-      `
-
-      const options = {
-        replacements: { privacy: videoLive.privacy, id: videoLive.id },
-        type: Sequelize.QueryTypes.UPDATE,
-        transaction: utils.transaction
-      }
-
-      await utils.sequelize.query(query, options)
-    }
-  }
-}
-
-function down (options) {
-  throw new Error('Not implemented.')
-}
-
-export {
-  up,
-  down
-}
-- 
cgit v1.2.3