#!/bin/bash

LOG_FILE="/var/log/mythtv/update_database.log"
mv -f $LOG_FILE $LOG_FILE.old
exec >$LOG_FILE 2>&1

copy_channel () {
  from_chanid=$1
  to_chanid=$2

# You really only need to copy the channel table data over once, but
# it shouldn't hurt anything to do it every time.  I could probably
# make this smarter about that...

mysql -u root mythconverg <<EOF

delete from channel
where chanid = '$to_chanid';

insert into channel
(select '$to_chanid', channum, freqid, sourceid,
        callsign, name, icon, finetune, videofilters, xmltvid,
        recpriority, contrast, brightness, colour, hue, tvformat,
        commfree, visible, outputfilters, useonairguide, mplexid,
        serviceid, atscsrcid
        from channel
        where chanid = '$from_chanid');

delete from program
where chanid = '$to_chanid';

insert into program
(select '$to_chanid', starttime, endtime, title, subtitle, description,
        category, category_type, airdate, stars, previouslyshown,
        title_pronounce, stereo, subtitled, hdtv, closecaptioned,
        partnumber, parttotal, seriesid, originalairdate, showtype,
        colorcode, syndicatedepisodenumber, programid, manualid,
        generic, listingsource, first, last
        from program
        where chanid = '$from_chanid');

delete from credits
where chanid = '$to_chanid';

insert into credits
(select person, '$to_chanid', starttime, role
        from credits
        where chanid = '$from_chanid');

delete from programgenres
where chanid = '$to_chanid';

insert into programgenres
(select '$to_chanid', starttime, relevance, genre
        from programgenres
        where chanid = '$from_chanid');

delete from programrating
where chanid = '$to_chanid';

insert into programrating
(select '$to_chanid', starttime, system, rating
        from programrating
        where chanid = '$from_chanid');

commit;
EOF
}

fill_options="$*"
if [ -z "$fill_options" -o "$fill_options" = "--quiet" ] ; then
    if [ $(date +%A) == "Sunday" ] ; then
        fill_options="--refresh-all"
    else
        # fill_options="--refresh-second"
        fill_options=""
    fi
fi

/usr/bin/mythfilldatabase $fill_options
sleep 5 # Give the DB time to settle.

# We can add as many mappings here as needed.
echo ; echo "Merging lineups" ; echo
copy_channel 2251 1098

# This only needs to be done once at the end.
/usr/bin/mythbackend --resched

echo
echo "Database update completed"

exit 0

tv_grab_na --configure --config-file /home/mythtv/config.a
[enter options for first location]
tv_grab_na --configure --config-file /home/mythtv/config.b
[enter options for second location]

#!/bin/sh
tv_grab_na --config-file /home/mythtv/config.a --file /tmp/a.xml
tv_grab_na --config-file /home/mythtv/config.b --file /tmp/b.xml
mythfilldatabase --file 0 0 /tmp/a.xml
mythfilldatabase --file 0 0 /tmp/b.xml