def test_custom_report(self):
reset_customization('User')
custom_report_name = save_report(
'Permitted Documents For User',
'Permitted Documents For User Custom',
json.dumps([{
'fieldname': 'email',
'fieldtype': 'Data',
'label': 'Email',
'insert_after_index': 0,
'link_field': 'name',
'doctype': 'User',
'options': 'Email',
'width': 100,
'id':'email',
'name': 'Email'
}]))
custom_report = frappe.get_doc('Report', custom_report_name)
columns, result = custom_report.run_query_report(
filters={
'user': '******',
'doctype': 'User'
}, user=frappe.session.user)
self.assertListEqual(['email'], [column.get('fieldname') for column in columns])
admin_dict = frappe.core.utils.find(result, lambda d: d['name'] == 'Administrator')
self.assertDictEqual({'name': 'Administrator', 'user_type': 'System User', 'email': '*****@*****.**'}, admin_dict)
def test_report_with_custom_column(self):
reset_customization("User")
response = run(
"Permitted Documents For User",
filters={
"user": "******",
"doctype": "User"
},
custom_columns=[{
"fieldname": "email",
"fieldtype": "Data",
"label": "Email",
"insert_after_index": 0,
"link_field": "name",
"doctype": "User",
"options": "Email",
"width": 100,
"id": "email",
"name": "Email",
}],
)
result = response.get("result")
columns = response.get("columns")
self.assertListEqual(["name", "email", "user_type"],
[column.get("fieldname") for column in columns])
admin_dict = frappe.core.utils.find(
result, lambda d: d["name"] == "Administrator")
self.assertDictEqual(
{
"name": "Administrator",
"user_type": "System User",
"email": "*****@*****.**"
}, admin_dict)
def test_report_with_custom_column(self):
reset_customization('User')
response = run('Permitted Documents For User',
filters={
'user': '******',
'doctype': 'User'
},
custom_columns=[{
'fieldname': 'email',
'fieldtype': 'Data',
'label': 'Email',
'insert_after_index': 0,
'link_field': 'name',
'doctype': 'User',
'options': 'Email',
'width': 100,
'id': 'email',
'name': 'Email'
}])
result = response.get('result')
columns = response.get('columns')
self.assertListEqual(['name', 'email', 'user_type'],
[column.get('fieldname') for column in columns])
admin_dict = frappe.core.utils.find(
result, lambda d: d['name'] == 'Administrator')
self.assertDictEqual(
{
'name': 'Administrator',
'user_type': 'System User',
'email': '*****@*****.**'
}, admin_dict)
def test_custom_report(self):
reset_customization("User")
custom_report_name = save_report(
"Permitted Documents For User",
"Permitted Documents For User Custom",
json.dumps([{
"fieldname": "email",
"fieldtype": "Data",
"label": "Email",
"insert_after_index": 0,
"link_field": "name",
"doctype": "User",
"options": "Email",
"width": 100,
"id": "email",
"name": "Email",
}]),
)
custom_report = frappe.get_doc("Report", custom_report_name)
columns, result = custom_report.run_query_report(
filters={
"user": "******",
"doctype": "User"
},
user=frappe.session.user)
self.assertListEqual(["email"],
[column.get("fieldname") for column in columns])
admin_dict = frappe.core.utils.find(
result, lambda d: d["name"] == "Administrator")
self.assertDictEqual(
{
"name": "Administrator",
"user_type": "System User",
"email": "*****@*****.**"
}, admin_dict)
def setUp(self):
reset_customization('Blog Post')
def setUp(self):
reset_customization("Blog Post")
