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, 150 deletions

diff --git a/server/tests/shared/sql-command.ts b/server/tests/shared/sql-command.ts
deleted file mode 100644
index 5c53a8ac6..000000000
--- a/server/tests/shared/sql-command.ts
+++ /dev/null
@@ -1,150 +0,0 @@
-import { QueryTypes, Sequelize } from 'sequelize'
-import { forceNumber } from '@shared/core-utils'
-import { PeerTubeServer } from '@shared/server-commands'
-
-export class SQLCommand {
-  private sequelize: Sequelize
-
-  constructor (private readonly server: PeerTubeServer) {
-
-  }
-
-  deleteAll (table: string) {
-    const seq = this.getSequelize()
-
-    const options = { type: QueryTypes.DELETE }
-
-    return seq.query(`DELETE FROM "${table}"`, options)
-  }
-
-  async getVideoShareCount () {
-    const [ { total } ] = await this.selectQuery<{ total: string }>(`SELECT COUNT(*) as total FROM "videoShare"`)
-    if (total === null) return 0
-
-    return parseInt(total, 10)
-  }
-
-  async getInternalFileUrl (fileId: number) {
-    return this.selectQuery<{ fileUrl: string }>(`SELECT "fileUrl" FROM "videoFile" WHERE id = :fileId`, { fileId })
-      .then(rows => rows[0].fileUrl)
-  }
-
-  setActorField (to: string, field: string, value: string) {
-    return this.updateQuery(`UPDATE actor SET ${this.escapeColumnName(field)} = :value WHERE url = :to`, { value, to })
-  }
-
-  setVideoField (uuid: string, field: string, value: string) {
-    return this.updateQuery(`UPDATE video SET ${this.escapeColumnName(field)} = :value WHERE uuid = :uuid`, { value, uuid })
-  }
-
-  setPlaylistField (uuid: string, field: string, value: string) {
-    return this.updateQuery(`UPDATE "videoPlaylist" SET ${this.escapeColumnName(field)} = :value WHERE uuid = :uuid`, { value, uuid })
-  }
-
-  async countVideoViewsOf (uuid: string) {
-    const query = 'SELECT SUM("videoView"."views") AS "total" FROM "videoView" ' +
-      `INNER JOIN "video" ON "video"."id" = "videoView"."videoId" WHERE "video"."uuid" = :uuid`
-
-    const [ { total } ] = await this.selectQuery<{ total: number }>(query, { uuid })
-    if (!total) return 0
-
-    return forceNumber(total)
-  }
-
-  getActorImage (filename: string) {
-    return this.selectQuery<{ width: number, height: number }>(`SELECT * FROM "actorImage" WHERE filename = :filename`, { filename })
-      .then(rows => rows[0])
-  }
-
-  // ---------------------------------------------------------------------------
-
-  setPluginVersion (pluginName: string, newVersion: string) {
-    return this.setPluginField(pluginName, 'version', newVersion)
-  }
-
-  setPluginLatestVersion (pluginName: string, newVersion: string) {
-    return this.setPluginField(pluginName, 'latestVersion', newVersion)
-  }
-
-  setPluginField (pluginName: string, field: string, value: string) {
-    return this.updateQuery(
-      `UPDATE "plugin" SET ${this.escapeColumnName(field)} = :value WHERE "name" = :pluginName`,
-      { pluginName, value }
-    )
-  }
-
-  // ---------------------------------------------------------------------------
-
-  selectQuery <T extends object> (query: string, replacements: { [id: string]: string | number } = {}) {
-    const seq = this.getSequelize()
-    const options = {
-      type: QueryTypes.SELECT as QueryTypes.SELECT,
-      replacements
-    }
-
-    return seq.query<T>(query, options)
-  }
-
-  updateQuery (query: string, replacements: { [id: string]: string | number } = {}) {
-    const seq = this.getSequelize()
-    const options = { type: QueryTypes.UPDATE as QueryTypes.UPDATE, replacements }
-
-    return seq.query(query, options)
-  }
-
-  // ---------------------------------------------------------------------------
-
-  async getPlaylistInfohash (playlistId: number) {
-    const query = 'SELECT "p2pMediaLoaderInfohashes" FROM "videoStreamingPlaylist" WHERE id = :playlistId'
-
-    const result = await this.selectQuery<{ p2pMediaLoaderInfohashes: string }>(query, { playlistId })
-    if (!result || result.length === 0) return []
-
-    return result[0].p2pMediaLoaderInfohashes
-  }
-
-  // ---------------------------------------------------------------------------
-
-  setActorFollowScores (newScore: number) {
-    return this.updateQuery(`UPDATE "actorFollow" SET "score" = :newScore`, { newScore })
-  }
-
-  setTokenField (accessToken: string, field: string, value: string) {
-    return this.updateQuery(
-      `UPDATE "oAuthToken" SET ${this.escapeColumnName(field)} = :value WHERE "accessToken" = :accessToken`,
-      { value, accessToken }
-    )
-  }
-
-  async cleanup () {
-    if (!this.sequelize) return
-
-    await this.sequelize.close()
-    this.sequelize = undefined
-  }
-
-  private getSequelize () {
-    if (this.sequelize) return this.sequelize
-
-    const dbname = 'peertube_test' + this.server.internalServerNumber
-    const username = 'peertube'
-    const password = 'peertube'
-    const host = '127.0.0.1'
-    const port = 5432
-
-    this.sequelize = new Sequelize(dbname, username, password, {
-      dialect: 'postgres',
-      host,
-      port,
-      logging: false
-    })
-
-    return this.sequelize
-  }
-
-  private escapeColumnName (columnName: string) {
-    return this.getSequelize().escape(columnName)
-      .replace(/^'/, '"')
-      .replace(/'$/, '"')
-  }
-}