Yes, this is a bug in bulk_insert -- it calls the _listify method *before*
running the _before_insert callbacks instead of after (_listify changes the
format from a dictionary to a list of (field, value) tuples). If you don't
mind, please file a pydal github issue and reference this post.
Anthony
On Friday, May 29, 2015 at 3:21:33 PM UTC-4, Ian Ryder wrote:
>
> It was this:
>
> new_ilis = []
> ...
> new_ili = {
> 'income': this_rg.template_income,
> 'income_coding': rgli.income_coding,
> 'amount_item': rgli.amount_item,
> 'quantity': rgli.quantity,
> 'income_source': rgli.income_source,
> 'source_agency': rgli.source_agency,
> 'source_type': rgli.source_type
> }
> new_ilis.append(new_ili)
> ...
> db.income_line_item.bulk_insert(new_ilis)
>
>
>
> On Friday, May 29, 2015 at 1:43:37 PM UTC+2, Anthony wrote:
>>
>> Possible bug. What does your bulk_insert code look like?
>>
>> On Friday, May 29, 2015 at 1:32:35 AM UTC-4, Ian Ryder wrote:
>>>
>>> OK - I think I have the answer.
>>>
>>> I discovered it wasn't table-specific, it worked with this same method /
>>> table elsewhere in the app. The place it was failing was using bulk_insert.
>>> I changed to insert individually and all works fine.
>>>
>>> Bug?
>>>
>>> On Friday, May 29, 2015 at 6:39:56 AM UTC+2, Ian Ryder wrote:
>>>>
>>>> Hi, the key point is I'm not getting passed a dict, I'm getting passed
>>>> a list. Here's a dump of what the _is_before handler gets passed:
>>>>
>>>> [(<pydal.objects.Field object at 0x11eb9ad10>, datetime.datetime(2015,
>>>> 5, 29, 6, 32, 27, 732420)), (<pydal.objects.Field object at 0x1334a5150
>>>> >, 1L), (<pydal.objects.Field object at 0x1334a5290>, 8L), (<pydal.
>>>> objects.Field object at 0x1334a5390>, 2L), (<pydal.objects.Field object
>>>> at 0x11c2dfcd0>, 5.0), (<pydal.objects.Field object at 0x1334a57d0>,
>>>> 14093L), (<pydal.objects.Field object at 0x1334a5b10>, 'APPEAL'), (<
>>>> pydal.objects.Field object at 0x1334a5050>, 1L), (<pydal.objects.Field
>>>> object at 0x1334a5410>, 358001L), (<pydal.objects.Field object at
>>>> 0x11eb9a4d0>, datetime.datetime(2015, 5, 29, 6, 32, 27, 732420)), (<
>>>> pydal.objects.Field object at 0x1334a53d0>, 5.0), (<pydal.objects.Field
>>>> object at 0x1334a5690>, True), (<pydal.objects.Field object at
>>>> 0x1334a55d0>, 1L)]
>>>>
>>>> I test it on a different table and it gets a dict as expected:
>>>> {'query_group': 1, 'name': 'asddasdasdasdsada', 'created_date':
>>>> datetime.datetime(2015, 5, 29, 6, 27, 37, 2291), 'run_order': 0, 'type'
>>>> : '', 'sum_description': '', 'created_by': 1L}
>>>>
>>>> I'll post again the definition for the one that isn't working:
>>>> db.income_line_item._before_insert.append(lambda f:
>>>> trigger_ili_before_insert(f))
>>>>
>>>> Which is essentially the same for the one that is working:
>>>> db.query._before_insert.append(lambda f: query_before_test(f))
>>>>
>>>>
>>>>
>>>>
>>>> On Thursday, May 28, 2015 at 11:10:21 PM UTC+2, Niphlod wrote:
>>>>>
>>>>> the book shows how to print every argument passed to those
>>>>> functions.... I dunno how to make the book clearer :°°°D
>>>>>
>>>>>
>>>>> before_insert ....
>>>>>
>>>>>
>>>>> def this_is_before_insert(some_dict):
>>>>> if 'last_name' in some_dict:
>>>>> some_dict['last_name'] = 'altering' + some_dict['last_name']
>>>>>
>>>>> db.auth_user._before_insert.append(lambda f: this_is_before_insert(f))
>>>>>
>>>>> >>>db.auth_user.insert(first_name='john')
>>>>> 1L
>>>>> >>> db.auth_user.insert(last_name='doe')
>>>>> 2L
>>>>> >>> rtn = db(db.auth_user.id>0).select(db.auth_user.first_name, db.
>>>>> auth_user.last_name)
>>>>> >>> print str(rtn)
>>>>> auth_user.first_name,auth_user.last_name
>>>>> john,
>>>>> ,alteringdoe
>>>>>
>>>>> before_update ...
>>>>>
>>>>> def this_is_before_update(a_set, some_dict):
>>>>> if 'last_name' in some_dict:
>>>>> some_dict['last_name'] += 'was_updated'
>>>>>
>>>>> db.auth_user._before_update.append(lambda s,f: this_is_before_update(s
>>>>> ,f))
>>>>>
>>>>> >>> db.auth_user.insert(first_name='john', last_name='doe')
>>>>> 1L
>>>>> >>> db(db.auth_user.first_name=='john').update(last_name='white')
>>>>> 1
>>>>> >>> rtn = db(db.auth_user.id>0).select(db.auth_user.first_name, db.
>>>>> auth_user.last_name)
>>>>> >>> print str(rtn)
>>>>> auth_user.first_name,auth_user.last_name
>>>>> john,whitewas_updated
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
--
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.
