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
|
"""relation/adding records
Adding a relation is as easy as adding the relation name to the layout.
Note that in this case the table name is not sufficient, we need to know
the mapping so we pass a class_ attribute that is really a mapped class
(in this example built with declarative layer)
"""
lay = """
first_name
last_name
nation
m2m=movies -
"""
t = SqlMask(model.Director, dbproxy=db, layout=lay)
t.add_filter(last_name='Faenza')
t.filter_panel.reload()
r = t.related.movies
r.totals.add_total('year')
f = r.mapper.class_()
f.title = 'Alla luce del sole'
r.add_record(f)
|