Furthermore, in oc_playlist_seminar_video should be not only the invisible ones but as well the explicitly visible ones from V2, because there is the config option OPENCAST_HIDE_EPISODES which defines if videos are per default only visible for lecturers.

This works the following way:

Initally all videos have the visibility "default". If they are visible for students is determined by said config option, so the videos could be visible or invisible, depending on the setting.
Then there are explicit visibilities, which than deviate from the default.

So, in the migration from V2 to V3 it is necessary to migrate all visibility settings for episodes in courses to make sure every scenario is covered.

Here is some SQL-Statements to get started (courtesy by a colleague):

Migrate all explicitly set invisible videos:

INSERT INTO oc_playlist_seminar_video (playlist_seminar_id, video_id, visibility, visible_timestamp)
SELECT oc_playlist_seminar.id, video_id, 'hidden', NULL FROM oc_playlist_seminar
JOIN oc_playlist_video USING(playlist_id)
JOIN oc_video ON oc_video.id = video_id
JOIN oc_seminar_episodes ON episode_id = episode AND oc_playlist_seminar.seminar_id = oc_seminar_episodes.seminar_id
WHERE oc_seminar_episodes.visible = 'invisible'

Migrate all explicitly set visible videos:

INSERT INTO oc_playlist_seminar_video (playlist_seminar_id, video_id, visibility, visible_timestamp)
SELECT oc_playlist_seminar.id, video_id, 'visible', NULL FROM oc_playlist_seminar
JOIN oc_playlist_video USING(playlist_id)
JOIN oc_video ON oc_video.id = video_id
JOIN oc_seminar_episodes ON episode_id = episode AND oc_playlist_seminar.seminar_id = oc_seminar_episodes.seminar_id
WHERE oc_seminar_episodes.visible = 'visible'
  OR oc_seminar_episodes.visible = 'free'

Sichtbarkeiten der Videos wurden nicht migriert #1286

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions