Python Parser.parse示例

示例#1

def test_where1():
    p = Parser('SELECT "f1" FROM t1 WHERE f1=1 AND f2=2')
    p.parse()
    assert p.where == "WHERE f1=1 AND f2=2"

示例#2

def test_where2():
    p = Parser('SELECT "f1" FROM t1 WHERE f1=%s')
    p.parse()
    assert p.where == "WHERE f1=%s"

示例#3

def test_order(sql):
    p = Parser(sql)
    p.parse()
    assert p.parts['from'] == ' FROM t1'