def test_resolve_dual_digit_variable(self):
expected = '(10*C0+1*C1)'
converter = FormulaConverter(variable_addresses={'A': 0, 'B': 1})
actual = converter._resolve_formula(text='AB')
self.assertEqual(actual, expected)
def test_resolve_reference_of_unknown_variable(self):
expected = 'A'
converter = FormulaConverter(variable_addresses={'B': 0})
actual = converter._resolve_formula(text='A')
self.assertEqual(actual, expected)
def test_resolve_basic_math_operations(self):
expected = 'C0 + C1 - C2 * C3 / C4'
converter = FormulaConverter(variable_addresses={'A': 0, 'B': 1, 'C': 2, 'D': 3, 'E': 4})
actual = converter._resolve_formula(text='A + B - C * D / E', )
self.assertEqual(actual, expected)
def test_resolve_simple_formula(self):
expected = 'C0 + C1'
converter = FormulaConverter(variable_addresses={'A': 0, 'B': 1})
actual = converter._resolve_formula(text='A + B')
self.assertEqual(actual, expected)
