I'm trying to determine the best way to code the following situation in
web2py.
Currently I have a model that has this in it:
db.define_table('ingredient',
Field('ingredient_name', 'string', required=True),
Field('kind_ref', 'reference kind', required=True,
requires=IS_IN_DB(db, 'kind.id','%(kind_name)s')),
Field('type_ref', 'reference ingredient_type',
required=True, requires=IS_IN_DB(db, 'ingredient_type.id','%(type_name)s')),
Field('subtype_ref', 'reference ingredient_subtype',
required=True, requires=IS_IN_DB(db,
'ingredient_subtype.id','%(subtype_name)s')),
Field('brand_ref', 'reference ingredient_brand',
required=True, requires=IS_IN_DB(db,
'ingredient_brand.id','%(brand_name)s')),
Field('is_approved', 'boolean', default=True),
Field('for_match', 'boolean', default=True),
Field('ingredient_so', 'integer', default=50),
format='%(ingredient_name)s'
)
db.define_table('drink_recipe_ingredients',
Field('drink_recipe_ref', 'reference drink_recipe',
requires=IS_IN_DB(db, 'drink_recipe.id','%(drink_recipe_name)s')),
Field('ingredient_ref', 'reference ingredient',
requires=IS_IN_DB(db, 'ingredient.id','%(ingredient_name)s')),
Field('quantity'),
Field('unit_ref', 'reference unit', requires=IS_IN_DB(db,
'unit.id','%(unit_of_measure)s')),
Field('is_approved', 'boolean', default=True),
Field('drink_recipe_ingredients_so', 'integer', default=50)
)
from a pseudo use case perspective what I want to do is:
1) back end grab 3 sets of data (one for kind, 1,2,3) kinda like: alcohols
= db((db.ingredient.kind_ref=='1') & (db.ingredient.for_match==True) &
(db.ingredient.is_approved==True)).select()
2) front end display a check box that indicates that you are or are not
including information from those three sets of information - "category
selector"
3) display those three lists of items with check boxes next to each item in
the list
4) let the user select the check boxes and submit
5) in the back end - use the "category selector" and the checked items in
each category to create another query that pulls information from the
drink_recipe_ingredients table
no data gathered is stored in the database. more than one user can be
executing this behavior at the same time.
Any advice on the best way to this would be great.
--
