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)