def setup_and_prepare_test(self, hour=None):
frappe.db.sql('delete from `tabDaily Work Summary`')
frappe.db.sql('delete from `tabEmail Queue`')
frappe.db.sql('delete from `tabEmail Queue Recipient`')
frappe.db.sql('delete from `tabCommunication`')
frappe.db.sql('delete from `tabDaily Work Summary Group`')
self.users = frappe.get_all('User',
fields=['email'],
filters=dict(email=('!=',
'*****@*****.**')))
self.setup_groups(hour)
from erpnext.hr.doctype.daily_work_summary_group.daily_work_summary_group \
import trigger_emails
trigger_emails()
# check if emails are created
self.emails = frappe.db.sql(
"""select r.recipient, q.message, q.message_id \
from `tabEmail Queue` as q, `tabEmail Queue Recipient` as r \
where q.name = r.parent""",
as_dict=1)
frappe.db.commit()
def setup_and_prepare_test(self, hour=None):
frappe.db.sql('delete from `tabDaily Work Summary`')
frappe.db.sql('delete from `tabEmail Queue`')
frappe.db.sql('delete from `tabEmail Queue Recipient`')
frappe.db.sql('delete from `tabCommunication`')
frappe.db.sql('delete from `tabDaily Work Summary Group`')
self.users = frappe.get_all('User',
fields=['email'],
filters=dict(email=('!=', '*****@*****.**')))
self.setup_groups(hour)
from erpnext.hr.doctype.daily_work_summary_group.daily_work_summary_group \
import trigger_emails
trigger_emails()
# check if emails are created
self.emails = frappe.db.sql("""select r.recipient, q.message, q.message_id \
from `tabEmail Queue` as q, `tabEmail Queue Recipient` as r \
where q.name = r.parent""", as_dict=1)
frappe.db.commit()