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
|
#!/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:///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( {'last_name':'cognome...',})
def_movie = defaults.Defaults('movie', metadata=db.metadata)
#def_movie.fk( 'director_id', 'last_name', 'Olmi')
lay = """
title
year
description
date_release
director_id
"""
if 'm' in sys.argv:
t = SqlMask('movie', dbproxy=db, single=True, layout=lay)
else:
t = SqlTable('movie', dbproxy=db, single=True, dev=False,
order_by='director_id', rows=20)
t.reload()
t.totals.add_break('director_id')
t.totals.add_total('year')
t.completions.director_id.group_by = 'nation'
#t.mapper.local_table.metadata.bind.echo = True
t.completions.director_id.autostart = 2
try:
gtk.main()
except KeyboardInterrupt:
pass
|
