def test_delete_event_by_queue_between(self): self._insert_entry_queue_full( datetime(2012, 7, 1, 7, 1, 1, tzinfo=UTC), 'delete_between_1', 'q1') self._insert_entry_queue_full( datetime(2012, 7, 1, 8, 1, 1, tzinfo=UTC), 'delete_between_2', 'q1') self._insert_entry_queue_full( datetime(2012, 7, 1, 9, 1, 1, tzinfo=UTC), 'delete_between_3', 'q1') self._insert_entry_queue_full( datetime(2012, 7, 1, 8, 1, 0, tzinfo=UTC), 'delete_between_4', 'q2') queue_log_dao.delete_event_by_queue_between( 'FULL', 'q1', '2012-07-01 08:00:00.000000', '2012-07-01 08:59:59.999999') callids = [ r.callid for r in self.session.query(QueueLog.callid).filter( QueueLog.callid.like('delete_between_%')) ] expected = ['delete_between_1', 'delete_between_3', 'delete_between_4'] self.assertEqual(callids, expected)
def test_delete_event_by_queue_between(self): self._insert_entry_queue_full(datetime(2012, 07, 01, 7, 1, 1), 'delete_between_1', 'q1') self._insert_entry_queue_full(datetime(2012, 07, 01, 8, 1, 1), 'delete_between_2', 'q1') self._insert_entry_queue_full(datetime(2012, 07, 01, 9, 1, 1), 'delete_between_3', 'q1') self._insert_entry_queue_full(datetime(2012, 07, 01, 8, 1, 0), 'delete_between_4', 'q2') queue_log_dao.delete_event_by_queue_between( 'FULL', 'q1', '2012-07-01 08:00:00.000000', '2012-07-01 08:59:59.999999') callids = [r.callid for r in self.session.query(QueueLog.callid) .filter(QueueLog.callid.like('delete_between_%'))] expected = ['delete_between_1', 'delete_between_3', 'delete_between_4'] self.assertEquals(callids, expected)
def delete_event_by_queue_between(event, queuename, start, end): queue_log_dao.delete_event_by_queue_between(event, queuename, start, end)
def delete_event_by_queue_between(event, queuename, start, end): with session_scope(): queue_log_dao.delete_event_by_queue_between(event, queuename, start, end)