bool CPVRDatabase::Persist(CPVRChannel &channel, bool bQueueWrite /* = false */)
{
bool bReturn(false);
/* invalid channel */
if (channel.UniqueID() <= 0)
{
CLog::Log(LOGERROR, "PVR - %s - invalid channel uid: %d", __FUNCTION__, channel.UniqueID());
return bReturn;
}
CStdString strQuery;
if (channel.ChannelID() <= 0)
{
/* new channel */
strQuery = PrepareSQL("INSERT INTO channels ("
"iUniqueId, bIsRadio, bIsHidden, bIsUserSetIcon, bIsLocked, "
"sIconPath, sChannelName, bIsVirtual, bEPGEnabled, sEPGScraper, iLastWatched, iClientId, "
"iClientChannelNumber, sInputFormat, sStreamURL, iEncryptionSystem, idEpg) "
"VALUES (%i, %i, %i, %i, %i, '%s', '%s', %i, %i, '%s', %u, %i, %i, '%s', '%s', %i, %i)",
channel.UniqueID(), (channel.IsRadio() ? 1 :0), (channel.IsHidden() ? 1 : 0), (channel.IsUserSetIcon() ? 1 : 0), (channel.IsLocked() ? 1 : 0),
channel.IconPath().c_str(), channel.ChannelName().c_str(), (channel.IsVirtual() ? 1 : 0), (channel.EPGEnabled() ? 1 : 0), channel.EPGScraper().c_str(), channel.LastWatched(), channel.ClientID(),
channel.ClientChannelNumber(), channel.InputFormat().c_str(), channel.StreamURL().c_str(), channel.EncryptionSystem(),
channel.EpgID());
}
else
{
/* update channel */
strQuery = PrepareSQL("REPLACE INTO channels ("
"iUniqueId, bIsRadio, bIsHidden, bIsUserSetIcon, bIsLocked, "
"sIconPath, sChannelName, bIsVirtual, bEPGEnabled, sEPGScraper, iLastWatched, iClientId, "
"iClientChannelNumber, sInputFormat, sStreamURL, iEncryptionSystem, idChannel, idEpg) "
"VALUES (%i, %i, %i, %i, %i, '%s', '%s', %i, %i, '%s', %u, %i, %i, '%s', '%s', %i, %i, %i)",
channel.UniqueID(), (channel.IsRadio() ? 1 :0), (channel.IsHidden() ? 1 : 0), (channel.IsUserSetIcon() ? 1 : 0), (channel.IsLocked() ? 1 : 0),
channel.IconPath().c_str(), channel.ChannelName().c_str(), (channel.IsVirtual() ? 1 : 0), (channel.EPGEnabled() ? 1 : 0), channel.EPGScraper().c_str(), channel.LastWatched(), channel.ClientID(),
channel.ClientChannelNumber(), channel.InputFormat().c_str(), channel.StreamURL().c_str(), channel.EncryptionSystem(), channel.ChannelID(),
channel.EpgID());
}
if (bQueueWrite)
{
QueueInsertQuery(strQuery);
bReturn = true;
}
else if (ExecuteQuery(strQuery))
{
CSingleLock lock(channel.m_critSection);
if (channel.m_iChannelId <= 0)
channel.m_iChannelId = (int)m_pDS->lastinsertid();
bReturn = true;
}
return bReturn;
}
int CPVRDatabase::Persist(const CPVRChannel &channel, bool bQueueWrite /* = false */)
{
int iReturn = -1;
/* invalid channel */
if (channel.UniqueID() <= 0)
{
CLog::Log(LOGERROR, "PVRDB - %s - invalid channel uid: %d",
__FUNCTION__, channel.UniqueID());
return iReturn;
}
CStdString strQuery;
if (channel.ChannelID() <= 0)
{
/* new channel */
strQuery = FormatSQL("INSERT INTO channels ("
"iUniqueId, bIsRadio, bIsHidden, "
"sIconPath, sChannelName, bIsVirtual, bEPGEnabled, sEPGScraper, iLastWatched, iClientId, "
"iClientChannelNumber, sInputFormat, sStreamURL, iEncryptionSystem, idEpg) "
"VALUES (%i, %i, %i, '%s', '%s', %i, %i, '%s', %u, %i, %i, '%s', '%s', %i, %i);",
channel.UniqueID(), (channel.IsRadio() ? 1 :0), (channel.IsHidden() ? 1 : 0),
channel.IconPath().c_str(), channel.ChannelName().c_str(), (channel.IsVirtual() ? 1 : 0), (channel.EPGEnabled() ? 1 : 0), channel.EPGScraper().c_str(), channel.LastWatched(), channel.ClientID(),
channel.ClientChannelNumber(), channel.InputFormat().c_str(), channel.StreamURL().c_str(), channel.EncryptionSystem(),
channel.EpgID());
}
else
{
/* update channel */
strQuery = FormatSQL("REPLACE INTO channels ("
"iUniqueId, bIsRadio, bIsHidden, "
"sIconPath, sChannelName, bIsVirtual, bEPGEnabled, sEPGScraper, iLastWatched, iClientId, "
"iClientChannelNumber, sInputFormat, sStreamURL, iEncryptionSystem, idChannel, idEpg) "
"VALUES (%i, %i, %i, '%s', '%s', %i, %i, '%s', %u, %i, %i, '%s', '%s', %i, %i, %i);",
channel.UniqueID(), (channel.IsRadio() ? 1 :0), (channel.IsHidden() ? 1 : 0),
channel.IconPath().c_str(), channel.ChannelName().c_str(), (channel.IsVirtual() ? 1 : 0), (channel.EPGEnabled() ? 1 : 0), channel.EPGScraper().c_str(), channel.LastWatched(), channel.ClientID(),
channel.ClientChannelNumber(), channel.InputFormat().c_str(), channel.StreamURL().c_str(), channel.EncryptionSystem(), channel.ChannelID(),
channel.EpgID());
}
if (bQueueWrite)
{
QueueInsertQuery(strQuery);
iReturn = 0;
}
else if (ExecuteQuery(strQuery))
{
iReturn = (channel.ChannelID() <= 0) ? (int) m_pDS->lastinsertid() : channel.ChannelID();
}
return iReturn;
}
long CPVRDatabase::UpdateChannel(const CPVRChannel &channel, bool bQueueWrite /* = false */)
{
long iReturn = -1;
/* invalid channel */
if (channel.UniqueID() <= 0)
{
CLog::Log(LOGERROR, "PVRDB - %s - invalid channel uid: %d",
__FUNCTION__, channel.UniqueID());
return iReturn;
}
CStdString strQuery;
if (channel.ChannelID() <= 0)
{
/* new channel */
strQuery = FormatSQL("INSERT INTO Channels ("
"UniqueId, ChannelNumber, GroupId, IsRadio, IsHidden, "
"IconPath, ChannelName, IsVirtual, EPGEnabled, EPGScraper, ClientId, "
"ClientChannelNumber, InputFormat, StreamURL, EncryptionSystem) "
"VALUES (%i, %i, %i, %i, %i, '%s', '%s', %i, %i, '%s', %i, %i, '%s', '%s', %i)\n",
channel.UniqueID(), channel.ChannelNumber(), channel.GroupID(), (channel.IsRadio() ? 1 :0), (channel.IsHidden() ? 1 : 0),
channel.IconPath().c_str(), channel.ChannelName().c_str(), (channel.IsVirtual() ? 1 : 0), (channel.EPGEnabled() ? 1 : 0), channel.EPGScraper().c_str(), channel.ClientID(),
channel.ClientChannelNumber(), channel.InputFormat().c_str(), channel.StreamURL().c_str(), channel.EncryptionSystem());
}
else
{
/* update channel */
strQuery = FormatSQL("REPLACE INTO Channels ("
"UniqueId, ChannelNumber, GroupId, IsRadio, IsHidden, "
"IconPath, ChannelName, IsVirtual, EPGEnabled, EPGScraper, ClientId, "
"ClientChannelNumber, InputFormat, StreamURL, EncryptionSystem, ChannelId) "
"VALUES (%i, %i, %i, %i, %i, '%s', '%s', %i, %i, '%s', %i, %i, '%s', '%s', %i, %i)\n",
channel.UniqueID(), channel.ChannelNumber(), channel.GroupID(), (channel.IsRadio() ? 1 :0), (channel.IsHidden() ? 1 : 0),
channel.IconPath().c_str(), channel.ChannelName().c_str(), (channel.IsVirtual() ? 1 : 0), (channel.EPGEnabled() ? 1 : 0), channel.EPGScraper().c_str(), channel.ClientID(),
channel.ClientChannelNumber(), channel.InputFormat().c_str(), channel.StreamURL().c_str(), channel.EncryptionSystem(), channel.ChannelID());
}
if (bQueueWrite)
{
QueueInsertQuery(strQuery);
iReturn = 0;
}
else if (ExecuteQuery(strQuery))
{
iReturn = (channel.ChannelID() <= 0) ? (long) m_pDS->lastinsertid() : channel.ChannelID();
}
return iReturn;
}
bool CPVRClients::OpenLiveStream(const CPVRChannel &tag)
{
bool bReturn = false;
CSingleLock lock(m_critSection);
if (m_currentChannel)
delete m_currentChannel;
if (m_currentRecording)
delete m_currentRecording;
ResetQualityData();
/* try to open the stream on the client */
if (tag.StreamURL().IsEmpty() &&
m_clientsProps[tag.ClientID()].HandleInputStream &&
m_clientMap[tag.ClientID()]->OpenLiveStream(tag))
{
m_currentChannel = &tag;
if (tag.ClientID() == XBMC_VIRTUAL_CLIENTID)
m_strPlayingClientName = g_localizeStrings.Get(19209);
else if (!tag.IsVirtual())
m_strPlayingClientName = GetClientName(tag.ClientID());
else
m_strPlayingClientName = g_localizeStrings.Get(13205);
m_scanStart = CTimeUtils::GetTimeMS(); /* Reset the stream scan timer */
bReturn = true;
}
return bReturn;
}
bool CPVRClients::OpenStream(const CPVRChannel &tag, bool bIsSwitchingChannel)
{
bool bReturn(false);
CloseStream();
/* try to open the stream on the client */
PVR_CLIENT client;
if (GetConnectedClient(tag.ClientID(), client) &&
client->OpenStream(tag, bIsSwitchingChannel))
{
CSingleLock lock(m_critSection);
m_playingClientId = tag.ClientID();
m_bIsPlayingLiveTV = true;
if (tag.ClientID() == PVR_VIRTUAL_CLIENT_ID)
m_strPlayingClientName = g_localizeStrings.Get(19209);
else if (!tag.IsVirtual() && client.get())
m_strPlayingClientName = client->GetFriendlyName();
else
m_strPlayingClientName = g_localizeStrings.Get(13205);
bReturn = true;
}
return bReturn;
}
bool CPVRClients::OpenLiveStream(const CPVRChannel &tag)
{
bool bReturn(false);
CSingleLock lock(m_critSection);
m_bIsPlayingLiveTV = false;
m_bIsPlayingRecording = false;
ResetQualityData(m_qualityInfo);
/* try to open the stream on the client */
boost::shared_ptr<CPVRClient> client;
if (tag.StreamURL().IsEmpty() == false ||
(GetConnectedClient(tag.ClientID(), client) &&
client->GetAddonCapabilities().bHandlesInputStream &&
client->OpenLiveStream(tag)))
{
m_currentChannel = tag;
m_bIsPlayingLiveTV = true;
if (tag.ClientID() == XBMC_VIRTUAL_CLIENTID)
m_strPlayingClientName = g_localizeStrings.Get(19209);
else if (!tag.IsVirtual())
GetClientName(tag.ClientID(), m_strPlayingClientName);
else
m_strPlayingClientName = g_localizeStrings.Get(13205);
bReturn = true;
}
return bReturn;
}
void CPVRChannelGroup::RemoveInvalidChannels(void)
{
for (unsigned int ptr = 0; ptr < size(); ptr--)
{
CPVRChannel *channel = at(ptr).channel;
if (channel->IsVirtual())
continue;
if (at(ptr).channel->ClientChannelNumber() <= 0)
{
CLog::Log(LOGERROR, "PVRChannelGroup - %s - removing invalid channel '%s' from client '%i': no valid client channel number",
__FUNCTION__, channel->ChannelName().c_str(), channel->ClientID());
erase(begin() + ptr);
ptr--;
m_bChanged = true;
continue;
}
if (channel->UniqueID() <= 0)
{
CLog::Log(LOGERROR, "PVRChannelGroup - %s - removing invalid channel '%s' from client '%i': no valid unique ID",
__FUNCTION__, channel->ChannelName().c_str(), channel->ClientID());
erase(begin() + ptr);
ptr--;
m_bChanged = true;
continue;
}
}
}
void CPVRClients::UpdateCharInfoSignalStatus(void)
{
CPVRChannel currentChannel;
boost::shared_ptr<CPVRClient> client;
PVR_SIGNAL_STATUS qualityInfo;
ResetQualityData(qualityInfo);
if (GetPlayingChannel(currentChannel) &&
g_guiSettings.GetBool("pvrplayback.signalquality") &&
!currentChannel.IsVirtual() &&
GetConnectedClient(currentChannel.ClientID(), client))
{
client->SignalQuality(qualityInfo);
}
CSingleLock lock(m_critSection);
m_qualityInfo = qualityInfo;
}
void CPVRChannelGroup::RemoveInvalidChannels(void)
{
bool bDelete(false);
CSingleLock lock(m_critSection);
for (unsigned int ptr = 0; ptr < m_members.size(); ptr--)
{
bDelete = false;
CPVRChannel *channel = m_members.at(ptr).channel;
if (channel->IsVirtual())
continue;
if (m_members.at(ptr).channel->ClientChannelNumber() <= 0)
{
CLog::Log(LOGERROR, "PVRChannelGroup - %s - removing invalid channel '%s' from client '%i': no valid client channel number",
__FUNCTION__, channel->ChannelName().c_str(), channel->ClientID());
bDelete = true;
}
if (!bDelete && channel->UniqueID() <= 0)
{
CLog::Log(LOGERROR, "PVRChannelGroup - %s - removing invalid channel '%s' from client '%i': no valid unique ID",
__FUNCTION__, channel->ChannelName().c_str(), channel->ClientID());
bDelete = true;
}
/* remove this channel from all non-system groups if this is the internal group */
if (bDelete)
{
if (IsInternalGroup())
{
g_PVRChannelGroups->Get(m_bRadio)->RemoveFromAllGroups(channel);
channel->Delete();
}
else
{
m_members.erase(m_members.begin() + ptr);
}
m_bChanged = true;
}
}
}
bool CPVRClients::OpenLiveStream(const CPVRChannel &tag)
{
bool bReturn(false);
CSingleLock lock(m_critSection);
if (m_currentChannel)
{
delete m_currentChannel;
m_currentChannel = NULL;
}
if (m_currentRecording)
{
delete m_currentRecording;
m_currentRecording = NULL;
}
ResetQualityData();
/* try to open the stream on the client */
if ((tag.StreamURL().IsEmpty() == false ||
m_clientsProps[tag.ClientID()].bHandlesInputStream) &&
m_clientMap[tag.ClientID()]->OpenLiveStream(tag))
{
m_currentChannel = &tag;
if (tag.ClientID() == XBMC_VIRTUAL_CLIENTID)
m_strPlayingClientName = g_localizeStrings.Get(19209);
else if (!tag.IsVirtual())
m_strPlayingClientName = GetClientName(tag.ClientID());
else
m_strPlayingClientName = g_localizeStrings.Get(13205);
bReturn = true;
}
return bReturn;
}
bool CPVRChannelGroupInternal::UpdateGroupEntries(CPVRChannelGroup *channels)
{
CPVRDatabase *database = CPVRManager::Get()->GetTVDatabase();
if(!database && !database->Open())
return false;
int iSize = size();
for (int ptr = 0; ptr < iSize; ptr++)
{
CPVRChannel *channel = at(ptr).channel;
/* ignore virtual channels */
if (channel->IsVirtual())
continue;
/* check if this channel is still present */
const CPVRChannel *existingChannel = channels->GetByUniqueID(channel->UniqueID());
if (existingChannel)
{
/* if it's present, update the current tag */
if (channel->UpdateFromClient(*existingChannel))
{
channel->Persist(true);
CLog::Log(LOGINFO,"PVRChannelGroupInternal - %s - updated %s channel '%s'",
__FUNCTION__, m_bRadio ? "radio" : "TV", channel->ChannelName().c_str());
}
/* remove this tag from the temporary channel list */
channels->RemoveByUniqueID(channel->UniqueID());
}
else
{
/* channel is no longer present */
CLog::Log(LOGINFO,"PVRChannelGroupInternal - %s - removing %s channel '%s'",
__FUNCTION__, m_bRadio ? "radio" : "TV", channel->ChannelName().c_str());
channel->Delete();
erase(begin() + ptr);
ptr--;
iSize--;
}
}
/* the temporary channel list only contains new channels now */
for (unsigned int ptr = 0; ptr < channels->size(); ptr++)
{
CPVRChannel *channel = channels->at(ptr).channel;
channel->Persist(true);
PVRChannelGroupMember member = { channel, size() };
push_back(member);
CLog::Log(LOGINFO,"PVRChannelGroupInternal - %s - added %s channel '%s'",
__FUNCTION__, m_bRadio ? "radio" : "TV", channel->ChannelName().c_str());
}
/* post the queries generated by the update */
database->CommitInsertQueries();
database->Close();
Renumber();
return true;
}
bool CPVRChannels::Update(CPVRChannels *channels)
{
/* the database has already been opened */
CPVRDatabase *database = g_PVRManager.GetTVDatabase();
int iSize = size();
for (int ptr = 0; ptr < iSize; ptr++)
{
CPVRChannel *channel = at(ptr);
/* ignore virtual channels */
if (channel->IsVirtual())
continue;
/* check if this channel is still present */
CPVRChannel *existingChannel = channels->GetByUniqueID(channel->UniqueID());
if (existingChannel)
{
/* if it's present, update the current tag */
if (channel->UpdateFromClient(*existingChannel))
{
channel->Persist(true);
CLog::Log(LOGINFO,"%s - updated %s channel '%s'",
__FUNCTION__, m_bRadio ? "radio" : "TV", channel->ChannelName().c_str());
}
/* remove this tag from the temporary channel list */
channels->RemoveByUniqueID(channel->UniqueID());
}
else
{
/* channel is no longer present */
CLog::Log(LOGINFO,"%s - removing %s channel '%s'",
__FUNCTION__, m_bRadio ? "radio" : "TV", channel->ChannelName().c_str());
database->RemoveChannel(*channel);
erase(begin() + ptr);
ptr--;
iSize--;
}
}
/* the temporary channel list only contains new channels now */
for (unsigned int ptr = 0; ptr < channels->size(); ptr++)
{
CPVRChannel *channel = channels->at(ptr);
channel->Persist(true);
push_back(channel);
CLog::Log(LOGINFO,"%s - added %s channel '%s'",
__FUNCTION__, m_bRadio ? "radio" : "TV", channel->ChannelName().c_str());
}
/* post the queries generated by the update */
database->CommitInsertQueries();
/* recount hidden channels */
m_iHiddenChannels = 0;
for (unsigned int i = 0; i < size(); i++)
{
if (at(i)->IsHidden())
m_iHiddenChannels++;
}
m_bIsSorted = false;
return true;
}
