It's not clear what you are trying to do.
On Monday, November 19, 2012 1:43:47 PM UTC-5, Amber Doctor wrote:
>
> 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.
>
--
