Is it possible to add multiple sql constraint in a same model need help................This code is works or not?

Question

class scheme_type_info(osv.osv):

_name='scheme.type.info'

_columns={
'scheme_id':fields.integer('Scheme Type',required=True,size=50),
'interval':fields.integer('Start Days',required=True,size=64,help="set the number of start date interval"),
'interval1':fields.integer('End Days',required=True,size=64,help="set the number of end date interval"),
'criteria':fields.integer('Number of Tickets',required=True),
'salary':fields.float('Amount',required=True),
'active':fields.boolean('Active')
}
_sql_c

Jaakko Komulainen · Answer

_sql_constraints is a list so you can add them like:

_sql_constraints =[('unique_scheme_id','unique(scheme_id)','Error! scheme Id Already Exist'), ('unique_interval','unique(interval)','Error! Start Day Already Exist'),('unique_interval1','unique(interval1)','Error! End Day Already Exist')]

René Schuster · Answer

I'm not sure how your code will perform, either throw an error, or just use the last constraint.

But what you want is easy to achieve:

sql_constraints is a *list* of tuples: So add all your constraints into one list:

_sql_constraints = [
('unique_scheme_id', 'unique(scheme_id)', 'Error! scheme Id Already Exist'),
('unique_interval', 'unique(interval)', 'Error! Start Day Already Exist'),
('unique_interval1', 'unique(interval1)', 'Error! End Day Already Exist')
]

Note: It might be possible tha

Ruchir Shukla · Answer

Try this : It will work

_sql_constraints = [('unique_scheme_id','unique(scheme_id)','Error! scheme Id Already Exist'),

('unique_interval','unique(interval)','Error! Start Day Already Exist')]

Це запитання позначене

Enjoying the discussion? Don't just read, join in!