zimfarm icon indicating copy to clipboard operation
zimfarm copied to clipboard

Youtube offliner definition update (new flag + remove playlist mode) + fix TED offliner definition

Open benoit74 opened this issue 9 months ago • 2 comments

Fix #878

Changes

  • add new long_description field to youtube offliner definition
  • fix field type of TED long_description (was String instead of LongString)
  • remove all "playlist-mode" youtube flags (including metadata-from) and change utility to youtube2zim
  • remove any reference to "Single mode" in remaining youtube flags descriptions

Nota:

SQL updates will have to be ran manually to get rid of removed config flags

UPDATE schedule SET config = config::jsonb #- '{flags, indiv-playlists}'
WHERE config::jsonb -> 'flags' -> 'indiv-playlists' IS NOT NULL
AND config::jsonb -> 'image' ->> 'name' = 'ghcr.io/openzim/youtube';

UPDATE schedule SET config = config::jsonb #- '{flags, playlists-name}'
WHERE config::jsonb -> 'flags' -> 'playlists-name' IS NOT NULL
AND config::jsonb -> 'image' ->> 'name' = 'ghcr.io/openzim/youtube';

UPDATE schedule SET config = config::jsonb #- '{flags, playlists-zim-file}'
WHERE config::jsonb -> 'flags' -> 'playlists-zim-file' IS NOT NULL
AND config::jsonb -> 'image' ->> 'name' = 'ghcr.io/openzim/youtube';

UPDATE schedule SET config = config::jsonb #- '{flags, playlists-title}'
WHERE config::jsonb -> 'flags' -> 'playlists-title' IS NOT NULL
AND config::jsonb -> 'image' ->> 'name' = 'ghcr.io/openzim/youtube';

UPDATE schedule SET config = config::jsonb #- '{flags, playlists-description}'
WHERE config::jsonb -> 'flags' -> 'playlists-description' IS NOT NULL
AND config::jsonb -> 'image' ->> 'name' = 'ghcr.io/openzim/youtube';

UPDATE schedule SET config = config::jsonb #- '{flags, metadata-from}'
WHERE config::jsonb -> 'flags' -> 'metadata-from' IS NOT NULL
AND config::jsonb -> 'image' ->> 'name' = 'ghcr.io/openzim/youtube';

benoit74 avatar May 22 '24 15:05 benoit74