querpy/doc_example.py at master · circld/querpy · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
"""
Build README.md example

>>> python doc_example.py > file_name.txt
"""

commands = [
    '>>> from querpy import Query',
    '>>> new_query = Query()',
    ">>> new_query.f += 'ex_db.dbo.ex_table tbl'",
    ">>> new_query.s += ['col1', 'col2', 'col3']",
    ">>> new_query.s += 'col4'  # can take single strings",
    ">>> new_query.w += 'col1 = 1'  # can also take a list",
    ">>> new_query.w |= 'col2 IS NULL'  # handles &= and |= operators",
    ">>> print new_query",
    ">>> new_query",
    ">>> new_query.s.clear()  # clear SELECT component",
    ">>> new_query.s += 'col1'",
    ">>> new_query",
    ">>> new_query.s[0] = 'col2'",
    ">>> print new_query.s",
    ">>> new_query.j += 'ex_db.dbo.new_tbl nt ON tbl.id = nt.id'",
    ">>> new_query.s += 'nt.id'",
    ">>> new_query",
    ">>> from querpy import build_join",
    ">>> new_query.j.clear()",
    ">>> new_query.join_type = 'LEFT'",
    ">>> new_query.j += build_join('ex_db.dbo.new_tbl nt', 'tbl.id', 'nt.id',"
    " 'tbl.city', 'nt.city')",
    ">>> new_query.join_type = ''  # set back to regular join",
    ">>> new_query",
    ">>> new_query.statement",
]

def main():

    for c in commands:
        print c
        if c in ('>>> new_query', '>>> new_query.statement'):
            print eval(c[4:])
        else:
            exec(c[4:])


if __name__ == '__main__':

    main()