Re: [web2py] SOLVED - list:string - IS_IN_SET

[Jim Steil]

Did that already and couldn't find anything.


On 7/15/2011 2:16 PM, Anthony wrote:

Not sure about that -- check out http://web2py.com/book/default/chapter/06#Fixing-Broken-Migrations.

On Friday, July 15, 2011 3:09:37 PM UTC-4, Jim S wrote:

    Ok, I updated my table def here to be

    Field('itemType', length=50, required=True, label='Item Type'),

, ran with migrate=False, fake_migrate=True and everything works. When I remove migrate=False, fake_migrate=True, then I get the

    following traceback:

    Traceback(most recent call last):
       File"gluon/restricted.py",line184,inrestricted
       File"C:/dev/web2py/applications/InfoCenter/models/db.py"  
<http://127.0.0.1:8000/admin/default/edit/InfoCenter/models/db.py>,line372,in<module>
       File"gluon/dal.py",line4213,indefine_table
       File"gluon/dal.py",line641,increate_table
       File"gluon/dal.py",line696,inmigrate_table
       File"gluon/dal.py",line4570,in__getitem__
    KeyError:'itemtype'


    Thoughts?

        -Jim


    On 7/15/2011 1:05 PM, Jim Steil wrote:

    Found this one myself.  Don't use 'list:string'.  This is just a
    regular string field.

    On 7/15/2011 12:55 PM, Jim Steil wrote:

    Hi

    Having another problem today with the following:

    table defined as:

    priceBackerItem = db.define_table('priceBackerItem',
                Field('priceBackerItemId', 'id'),
                Field('priceBackerId', db.priceBacker,
    required=True, label='Price Backer'),
                Field('itemType', 'list:string', required=True,
    label='Item Type'),
                Field('sequence', 'integer'),
                Field('description', 'text'),
                Field('price', 'decimal(9,2)', label='15-Day Price'),
                Field('subscript', 'text'))

    priceBackerItem.priceBackerItemId.requires = IS_NOT_EMPTY()
    priceBackerItem.itemType.requires = IS_IN_SET(['Special
    Formulation Price Adjustment',
          'Medication Price Adjustment'],
          zero='choose one',multiple=False)

    Using CRUD, when the update form displays, it never displays the
    current value of item type.  The reason is (my best guess) that
    when I look in the database (mysql), I see the values as:

    |Medication Price Adjustment| or
    |Special Formulation Price Adjustment|

    ...including the vertical lines in the text.

    Any advice?

        -Jim