Пример #1
0
 def test_paste_values3(self):
     """test pasting data into row headers only with new row"""
     model = PivotModel()
     model.set_new_data(self.data, self.index_names, self.index_types)
     paste_data = [['aa_new', 9],['bb_new', 10]]
     row_header_data = model._row_data_header.copy()
     row_header_data[0] = ('a','aa_new', 9)
     row_header_data.append((None,'bb_new', 10))
     model.paste_data(row_start=1, row_header_data=paste_data, row_mask=[0,6])
     self.assertEqual(model._row_data_header, row_header_data)
Пример #2
0
 def test_paste_values5(self):
     """test pasting data into columns headers only with new column"""
     model = PivotModel()
     model.set_new_data(self.data, self.index_names, self.index_types, rows=(), columns=tuple(self.index_names))
     paste_data = [['aa_new', 'bb_new'],[9, 10]]
     col_header_data = model._column_data_header.copy()
     col_header_data[0] = ('a','aa_new', 9)
     col_header_data.append((None,'bb_new', 10))
     model.paste_data(col_start=1, col_header_data=paste_data, col_mask=[0,6])
     self.assertEqual(model._column_data_header, col_header_data)
Пример #3
0
 def test_paste_values1(self):
     """test pasting data into data only"""
     model = PivotModel()
     model.set_new_data(self.data, self.index_names, self.index_types)
     model.set_pivot(['test1','test2'], ['test3'], [], ())
     data = [['paste1', 'paste2', None, None, None],
             ['paste3', 'paste4', None, None, None],
             [None, None, 'value_b_cc_3', None, None],
             [None, None, None, 'value_c_cc_4', None],
             [None, None, None, None, 'value_d_dd_5'],
             [None, None, None, None, 'value_e_ee_5']]
     model.paste_data(data=[['paste1', 'paste2'],['paste3', 'paste4']], row_mask=[0, 1], col_mask=[0, 1])
     data_model = [[d for d in inner] for inner in model.get_pivoted_data(range(6),range(5))]
     self.assertEqual(data_model, data)