How to add a sql_constraint?

callmeknud · **Joined:** Fri Apr 30, 2010 10:35 am **Posts:** 90

hello,

how can a sql_constraint be added?

the "OpenERP" sql_constraint is looking for an existing postgres constraint, right?

so, do i have to create the postgres constraint manually in postgress, or is there any way to do it in python code?

thanks

GEM · **Posted:** Mon May 02, 2011 4:38 pm

do a module with inheritance (python code), and add your sql constraint :
a little result by searching with menu search at the top of the page :
topic18021.html?hilit=sql_constraint

callmeknud · **Joined:** Fri Apr 30, 2010 10:35 am **Posts:** 90

thanks for your answer.

i already seached within the forum, but it's not clear to me.

as an example, i would like to add a sql_constaint to my own module:
_sql_constraints = [
('my_key_value', 'UNIQUE (key_value)', 'key value has to be unique !')
]

is my_key_value the name of the postgresql constraint?
if i install the module, i get tuple is not callable and there is no constraint created within postgresql.

can you please help me further?

GEM · **Posted:** Tue May 03, 2011 9:08 am

from technical memento :

Code:

_sql_constraints list of tuples defining the SQL constraints, in the form
(name, sql_def, message)

example :

Code:

_sql_constraints = [('name_uniq','unique(name)', 'Idea must be unique!')]

callmeknud · **Joined:** Fri Apr 30, 2010 10:35 am **Posts:** 90

thank you very much.

It is working now, i sticked to the naming like 'name_uniq'.

GEM · **Posted:** Tue May 03, 2011 3:26 pm

openerp technical memento :
http://www.openerp.com/download/OpenERP ... v0.6.3.pdf