This directory contains scripts that:

enable migrating to the new podcaster

automatically connect Shows with Channels by setting podcast_channel_id field in the show table

test the new podcaster's API (audio file creation, xml file creation)

time to migrate the podcasts!

then execute the following scripts by clicking on them (in order!)

1) ensure all database migrations are run successfully

2) Ingest podcast xml data (takes a couple minutes)

3) Run Connect Shows with Channels. To auto-connect many shows to their channels Observe the output, because not all will work, and the rest have to be done manually

4) import old playsheets . (probably already done)

5) run connect playsheets with episodes. more tba...

  revert steps:

    truncate podcast_episodes, podcast_channels
    delete podcast_channel_id in every show ( UPDATE shows set podcast_channel_id = NULL; )
    delete episode_id in every playlist (UPDATE playlists SET podcast_episode = NULL; )