[github/Chocobozzz/PeerTube.git] / server / initializers / migrations / 0612-captions-unique.ts

import * as Sequelize from 'sequelize'

async function up (utils: {
  transaction: Sequelize.Transaction
  queryInterface: Sequelize.QueryInterface
  sequelize: Sequelize.Sequelize
  db: any
}): Promise<void> {

  await utils.sequelize.query(
    'DELETE FROM "videoCaption" v1 USING (SELECT MIN(id) as id, "filename" FROM "videoCaption" ' +
    'GROUP BY "filename" HAVING COUNT(*) > 1) v2 WHERE v1."filename" = v2."filename" AND v1.id <> v2.id'
  )
}

function down (options) {
  throw new Error('Not implemented.')
}

export {
  up,
  down
}
Commit	Line	Data
083328eb C	1	import * as Sequelize from 'sequelize'
	2
	3	async function up (utils: {
	4	transaction: Sequelize.Transaction
	5	queryInterface: Sequelize.QueryInterface
	6	sequelize: Sequelize.Sequelize
	7	db: any
	8	}): Promise<void> {
	9
	10	await utils.sequelize.query(
	11	'DELETE FROM "videoCaption" v1 USING (SELECT MIN(id) as id, "filename" FROM "videoCaption" ' +
	12	'GROUP BY "filename" HAVING COUNT(*) > 1) v2 WHERE v1."filename" = v2."filename" AND v1.id <> v2.id'
	13	)
	14	}
	15
	16	function down (options) {
	17	throw new Error('Not implemented.')
	18	}
	19
	20	export {
	21	up,
	22	down
	23	}