is it possible belongs to handle if there is only one value?
e.g.
*models/db.py*
db.define_table('test0',
Field('name'),
format = '%(name)s')
db.define_table('test1',
Field('name'),
Field('test0', 'reference test0'),
format = '%(name)s')
*controllers/default.py*
def install():
if db(db.test0).isempty() and db(db.test1).isempty():
db.test0.bulk_insert([{'name' : 'test0 - a'}, {'name' : 'test0 - b'}, ] )
db.test1.bulk_insert([{'name' : 'test1 - a', 'test0' : 1}, {'name' : 'test1
- b', 'test0' : 2}, ] )
def test0():
form = SQLFORM.factory(
Field("test0", "list:reference test0",
requires = IS_EMPTY_OR(IS_IN_DB(db, db.test0.id, db.test0._format,
multiple = True) ) ) )
if form.process().accepted:
redirect(URL('test1', vars = form.vars) )
elif form.errors:
response.flash = T('Form has errors')
return dict(form = form)
def test1():
test0 = request.vars.test0
query = (db.test1.test0.belongs(test0) )
rows = db(query).select()
return dict(test0 = test0, query = query, rows = rows)
*result:*
http://127.0.0.1:8000/a/default/test1?test0=1#
query :
<Query (test1.test0 IN ())>
rows :
test0 :
1
http://127.0.0.1:8000/a/default/test1?test0=1&test0=2#
query :
<Query (test1.test0 IN (1,2))>
rows :
test1.idtest1.nametest1.test0
1 test1 - a test0 - a
2 test1 - b test0 - b
test0 :
1
2
*question:*
why belongs cannot handle if the value of dict is only one value? how can
achieve it using web2py way?
thanks and best regards,
stifan
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
