Changes between Initial Version and Version 3 of Ticket #12519


Ignore:
Timestamp:
Dec 9, 2015, 2:54:06 AM (9 years ago)
Author:
Karl Egly
Comment:

Resetting some attributes back to defaults.

The lineupid=0 comes from calling void DataDirectProcessor::UpdateStationViewTable?(QString lineupid). I don't see this being due to the merging of "cardinput" into "capturecard". This is Schedules Direct specific code. I don't see much one of the european developers can do here.

Also fixed the formatting while here.

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #12519

    • Property Priority changed from major to minor
    • Property Milestone changed from 0.28 to unknown
    • Property Severity changed from high to medium

  • Ticket #12519 – Description

    initial v3  
    22
    33So I downloaded the DD XML using tv_grab_na_dd, stripped out everything but the "station" and "lineup" elements.  I ran mythfilldatabase with full debug and found the following.  This happened after both "dd_station" and "dd_lineupmap" were populated:
    4 
     4{{{
    552015-10-05 14:44:26.115590 I  MSqlQuery::exec(DBManager1) SELECT sourceid FROM videosource WHERE lineupid = 'NJ67209:X' <<<< Took 0ms, Returned 1 row(s)
    662015-10-05 14:44:26.115624 I  DataDirect: sourceid 8 has lineup type: CableDigital
    … …  
    13132015-10-05 14:44:26.117184 I  MSqlQuery::exec(DataDirectCon) TRUNCATE TABLE dd_v_station;
    14142015-10-05 14:44:26.118541 I  MSqlQuery::exec(DataDirectCon) INSERT INTO dd_v_station      ( stationid,            callsign,         stationname,        affiliate,            fccchannelnumber, channel,            channelMinor) SELECT dd_station.stationid, callsign,         stationname,        affiliate,            fccchannelnumber, channel,            channelMinor FROM dd_station, dd_lineupmap WHERE ((dd_station.stationid  = dd_lineupmap.stationid) AND        (dd_lineupmap.lineupid = '0')) <<<< Took 1ms
    15 
     15}}}
    1616Why is "dd_lineupmap.lineupid='0'" a constraint?  You can see a few line earlier the lineupid is not '0'.  I suspect the issue is here...  I assume this has to do with the merging of "cardinput" into "capturecard".
    1717