Function verify_sql_matches

tests/comparison/tests/test_query_objects.py:56–65

Assert that the actual and expected SQL queries match. Trailing white space is stripped by default.

(actual, expected, strip=True)

def verify_sql_matches(actual, expected, strip=True):
  """
  Assert that the actual and expected SQL queries match. Trailing white space is
  stripped by default.
  """
  if strip:
    actual = actual.strip()
    expected = expected.strip()
  assert actual == expected, 'actual SQL "{actual}" != expected SQL "{expected}"'.format(
      actual=actual, expected=expected)


@pytest.fixture