Done - thanks for your help
On Friday, May 29, 2015 at 11:48:38 PM UTC+2, Anthony wrote:
>
> 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.
