]>
Commit | Line | Data |
---|---|---|
a8b1b404 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 | const query = 'DELETE FROM "thumbnail" s1 ' + | |
11 | 'USING (SELECT MIN(id) as id, "filename", "type" FROM "thumbnail" GROUP BY "filename", "type" HAVING COUNT(*) > 1) s2 ' + | |
12 | 'WHERE s1."filename" = s2."filename" AND s1."type" = s2."type" AND s1.id <> s2.id' | |
13 | await utils.sequelize.query(query) | |
14 | } | |
15 | } | |
16 | ||
17 | function down (options) { | |
18 | throw new Error('Not implemented.') | |
19 | } | |
20 | ||
21 | export { | |
22 | up, | |
23 | down | |
24 | } |