rendered paste bodyIndex: libs/libmythtv/channelutil.cpp
===================================================================
--- libs/libmythtv/channelutil.cpp (revision 9481)
+++ libs/libmythtv/channelutil.cpp (working copy)
@@ -20,51 +20,68 @@
{
MSqlQuery query(MSqlQuery::InitCon());
// If transport not present add it, and move on to the next
- query.prepare(
- "INSERT INTO dtv_multiplex "
- " (transportid, networkid, frequency, symbolrate, "
- " fec, polarity, modulation, constellation, bandwidth, "
- " hierarchy, hp_code_rate, lp_code_rate, guard_interval, "
- " transmission_mode, inversion, sourceid, sistandard) "
- "VALUES "
- " (:TRANSPORTID, :NETWORKID, :FREQUENCY, :SYMBOLRATE, "
- " :FEC, :POLARITY, :MODULATION, :CONSTELLATION, :BANDWIDTH, "
- " :HIERARCHY, :HP_CODE_RATE, :LP_CODE_RATE, :GUARD_INTERVAL, "
- " :TRANS_MODE, :INVERSION, :SOURCEID, :SISTANDARD);");
+ query.prepare("SELECT * FROM dtv_multiplex WHERE sourceid=:SOURCEID AND transportid=:TRANSPORTID AND networkid=:NETWORKID");
query.bindValue(":SOURCEID", db_source_id);
+ if (network_id > 0)
+ query.bindValue(":NETWORKID", network_id);
if (transport_id > 0)
query.bindValue(":TRANSPORTID",transport_id);
- if (network_id > 0)
- query.bindValue(":NETWORKID", network_id);
- query.bindValue(":FREQUENCY", frequency);
- if (modulation != QString::null)
- query.bindValue(":MODULATION", modulation);
- query.bindValue(":SISTANDARD", sistandard);
- if (symbol_rate >= 0)
- query.bindValue(":SYMBOLRATE", symbol_rate);
- if (polarity >= 0)
- query.bindValue(":POLARITY", QString("%1").arg(polarity));
- if (inner_FEC != QString::null)
- query.bindValue(":FEC", inner_FEC);
-
- if (set_odfm_info)
+ if (!query.exec() || !query.isActive())
{
- query.bindValue(":INVERSION", QString("%1").arg(inversion));
- query.bindValue(":BANDWIDTH", QString("%1").arg(bandwidth));
- query.bindValue(":HP_CODE_RATE", hp_code_rate);
- query.bindValue(":LP_CODE_RATE", lp_code_rate);
- query.bindValue(":CONSTELLATION", constellation);
- query.bindValue(":TRANS_MODE", QString("%1").arg(trans_mode));
- query.bindValue(":GUARD_INTERVAL", guard_interval);
- query.bindValue(":HIERARCHY", QString("%1").arg(hierarchy));
+ MythContext::DBError("Selecting duplicate transport from Database.", query);
+ return false;
}
- if (!query.exec() || !query.isActive())
+ if (query.size() == 0)
{
- MythContext::DBError("Adding transport to Database.", query);
- return false;
+ query.prepare(
+ "INSERT INTO dtv_multiplex "
+ " (transportid, networkid, frequency, symbolrate, "
+ " fec, polarity, modulation, constellation, bandwidth, "
+ " hierarchy, hp_code_rate, lp_code_rate, guard_interval, "
+ " transmission_mode, inversion, sourceid, sistandard) "
+ "VALUES "
+ " (:TRANSPORTID, :NETWORKID, :FREQUENCY, :SYMBOLRATE, "
+ " :FEC, :POLARITY, :MODULATION, :CONSTELLATION, :BANDWIDTH, "
+ " :HIERARCHY, :HP_CODE_RATE, :LP_CODE_RATE, :GUARD_INTERVAL, "
+ " :TRANS_MODE, :INVERSION, :SOURCEID, :SISTANDARD);");
+
+ query.bindValue(":SOURCEID", db_source_id);
+ if (transport_id > 0)
+ query.bindValue(":TRANSPORTID",transport_id);
+ if (network_id > 0)
+ query.bindValue(":NETWORKID", network_id);
+ query.bindValue(":FREQUENCY", frequency);
+ if (modulation != QString::null)
+ query.bindValue(":MODULATION", modulation);
+ query.bindValue(":SISTANDARD", sistandard);
+
+ if (symbol_rate >= 0)
+ query.bindValue(":SYMBOLRATE", symbol_rate);
+ if (polarity >= 0)
+ query.bindValue(":POLARITY", QString("%1").arg(polarity));
+ if (inner_FEC != QString::null)
+ query.bindValue(":FEC", inner_FEC);
+
+ if (set_odfm_info)
+ {
+ query.bindValue(":INVERSION", QString("%1").arg(inversion));
+ query.bindValue(":BANDWIDTH", QString("%1").arg(bandwidth));
+ query.bindValue(":HP_CODE_RATE", hp_code_rate);
+ query.bindValue(":LP_CODE_RATE", lp_code_rate);
+ query.bindValue(":CONSTELLATION", constellation);
+ query.bindValue(":TRANS_MODE", QString("%1").arg(trans_mode));
+ query.bindValue(":GUARD_INTERVAL", guard_interval);
+ query.bindValue(":HIERARCHY", QString("%1").arg(hierarchy));
+ }
+
+ if (!query.exec() || !query.isActive())
+ {
+ MythContext::DBError("Adding transport to Database.", query);
+ return false;
+ }
}
return true;
@@ -163,6 +180,9 @@
Alpha()
OtherFrequencyInUse()
*/
+
+ if (cd.OtherFrequencyInUse() == 1)
+ VERBOSE(VB_SIPARSER, "Alternative frequency available, not used at present");
}
else if (tag == DescriptorID::satellite_delivery_system)
{
@@ -206,29 +226,29 @@
if (mux >= 0)
muxes.push_back(mux);
}
- else if (tag == DescriptorID::frequency_list)
- {
- const FrequencyListDescriptor cd(desc);
- //uint ct = cd.CodingType(); //nd,sat,cable,terra
- for (uint i = 0; i<cd.FrequencyCount(); i++)
- {
- int mux = ChannelUtil::CreateMultiplex(
- sourceid, "dvb",
- cd.FrequencyHz(i), QString::null/*modulation*/,
- // DVB specific
- tsid, netid,
- false,
- -1, -1,
- -1, -1,
- -1,
- QString::null, QString::null,
- -1, QString::null,
- QString::null, QString::null);
-
- if (mux >= 0)
- muxes.push_back(mux);
- }
- }
+// else if (tag == DescriptorID::frequency_list)
+// {
+// const FrequencyListDescriptor cd(desc);
+// //uint ct = cd.CodingType(); //nd,sat,cable,terra
+// for (uint i = 0; i<cd.FrequencyCount(); i++)
+// {
+// int mux = ChannelUtil::CreateMultiplex(
+// sourceid, "dvb",
+// cd.FrequencyHz(i), QString::null/*modulation*/,
+// // DVB specific
+// tsid, netid,
+// false,
+// -1, -1,
+// -1, -1,
+// -1,
+// QString::null, QString::null,
+// -1, QString::null,
+// QString::null, QString::null);
+//
+// if (mux >= 0)
+// muxes.push_back(mux);
+// }
+// }
}
/** \fn ChannelUtil::CreateMultiplexes(int, const NetworkInformationTable*)