From 4805cff179cbf518abb4c1b494b477c71f84b989 Mon Sep 17 00:00:00 2001 From: Chocobozzz Date: Mon, 29 Jan 2018 11:58:07 +0100 Subject: Fix migrations --- server/initializers/constants.ts | 2 +- .../migrations/0190-video-comment-unique-url.ts | 23 ++++++++++++++++++++++ 2 files changed, 24 insertions(+), 1 deletion(-) create mode 100644 server/initializers/migrations/0190-video-comment-unique-url.ts (limited to 'server') diff --git a/server/initializers/constants.ts b/server/initializers/constants.ts index a88f9642c..03828f54f 100644 --- a/server/initializers/constants.ts +++ b/server/initializers/constants.ts @@ -12,7 +12,7 @@ let config: IConfig = require('config') // --------------------------------------------------------------------------- -const LAST_MIGRATION_VERSION = 185 +const LAST_MIGRATION_VERSION = 190 // --------------------------------------------------------------------------- diff --git a/server/initializers/migrations/0190-video-comment-unique-url.ts b/server/initializers/migrations/0190-video-comment-unique-url.ts new file mode 100644 index 000000000..b196c9352 --- /dev/null +++ b/server/initializers/migrations/0190-video-comment-unique-url.ts @@ -0,0 +1,23 @@ +import * as Sequelize from 'sequelize' + +async function up (utils: { + transaction: Sequelize.Transaction, + queryInterface: Sequelize.QueryInterface, + sequelize: Sequelize.Sequelize +}): Promise { + { + const query = 'DELETE FROM "videoComment" s1 ' + + 'USING (SELECT MIN(id) as id, url FROM "videoComment" GROUP BY "url" HAVING COUNT(*) > 1) s2 ' + + 'WHERE s1."url" = s2."url" AND s1.id <> s2.id' + await utils.sequelize.query(query) + } +} + +function down (options) { + throw new Error('Not implemented.') +} + +export { + up, + down +} -- cgit v1.2.3