From 348c2ce3ff3fe2f25a31f08bfb36c88723a0ce46 Mon Sep 17 00:00:00 2001 From: Chocobozzz Date: Mon, 21 Mar 2022 14:54:29 +0100 Subject: Remove old migration files --- .../migrations/0290-account-video-rate-url.ts | 46 ---------------------- 1 file changed, 46 deletions(-) delete mode 100644 server/initializers/migrations/0290-account-video-rate-url.ts (limited to 'server/initializers/migrations/0290-account-video-rate-url.ts') diff --git a/server/initializers/migrations/0290-account-video-rate-url.ts b/server/initializers/migrations/0290-account-video-rate-url.ts deleted file mode 100644 index b974b1a81..000000000 --- a/server/initializers/migrations/0290-account-video-rate-url.ts +++ /dev/null @@ -1,46 +0,0 @@ -import * as Sequelize from 'sequelize' - -async function up (utils: { - transaction: Sequelize.Transaction - queryInterface: Sequelize.QueryInterface - sequelize: Sequelize.Sequelize - db: any -}): Promise { - { - const data = { - type: Sequelize.STRING(2000), - allowNull: true - } - - await utils.queryInterface.addColumn('accountVideoRate', 'url', data) - } - - { - const builtUrlQuery = `SELECT "actor"."url" || '/' || "accountVideoRate"."type" || 's/' || "videoId" ` + - 'FROM "accountVideoRate" ' + - 'INNER JOIN account ON account.id = "accountVideoRate"."accountId" ' + - 'INNER JOIN actor ON actor.id = account."actorId" ' + - 'WHERE "base".id = "accountVideoRate".id' - - const query = 'UPDATE "accountVideoRate" base SET "url" = (' + builtUrlQuery + ') WHERE "url" IS NULL' - await utils.sequelize.query(query) - } - - { - const data = { - type: Sequelize.STRING(2000), - allowNull: false, - defaultValue: null - } - await utils.queryInterface.changeColumn('accountVideoRate', 'url', data) - } -} - -function down (options) { - throw new Error('Not implemented.') -} - -export { - up, - down -} -- cgit v1.2.3