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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
|
#!/usr/bin/python
import sys
from sqlkit import debug as dbg
#dbg.debug(True)
dbg.debug(True, gtk=True)
dbg.trace_class(ok='SqlTable|SqlWidget|SqlMask|Completion')
but = 'set_fkey_descr|(lookup|set|get)_value|[el]ne_cb|match_func' + \
'|cell_default_cb|cell_bool_cb'
dbg.trace_function(exclude=but)
import sqlkit
from sqlkit.widgets import SqlTable, SqlMask
from sqlkit.db import proxy, defaults, utils
import gtk
db = proxy.DbProxy(engine="sqlite:///../../demo/sql/model/movies.sqlite")
session = db.get_session()
utils.TableDescr('director', format='%(first_name).1s. %(last_name)s',
metadata=db.metadata)
utils.TableDescr('movie', format='%(title)s. %(year)s',
metadata=db.metadata)
def_director = defaults.Defaults('director', metadata=db.metadata)
def_director.set_defaults( {'first_name':'nome...',})
def_movie = defaults.Defaults('movie', metadata=db.metadata)
#def_movie.fk( 'director_id', 'last_name', 'Olmi')
lay = """
first_name
last_name
nation
o2m=films -
"""
if 'm' in sys.argv:
t = SqlMask('director', dbproxy=db, single=True, layout=lay)
else:
t = SqlTable('director', dbproxy=db, single=True, dev=False,
order_by='last_name',
rows=6,
#field_list='director_id,title'
)
# t.reload()
t.completions.last_name.filter(nation='$nation')
# t.totals.add_total('year')
#t.mapper.local_table.metadata.bind.echo = True
#t.completions.director_id.autostart=1
try:
gtk.main()
except KeyboardInterrupt:
pass
|
