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
Create an account today to enjoy exclusive features and engage with our awesome community!
Registrar-se| Related Posts | Respostes | Vistes | Activitat | |
|---|---|---|---|---|
|
6
de des. 23
|
67351 | ||
|
1
de març 19
|
11185 | ||
|
0
de febr. 16
|
4 | ||
|
0
de des. 15
|
4044 | ||
|
2
de març 15
|
11100 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
