def test_expired(self):
self.test_email_queue()
frappe.db.sql("update `tabEmail Queue` set creation=DATE_SUB(curdate(), interval 8 day)")
from frappe.email.queue import clear_outbox
clear_outbox()
email_queue = frappe.db.sql("""select * from `tabEmail Queue` where status='Expired'""", as_dict=1)
self.assertEquals(len(email_queue), 2)
self.assertTrue('*****@*****.**' in [d['recipient'] for d in email_queue])
self.assertTrue('*****@*****.**' in [d['recipient'] for d in email_queue])
def test_expired(self):
self.test_email_queue()
frappe.db.sql("update `tabEmail Queue` set modified=DATE_SUB(curdate(), interval 8 day)")
from frappe.email.queue import clear_outbox
clear_outbox()
email_queue = frappe.db.sql("""select name from `tabEmail Queue` where status='Expired'""", as_dict=1)
self.assertEquals(len(email_queue), 1)
queue_recipients = [r.recipient for r in frappe.db.sql("""select recipient from `tabEmail Queue Recipient`
where parent = %s""",email_queue[0].name, as_dict=1)]
self.assertTrue('*****@*****.**' in queue_recipients)
self.assertTrue('*****@*****.**' in queue_recipients)
self.assertEquals(len(queue_recipients), 2)
def test_expired(self):
self.test_email_queue()
frappe.db.sql("UPDATE `tabEmail Queue` SET `modified`=(NOW() - INTERVAL '8' day)")
from frappe.email.queue import clear_outbox
clear_outbox()
email_queue = frappe.db.sql("""select name from `tabEmail Queue` where status='Expired'""", as_dict=1)
self.assertEqual(len(email_queue), 1)
queue_recipients = [r.recipient for r in frappe.db.sql("""select recipient from `tabEmail Queue Recipient`
where parent = %s""",email_queue[0].name, as_dict=1)]
self.assertTrue('*****@*****.**' in queue_recipients)
self.assertTrue('*****@*****.**' in queue_recipients)
self.assertEqual(len(queue_recipients), 2)
def test_expired(self):
self.test_email_queue()
frappe.db.sql("update `tabEmail Queue` set modified=DATE_SUB(curdate(), interval 8 day)")
from frappe.email.queue import clear_outbox
clear_outbox()
email_queue = frappe.db.sql("""select name from `tabEmail Queue` where status='Expired'""", as_dict=1)
self.assertEqual(len(email_queue), 1)
queue_recipients = [r.recipient for r in frappe.db.sql("""select recipient from `tabEmail Queue Recipient`
where parent = %s""",email_queue[0].name, as_dict=1)]
self.assertTrue('*****@*****.**' in queue_recipients)
self.assertTrue('*****@*****.**' in queue_recipients)
self.assertEqual(len(queue_recipients), 2)
def test_expired(self):
self.test_email_queue()
frappe.db.sql(
"update `tabEmail Queue` set creation=DATE_SUB(curdate(), interval 8 day)"
)
from frappe.email.queue import clear_outbox
clear_outbox()
email_queue = frappe.db.sql(
"""select * from `tabEmail Queue` where status='Expired'""",
as_dict=1)
self.assertEquals(len(email_queue), 2)
self.assertTrue(
'*****@*****.**' in [d['recipient'] for d in email_queue])
self.assertTrue(
'*****@*****.**' in [d['recipient'] for d in email_queue])
def clear_email_queue(self): from frappe.email.queue import clear_outbox clear_outbox(days=self.clear_email_queue_after)
