how to access database using python code?

Question

I want to access database and get the name from a table to check if the name exist or not.

I know that I need to override the create function but I have no idea for what should I put inside the function

Also, i'd like to ask how to pop up en error message like the validate checking when the name is existed

Deepa Venkatesh · Answer

you can use *cursor*(or cr) present in a method..

almost all ORM methods will have these paramaters: /*self, cr, uid*/

so one can use cr, which is nothing but cursor paramater used to deal with database...

/Example:/ cr.execute("select * from res_partner")

And to do validation: you can set *_sql_constraints* in your object

Hint: use Ctrl + H to search in you the addons, if you are using EDI like eclipse/aptana studio

相关帖文	回复	查看
Database for my module not created 已解决 python module database	4 4月 24	1848
How to connect to Odoo.sh database from external application? 已解决 python database odoo.sh	3 5月 22	15441
What is the best way to guarantee my model fields are added in the database, so I don't have to add them manually via SQL? python fields database	1 12月 16	3184
How is qty on hand calculated? python database orm	1 3月 15	12172
Get field value And Use It In Data Base Statement? python fields database	0 3月 15	3369