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