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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
