def remove_between(dao_sess, start, end):
logger.info('Removing queue cache between %s - %s', start, end)
callids = stat_call_on_queue_dao.find_all_callid_between_date(
dao_sess, start, end)
if callids:
stat_call_on_queue_dao.remove_callids(dao_sess, callids)
stat_queue_periodic_dao.remove_after(dao_sess, start)
def test_remove_after(self):
queue_name, queue_id = self._insert_queue_to_stat_queue()
stats = {queue_id: {'full': 4, 'total': 10}}
with flush_session(self.session):
stat_queue_periodic_dao.insert_stats(self.session, stats,
dt(2012, 1, 1, tzinfo=UTC))
stat_queue_periodic_dao.insert_stats(self.session, stats,
dt(2012, 1, 2, tzinfo=UTC))
stat_queue_periodic_dao.insert_stats(self.session, stats,
dt(2012, 1, 3, tzinfo=UTC))
stat_queue_periodic_dao.remove_after(self.session,
dt(2012, 1, 2, tzinfo=UTC))
res = self.session.query(StatQueuePeriodic.time)
self.assertEqual(res.count(), 1)
self.assertEqual(res[0].time, dt(2012, 1, 1, tzinfo=UTC))
def test_remove_after(self):
queue_name, queue_id = self._insert_queue_to_stat_queue()
stats = {queue_id: {'full': 4, 'total': 10}}
self.session.begin()
stat_queue_periodic_dao.insert_stats(self.session, stats,
datetime.datetime(2012, 1, 1))
stat_queue_periodic_dao.insert_stats(self.session, stats,
datetime.datetime(2012, 1, 2))
stat_queue_periodic_dao.insert_stats(self.session, stats,
datetime.datetime(2012, 1, 3))
self.session.commit()
stat_queue_periodic_dao.remove_after(self.session,
datetime.datetime(2012, 1, 2))
res = self.session.query(StatQueuePeriodic.time)
self.assertEqual(res.count(), 1)
self.assertEqual(res[0].time, datetime.datetime(2012, 1, 1))
def test_remove_after(self):
queue_name, queue_id = self._insert_queue_to_stat_queue()
stats = {
queue_id: {
'full': 4,
'total': 10
}
}
with flush_session(self.session):
stat_queue_periodic_dao.insert_stats(self.session, stats, datetime.datetime(2012, 1, 1))
stat_queue_periodic_dao.insert_stats(self.session, stats, datetime.datetime(2012, 1, 2))
stat_queue_periodic_dao.insert_stats(self.session, stats, datetime.datetime(2012, 1, 3))
stat_queue_periodic_dao.remove_after(self.session, datetime.datetime(2012, 1, 2))
res = self.session.query(StatQueuePeriodic.time)
self.assertEqual(res.count(), 1)
self.assertEqual(res[0].time, datetime.datetime(2012, 1, 1))
def remove_between(dao_sess, start, end):
logger.info('Removing queue cache between %s - %s', start, end)
callids = stat_call_on_queue_dao.find_all_callid_between_date(dao_sess, start, end)
if callids:
stat_call_on_queue_dao.remove_callids(dao_sess, callids)
stat_queue_periodic_dao.remove_after(dao_sess, start)