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/defaults
Deaults are set on the database table not on the SqlMask/SqlTable
When setting the default for a foreig key, you can use method fk that
sets directly via the name. In that case you need to say which field you want
to use for SELECT
"""
from sqlkit.db import defaults
def_movie = defaults.Defaults('movie', metadata=db.metadata)
def_movie.set_defaults(
{'date_release' : def_movie.today,
'title' : 'A nice title...',
} )
def_movie.fk('director_id', 'last_name', 'Fellini')
#t = SqlMask('movie', dbproxy=db, )
t = SqlTable('movie', dbproxy=db, )
## unregister to prevet conflicts in following examples
#del defaults.tables['movie']
|
