def test_get_cell_promote(self):
rd = report_data('points')
ss = SeriesSpec(2, 0, dict(op='eq', args=['monique']))
ss.promote_colnos_to_headers(rd.instances[0])
self.assertEqual(2, ss.actual_data_colno(rd.instances[0]))
self.assertEqual(0, ss.actual_filtering_colno(rd.instances[0]))
self.assertEqual(210, ss.get_cell(rd.instances[0]).value)
self.assertEqual(220, ss.get_cell(rd.instances[1]).value)
self.assertEqual(265, ss.get_cell(rd.instances[2]).value)
self.assertIsNone(ss.get_cell(rd.instances[3]))
rep2 = reports.Report.insert(
report_data('points').owner_id, 'points_colchange')
res2 = rep2.process_input(
json.dumps([
dict(points=300, user_name='john'),
dict(points=400, user_name='monique'),
]))
self.assertEqual(0, ss.actual_data_colno(res2.report_instance))
self.assertEqual(1, ss.actual_filtering_colno(res2.report_instance))
self.assertEqual(400, ss.get_cell(res2.report_instance).value)
ss = SeriesSpec(2, 0, dict(op='eq', args=['monique']))
self.assertIsNone(ss.get_cell(res2.report_instance))
def test_get_cell_nopromote(self):
rd = report_data('points')
ss = SeriesSpec(2, 0, dict(op='eq', args=['monique']))
self.assertEqual(2, ss.actual_data_colno(rd.instances[0]))
self.assertEqual(0, ss.actual_filtering_colno(rd.instances[0]))
self.assertEqual(210, ss.get_cell(rd.instances[0]).value)
self.assertEqual(220, ss.get_cell(rd.instances[1]).value)
self.assertEqual(265, ss.get_cell(rd.instances[2]).value)
self.assertIsNone(ss.get_cell(rd.instances[3]))
