void DBMaintenance::Do1DayMaintenance()
{
DateTime yesterday;
DateTime tendaysago;
yesterday.Add(0,0,0,-1);
tendaysago.Add(0,0,0,-10);
m_db->Execute("BEGIN;");
SQLite3DB::Statement st=m_db->Prepare("DELETE FROM tblIdentity WHERE (DateAdded<? AND LastSeen IS NULL) OR LastSeen<? AND Ignored=0;");
st.Bind(0,tendaysago.Format("%Y-%m-%d"));
st.Bind(1,tendaysago.Format("%Y-%m-%d"));
st.Step();
st=m_db->Prepare("DELETE FROM tblAnnounceIndex WHERE Date<?;");
st.Bind(0,yesterday.Format("%Y-%m-%d"));
st.Step();
st=m_db->Prepare("DELETE FROM tblIdentityEdition WHERE Date<?;");
st.Bind(0,yesterday.Format("%Y-%m-%d"));
st.Step();
st=m_db->Prepare("DELETE FROM tblInsertedMessageIndex WHERE Date<?;");
st.Bind(0,yesterday.Format("%Y-%m-%d"));
st.Step();
st=m_db->Prepare("DELETE FROM tblRetrievedMessageIndex WHERE Date<?;");
st.Bind(0,yesterday.Format("%Y-%m-%d"));
st.Step();
m_db->Execute("COMMIT;");
m_log->Error("DBMaintenance::Do1DayMaintenance");
}
void DBMaintenance::Process()
{
DateTime now;
DateTime sixhoursago;
DateTime onedayago;
sixhoursago.Add(0,0,-6);
onedayago.Add(0,0,0,-1);
if(m_last6hourmaintenance<sixhoursago)
{
Do6HoursMaintenance();
m_last6hourmaintenance.SetNowUTC();
}
if(m_last1daymaintenance<onedayago)
{
Do1DayMaintenance();
m_last1daymaintenance.SetNowUTC();
}
}
