Here is a possibility to make DAL a bit more transparent for those who
use Oracle:
when we use statements like:
db(db.tablename.fieldname.belongs(the_list)).update(x=y)
Oracle (unlike its open-source counterparts) fires an error coded
ORA-01795 if length of 'the_list' exceeds 1000. There is no workaround
for this problem in Google rather than manually create a cycle over
the_list and feed the 1000-chunks to Oracle:
for i in range(0, len(the_list), 1000):
chunk = the_list[i:i+999]
db(db.tablename.fieldname.belongs(chunk)).update(x=y)
Would be nice to hide this from web2py developers and implement this
loop inside the DAL.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
