def initial_operations_template(building): wb = Workbook() ws = wb.worksheets[0] ws.title = u'Solduri inițiale' ws.cell(row=0, column=0).value = 'ID intern' ws.cell(row=0, column=1).value = 'Apartament' ws.cell(row=0, column=2).value = 'Sold' ws.cell(row=0, column=3).value = 'Data' def attr_validator(attr): l = (str(getattr(ap, attr)) for ap in building.apartments()) formula = '"' + ','.join(l) + '"' validator = DataValidation(ValidationType.LIST, formula1=formula, allow_blank=False) return validator id_validator = attr_validator('id') ws.add_data_validation(id_validator) name_validator = attr_validator('name') ws.add_data_validation(name_validator) decimal_validator = DataValidation(ValidationType.DECIMAL, allow_blank=True) decimal_validator.set_error_message('Introduceți un număr zecimal', 'Eroare de validare') ws.add_data_validation(decimal_validator) date_validator = DataValidation(ValidationType.DATE, allow_blank=True) date_validator.set_error_message('Introduceți o dată', 'Eroare de validare') ws.add_data_validation(date_validator) row = 1 now = datetime.now() for ap in building.apartments(): cell_id = ws.cell(row=row, column=0) cell_id.value = ap.id id_validator.add_cell(cell_id) cell_name = ws.cell(row=row, column=1) cell_name.value = ap.name name_validator.add_cell(cell_name) cell_balance = ws.cell(row=row, column=2) cell_balance.style.fill.fill_type = Fill.FILL_SOLID cell_balance.style.fill.start_color.index = Color.YELLOW decimal_validator.add_cell(cell_balance) cell_date = ws.cell(row=row, column=3) cell_date.value = now cell_date.style.number_format.format_code = 'yyyy-mm-dd' cell_date.style.fill.fill_type = Fill.FILL_SOLID cell_date.style.fill.start_color.index = Color.YELLOW date_validator.add_cell(cell_date) row += 1 ws.column_dimensions['A'].visible = False ws.column_dimensions['B'].width = 20.0 ws.column_dimensions['C'].width = 20.0 ws.column_dimensions['D'].width = 20.0 temp = tempfile.NamedTemporaryFile() wb.save(temp) return temp
def test_error_message(): dv = DataValidation(ValidationType.LIST, formula1='"Dog,Cat,Fish"') dv.set_error_message('You done bad') eq_(dv.generate_attributes_map()['errorTitle'], 'Validation Error') eq_(dv.generate_attributes_map()['error'], 'You done bad')
def test_error_message(): dv = DataValidation(ValidationType.LIST, formula1='"Dog,Cat,Fish"') dv.set_error_message('You done bad') assert dv.generate_attributes_map()['errorTitle'] == 'Validation Error' assert dv.generate_attributes_map()['error'] == 'You done bad'