File: ex_40_completion.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 (32 lines) | stat: -rw-r--r-- 896 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
25
26
27
28
29
30
31
32
"""completion/basic

Completion is the way you can save typing. When completion is invoked entry
completion is used to show possible completions. If the field is a foreign key,
completion is done against the value of the foreign key (ie: not the id). The
value is searched for via the attribute that better represent the record
or declared as search field for the table or the first char field.

You can invoke completion via Control-Return in any field and clicking on the
down arrow for foreign key.

Completion works both in Table view and Mask view.

Completion on a field that is not a foreign key return a selection of values
of the field

Completion has 2 flavours: start and regexp: see docs

You don't need to do anything particular to start a plain/basic completion

"""

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

t = SqlMask(model.Movie, dbproxy=db, layout=lay)