Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I have sql constraint defined like this:
_sql_constraints = [
('checksum_uniq', 'unique(checksum)', ' The same file already exists in the system!'),
]
Then in a loop I create records
for file in files:
try:
self.env[model].create({'filename':file.fname,'file':file.file_data})
except IntegrityError, e:
print 'skipping file ' + file.fname
The problem is that the cursor is closed after IntegrityError so the loop fails after that but I want to skip the records that fail and continue the loop.
You found a solution ?
how to continue for loop when create has error?
use continue and pass do not work.
for file in files:
if file:
self.env[model].create({'filename':file.fname,'file':file.file_data})
else:
print 'skipping file ' + file.fname
This doesn't really makes sense. Maybe I was not clear but the problem is that if file.checksum is duplicated with another already in the system then it throws a Error and the only option I have is to rollback the whole transaction
أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!
تسجيل| المنشورات ذات الصلة | الردود | أدوات العرض | النشاط | |
|---|---|---|---|---|
|
6
ديسمبر 23
|
66239 | ||
|
1
مارس 19
|
10657 | ||
|
0
فبراير 16
|
4 | ||
|
0
ديسمبر 15
|
3626 | ||
|
2
مارس 15
|
10403 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
