File: ex_02a_table_movie.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 (24 lines) | stat: -rw-r--r-- 542 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
24
"""base/tree table

Tree Table
----------

In this example a table is displayed with gerarchical grouping

"""

from sqlkit.widgets.table.modelproxy import Header, ModelProxy

class MyModel(ModelProxy):

    def make_header_obj(self, field_value):

        return Header(self.master, 'title', self.master.gui_fields.director_id.get_human_value(field_value))


t = SqlTable('movie', dbproxy=db, order_by='title', )
t.modelproxy = t.modelproxy.copy(MyModel)
t.modelproxy.tree_field_name = 'director_id'
t.hide_fields('director_id')
t.reload()