mysql mythconverg <<EOF
show tables;
quit
EOF

#!/bin/bash
videodir="/myth/video/sub-directory"
let "episodenum=1"
metadatafile=flat_file_with_your_metadata.mtd

ls ${videodir}/[0-9][0-9]* | while read videofile; do
    echo ${episodenum}
    episode_summary=$(head -n${episodenum} ${metadatafile} | tail -n1)

    if [ ${episodenum} -lt 10 ]; then
    two_digit_episode_num='0'${episodenum}
    else
    two_digit_episode_num=${episodenum}
    fi

    title=${two_digit_episode_num}'-'$(echo ${episode_summary} | cut -f1 -d":");
    airdate=$(echo ${episode_summary} | cut -f2 -d":" | cut -f3 -d " ");
    plot_summary=$(echo ${episode_summary} | cut -f3 -d":" | sed "s/'/\\\'/g")

    echo ${videofile}
    echo ${title}
    echo ${airdate}
    echo ${plot_summary}

    dataexists=$(mysql --skip-column-names -B -p$password -e "use mythconverg; select filename from videometadata where filename='${videofile}';")
    if [ ! -n "$dataexists" ]
    then
        echo "Metadata does not exist for ${title}"
    else
        echo "Metadata found for ${title}!  Updating!"
        mysql -p$password -e "use mythconverg; UPDATE videometadata SET title='${title}',plot='${plot_summary}',year='${airdate}' where filename='${videofile}';"
    fi
    let "episodenum++"
done