Command to generate storyboard thumbnail for all older videos

PeerTube
18

hi @Chocobozzz , do you think these sql query can do the job :

UPDATE videoStreamingPlaylist
SET playlistUrl = REPLACE(playlistUrl, ‹ /hls/ ›, ‹ /streaming-playlistshls/ ›)
WHERE playlistUrl LIKE ‹ %/hls/% ›;

and this one :

UPDATE videoStreamingPlaylist
SET segmentsSha256Url = REPLACE(segmentsSha256Url, ‹ /hls/ ›, ‹ /streaming-playlistshls/ ›)
WHERE segmentsSha256Url LIKE ‹ %/hls/% ›;

and :

UPDATE « videoFile »
SET « fileUrl » = REPLACE(« fileUrl », ‹ /hls/ ›, ‹ /streaming-playlistshls/ ›)
WHERE « fileUrl » like ‹ %/hls/% ›;

Then we have to move all video s3 folder from /hls/ to /streaming-playlisthls/
and correct the acl on each video file for public read (acl are not copied when we copy or move object)