copy_channel 2251 1098

copy_channel 2017 1017
copy_channel 2029 1029
copy_channel 2042 1042

echo ;  echo "Fixing AZNTV" ; echo
copy_channel 0670 9670
copy_channel 0671 9671
copy_channel 0672 9672
copy_channel 0673 9673
copy_channel 0674 9674
copy_channel 0675 9675
copy_channel 0676 9676
copy_channel 0680 9680

2007-03-30 12:40:44.140 Updating source #1 (zap2it boi) with grabber datadirect
2007-03-30 12:42:39.293 Updating source #2 (Zap2it PDX) with grabber datadirect

mysql -u root mythconverg <<EOF
delete from program
where chanid = '$to_chanid';

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, tmoffset, atsc_major_chan, atsc_minor_chan,
from channel
where chanid = '$from_chanid');

delete from program
where chanid = '$to_chanid';

mysql -u root mythconverg -e "desc channel"

#!/bin/bash

exec >/var/log/mythtv/update_database.log 2>&1

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

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';

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
    # fill_options="--refresh-second"
    fill_options=""
fi

/usr/bin/mythfilldatabase $fill_options
sleep 5

echo ;  echo "Fixing AZNTV" ; echo
copy_channel 0670 9670
copy_channel 0671 9671
copy_channel 0672 9672
copy_channel 0673 9673
copy_channel 0674 9674
copy_channel 0675 9675
copy_channel 0676 9676
copy_channel 0680 9680

/usr/bin/mythbackend --resched

echo
echo "Database update completed"

delete from program
where chanid = '$to_chanid';

Fixing AZNTV

ERROR 1064 at line 4: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'from channel where chanid = '9670')' at line 6

#!/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