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)

1 files changed, 0 insertions, 83 deletions

diff --git a/server/initializers/migrations/0520-abuses-split.ts b/server/initializers/migrations/0520-abuses-split.ts
deleted file mode 100644
index 136d5c2b2..000000000
--- a/server/initializers/migrations/0520-abuses-split.ts
+++ /dev/null
@@ -1,83 +0,0 @@
-import * as Sequelize from 'sequelize'
-
-async function up (utils: {
-  transaction: Sequelize.Transaction
-  queryInterface: Sequelize.QueryInterface
-  sequelize: Sequelize.Sequelize
-}): Promise<void> {
-  await utils.queryInterface.renameTable('videoAbuse', 'abuse')
-
-  await utils.sequelize.query(`
-    ALTER TABLE "abuse"
-    ADD COLUMN "flaggedAccountId" INTEGER REFERENCES "account" ("id") ON DELETE SET NULL ON UPDATE CASCADE
-  `)
-
-  await utils.sequelize.query(`
-    UPDATE "abuse" SET "videoId" = NULL
-    WHERE "videoId" NOT IN (SELECT "id" FROM "video")
-  `)
-
-  await utils.sequelize.query(`
-    UPDATE "abuse" SET "flaggedAccountId" = "videoChannel"."accountId"
-    FROM "video" INNER JOIN "videoChannel" ON "video"."channelId" = "videoChannel"."id"
-    WHERE "abuse"."videoId" = "video"."id"
-  `)
-
-  await utils.sequelize.query('DROP INDEX IF EXISTS video_abuse_video_id;')
-  await utils.sequelize.query('DROP INDEX IF EXISTS video_abuse_reporter_account_id;')
-
-  await utils.sequelize.query(`
-    CREATE TABLE IF NOT EXISTS "videoAbuse" (
-      "id" serial,
-      "startAt" integer DEFAULT NULL,
-      "endAt" integer DEFAULT NULL,
-      "deletedVideo" jsonb DEFAULT NULL,
-      "abuseId" integer NOT NULL REFERENCES "abuse" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
-      "videoId" integer REFERENCES "video" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
-      "createdAt" TIMESTAMP WITH time zone NOT NULL,
-      "updatedAt" timestamp WITH time zone NOT NULL,
-      PRIMARY KEY ("id")
-    );
-  `)
-
-  await utils.sequelize.query(`
-    CREATE TABLE IF NOT EXISTS "commentAbuse" (
-      "id" serial,
-      "abuseId" integer NOT NULL REFERENCES "abuse" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
-      "videoCommentId" integer REFERENCES "videoComment" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
-      "createdAt" timestamp WITH time zone NOT NULL,
-      "updatedAt" timestamp WITH time zone NOT NULL,
-      PRIMARY KEY ("id")
-    );
-  `)
-
-  await utils.sequelize.query(`
-      INSERT INTO "videoAbuse" ("startAt", "endAt", "deletedVideo", "abuseId", "videoId", "createdAt", "updatedAt")
-      SELECT "abuse"."startAt", "abuse"."endAt", "abuse"."deletedVideo", "abuse"."id", "abuse"."videoId",
-      "abuse"."createdAt", "abuse"."updatedAt"
-      FROM "abuse"
-  `)
-
-  await utils.queryInterface.removeColumn('abuse', 'startAt')
-  await utils.queryInterface.removeColumn('abuse', 'endAt')
-  await utils.queryInterface.removeColumn('abuse', 'deletedVideo')
-  await utils.queryInterface.removeColumn('abuse', 'videoId')
-
-  await utils.sequelize.query('DROP INDEX IF EXISTS user_notification_video_abuse_id')
-  await utils.queryInterface.renameColumn('userNotification', 'videoAbuseId', 'abuseId')
-
-  await utils.sequelize.query(
-    'ALTER INDEX IF EXISTS "videoAbuse_pkey" RENAME TO "abuse_pkey"'
-  )
-
-  await utils.queryInterface.renameColumn('userNotificationSetting', 'videoAbuseAsModerator', 'abuseAsModerator')
-}
-
-function down (options) {
-  throw new Error('Not implemented.')
-}
-
-export {
-  up,
-  down
-}