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
Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!
Zarejestruj się| Powiązane posty | Odpowiedzi | Widoki | Czynność | |
|---|---|---|---|---|
|
how to use constraint and sql constraint?
Rozwiązane
|
|
6
gru 23
|
69930 | |
|
1
mar 19
|
12785 | ||
|
0
lut 16
|
4 | ||
|
0
gru 15
|
5015 | ||
|
2
mar 15
|
12638 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
