Example #1
0
def test_normal_string_literal_not_replaced():
    q = 'SELECT "column_name" FROM table'
    replaced = replace(q, ns)
    assert_equals(q, replaced)
Example #2
0
def test_replaces_in_single_quote_string_literal():
    q = "SELECT thing FROM place WHERE val=':ident1'"
    replaced = replace(q, ns)
    assert_equals("SELECT thing FROM place WHERE val='val1'", replaced)
Example #3
0
def test_replaces_in_double_quote_string_literal():
    q = 'SELECT thing FROM place WHERE val=":ident1"'
    replaced = replace(q, ns)
    assert_equals('SELECT thing FROM place WHERE val="val1"', replaced)
Example #4
0
def test_multiple_placeholders_replaced():
    q = "SELECT :ident1 FROM :ident2 WHERE :ident1=:ident3"
    replaced = replace(q, ns)
    assert_equals("SELECT val1 FROM val2 WHERE val1=55", replaced)
Example #5
0
def test_not_found_placeholder_causes_exception():
    q = "SELECT :dummy FROM place"
    replace(q, ns)
Example #6
0
def test_single_placeholder_replaced():
    q = "SELECT :ident1 FROM place"
    replaced = replace(q, ns)
    assert_equals("SELECT val1 FROM place", replaced)
Example #7
0
def test_single_placeholder_replaced():
    q = "SELECT :ident1 FROM place"
    replaced = replace(q, ns)
    assert_equals("SELECT val1 FROM place", replaced)
Example #8
0
def test_normal_string_literal_not_replaced():
    q = 'SELECT "column_name" FROM table'
    replaced = replace(q, ns)
    assert_equals(q, replaced)
Example #9
0
def test_replaces_in_double_quote_string_literal():
    q = 'SELECT thing FROM place WHERE val=":ident1"'
    replaced = replace(q, ns)
    assert_equals('SELECT thing FROM place WHERE val="val1"', replaced)
Example #10
0
def test_replaces_in_single_quote_string_literal():
    q = "SELECT thing FROM place WHERE val=':ident1'"
    replaced = replace(q, ns)
    assert_equals("SELECT thing FROM place WHERE val='val1'", replaced)
Example #11
0
def test_not_found_placeholder_causes_exception():
    q = "SELECT :dummy FROM place"
    replace(q, ns)
Example #12
0
def test_multiple_placeholders_replaced():
    q = "SELECT :ident1 FROM :ident2 WHERE :ident1=:ident3"
    replaced = replace(q, ns)
    assert_equals("SELECT val1 FROM val2 WHERE val1=55", replaced)