bool CEpg::Load(void)
{
bool bReturn(false);
CEpgDatabase *database = g_EpgContainer.GetDatabase();
if (!database || !database->IsOpen())
{
CLog::Log(LOGERROR, "EPG - %s - could not open the database", __FUNCTION__);
return bReturn;
}
CSingleLock lock(m_critSection);
int iEntriesLoaded = database->Get(*this);
if (iEntriesLoaded <= 0)
{
CLog::Log(LOGDEBUG, "EPG - %s - no database entries found for table '%s'.", __FUNCTION__, m_strName.c_str());
}
else
{
m_lastScanTime = GetLastScanTime();
#if EPG_DEBUGGING
CLog::Log(LOGDEBUG, "EPG - %s - %d entries loaded for table '%s'.", __FUNCTION__, (int) m_tags.size(), m_strName.c_str());
#endif
bReturn = true;
}
m_bLoaded = true;
return bReturn;
}
CDateTime CEpg::GetLastScanTime(void)
{
CDateTime lastScanTime;
{
CSingleLock lock(m_critSection);
if (!m_lastScanTime.IsValid())
{
if (!CSettings::GetInstance().GetBool(CSettings::SETTING_EPG_IGNOREDBFORCLIENT))
{
CEpgDatabase *database = g_EpgContainer.GetDatabase();
CDateTime dtReturn; dtReturn.SetValid(false);
if (database && database->IsOpen())
database->GetLastEpgScanTime(m_iEpgID, &m_lastScanTime);
}
if (!m_lastScanTime.IsValid())
{
m_lastScanTime.SetDateTime(1970, 1, 1, 0, 0, 0);
assert(m_lastScanTime.IsValid());
}
}
lastScanTime = m_lastScanTime;
}
return m_lastScanTime;
}
CDateTime CEpg::GetLastScanTime(void)
{
CDateTime lastScanTime;
{
CSingleLock lock(m_critSection);
if (!m_lastScanTime.IsValid())
{
if (!CSettings::Get().GetBool("epg.ignoredbforclient"))
{
CEpgDatabase *database = g_EpgContainer.GetDatabase();
CDateTime dtReturn; dtReturn.SetValid(false);
if (database && database->IsOpen())
database->GetLastEpgScanTime(m_iEpgID, &m_lastScanTime);
}
if (!m_lastScanTime.IsValid())
{
m_lastScanTime.SetDateTime(0, 0, 0, 0, 0, 0);
m_lastScanTime.SetValid(true);
}
}
lastScanTime = m_lastScanTime;
}
return m_lastScanTime;
}
bool CEpgInfoTag::Persist(bool bSingleUpdate /* = true */)
{
bool bReturn = false;
#if EPG_DEBUGGING
CLog::Log(LOGDEBUG, "Epg - %s - Infotag '%s' %s, persisting...", __FUNCTION__, m_strTitle.c_str(), m_iBroadcastId > 0 ? "has changes" : "is new");
#endif
CEpgDatabase *database = g_EpgContainer.GetDatabase();
if (!database || (bSingleUpdate && !database->IsOpen()))
{
CLog::Log(LOGERROR, "%s - could not open the database", __FUNCTION__);
return bReturn;
}
int iId = database->Persist(*this, bSingleUpdate);
if (iId >= 0)
{
bReturn = true;
if (iId > 0)
m_iBroadcastId = iId;
}
return bReturn;
}
bool CEpg::UpdateEntries(const CEpg &epg, bool bStoreInDb /* = true */)
{
bool bReturn(false);
CEpgDatabase *database = g_EpgContainer.GetDatabase();
if (epg.m_tags.size() > 0)
{
if (bStoreInDb)
{
if (!database || !database->IsOpen())
{
CLog::Log(LOGERROR, "%s - could not open the database", __FUNCTION__);
return bReturn;
}
database->BeginTransaction();
}
{
CSingleLock lock(m_critSection);
CLog::Log(LOGDEBUG, "%s - %zu entries in memory before merging", __FUNCTION__, m_tags.size());
/* copy over tags */
for (map<CDateTime, CEpgInfoTagPtr>::const_iterator it = epg.m_tags.begin(); it != epg.m_tags.end(); it++)
UpdateEntry(*it->second, bStoreInDb, false);
CLog::Log(LOGDEBUG, "%s - %zu entries in memory after merging and before fixing", __FUNCTION__, m_tags.size());
FixOverlappingEvents(bStoreInDb);
CLog::Log(LOGDEBUG, "%s - %zu entries in memory after fixing", __FUNCTION__, m_tags.size());
/* update the last scan time of this table */
m_lastScanTime = CDateTime::GetCurrentDateTime().GetAsUTCDateTime();
SetChanged();
}
/* persist changes */
if (bStoreInDb)
{
bReturn = database->CommitTransaction();
if (bReturn)
Persist(true);
}
else
bReturn = true;
}
else
{
if (bStoreInDb)
bReturn = Persist(true);
else
bReturn = true;
}
NotifyObservers(ObservableMessageEpg);
return bReturn;
}
bool CEpg::Persist(bool bUpdateLastScanTime /* = false */)
{
if (g_guiSettings.GetBool("epg.ignoredbforclient"))
return true;
CEpgDatabase *database = g_EpgContainer.GetDatabase();
if (!database || !database->IsOpen())
{
CLog::Log(LOGERROR, "%s - could not open the database", __FUNCTION__);
return false;
}
CEpg epgCopy;
{
CSingleLock lock(m_critSection);
epgCopy = *this;
m_bChanged = false;
m_bTagsChanged = false;
}
database->BeginTransaction();
if (epgCopy.m_iEpgID <= 0 || epgCopy.m_bChanged)
{
int iId = database->Persist(epgCopy);
if (iId > 0)
{
epgCopy.m_iEpgID = iId;
epgCopy.m_bChanged = false;
if (m_iEpgID != epgCopy.m_iEpgID)
{
CSingleLock lock(m_critSection);
m_iEpgID = epgCopy.m_iEpgID;
}
}
}
bool bReturn(true);
if (bUpdateLastScanTime)
bReturn = database->PersistLastEpgScanTime(epgCopy.m_iEpgID);
database->CommitTransaction();
return bReturn;
}
bool CEpg::Persist(void)
{
if (CSettings::GetInstance().GetBool(CSettings::SETTING_EPG_IGNOREDBFORCLIENT) || !NeedsSave())
return true;
#if EPG_DEBUGGING
CLog::Log(LOGDEBUG, "persist table '%s' (#%d) changed=%d deleted=%d", Name().c_str(), m_iEpgID, m_changedTags.size(), m_deletedTags.size());
#endif
CEpgDatabase *database = g_EpgContainer.GetDatabase();
if (!database || !database->IsOpen())
{
CLog::Log(LOGERROR, "EPG - %s - could not open the database", __FUNCTION__);
return false;
}
{
CSingleLock lock(m_critSection);
if (m_iEpgID <= 0 || m_bChanged)
{
int iId = database->Persist(*this, m_iEpgID > 0);
if (iId > 0)
m_iEpgID = iId;
}
for (std::map<int, CEpgInfoTagPtr>::iterator it = m_deletedTags.begin(); it != m_deletedTags.end(); ++it)
database->Delete(*it->second);
for (std::map<int, CEpgInfoTagPtr>::iterator it = m_changedTags.begin(); it != m_changedTags.end(); ++it)
it->second->Persist(false);
if (m_bUpdateLastScanTime)
database->PersistLastEpgScanTime(m_iEpgID, true);
m_deletedTags.clear();
m_changedTags.clear();
m_bChanged = false;
m_bTagsChanged = false;
m_bUpdateLastScanTime = false;
}
return database->CommitInsertQueries();
}
bool CEpg::PersistTags(void) const
{
bool bReturn = false;
CEpgDatabase *database = g_EpgContainer.GetDatabase();
if (!database || !database->IsOpen())
{
CLog::Log(LOGERROR, "EPG - %s - could not load the database", __FUNCTION__);
return bReturn;
}
CDateTime first = GetFirstDate();
CDateTime last = GetLastDate();
time_t iStart(0), iEnd(0);
if (first.IsValid())
first.GetAsTime(iStart);
if (last.IsValid())
last.GetAsTime(iEnd);
database->Delete(*this, iStart, iEnd);
if (m_tags.size() > 0)
{
for (map<CDateTime, CEpgInfoTag *>::const_iterator it = m_tags.begin(); it != m_tags.end(); it++)
{
if (!it->second->Persist())
{
CLog::Log(LOGERROR, "failed to persist epg tag %d", it->second->UniqueBroadcastID());
bReturn = false;
}
}
}
else
{
/* Return true if we have no tags, so that no error is logged */
bReturn = true;
}
return bReturn;
}