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
Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!
Rekisteröidy| Aiheeseen liittyviä artikkeleita | Vastaukset | Näkymät | Toimenpide | |
|---|---|---|---|---|
|
6
jouluk. 23
|
66250 | ||
|
1
maalisk. 19
|
10666 | ||
|
0
helmik. 16
|
4 | ||
|
0
jouluk. 15
|
3631 | ||
|
2
maalisk. 15
|
10414 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
