1 | Here's a typical example of a program that was claimed to be longer |
---|
2 | than its timeslot, and really was---a recording that padded the ending |
---|
3 | by only 2 minutes past the claimed timeslot lost the last several |
---|
4 | minutes of the actual movie: |
---|
5 | |
---|
6 | program id='MV000008560000'> |
---|
7 | <title>Duel</title> |
---|
8 | <description>The unseen driver of a tailgating semi tries to run a traveling salesman (Dennis Weaver) off the road.</description> |
---|
9 | <mpaaRating>PG</mpaaRating> |
---|
10 | <starRating>***+</starRating> |
---|
11 | <runTime>PT01H35M</runTime> |
---|
12 | <year>1971</year> |
---|
13 | <advisories> |
---|
14 | <advisory>Violence</advisory> |
---|
15 | </advisories> |
---|
16 | </program> |
---|
17 | |
---|
18 | <schedule program='MV000008560000' station='12852' time='2009-06-06T08:30:00Z' duration='PT01H30M'/> |
---|
19 | |
---|
20 | Here are some tcsh aliases for noticing such things, given that the |
---|
21 | patch is installed and the relevant data is in the DB. You'll have |
---|
22 | to supply your own settings for dbhost, dbuser, and dbpass, of course: |
---|
23 | |
---|
24 | setenv dbargs "-h $dbhost -u${dbuser} -p${dbpass} mythconverg" |
---|
25 | |
---|
26 | alias inmysql 'mysql -s -B $dbargs \!*' |
---|
27 | alias domysql 'inmysql --exec \!*' |
---|
28 | |
---|
29 | setenv sd_table "program, record" |
---|
30 | setenv sd_diff "(UNIX_TIMESTAMP(program.endtime) - UNIX_TIMESTAMP(program.starttime))" |
---|
31 | setenv sd_min "(program.sd_runtime * 60)" |
---|
32 | setenv sd_match "program.title = record.title AND program.chanid = record.chanid AND program.sd_runtime > 0 AND $sd_diff < $sd_min" |
---|
33 | setenv sd_order "title, starttime" |
---|
34 | setenv sd_over "FLOOR(($sd_min - $sd_diff) / 60) AS overflow" |
---|
35 | setenv sd_rest "program.sd_runtime, program.title, program.chanid, program.starttime, program.endtime" |
---|
36 | setenv sd_show "$sd_over, $sd_rest" |
---|
37 | |
---|
38 | alias overflows 'domysql "SELECT $sd_show FROM $sd_table WHERE $sd_match ORDER BY $sd_order;"' |
---|
39 | |
---|
40 | ...and here's the output: |
---|
41 | |
---|
42 | > overflows |
---|
43 | 15 75 Dr. Jack 3213 2009-08-05 09:30:00 2009-08-05 10:30:00 |
---|
44 | 10 105 Drama/Mex 3201 2009-08-11 23:00:00 2009-08-12 00:35:00 |
---|
45 | 11 86 For Heaven's Sake 3213 2009-08-05 17:15:00 2009-08-05 18:30:00 |
---|
46 | 2 77 Why Worry? 3213 2009-08-05 12:00:00 2009-08-05 13:15:00 |
---|