]> git.immae.eu Git - github/Chocobozzz/PeerTube.git/blob - server/initializers/migrations/0415-thumbnail-auto-generated.ts
Try to fix video duplication
[github/Chocobozzz/PeerTube.git] / server / initializers / migrations / 0415-thumbnail-auto-generated.ts
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 data = {
11 type: Sequelize.BOOLEAN,
12 allowNull: true,
13 defaultValue: null
14 }
15
16 await utils.queryInterface.addColumn('thumbnail', 'automaticallyGenerated', data)
17 }
18
19 {
20 // Set auto generated to true for watch later playlists
21 const query = 'UPDATE thumbnail SET "automaticallyGenerated" = true WHERE "videoPlaylistId" IN ' +
22 '(SELECT id FROM "videoPlaylist" WHERE type = 2)'
23
24 await utils.sequelize.query(query)
25 }
26 }
27
28 function down (options) {
29 throw new Error('Not implemented.')
30 }
31
32 export {
33 up,
34 down
35 }