File: ex_16_join.py

package info (click to toggle)
sqlkit 0.9.5-1
  • links: PTS, VCS
  • area: main
  • in suites: wheezy
  • size: 8,184 kB
  • sloc: python: 17,477; sql: 166; makefile: 95; xml: 23; sh: 11
file content (13 lines) | stat: -rw-r--r-- 318 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
 
"""base/join

You can edit the join of 2 tables just using tables='table1 table2'

note that in a join you need to filter/add constraint on a name that is
a composition between table and field_name

"""

t = SqlTable("movie director", dbproxy=db )
t.add_filter(director_nation='IT') # NOTE director_nation
t.reload()