Skip to Content
This question has been flagged
constraintintegrityerrorsqlexception
3 Respostes
7387 Vistes
Avatar
Magen

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.


Avatar
Descartar
Avatar
Eauzon
Best Answer

You found a solution ?

Avatar
Descartar
Avatar
Trịnh Văn Quang
Best Answer

how to continue for loop when create has error? 
use continue and pass do not work. 

Avatar
Descartar
Avatar
Rakesh Vadeghar
Best Answer 

for file in files:
    if file:
        self.env[model].create({'filename':file.fname,'file':file.file_data})
    else:
        print 'skipping file ' + file.fname

Avatar
Descartar
Magen
Autor

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

Related Posts Respostes Vistes Activitat
how to use constraint and sql constraint? Solved
constraint sql
Avatar
Avatar
Avatar
Avatar
Avatar
6
de des. 23
69929
Override SQL constraint
constraint sql
Avatar
Avatar
1
de març 19
12779
Sql constraints occurs when edit in record
constraint edit sql
Avatar
0
de febr. 16
4
How to block duplicating RECORDS (with the same employee_id)?
constraint sql openerp7
Avatar
0
de des. 15
5014
CHECK sql_constraints
v7 constraint sql
Avatar
Avatar
Avatar
2
de març 15
12637