yes, you all right, in the past i learned the after_insert callback can be
access via f.amount, yet it still work when using insert, but not
bulk_insert (must use dict f['amount'] ), please correct me if i'm wrong
about my conclusion
thanks and best regards,
stifan
On Thursday, April 21, 2016 at 9:03:16 PM UTC+7, Anthony wrote:
>
> On Thursday, April 21, 2016 at 1:57:20 AM UTC-4, 黄祥 wrote:
>>
>> meet strange behaviour in after_insert callback, when using variable
>> (e.g. f.amount) is not work, but when using dict (e.g. f['amount'] ) work
>> models/db_wizard_4_subscription.py
>> # not work
>> def __after_insert_subscription_detail(f, id):
>> unit = float(f.amount) / float(f.nav_per_unit)
>>
>
> Why would you expect that to work? As noted in the documentation:
>
> Here f is a dict of fields passed to insert or update...
>
>
> Anthony
>
>
>
>>
>> """
>> # work
>> def __after_insert_subscription_detail(f, id):
>> unit = float(f['amount'] ) / float(f['nav_per_unit'] )
>> """
>>
>> def on_define_subscription_detail(table):
>> table._after_insert.append(__after_insert_subscription_detail)
>>
>> db.define_table('subscription_detail',
>> Field('subscription_no', 'reference subscription_header'),
>> Field('account', 'reference account'),
>> Field('nav_date', 'date'),
>> Field('nav_per_unit', 'double'),
>> Field('amount', 'double'),
>> Field('fee', 'double'),
>> Field('fee_amount', 'double'),
>> Field('unit', 'double'),
>> auth.signature,
>> on_define = on_define_subscription_detail,
>> format = '%(subscription_no)s')
>>
>> Traceback (most recent call last):
>> File "/Users/MacBookPro/site/web2py/gluon/restricted.py", line 227, in
>> restricted
>> exec ccode in environment
>> File
>> "/Users/MacBookPro/site/web2py/applications/mutualfunds/controllers/install.py",
>>
>> line 221, in <module>
>> File "/Users/MacBookPro/site/web2py/gluon/globals.py", line 417, in
>> <lambda>
>> self._caller = lambda f: f()
>> File
>> "/Users/MacBookPro/site/web2py/applications/mutualfunds/controllers/install.py",
>>
>> line 201, in index
>> 'fee_amount' : 0}, ] )
>> File
>> "/Users/MacBookPro/site/web2py/gluon/packages/dal/pydal/objects.py", line
>> 831, in bulk_insert
>> ret and [[f(item, ret[k]) for k, item in enumerate(items)] for f in
>> self._after_insert]
>> File
>> "/Users/MacBookPro/site/web2py/applications/mutualfunds/models/db_wizard_4_subscription.py",
>>
>> line 43, in __after_insert_subscription_detail
>> unit = float(f.amount) / float(f.nav_per_unit)
>> AttributeError: 'dict' object has no attribute 'amount'
>>
>> controllers/install.py
>> db.subscription_detail.bulk_insert([{'subscription_no' : 1, 'account' :
>> 1, 'nav_date' : '2016-01-01',
>> 'nav_per_unit' : 1.0, 'amount' : 1, 'fee' : 0,
>> 'fee_amount' : 0},
>> {'subscription_no' : 2, 'account' : 1, 'nav_date' : '2016-01-02',
>> 'nav_per_unit' : 1.1, 'amount' : 2, 'fee' : 0,
>> 'fee_amount' : 0}, ] )
>>
>> anyone know about this behaviour? is it normal?
>>
>> 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.
