def test_updating_report_data_source(self):
"""
Test that changing the app or number column for a report results in an update to the data source next time
the report is saved.
"""
# Make report
builder_form = ConfigureTableReportForm(
"Test Report",
self.app._id,
"case",
"some_case_type",
existing_report=None,
data={
'group_by': ['closed'],
'chart':
'bar',
'user_filters':
'[]',
'default_filters':
'[]',
'columns':
'[{"property": "closed", "display_text": "closed", "calculation": "Count per Choice"}]',
})
self.assertTrue(builder_form.is_valid())
report = builder_form.create_report()
self.assertEqual(report.config.configured_indicators[0]['datatype'],
"string")
# Make an edit to the first report builder report
builder_form = ConfigureTableReportForm(
"Test Report",
self.app._id,
"case",
"some_case_type",
existing_report=report,
data={
'group_by': ['user_id'],
'chart':
'bar',
'user_filters':
'[]',
'default_filters':
'[]',
# Note that a "Sum" calculation on the closed case property isn't very sensical, but doing it so
# that I can have a numeric calculation without having to create real case properties for this case
# type.
'columns':
'[{"property": "closed", "display_text": "closed", "calculation": "Sum"}]',
})
self.assertTrue(builder_form.is_valid())
builder_form.update_report()
# reload report data source, because report.config is memoized
data_source = DataSourceConfiguration.get(report.config._id)
# The closed property indicator should now be decimal type because the user indicated that it was numeric
# by giving the column the "Sum" aggregation.
self.assertEqual(data_source.configured_indicators[0]['datatype'],
"decimal")
def test_count_column_existence(self, _, __):
"""
Confirm that aggregated reports have a count column option, and that
non aggregated reports do not.
"""
def get_count_column_columns(configuration_form):
return len(
filter(lambda x: isinstance(x, CountColumn),
configuration_form.report_column_options.values()))
list_report_form = ConfigureListReportForm(
"my report",
factory.app._id,
"form",
form1.unique_id,
)
self.assertEqual(get_count_column_columns(list_report_form), 0)
table_report_form = ConfigureTableReportForm(
"my report",
factory.app._id,
"form",
form1.unique_id,
)
self.assertEqual(get_count_column_columns(table_report_form), 1)
def test_multiselect_aggregation(self):
"""
Check report column aggregation for multi-select questions set to "group by"
"""
builder_form = ConfigureTableReportForm(
"My Report",
self.app._id,
"form",
self.form.unique_id,
data={
'user_filters': '[]',
'default_filters': '[]',
'columns':
'[{"property": "/data/state", "display_text": "state", "calculation": "Group By"}]',
'chart': 'pie',
})
self.assertTrue(builder_form.is_valid())
report = builder_form.create_report()
self.assertEqual(report.columns[0]['aggregation'], 'simple')
def test_updating_report_data_source(self):
"""
Test that changing the app or number column for a report results in an update to the data source next time
the report is saved.
"""
# Make report
builder_form = ConfigureTableReportForm(
"Test Report",
self.app._id,
"case",
"some_case_type",
existing_report=None,
data={
'group_by': 'closed',
'user_filters': '[]',
'default_filters': '[]',
'columns': '[{"property": "closed", "display_text": "closed", "calculation": "Count per Choice"}]',
}
)
self.assertTrue(builder_form.is_valid())
report = builder_form.create_report()
self.assertEqual(report.config.configured_indicators[0]['datatype'], "string")
# Make an edit to the first report builder report
builder_form = ConfigureTableReportForm(
"Test Report",
self.app._id,
"case",
"some_case_type",
existing_report=report,
data={
'group_by': 'user_id',
'user_filters': '[]',
'default_filters': '[]',
# Note that a "Sum" calculation on the closed case property isn't very sensical, but doing it so
# that I can have a numeric calculation without having to create real case properties for this case
# type.
'columns': '[{"property": "closed", "display_text": "closed", "calculation": "Sum"}]',
}
)
self.assertTrue(builder_form.is_valid())
builder_form.update_report()
# reload report data source, because report.config is memoized
data_source = DataSourceConfiguration.get(report.config._id)
# The closed property indicator should now be decimal type because the user indicated that it was numeric
# by giving the column the "Sum" aggregation.
self.assertEqual(data_source.configured_indicators[0]['datatype'], "decimal")