Attachment 10728 Details for Bug 24099 – sql script to get/save xmltvid field prior to channel scan

sql script to get/save xmltvid field prior to channel scan

get_xmltvid.sql (text/plain), 1.20 KB, created by Bit Twister on 2019-02-04 15:50:18 CET

(hide)

Description:

Filename:

MIME Type:

Creator: Bit Twister

Created: 2019-02-04 15:50:18 CET

Size: 1.20 KB

patch

obsolete

>-- -----------------start of get_xmltvid.sql ------------------------------
>--
>-- sql script to save current xmltvid fields needed by program guide.
>-- or you plan on deleting all channels and run a scan channels.
>--
>-- output:  /var/lib/mysql/mythconverg/xmltvid_update.sql
>--
>-- Workaround needed for
>-- mythtv-setup: unable to automagically set xmltvid field
>--   https://code.mythtv.org/trac/ticket/13388
>-- for clean mythtv backend installs or when you run a channel scan.
>--
>-- Usage:
>--
>--  rm --force /var/lib/mysql/mythconverg/xmltvid_update.sql
>--
>--  mysql --user=root --password=mysql_passwd_here  mythconverg  \
>--      < /wherever/get_xmltvid.sql
>--
>--  tr -d "\t" < /var/lib/mysql/mythconverg/xmltvid_update.sql \
>--      > /wherever/xmltvid_update.sql
>--
>-- to update xmltvid field, run
>-- mysql --user=root --password=mysql_passwd_here  mythconverg  \
>--     < /wherever/xmltvid_update.sql
>--
>-- -----------------------------------------------------------------------
>
>use mythconverg ;
>SELECT 'UPDATE channel SET xmltvid="',xmltvid,'" WHERE channum="',channum,'" ;'
>FROM channel
>WHERE xmltvid <> ''
>into outfile 'xmltvid_update.sql' ;
>
>-- ------------------end of get_xmltvid.sql ------------------------------

-- -----------------start of get_xmltvid.sql ------------------------------
--
-- sql script to save current xmltvid fields needed by program guide.
-- or you plan on deleting all channels and run a scan channels.
--
-- output:  /var/lib/mysql/mythconverg/xmltvid_update.sql
--
-- Workaround needed for
-- mythtv-setup: unable to automagically set xmltvid field
--   https://code.mythtv.org/trac/ticket/13388
-- for clean mythtv backend installs or when you run a channel scan.
--
-- Usage:
--
--  rm --force /var/lib/mysql/mythconverg/xmltvid_update.sql
--
--  mysql --user=root --password=mysql_passwd_here  mythconverg  \
--      < /wherever/get_xmltvid.sql
--
--  tr -d "\t" < /var/lib/mysql/mythconverg/xmltvid_update.sql \
--      > /wherever/xmltvid_update.sql
--
-- to update xmltvid field, run
-- mysql --user=root --password=mysql_passwd_here  mythconverg  \
--     < /wherever/xmltvid_update.sql
--
-- -----------------------------------------------------------------------

use mythconverg ;
SELECT 'UPDATE channel SET xmltvid="',xmltvid,'" WHERE channum="',channum,'" ;'
FROM channel
WHERE xmltvid <> ''
into outfile 'xmltvid_update.sql' ;

-- ------------------end of get_xmltvid.sql ------------------------------

Actions: View

Attachments on bug 24099: 10722 | 10723 | 10724 | 10728 | 10731