File: ex_78_printing-fk.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 (23 lines) | stat: -rw-r--r-- 607 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
"""printing/foreign key

How to cope with foreign keys. The template has '$director_id', that will be
rendered as the last_name of the Director instead of the id that is the
value of the foreign key attribute.

This happens becouse the main object and the objects in 'Table1' are wrapped into ObjProxy, a
proxy that follows the foreign key and retrieves the "correct" (well, best match) value.

"""

lay = """
  title
  year
  date_release
  director_id
"""

t = SqlMask(model.Movie, layout=lay, dbproxy=db)
t.printing.add_menu_entry('Print to pdf', 'movie-fk.odt', mode='pdf', accel='<Alt>p')
t.reload()