def test_format_operation_with_named_parameters():
"""format_operation() is used for Python style parameter expansion"""
assert format_operation("INSERT INTO TEST VALUES(%(name)s, %(val)s)", {
'name': 'Hello World',
'val': 2
}) == "INSERT INTO TEST VALUES('Hello World', 2)"
def test_format_operation_with_positional_parameters():
"""Test that correct number of parameters produces correct result."""
assert format_operation(
"INSERT INTO TEST VALUES(%s, %s)",
('Hello World', 2)) == "INSERT INTO TEST VALUES('Hello World', 2)"
def test_format_operation_with_too_many_positional_parameters_raises():
"""Test that providing too many parameters raises exception"""
with pytest.raises(ProgrammingError):
format_operation("INSERT INTO TEST VALUES(%s)", ('Hello World', 2))
def test_format_operation_without_parameters(parameters):
"""Test that providing no parameter produces correct result."""
operation = "SELECT * FROM TEST WHERE fuu = 'bar'"
assert format_operation(operation, parameters) == operation
def test_format_operation_with_named_parameters():
"""format_operation() is used for Python style parameter expansion"""
assert format_operation(
"INSERT INTO TEST VALUES(%(name)s, %(val)s)",
{'name': 'Hello World', 'val': 2}
) == "INSERT INTO TEST VALUES('Hello World', 2)"
def test_format_operation_with_too_many_positional_parameters_raises():
"""Test that providing too many parameters raises exception"""
with pytest.raises(ProgrammingError):
format_operation("INSERT INTO TEST VALUES(%s)", ('Hello World', 2))
def test_format_operation_with_positional_parameters():
"""Test that correct number of parameters produces correct result."""
assert format_operation(
"INSERT INTO TEST VALUES(%s, %s)", ('Hello World', 2)
) == "INSERT INTO TEST VALUES('Hello World', 2)"
def test_format_operation_without_parameters(parameters):
"""Test that providing no parameter produces correct result."""
operation = "SELECT * FROM TEST WHERE fuu = 'bar'"
assert format_operation(operation, parameters) == operation
