aboutsummaryrefslogtreecommitdiffhomepage
path: root/scripts/migrations
diff options
context:
space:
mode:
Diffstat (limited to 'scripts/migrations')
-rw-r--r--scripts/migrations/peertube-2.1.ts77
1 files changed, 77 insertions, 0 deletions
diff --git a/scripts/migrations/peertube-2.1.ts b/scripts/migrations/peertube-2.1.ts
new file mode 100644
index 000000000..892497a88
--- /dev/null
+++ b/scripts/migrations/peertube-2.1.ts
@@ -0,0 +1,77 @@
1import { registerTSPaths } from '../../server/helpers/register-ts-paths'
2registerTSPaths()
3
4import { initDatabaseModels, sequelizeTypescript } from '../../server/initializers'
5import * as Sequelize from 'sequelize'
6import { join } from 'path'
7import { HLS_STREAMING_PLAYLIST_DIRECTORY, STATIC_PATHS, WEBSERVER } from '@server/initializers/constants'
8import { pathExists, stat, writeFile } from 'fs-extra'
9import { createTorrentPromise } from '@server/helpers/webtorrent'
10import { CONFIG } from '@server/initializers/config'
11import * as parseTorrent from 'parse-torrent'
12import { logger } from '@server/helpers/logger'
13
14run()
15 .then(() => process.exit(0))
16 .catch(err => {
17 console.error(err)
18 process.exit(-1)
19 })
20
21async function run () {
22 logger.info('Creating torrents and updating database for HSL files.')
23
24 await initDatabaseModels(true)
25
26 const query = 'select "videoFile".id as id, "videoFile".resolution as resolution, "video".uuid as uuid from "videoFile" ' +
27 'inner join "videoStreamingPlaylist" ON "videoStreamingPlaylist".id = "videoFile"."videoStreamingPlaylistId" ' +
28 'inner join video ON video.id = "videoStreamingPlaylist"."videoId" ' +
29 'WHERE video.remote IS FALSE'
30 const options = {
31 type: Sequelize.QueryTypes.SELECT
32 }
33 const res = await sequelizeTypescript.query(query, options)
34
35 for (const row of res) {
36 const videoFilename = `${row['uuid']}-${row['resolution']}-fragmented.mp4`
37 const videoFilePath = join(HLS_STREAMING_PLAYLIST_DIRECTORY, row['uuid'], videoFilename)
38
39 logger.info('Processing %s.', videoFilePath)
40
41 if (!await pathExists(videoFilePath)) {
42 console.warn('Cannot generate torrent of %s: file does not exist.', videoFilePath)
43 continue
44 }
45
46 const createTorrentOptions = {
47 // Keep the extname, it's used by the client to stream the file inside a web browser
48 name: `video ${row['uuid']}`,
49 createdBy: 'PeerTube',
50 announceList: [
51 [ WEBSERVER.WS + '://' + WEBSERVER.HOSTNAME + ':' + WEBSERVER.PORT + '/tracker/socket' ],
52 [ WEBSERVER.URL + '/tracker/announce' ]
53 ],
54 urlList: [ WEBSERVER.URL + join(STATIC_PATHS.STREAMING_PLAYLISTS.HLS, row['uuid'], videoFilename) ]
55 }
56 const torrent = await createTorrentPromise(videoFilePath, createTorrentOptions)
57
58 const torrentName = `${row['uuid']}-${row['resolution']}-hls.torrent`
59 const filePath = join(CONFIG.STORAGE.TORRENTS_DIR, torrentName)
60
61 await writeFile(filePath, torrent)
62
63 const parsedTorrent = parseTorrent(torrent)
64 const infoHash = parsedTorrent.infoHash
65
66 const stats = await stat(videoFilePath)
67 const size = stats.size
68
69 const queryUpdate = 'UPDATE "videoFile" SET "infoHash" = ?, "size" = ? WHERE id = ?'
70
71 const options = {
72 type: Sequelize.QueryTypes.UPDATE,
73 replacements: [ infoHash, size, row['id'] ]
74 }
75 await sequelizeTypescript.query(queryUpdate, options)
76 }
77}